Skip to main content
Solved

Landed Cost Layers


I am trying to figure out how to look at the landed costs for a stock item.

We can see the Inventory value but we cannot see ‘how’ these values were determined.

I’m looking for a query or report that would list an item’s cost history, it’s receipts, whether or not the cost came from the purchase, whether or not the cost came from a landed-cost entry, etc.  

Can anyone point me in a direction or give the the DAC’s that might be involved in creating a Generic Inquiry so that we could get at that level of data?

Thank you,

Mike

Best answer by Laura02

Hello,

Where the cost comes from and ability to see the “layers” depends on the Valuation method of your items.

If you are using a layered inventory method like Average, then you can see Landed Cost entries along with merchandise purchase price and COGS in the Inventory Valuation - Detailed version.

Example STANDARD cost (not layered method):

Landed Costs look like “Adjustment” in the above screen shot. This is a Standard Cost item so LC shows $0 and posts to Landed Cost Variance instead. We can see historical transactions - Receipts, Issues (cogs). Cost on the above item will always be Qty X standard cost listed in the Cost/Price tab of the item.

I don’t see a report or inquiry that differentiates Landed Cost adjustments from regular adjustments. Adding the Reason Code to the above report will likely work, to identify LC adjustments.

View original
Did this topic help you find an answer to your question?

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • August 15, 2022

Hello,

Where the cost comes from and ability to see the “layers” depends on the Valuation method of your items.

If you are using a layered inventory method like Average, then you can see Landed Cost entries along with merchandise purchase price and COGS in the Inventory Valuation - Detailed version.

Example STANDARD cost (not layered method):

Landed Costs look like “Adjustment” in the above screen shot. This is a Standard Cost item so LC shows $0 and posts to Landed Cost Variance instead. We can see historical transactions - Receipts, Issues (cogs). Cost on the above item will always be Qty X standard cost listed in the Cost/Price tab of the item.

I don’t see a report or inquiry that differentiates Landed Cost adjustments from regular adjustments. Adding the Reason Code to the above report will likely work, to identify LC adjustments.


  • Author
  • Jr Varsity III
  • 21 replies
  • August 18, 2022

Thank you for your reply Laura.

We can see the adjustments on the Inventory Valuation Detail report but we still don’t have any reports or GI’s that get us down to the ‘layer’ of inventory.  The client is satisfied with the report as presented to her as she can click on the Adjustment links and find out more about what it was that affected the cost of the item.  So you’ve answered the question sufficient for the client.  Thank you.


Forum|alt.badge.img+3
  • Varsity I
  • 205 replies
  • October 31, 2022

Attached is an old query from the inventory training course to show the cost layers. Probably needs to be changed to reflect multi-currency.,  You can also check the box in Inventory Transaction History to include landed cost.


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