Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Amy Axness]

We are on AX 2012 R2.  We do an annual physical inventory, and I am looking for suggestions on how to update the cost price and cost amount in the count journal to the ?weighted average amount instead of the price from the inventory master.  I have tested the following with no success:
1) Export the count journal, update the price in Excel and import it back in to a new journal.  This is an issue because i can’t get the inventory location to populate back into the journal.
2) Use the excel add-in to update the price.  I receive the following message when trying to publish the data back into AX.  It seems to work for a journal that is less than 10 lines, but when I try to update more than that, I get this message on every line.

The only other idea I have it to enter the average cost into the price field on the items so the count journal pulls that cost, then switch it back to the actual price when I’m done.

Does anyone have any other ideas, or successful processes for updating the price in the count journal?

——————————
Amy Axness
Controller
J&D Manufacturing
Eau Claire WI
——————————

[Kimberly Tallman]

Amy, 
Unfortunately, the counting journal is not designed to work this way. Since you’re weighted average, there are varying approaches to this. Typically though, clients update the default cost on the item itself and then make any necessary adjustments at the transaction-level at inventory close. Remember that the cost from the item master is only used (in regards to counting journals) when increasing inventory through a counting journal – you cannot modify the ‘cost’ of an item on the reduction of inventory. 
Suggested steps are below:
1. Run inventory recalc and update latest cost price on items (this is a flag on the item master). 
2. If you don’t have the flag set on the items, you could either do it from the backend/run a script
3. Perform full physical/post journals
4. Assuming this is along with month-end/fiscal period end, run inventory close
5. Make adjustments as-needed to individual transactions
As always, validate the process you want to use in a Test environment first. 
Thanks!
Kim

——————————
Kimberly Tallman
Solution Architect
Hitachi Solutions
Indianapolis IN
——————————
——————————————-

[Eric Piersol]

Are you using the Inventory Close Process each month? 

Are you on Standard Cost or Weighted Average for your Costing Method?

——————————
Eric Piersol
Practice Director, Microsoft ERP
Plus Consulting
Carnegie PA
——————————
——————————————-

[Amy Axness]

Yes, we close inventory every month.
We are weighted average.

——————————
Amy Axness
Controller
J&D Manufacturing
Eau Claire WI
——————————
——————————————-

[Guy Terry]

Hi Amy,

Don’t forget about the ‘Latest cost price’ tick box on the Manage costs fast tab of the Item. This will cause AX to automatically update the cost price on the item. You might find that this keeps it closer to the running average cost price that you are looking for.

——————————
Guy Terry
Application Consultant
Annata
Portsmouth
——————————
——————————————-