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

[Ladebiyi]

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:

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

[Ladebiyi · Accepted solution]

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 

[jitin_chawla]

Hi,

This cannot be determined with ease what has happened.

A few things may be you can check is by running the detect query in SAP Note 1448514. Another thing which can be checked is by running the following query on the SQL/HANA studio:

Select * from JDT1 where "Account" ="ShortName" and "Account" = '607901' and "Debit" = 17.56;

Select * from JDT1 where "Account" ="ShortName" and "Account" = '607901' and "Credit" = 17.56;

Check if more than one entry, then is there a different in some field value in both or not.

Kr,

Jitin

[Ladebiyi]

Thank you for your response Jitin but I am unable to access any notes.  I have also run the suggested query in SAP and only one entry is displayed

[jitin_chawla]

Hi, To access the SAP note, you need to login with Partner S-User ID and password. Also, may be you can check by running the P/L for the specific period range of the JE to confirm, if the difference value relates to the entry identified or it is some other. Check the JE itself whether values appear properly in the rows. Kr, Jitin

[Ladebiyi]

Unfortunately none of the responses below have provided a resolution.  I've included screenshots of both the P&L and Trial balance

P&L which shows the YTD balance as GBP4,450.34:

Trial Balance  which shows the closing balance of GBP4,432.78:

The Account Balance shows the transactions that took place during the month:

I would like to keep this question marked as unresolved so that maybe if someone else experiences this then they can add to this

[Ladebiyi]

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