Hello Community,
We run inventory on a FIFO valuation and do lot tracing. We have had an increase of new employees training and I unfortunately found that some items in our inventory that were not inputted correctly. We have a list of about 3 items with 3 different lot numbers that are labeled as FG item group but should be R for raw material. In addition, the Cost group should be Materials in stead of FG. When trying to change the classifications, I get the error "A change of the item group can lead to reconciliation issues, because inventory transactions exist for item." What is the best way to fix this and not have any issues with reconciliation?
Please help.
Hi,
You can lower your inventory to zero balance, change the item group and re load the transactions.
I believe the only issue with that is that when I zero out the quantity of inventory, change the item group, and count the inventory back it will have a financial cost associated with the updated pricing as of today...not the lower cost of that batch from a few weeks back.
During counting you should be able to define the cost amount manually.
Thank you!
Billur,
I have zeroed out all on-hand inventory and that reconciliation warning message still comes up. Will it have any affect on anything else or will it always say that as a general warning? Should I be checking anywhere else or just go ahead and reload the transactions?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 776 Most Valuable Professional
André Arnaud de Cal... 606 Super User 2025 Season 2
Sohaib Cheema 402 User Group Leader
