Have a look on inventory dimension group on item card. you can set which dimension you want to be mandatory over there in all over the system.
Ta --- James Flavell <[EMAIL PROTECTED]> wrote: > I hope someone can help me, > > Whenever an inventtrans is created/updated etc I > want to check that one of > the dimensions is set. This is because I have > created an inventory movement > report that assumes the dimension is always set but > I dont want to have to > go round every place in the system and put > mandatory/checks as this will > take forever, so I am hoping there is on place I can > catch this. If the > dimension is blank I would want to give an error and > abort the operation the > user was doing. > > If I was to put such checking in the validatewrite > of the inventtrans I am > not confident as I think it maybe too late as I know > there are a lot of > processing that is done before inventtrans is > finally updated... > > > Thanks > James > > -----Original Message----- > From: Theissen, Annette > [mailto:[EMAIL PROTECTED] > Sent: 25 August 2004 23:50 > To: '[EMAIL PROTECTED]' > Subject: AW: [development-axapta] Rows in a select > > > Try this: > > InventTrans inventtrans; > ; > select count(RecID) from inventtrans where > inventtras.transtype==3; > info(int2str(inventTrans.RecID)); > > The number of records is then stored in > inventTrans.RecID. > Also, please consider using enums instead of > numbers. Here, you ought to > write InventTransType::Purch instead of 3. It > makes the code a lotmore > readable! > > Hope this helps! > > Annette > > > Mit freundlichen Gr��en / Best regards > Dipl. Phys. Annette Thei�en > System Software Entwicklung > ______________________________________________ > Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 > Hannover > Phone: +49/511/94996-0 - Fax: +49/511/94996-900 > mailto:[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> - > http://www.viscom.de <http://www.viscom.de/> > > -----Urspr�ngliche Nachricht----- > Von: Alfonso Collados Arroyo > [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 25. August 2004 16:40 > An: 'Development-Axapta (E-mail) > Betreff: [development-axapta] Rows in a select > > > Hi, > How can i know in a 'select' the number of > registers returned? > For example, > Code: > InventTrans inventtrans; > ; > select inventtrans where > inventtras.transtype==3; > I need to know the number of registers. > > Thanks > > > Yahoo! Groups Sponsor > > ADVERTISEMENT > > > <http://us.ard.yahoo.com/SIG=129585agv/M=298184.5285298.6392945.3001176/D=gr > > oups/S=1705006764:HM/EXP=1093531563/A=2319498/R=0/SIG=11thfntfp/*http://www. > netflix.com/Default?mqso=60185352&partid=5285298> > click here > > > <http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S= > :HM/A=2319498/rand=146572662> > > > _____ > > Yahoo! Groups Links > > > * To visit your group on the web, go to: > http://groups.yahoo.com/group/development-axapta/ > > <http://groups.yahoo.com/group/development-axapta/> > > > * To unsubscribe from this group, send an > email to: > [EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]> > > > * Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > > > [Non-text portions of this message have been > removed] > > > Yahoo! Groups Sponsor > ADVERTISEMENT > > > > > > ---------------------------------------------------------------------------- > -- > Yahoo! Groups Links > > a.. To visit your group on the web, go to: > > http://groups.yahoo.com/group/development-axapta/ > > b.. To unsubscribe from this group, send an > email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > > [Non-text portions of this message have been > removed] > > > __________________________________ Do you Yahoo!? Y! Messenger - Communicate in real time. Download now. http://messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
