Solved

The amount of Inventory Summary vs Inventory Valuation Report

  • 8 September 2022
  • 4 replies
  • 298 views
N
Rank
Userlevel 1

Hi All,

 

I have another question about Inventory Summary and Inventory Valuation Report. I just realized that the amount in those two reports are not the same. Please refer to the screenshot documents below:

In Inventory Valuation Report, the total cost is $80,109.09 which is the correct. However, when I opened Inventory Summary to see the Estimated Cost per unit. Instead of the total cost is $80,109.09, the total cost in Inventory Summary is $80,108. Please refer to the screenshot document below:

 

Please kindly advise why is the amount of total cost is different between two reports. 

 

Thank you

 

Regards,

Nadia

icon

Best answer by Kandy Beatty 9 September 2022, 14:15

View original

4 replies

manikantad18
Rank
Userlevel 7
Badge +12

Hi @nadia02 What is the Amount shown in the Historical inventory valuation report?

Is it possible to share the details of the Inventory valuation excel data to review for any clue

Thanks

Acumatica Functional Consultant
Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @nadia02 

As @manikantad18  What is your valuation method on the actual inventory item?

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
N
Rank
Userlevel 1

Hi @manikantad18, please kindly check the attached screenshot document below for Historical Inventory Valuation which the total amount is similar to Inventory Valuation Report.

 

Hi @kbeatty21, I use FIFO valuation for this item. However, Inventory Summary gives the average of estimated cost per unit.

Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @nadia02  

A few things to look at for your warehouses:

  1. What is the FIFO default returns costing?
  2. Are the locations Cost Separately? 

Here is also what the help explains about FIFO (this may  help you)

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved