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.
Solved
Where is PO line pre-posting info reside
Best answer by Abdul
Hi
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
+20Hi
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
https://www.linkedin.com/in/abdul-rehman-ifscloudexpert/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.