Purpose of this diagnostic (OPMDCOGSDiag.sql) is to identify the sales orders which constitute the Deferred COGS account balance.

This will help to get the detailed transaction information for Sales Order/s Order Management, Account Receivables, Inventory and OPM financials sub ledger at the Organization level.  This script is applicable for various scenarios of Standard Sales Order, Return Orders (RMA) coupled with all the applicable OPM costing methods like Standard, Actual and Lot costing. 

OBJECTIVE: The sales order(s) which are at different stages of their life cycle in one spreadsheet at one go.

To collect the information of:

• This will help in:
• Lesser time for data collection.
• Faster diagnosis of the issue.
• Easy collaboration across different modules like  Order Management, Accounts Receivables, Inventory and Cost Management.

 You can download the script from Doc ID 1617599.1 DCOGS Balance Breakup (SO/RMA) and Diagnostic Analyzer in OPM Financials.