Skip to Content
0

SAP B1 Expense section of Profit and Loss Statement

Apr 05, 2017 at 01:56 PM

93

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Rizki Wicaksana Apr 05, 2017 at 03:04 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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)

0
Rizki Wicaksana Apr 06, 2017 at 01:53 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you.

0