Customer Receivables Aging showing negative $ amounts

[Former Member]

My Customer Receivables Aging is showing negative dollar amounts as the balances, however if you drill down to the invoices they show as positive, as does the GL balance. any ideas why?

[Former Member]

The BP balance shows as -xxx.xx (ex: -760.00), however the invoice itself shows as 760.00, both on the document itself and on the drill down from the balance that shows the lines that make up the balance.

The checkbox for Display Credit Balance with Negative sign is not checked.

[jitin_chawla]

Hi Kathy,

The reason for the display of negative on the customer balance is same. As the Display credit amount with negative sign is not checked, the invoices value are displayed negative.

You can check the working in the DEMO Database where the tickbox 'Display credit amount with negative sign' is checked.

Also, you can search for relevant notes in the Service Market Place with the keywords 'Display credit amount negative sign'

Regards,

Jitin

[Former Member]

Hi Kathy,

This is a system setting. Under Administration>System Initialisation>Company Details on the Basic Initialisation tab, there is a setting to display credit balances with negative sign.

This cannot be changed once the system has been transacted

[Former Member]

This is showing on ALL customer BP's. The journal entries on the invoices are accurate (debit to AR, credit to Sales).

[Former Member]

Customer Receivables Aging will be based not only by invoice and credit memo but payment and payment term too.

If all your customers' agings become negative for no reason, log to SAP support ASAP.

[former_member583013]

Where are you seeing negative balances..ae you looking at the summary one line per BP where you see the Future Remit, 0 - 30, ...columns

or are you drilling down into the BP row and seeing them in the individual documents?

By negative are you seeing the balance in brackets like (xxx.xx)

[jitin_chawla]

Hi,

Can you check the whether the following tickbox is checked or unchecked under :

Administration > System Initialization > Company Details > Basic initialization tab > Display Credit Balance with Negative Sign

The box "Display Credit Balance with Negative Sign" will be unchecked.

Also, check the following link :

https://websmp207.sap-ag.de/~sapidb/011000358700000456302007E.zip

Hope it helps.

Regards,

Jitin

[Former Member]

Hi Kathy,

Please check all JE for this customer including the JE already reconciliated. Some inconsistant records might be there.

Thanks,

Gordon