Skip to Content

SAP B1 Expense section of Profit and Loss Statement

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 05, 2017 at 03:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2017 at 01:53 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded