cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos
869

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Morais,

Share Snapshot for System initialization and Trial Balance to check.

Thanks,

Harshal

0 Kudos

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

0 Kudos

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

Thanks,

Sajith

Former Member
0 Kudos

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

Answers (3)

Answers (3)

tejaswinigaadi
Discoverer
0 Kudos

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
0 Kudos

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

0 Kudos

Anybody has experienced this matter, please leave a comment