Skip to main content

Knowledge Center

Deviation between gross margin (GM) calculations

It is normal to have some minor deviations due to agio, but other deviations should be reconciled.

If deviation in the sales amount in the customer billing report and the financial report

  • Start by comparing the sales amount per ledger account in the customer billing report (CUSBILL) and the amount on each GL sales account.

    1. Not all sales accounts are included in the sales report. Inspect the postings against these accounts to make sure that they are correct.

    2. When deviation in the sales amount/-accounts are reconciled, inspect the cost of goods sold (COGS).

Possible reasons for deviation between COGS in the customer billing report and the financial report

  • Manual stock corrections.

    1. Write REP/100172 in the program field.

    2. Write PERIOD:YYYYMM in the filter field.

    3. Press ENTER. In this report you can see if there has been any Stock value adjustments or Stock quantity adjustments for the given period. When pressing enter on row for more details, you will be redirected to REP/100171. For even more details press enter on row and you are redirected to REP/100104.

    This report lists documents where manual stock corrections have been made. The Amount column shows the impact these corrections have on the stock value.

    In cases where goods have been registered into stock with another price than the price on the invoice, normally the Goods Reception (SSA) price will be corrected when the SSA is transferred to an invoice (SIN). The correction will show in the Supgniamount column. If the amount in the Amount column and the Supgniamount column for this item line are equal, it will not generate a deviation in the report. All posting of the type STOCKQTYADJ and STOCKVALADJ will generate a deviation.

  • Invoices (SIN) without any connection to a stock transaction document posted against COGS accounts.

    1. Write SINITEM in the program field.

    2. Write LegacyFilter('SOURCE<>"*SSA*",ACCNO="4*"') in the filter field to list invoices not connected to a shipping advice posted on GL accounts starting with 4.

    3. Press ENTER.

  • Credit notes (SCN) without any connection to a stock transaction document posted against COGS-accounts.

    1. Write ITM/SCN in the program field.

    2. Write SOURCE<>"*SCC*",SOURCE<>"*SRT*",ACCNO="4*" in the filter field to list credit notes not connected to a shipping advice posted on GL accounts starting with 4.

    3. Press ENTER.

  • Supplier invoices that have been credited, where the invoice (SIN) and the credit note (SCN) are posted in separate periods.

  • Manual GL entries not in the default flow of goods.

    1. Write ATRLIST/4* in the program field.

    2. Write TYPE="MAN*" in the filter field to list manual GL entries not connected to normal flow of goods posted on GL accounts.

    3. Press ENTER.

  • CUSBILL will only include documents like sales invoices (CIN) and sales credit notes (CCN). Any other documents (for example SIN and PAY) posted against any of the GL sales account will generate a deviation between CUSBILL and the financial report. To inspect possible other documents posted on sales ledger accounts:

    1. Write CASLIST in the program field.

    2. Write ACCCODE="3*",PERIOD:YYYYMM,DOC&lt;&gt;"C*" in the filter field.

  • Goods transferred from one location to another, where the goods are not confirmed as received at the new location.

  • Manually closed liabilities on the product balance where you have made changes to the provision for liabilities/claims without making equivalent changes in the GL.

    1. Write PROBAL/YYYYMM in the program field.

    2. Write CLOSEDOC="MAN*" in the filter field to list manually closed liabilities on the product balance.

    3. Press ENTER.

  • Shipping advices (CSA) that are not transferred to a sales invoice (CIN). It is the CSA that reduces the value of stock. If the period is closed without the CSA being transferred to a CIN, only the cost of goods sold will registered, not the income.

  • Sales invoices that have been credited, where the sales invoice (CIN) and the sales credit note (CCN) are posted in separate periods.

In this section: