Skip to main content
Solved

Where is PO line pre-posting info reside

  • Aug 21, 2025 2:50 PM UTC
  • 1 reply
  • 91 views
Hero (Customer)
Forum|alt.badge.img+16

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.

 

Best answer by Abdul

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

 

View original
Ron H

    1 reply

    Abdul
    Superhero (Partner)
    Forum|alt.badge.img+20
    • Abdul
    • Superhero (Partner)
    • Answer
    • Aug 21, 2025 3:05 PM UTC

    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

     

    https://www.linkedin.com/in/abdul-rehman-ifscloudexpert/
      Terms & ConditionsAccessibility statement