cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 profit & loss statement has recorded a cost transaction twice. Can someone let me know why?

Ladebiyi
Explorer
0 Kudos
261

When I run the general ledger report for the nominal ledger code and view the transactions in the "Account Balance" I can only see one entry (this specific example is for a £17.56 bank charge debited to the Bank Charges account code). However when I run the p/l the total value is exactly £17.56 extra so it looks like SAP has added an extra £17.56 but I don't know why

NB - there are no "BN" entries

Account Balance view:

Ladebiyi_0-1736159107350.png

Profit and loss statement showing £96.32 charge for the period rather than £78.76:

 

Ladebiyi_2-1736159293388.png

 

 

View Entire Topic
Ladebiyi
Explorer
0 Kudos

The solution is:

I have found the solution to my issue by making sure that "Local Currency" is the option selected in the "Display in First Column" section of the Profit and Loss Statement - Selection Criteria (even though both the local and system currency are GBP). My P&L now matches the Trial Balance