Historical Balances Data Migration error Positive and negative amounts are not allowed together

[former_member133489]

Dear Community,

When I try to upload the historical balances with the migration cockpit, I get the following error:

Positive and negative amounts are not allowed together.

Even if for the specific records mentioned I have only negative amounts in all the relevant fields.

Any idea why this issue comes up?

Thank you,

Diana 

[EricvanZundert · Accepted solution]

Hi Diana,

Good that you found it. As the amount is empty (but not negative...) it is treated as a positive figure and thus a mix of positive and negative 'amounts'.

Eric.

From the link below:

Currency and amount:

All currency amount fields in the migration template are mandatory. The amounts will not be derived automatically.

Transaction/document currency is mandatory. Local/company code currency and group currency are optional and will be derived automatically by the customizing settings maintained in system. An error message will be displayed if those currencies are filled in the template but do not match the customizing settings.

Recommendation: provide all currency information via the template to ensure the provided amounts match to the related currencies. Otherwise, inconsistencies might be migrated.

[former_member133489]

In fact, the error come up because I didn`t fill in any amount in the 3rd currency.

[EricvanZundert]

Hi Diana,

As a first action I would check or you may have double keys with a + and a - sign?

Maybe not grouped together, but if you remove duplicates on the key, then there should be none.

Eric.

Additional info:

https://help.sap.com/viewer/cc9ecc5f5f6b400a98d10e930324f7ad/2005.500/en-US/3d124205199a4a33b787907d...

>>>>

For migration, the debit/credit indicator will be controlled by the sign in the amount fields. Do not use different signs (positive and negative) within same record. The sign for negative values should be set at the beginning:

A positive value will post a debit entry (S)

A negative value will post a credit entry (H)

[Mehak_2024]

I am also getting the same error , Can anyone help to resolve .ERROR message :Positive and negative amounts are not allowed together