Skip to main content
Solved

Avg cost on Sales order


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+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

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
Did this topic help you find an answer to your question?

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? 


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

Hi @RohitBhandurge  Please find the details here

 


joakley
Freshman I
  • Freshman I
  • September 20, 2022

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


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

Hi @manikantad18 

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

 

 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

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

 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
RohitBhandurge wrote:

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

 

That is true also! Thanks @RohitBhandurge 


Forum|alt.badge.img+9
  • Semi-Pro I
  • September 21, 2022

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

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+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


Forum|alt.badge.img
  • Jr Varsity III
  • January 5, 2023

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? 

 

 


Forum|alt.badge.img
  • Freshman I
  • June 13, 2023

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


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