Home Discussions Questions & Answers Inventory Value Report Equivalent to Standard Oracle Reports

Inventory Value Report Equivalent to Standard Oracle Reports

Avatar photoCustomer November 11, 2022 at 4:10 am

We need to generate a comprehensive inventory valuation report that can run across multiple organizations and break down the value by elemental item cost level, encompassing Onhand, Intransit, and Receiving quantities. Which report should I use?

Viewing 6 reply threads
  • Author
    Replies
    • Support November 12, 2022 at 5:50 pm  

      You should use the CST Inventory Value – Multi-Organization (Item Costs) report. This report can be used to report inventory value by Elemental Item Cost level and Quantity Type.

    • Avatar photoCustomer November 13, 2022 at 11:41 pm  

      Does this Blitz Report replace specific standard Oracle reports?

    • Support November 15, 2022 at 4:47 pm  

      Yes, it corresponds to the standard Oracle reports: ‘Elemental Inventory Value Report’ and ‘All Inventories Value Report’. Templates are provided that match the existing standard Oracle report formats.

    • Avatar photoCustomer November 17, 2022 at 1:40 am  

      We sometimes need to include non-costed items in our reports. Are there any restrictions when running this report historically?

    • Support November 17, 2022 at 11:51 am  

      Yes, there is a technical note on this: To run the report including non-costed items, the ‘As of Date’ parameter must be left blank (current date). The report cannot be run historically when including non-costed items due to a bug in the Oracle API used to populate the costing tables.

    • Avatar photoCustomer November 17, 2022 at 9:39 pm  

      The report documentation mentions the output can be analyzed by Ledger, Operating Unit, Organization, Subinventory, Item Category, and Cost Group. How is this flexibility achieved?

    • Support November 19, 2022 at 5:36 am  

      This report is built to allow analysis by those attributes, typically leveraging the pivot aggregation layout templates functionality of Blitz Report.

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

Login with: