Monday, September 14, 2015

Determine if a G/L entry is a result of direct posting (or not)

Scenario:
Why is Gross Profit from Account Schedule Overview is significantly different than Profit from OLAP ?

Steps to investigate:
Make sure that Nett Sales figures from both sources are the same
In most cases, CoGS figures are different
CoGS on Acc. Shed. Overview is sum of balances of accounts number 420000..429999
Filter on G/L Entries table for accounts in that range AND System-Created Entry=No
Entries shown are the ones came from direct-posting

Other thing to consider:
(1)
If Adjust Cost Item Entries batch is still running while OLAP processing is also running, the resulted pivot in Excel may NOT show correct/final Cost Amount (and Profit)
To find out, perform this query on Business Analytics database:

SELECT  MAX(EntryNo_) AS Expr1 FROM  wLedgerEntryDimensionValueEntry

and compare the result with last entry created by ACIE batch (Source Code=INVTADJMT).


(2)
OLAP processing failed?

No comments:

Post a Comment