cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 Expense section of Profit and Loss Statement

david_goldstein
Explorer
0 Kudos

We are new users to SAP B1 running version 9.2. When we run the P & L, the signs on the amounts in the expense section are not showing correctly. They are showing correctly in the Revenue section. Example: Credit Balance revenue accounts are showing as positive amounts in the revenue section. Debit balance accounts are showing as negative amounts in the revenue section. so far, good. Then moving to the Expense section, Debit balance expense accounts are showing as negative amounts. This is incorrect - debit balance expense accounts in the Cost of Sales and other expense categories should show as positive amounts. Is there a setting that we've missed that can correct this? If not, how is this fixed.

Thank you

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi David,

P&L report that you mentioned above is not standard SAP B1, it is customize report which is generated by query.

To get report that you want, you can use crystal report.

You can ask your IT support or your SAP B1 Partner to create it.

Regards,

Rizki W.

david_goldstein
Explorer
0 Kudos

Thank you.

0 Kudos

Hi,

There is no problem with profit and loss statement SAP B1. You should understand the Profit and Loss statement Concept.

Please refer to Lorna Real's (SAP Support) Answer from this thread :

https://archive.sap.com/discussions/thread/900421

For Example :

A/R Invoice Journal

COGS (Debit) USD 900

Inventory (Credit) USD 900

A/R (Debit) USD 1000

Sales (Credit) USD 1000

So the gross profit is ==> Sales - COGS = USD 100 (in Credit)

if you agreed with "Credit Balance revenue accounts are showing as positive amounts in the revenue section". So the Cost of Sales must be the opposite of revenue accounts.

Hope this helps 🙂

Regards,

Rizki W

david_goldstein
Explorer
0 Kudos

Thanks for responding Rizki, but no this does not help ;( The DISPLAY of the account balances in the Expense section is backwards. Here's a very simplified version showing how accountants in the US prepare a P&L:

https://blogs.sap.com/2015/04/22/financial-reporting-in-a-nutshell-simplified/

(Look near the bottom of the page)