D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Mass changing item cost in D365 F&O

  • 1.  Mass changing item cost in D365 F&O

    SILVER CONTRIBUTOR
    Posted Feb 06, 2020 04:33 PM
    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
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Mass changing item cost in D365 F&O

    SILVER CONTRIBUTOR
    Posted Feb 07, 2020 08:54 AM
    Which costing method are you on  Standard, FIFO, etc.?

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

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Mass changing item cost in D365 F&O

    SILVER CONTRIBUTOR
    Posted Feb 07, 2020 09:04 AM
    We use Weighted avg.

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

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: Mass changing item cost in D365 F&O

    TOP CONTRIBUTOR
    Posted Feb 10, 2020 10:24 AM
      |   view attached
    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
    ------------------------------

    Attachment(s)

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: Mass changing item cost in D365 F&O

    SILVER CONTRIBUTOR
    Posted Feb 11, 2020 11:19 AM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: Mass changing item cost in D365 F&O

    SILVER CONTRIBUTOR
    Posted Apr 16, 2020 02:06 PM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role