Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

How to Reverse the Sign of Accounts when Importing Data using an On-Premise Connector

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.

  1. Go to Start> Computer
  2. Open the C drive
  3. Open AdaptivePlanning> CustomerParameters
  4. Open the "ReverseAccounts" file

Signs_Reversed.jpg

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

  • Was this article helpful?