web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Changing Item Group on...
Microsoft Dynamics AX (Archived)

Changing Item Group on a Standard Cost Item

(0) ShareShare
ReportReport
Posted on by Liam Lawson 2,830

Hi

The following scenario has happened in a TEST environment only.  I have a standard cost item 812019.  It is a purchased Item used in production.  Multiple transactions have been carried out where this item has been involved.  A standard cost is in place for this item as you would expect.

A decision was made to change the item Group associated with this item - when this was carried out a warning was given by the system - as follows:

"A change of the item group can lead to reconciliation issues, because stock
transactions exist for item 812019. Proceed?"

 

The user did proceed.  Don't you love users.

I'm pretty sure further transactions too place.  The user is now trying to update the standard cost of the item but when they attempt to activate the new pending cost they are getting messages similar to the following:

Warning Message (09:33:24) The transactions on voucher TEE-000016 do not balance as per 11/06/2015. (accounting currency: 18.76 - reporting currency: 26.45)
Info Message (09:33:24)\Voucher transactions Voucher TEE-000016, date 11/06/2015, account 7860--DP30, transaction currency amount 18.76, accounting currency amount 18.76, reporting currency amount 26.45, currency GBP, text
Info Message (09:33:24)\Voucher transactions Voucher TEE-000016, date 11/06/2015, account 2000-BU10-MCC, transaction currency amount -18.76, accounting currency amount -18.76, reporting currency amount -26.45, currency GBP, text

etc. etc.

Info Message (09:33:24)\Voucher transactions Voucher TEE-000016, date 11/06/2015, account 2450-BU10, transaction currency amount 126.48, accounting currency amount 126.48, reporting currency amount 178.34, currency GBP, text
Warning Message (09:33:24) Voucher cannot be posted because it contains errors.
Error Message (09:33:24) Posting has been cancelled.

 

Any advice appreciated.  Is what the user performed something that should not be done?  What is the best course of action?

 

Thanks

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Prashant Singh Profile Picture
    Prashant Singh 8,802 on at

    Check the posting profile setup for standard cost. like standard cost change variance. This issue is related to voucher imbalance.  

  • Liam Lawson Profile Picture
    Liam Lawson 2,830 on at

    Hi

    Thanks for response.  The Posting Profile appears to be setup okay.  Can you elaborate?

  • Suggested answer
    Prashant Singh Profile Picture
    Prashant Singh 8,802 on at

    reason for The transactions on voucher XXXX do not balance as per  xxxx may be the following.

    1. Voucher is having some penny diff. So you need to define in parameter.

    2. Posting profile missing. Means debit site is not equal to credit side.

  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,981 Moderator on at

    Did the old item group and the new item group have different main accounts configured?

    The advice for changing an item's item group is sometimes 'Create a new item, and forget about the old one'!

    However, to safely change an item group (where the accounts are different) involves some or all of the following steps, possibly in this order:

    Make sure all 'documents' containing the item are completely open or closed. i.e. You don't want any received but not invoiced purchase orders, invoice off your delivered sales orders, end any started works orders. If you accrue, for example when a PO is created, I imagine you won't want any open POs either.

    Adjust all inventory of the item to zero.

    Run inventory close (oops - not necessary on a standard costed item!)

    Change the Item group.

    Adjust all inventory back in.

    I don't recall ever doing this; I've only read the theory. Perhaps someone else will add comment....

  • Liam Lawson Profile Picture
    Liam Lawson 2,830 on at

    This works.  Thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans