4,818
Hi experts, we have to change the costing method in the item card from the FIFO to Average. But we have posted the items in the entry and we cannot change them directly from the item card. Please advise! Thank you!
*This post is locked for comments
If you already have had item entries for that item, you cannot modify the costing method in the item card by standard change. Using standard tools, you can write-off the remaining quantity to some technical cost account and then accept it back to a new item card which you would create with a new costing method. This will allow to have one cost which is already average, and further you would be able to use this new card normally.
There's an AddOn for that ;) www.ckl-kore.de/.../costing-method-change.html Very elegant solution for this issue.
Best and ideal way is to create new item card and transfer the inventory from old item to new item. This is to avoid any mismatch / issues going forward.
Option 2.
If first one is not feasible, You need to reduce the complete item A inventory to zero. Run adjust cost item entries batch job.
Change Item costing method to Average (you may need to comment the code, which validates the Item Ledger Entry check).
Once you change the costing method, don't forget to uncomment the code.
Subsequently upload the opening balance for Item A.
However I would personally recommend option 1.
You can opt option 2, if you have item transactions very very few (could be less than 10). So even if you face some inventory value mismatch later, you can easily reconcile.
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (