D365 Finance & Operations and Dynamics AX Forum

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
------------------------------

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

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

Original Message:
Sent: Feb 06, 2020 04:32 PM
From: Anilda Pena
Subject: Mass changing item cost in D365 F&O

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
------------------------------

We use Weighted avg.

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

Original Message:
Sent: Feb 07, 2020 08:54 AM
From: MICHAEL MILLS
Subject: Mass changing item cost in D365 F&O

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

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

Original Message:
Sent: Feb 06, 2020 04:32 PM
From: Anilda Pena
Subject: Mass changing item cost in D365 F&O

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 06, 2020 04:32 PM
From: Anilda Pena
Subject: Mass changing item cost in D365 F&O

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 06, 2020 04:32 PM
From: Anilda Pena
Subject: Mass changing item cost in D365 F&O

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 11, 2020 11:19 AM
From: Lizzeth Arredondo
Subject: Mass changing item cost in D365 F&O

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

Original Message:
Sent: Feb 06, 2020 04:32 PM
From: Anilda Pena
Subject: Mass changing item cost in D365 F&O

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
------------------------------