Solved

Avg cost on Sales order

  • 20 September 2022
  • 10 replies
  • 367 views

Userlevel 7
Badge +12

Hello Everyone.

I would like to understand the functionality of Avg cost in sales order 

I have reviewed the Stock Item Price cost and observed that avg cost is 256.85 but in My sales order when the SKU is selected it is showing 303.50

Further, I verified and observed the avg cost value is coming from the inventory summary- Estimated cost column

Just want to understand why the estimated cost value is not updated on the avg cost details under that SKU or else do we have functional calculations on this?

Any thoughts on this? Also, share the article if you have anything related to this.

 

Notes: All receipts are released, No pending transactions for this item with the respective purchasing side

icon

Best answer by ChandraM 21 September 2022, 22:18

View original

10 replies

Userlevel 5
Badge

@manikantad18 - Can you please check what is the Last Vendor Price on Vendors Tab of the Stock Item Profile? 

Userlevel 7
Badge +12

Hi @RohitBhandurge  Please find the details here

 

Userlevel 2

Hi @manikantad18 please check the cost at the warehouse level. The stock item average cost is a blend across all warehouses. 

Userlevel 7
Badge +15

Hi @manikantad18 

@RohitBhandurge  is correct, it is pulling from the Vendor Tab of the item for Last Cost:

 

 

Userlevel 5
Badge

@manikantad18 @kbeatty21 - Also please check for the Costs on Item Warehouse Details as @joakley70 advised. 

 

Userlevel 7
Badge +15

@manikantad18 @kbeatty21 - Also please check for the Costs on Item Warehouse Details as @joakley70 advised. 

 

That is true also! Thanks @RohitBhandurge 

Userlevel 7
Badge +9

Hi @manikantad18 Please find the below details.

Stock Items → Average Cost: The Average Cost fields in the Stock Item screen shows the Average cost for the Qty On Hand on all the Warehouse.

           => Qty On Hand on all Warehouses/ Total Cost

 

Sales Orders → Average Cost: Whereas the Average Cost in Sales Orders Details will show the Average Cost for the Selected Warehouse.

              =>Qty On Hand on selected Warehouse in the SO Line/ Total Cost

Thanks

 

Userlevel 7
Badge +12

 

Hi @ChandrasekharM Thank you for the help.

To every one

 

Avg cost in stock Item is displayed across all the warehouses, when you add the Item in SO the avg cost will be populated based on the warehouse avg cost.

thank you

Userlevel 3
Badge

Hi Folks, I have a question on this topic:

Is it possible to configure Acumatica to use stock item’s general Average Cost instead of Warehouse specific Average Cost for Issue (shipment) Transactions? 

 

 

Is there a way to pull one report with avg cost for all stock items and how? thank you. 

Reply


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