Skip to main content
Solved

Inventory Item Cost analysis


Is there A report or DAC that can show a detailed transactional cost analysis of an item? it should show the unit cost per piece, by PO receipt, including and excluding landed costs.

Please let me know. 

Best answer by Laura02

Hello,

I think you will need a custom report to analyze Purchase prices with and without landed costs. 

Purchase Order Receipt Details report might be used as a starting point - PO Receipt details already offers a range of dates and ability to select by item & vendor.

The PO Receipt includes both the Unit Cost of the Items and the Landed Cost amounts.  However, the Landed Cost amounts at the PO Receipt level are not separated by Item. 

Your custom report will need to join Inventory transactions to report the Landed Costs by item.  Some calculations will be needed.  Possibly, a subreport could be needed to calculate the Landed Costs by item from INTran.

Laura

View original

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • July 19, 2024

Hello,

Did you try Historical Inventory Valuation report, Detail version?

Laura


  • July 21, 2024

@Laura02  

I’m looking to analyze the “purchase” price trend with and without the landed cost, the Historical Inventory Valuation report is based on the inventory value since we use the average valuation method it wont give me that information.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • July 22, 2024

Hello,

I think you will need a custom report to analyze Purchase prices with and without landed costs. 

Purchase Order Receipt Details report might be used as a starting point - PO Receipt details already offers a range of dates and ability to select by item & vendor.

The PO Receipt includes both the Unit Cost of the Items and the Landed Cost amounts.  However, the Landed Cost amounts at the PO Receipt level are not separated by Item. 

Your custom report will need to join Inventory transactions to report the Landed Costs by item.  Some calculations will be needed.  Possibly, a subreport could be needed to calculate the Landed Costs by item from INTran.

Laura


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings