Reverse the sign of accounts when importing data with an on-premise connector
This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Question
How do I reverse the sign of Accounts when using an On-Premise Connector to import data?
Answer
Functionality can be built into the Connector to reverse signs for specific accounts or account ranges prior to importing the data. To see which accounts in your source system have been set up to have the signs reversed, go to the following location.
- Go to Start> Computer
- Open the C drive
- Open AdaptivePlanning> CustomerParameters
- Open the "ReverseAccounts" file
The "ReverseAccounts" file will display the accounts that currently have the sign reversed when importing. Add any additional accounts that should have the sign permanently reversed during imports to that file and save.
Use "#,#" format to enter a range of accounts
example:
16000,18999
Use # to just enter a single account
example:
16000
18000
18500