Skip to main content
Solved

Avg cost on Sales order

  • Sep 20, 2022 7:05 PM UTC
  • 10 replies
  • 692 views
  • Translate All

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

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

Best answer by ChandraM

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

 

View original

10 replies

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

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

Translate

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

Hi @RohitBhandurge  Please find the details here

 

Translate

joakley
Freshman I
  • Freshman I
  • Sep 20, 2022 7:37 PM UTC

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

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18

Hi @manikantad18 

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

 

 

Translate

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

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

 

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18

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

 

That is true also! Thanks @RohitBhandurge 

Translate

Forum|alt.badge.img+8
  • Semi-Pro I
  • Answer
  • Sep 21, 2022 8:18 PM UTC

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

 

Translate

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

 

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

Translate

Forum|alt.badge.img
  • Jr Varsity III
  • Jan 5, 2023 6:28 PM UTC

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? 

 

 

Translate

  • Jun 13, 2023 6:36 PM UTC

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

Translate