The Discrete_LCM_TransDataDiag.sql script extracts the transactional data from all the relevant tables in the Procure to Pay Cycle with Discrete LCM integration for a selected Purchase Order. It extracts the relevant information from the below product areas:
- Purchasing Information
- Receiving Information
- Landed Cost Information
- Payables Information
- Inventory Information and
- Discrete Financials Information
The data extract is presented in HTML format so to analyze and understand the root cause for the issues like item cost mismatch or incorrect journal entries. This also helps in understanding of any data corruption.
Refer to Doc ID 1677699.1
for an overview of LCM Transactional Data; as well as, how to download and run the Discrete LCM Transactional Data Diagnostic Analyzer, its' input parameters, and a sample output.