Home › Discussions › Questions & Answers › Historical PO Receipt Tracking in Actual Cost Environments

Historical PO Receipt Tracking in Actual Cost Environments

Avatar photoCustomer July 5, 2024 at 4:55 pm

We use Average Costing (Actual Costing) and need a detailed report on Purchase Order (PO) Receipt History over a date range. It must include metrics like prior costed quantity and new onhand quantity, which are crucial for actual costing environments.

Viewing 6 reply threads
  • Author
    Replies
    • Support July 7, 2024 at 10:26 am  

      You should use the CAC PO Receipt History for Actual Costing report. It is specifically designed for non-Standard Cost inventory organizations.

    • Avatar photoCustomer July 9, 2024 at 3:15 am  

      Can this report be used for Standard Cost organizations as well?

    • Support July 10, 2024 at 9:34 am  

      It *may* be used, but the documentation notes that columns such as prior costed quantity, prior cost, and new onhand quantity will have zero or empty values for Standard Cost organizations. The CAC PO Receipt History for Item Costing report may be a better choice for Standard Costing.

    • Avatar photoCustomer July 11, 2024 at 6:29 pm  

      What are the mandatory parameters for defining the time frame of the receipt history?

    • Support July 12, 2024 at 5:26 am  

      The mandatory parameters are ‘Transaction Date From’ and ‘Transaction Date To’, specifying the starting and ending transaction date for the PO Receipt History.

    • Avatar photoCustomer July 13, 2024 at 5:23 am  

      We need to filter this data down to a handful of items. Is there an item number parameter?

    • Support July 14, 2024 at 4:32 am  

      Yes, you can use the ‘Item Number’ parameter to enter a specific item number to review, or leave it blank/null to get all items.

  • Author
    Replies
Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123740

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19780

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14609

How to check if a patch is applied in Oracle EBS 12.2 14379

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14067

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11961

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9896

Migration to Java Web Start in Oracle EBS 12.2 instance 9888

Securing sensitive data with Oracle VPD 7791

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6444

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018