Skip to main content

Community,

 

any idea where does the below PO line Pre-posting info resides?  which file name? does these info stay in the same file forever or removed after posted to GL?

We need a quick report that needs these info.

 

Hi ​@ronhu,

Preposting information related to any object can be found in the PRE_ACCOUNTING_TAB, and it remains stored here even after GL posting.

For the Purchase Order line, you can use below SQL statement to get Preposting information.

Hope this helps.

SELECT * FROM PRE_ACCOUNTING
WHERE PRE_ACCOUNTING_ID IN (SELECT PRE_ACCOUNTING_ID
                            FROM PURCHASE_ORDER_LINE
                             WHERE ORDER_NO LIKE NVL('&ORDER_NO','%'))

 

Regards

Abdul Rehman

 

Reply


Terms & ConditionsCookie settings