on 04-05-2017 2:56 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.