SAP B1 9.1 Trial Balance shows incorrect Debit Blance and Credit Balance

[former_member228467]

We have configured the SAP B1 system to show debit balance in negative sign and credit balance positive sign by using default configuration in the SAP B1 9.1 PL05.

In the Company Details>Basic Initialization> untick: Display Credit Balance with Negative Sign as default

However, in the Trial Balance shows Debit Balance as Credit and Credit Balance as Debit, so debit and credit balance is incorrectly shown..

Solution is; rename the column header in the Trial Blance

[Former Member · Accepted solution]

Hi Morais,

Share Snapshot for System initialization and Trial Balance to check.

Thanks,

Harshal

[former_member228467 · Accepted solution]

Hi Harshal,

I have attached the couple of Snapshots, let's check the column header. I haven't renamed any column yet. TB Balance Column names should be changed, unless it won't be a correct TB

Thanks,

Sajith

[former_member228467 · Accepted solution]

This should not be any matter of entered system data, this appears like a system bug

Thanks,

Sajith

[Former Member · Accepted solution]

Hi Sajith,

Your settings are correct. I suggest you to raise a ticket to SAP or you may try with upgrade to PL 07.

Thanks,

Harshal

[tejaswinigaadi]

maybe it shows a negative balance because of the opening balance, to include this opening balance in the trial balance, at the trial balance selection criteria, check the opening balance for the period box.

[Former Member]

Hello Sajith,

I would recommend to explore your trial balance with more level such 10. Thereafter try to track which ledger account under the Non-Current and Current assets head is missed matched. Once you track the account which is missed matched, you may open the general ledger report for that respective account and track the entries hitting that account. You may be able to track the issue resulting in mis-match of trial balance amount.

Hope it will help you.

Regards,

Kuldeep

[former_member228467]

Anybody has experienced this matter, please leave a comment