Thank you for this Vishtaspa, I'll see if we can put these instructions to good use.
Feedback from Microsoft is that changing Units of Measure, for items with open and/or closed transactions, has been blocked in AX2009. Suggestion is that we rename item number with wrong Units of Measure, and enter the old code as a new item. I can see the reason for the tightening of the logic here, but clients do mourn some lost features - even features which we'd see as being a bit loose! George --- In Axapta-Knowledge-Village@yahoogroups.com, visti Sethna <visti2...@...> wrote: > > static void TEC_UpdateInvent(Args _args) > > { > > InventTableModule inventTableModule; > > inventTable inventTable; > > ; > > ttsbegin; > > > select forupdate inventTable where inventTable.ItemId == 'XXX'; > inventTable.BOMUnitId = 'YYY'; > // instead of XXX enter item id > // instead of YYY enter Unit id > > inventTable.doUpdate(); > > > > while select forupdate inventTableModule where inventTableModule.ItemId > == 'XXX' > > { > inventTableModule.UnitId = 'YYY'; > // instead of XXX enter item id > // instead of YYY enter Unit id > > inventTableModule.doUpdate(); > > } > > > > ttscommit; > > > > > > > > > > } > > > On Tue, Aug 24, 2010 at 6:51 AM, George Burrell < > george.burr...@...> wrote: > > > > > > > Hello group > > > > > > > > In Version 3, and I think Version 4, it was always possible to change a > > Unit of Measure for an item, provided that there were no open transactions > > for the item. > > > > > > > > In AX2009, we are finding an obstacle here .. the error message is implying > > that there are open transactions when there are not. > > > > > > > > While this is an unusual thing for a client to be doing, I would still like > > to know more background if you have any. > > > > TIA > > George > > > > > > > > > > -- > > *Thanks and Regards* > > ** > > *Vishtaspa N. Sethna*** > > *AX Functional Consultant** > > Tectura > **Level 8, Vibgyor Towers > C-62, G Block, > **Bandra Kurla Complex, > Bandra (E), > Mumbai, Maharashtra, 400051 > INDIA** > Board Tel (+91) 22 **40907152 > ** (+91) 22 4**0907153*** > > *Fax Number (+91) 22 **40907070*** > > *Mobile: (+91) 9833213532* > > *Email: > vishtaspananu.set...@...<https://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241&URL=mailto%3arajesh.degaonkar%40tectura.com> > *** > > *Web: > www.tectura.com<https://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241&URL=https%3a%2f%2fowa.mytectura.com%2fexchweb%2fbin%2fredir.asp%3fURL%3dhttp%3a%2f%2fwww.tectura.com%2f> > *** > > > > *Tectura | Your Business. Our Insight. * > > A worldwide provider of business consulting services. > www.tectura.com<https://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241&URL=http%3a%2f%2fwww.tectura.com%2f> > > [image: Reseller_India_2010] > > [image: presidentsclubhorizontal_2010] >