Home › Discussions › Questions & Answers › Margin Reporting: Item Cost vs. Target Selling Price

Margin Reporting: Item Cost vs. Target Selling Price

Avatar photoCustomer January 9, 2020 at 2:01 am

We need a report that compares the Item Master List Price against our Frozen cost (Cost Type 1). We also want to include the Market Price (Standard Price) and the Last PO Price, all converted into a specific target currency for standardization.

Viewing 6 reply threads
  • Author
    Replies
    • Support January 9, 2020 at 6:26 am  

      The CAC Item List Price vs. Item Cost report is designed for this comparison. It compares the item master list price against any cost type (Cost Type 1) and lists the Standard Price (Market Price), Last PO Price, and a converted Last PO Price.

    • Avatar photoCustomer January 10, 2020 at 11:59 am  

      The report description mentions that all prices are converted into the primary UOM and the ‘To Currency Code’. Is setting the ‘To Currency Code’ a mandatory step?

    • Support January 10, 2020 at 10:42 pm  

      While not explicitly listed in the parameter section as mandatory in the excerpt, the description notes that all item costs and prices are displayed in the specified ‘To Currency Code’, implying it is critical for the conversion logic. The conversion logic handles the fact that List Price is typically in a common, global currency.

    • Avatar photoCustomer January 11, 2020 at 5:21 am  

      Can I include a secondary cost type (Cost Type 2) in this comparison?

    • Support January 12, 2020 at 4:49 am  

      Yes, the parameters allow for reporting against a secondary cost type (Cost Type 2).

    • Avatar photoCustomer January 14, 2020 at 3:21 am  

      How does the report handle cancelled PO lines when calculating the Last PO Price?

    • Support January 14, 2020 at 6:21 pm  

      The report includes logic to fix the Last PO price calculation, specifically needing to exclude Cancelled PO Lines.

  • 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™ 123992

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14853

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

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 12113

Migration to Java Web Start in Oracle EBS 12.2 instance 10115

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 10071

Securing sensitive data with Oracle VPD 8062

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

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