Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Cost Group Correction

(0) ShareShare
ReportReport
Posted on by 258

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.

  • Jsabanovski Profile Picture
    Jsabanovski 258 on at
    RE: Cost Group Correction

    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?

  • Suggested answer
    Jsabanovski Profile Picture
    Jsabanovski 258 on at
    RE: Cost Group Correction

    Thank you!

  • Verified answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,615 Most Valuable Professional on at
    RE: Cost Group Correction

    During counting you should be able to define the cost amount manually.

  • Jsabanovski Profile Picture
    Jsabanovski 258 on at
    RE: Cost Group Correction

    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. 

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,615 Most Valuable Professional on at
    RE: Cost Group Correction

    Hi,

    You can lower your inventory to zero balance, change the item group and re load 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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,996 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,853 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans