[Anilda Pena]

Hello, Is there a way to mass update item cost We have situation were the cost was incorrect when we migrated from AX to D365. I’ve tried the inventory closing>adjustment but it looks like it only allows one at a time.  

Thank you,
Anilda 

——————————
Anilda Pena
Sr. IT Business Analyst
Omniparts Automotive
Franklin TN
——————————

[MICHAEL MILLS]

Which costing method are you on  Standard, FIFO, etc.?

——————————
Michael Mills
AX D365 Enterprise Consultant Operations
Blue Horseshoe Solutions
Carmel, IN
——————————
——————————————-

[Anilda Pena]

We use Weighted avg.

——————————
Anilda Pena
Sr. IT Business Analyst
Omniparts Automotive
Franklin TN
——————————
——————————————-

[Mark Schurmann]

Hi Anilda,

I am by no means an expert on the inventory module, however we had a short-lived business line that required us to make modest use of the inventory modules and had this same issue when it came time to writedown the inventory.  We had some success with the attached spreadsheet which can be imported into D365 using Data Management.  It creates an inventory movement journal.  Note that each item number removes inventory from a site/warehouse at its current value and then move it back into the same site/warehouse at the new value.  The offset account takes the net amount as the write-off expense.

——————————
Mark Schurmann
Accounting Systems Manager
Automobile Protection Corp
Norcross GA
——————————
——————————————-

[Lizzeth Arredondo]

Hello Anilda,

Firstly, do you have physical inventory with the wrong cost? If yes, you should download all inventory on-hand and then make an issue of it by using a inventory movement journal. You can type the lines in mass by using the Add-In tool in Microsoft Excel.

I recommend that you save this file or print the journal for future references.

Once you have done that, you have to do another movement journal for the entries with the right cost of all your inventory. This will correct the cost of the products as they now are entering with the right cost. In our experience, the “Latest cost price checkbox” in the released product details must be active in the item, so this be the price that will be reported. You can read more about the weighted average in this document: https://docs.microsoft.com/en-us/dynamics365/supply-chain/cost-management/running-average-cost-price

If the product does not have existence, there’s a way to change the cost price of the items in mass by using the “Pending and active item prices” entity in the Data Management Workspace. However, to do this you must have an active cost version (it may be a planned cost version or an standard version).

Hope this has been useful.

Best regards!

——————————
Lizzeth Arredondo
GCG – GONZALEZ, CORTINA, GLENDER Y CIA., S.A. DE C.V.
Col. Polanco Chapultepec
——————————
——————————————-

[Anilda Pena]

Lizzeth,

Sorry for late response.  I used your suggestion and was able to update the inventory cost.   
Thank you,
Anilda

——————————
Anilda Pena
Sr. IT Business Analyst
Omniparts Automotive
Franklin TN
——————————
——————————————-