Question

Update Unit Cost on Inventory Part

  • 13 December 2023
  • 4 replies
  • 139 views

Userlevel 5
Badge +8

How do I update unit cost on an inventory part that is set as weighted average?


4 replies

Userlevel 6
Badge +15

@Tenecia.Seeley if this is a Purchase part setup as Weighted Average and Cost Per Part, then the system will automatically update the unit cost every time there is a new PO Line receipt. It will evaluate the cost of the already existing stock and calculate the new unit cost considering the PO Line price.

Userlevel 6
Badge +19

Hello @Tenecia.Seeley 

You can change unit cost on inventory part window. Find your part and go to Costs tab. Click RMB and Modify Level Cost Details

 

 

Write the cost on New Cost column. This will create inventory value increase/inventory value decrease transactions automatically.

 

 

Hope this helps

Userlevel 5
Badge +8

@gumabs that option is greyed out for me?  Do you know how I can open that open to allow me to update it?

Userlevel 6
Badge +19

Hello @Tenecia.Seeley 

This could be a permission issue, can you check your permission set?

Reply