Hi please ensure these are done with great care and will have an impact on cost and quantity both. Forcefully updating the units of measure thought not a best practise is possible and i have done the same through this code that i have given you
On Wed, Aug 25, 2010 at 6:32 AM, george_spl < george.burr...@solutionpartners.co.nz> wrote: > > > 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<Axapta-Knowledge-Village%40yahoogroups.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] > > > > > -- *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...@tectura.com<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]