Thanks for the fifth time for today() :) ________________________________
Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gönderilmiş: Cum 11.02.2005 16:42 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: RE : RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t You dont' find inventDimParm, you build it. It tell InventSumDateDim what parameter to take from inventDim record. inventDimParm inventDimParm; inventDimParm.ItemIdFlag = true; inventDimParm.InventLocationIdFlag = true; InventSumDateDim::newParameters(myDate, myItemId, inventDim, inventDimParm); Here the method will only take care of the ItemId you pass (myItemId) and the InventLocationId stored in inventDim record (the parameter). Regards, Steeve... -----Message d'origine----- De : Cenk Ince [mailto:[EMAIL PROTECTED] Envoyé : 11 février 2005 09:25 À : Axapta-Knowledge-Village@yahoogroups.com Objet : YNT: RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Thank you Steeve Last question about it : Haw can i find inventDimParm? I can't find it in salesline for example? Best Regards Steeve... ________________________________ Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gönderilmi?: Cum 11.02.2005 15:43 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Actually InventSumDateDim (and other InventSumDate*) DOES NOT give sum of transactions on a date, it really give the qty of an item at a given date. What it does is that it takes the current qty (in InventSum) and roll back to the date (parameter) using the transactions to know what was the inventory qty at that date. Go ahead and try it. ;-) IIRC, InventSumDate will give the qty at the end the day so if you want to know the qty at the beginning of the day you'll probably have to pass (date - 1) has parameter. Regards, Steeve... -----Message d'origine----- De : Cenk Ince [mailto:[EMAIL PROTECTED] Envoyé : 11 février 2005 02:30 À : Axapta-Knowledge-Village@yahoogroups.com Objet : YNT: [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Thansk Steeve Probably i asked my question not a clear way. InventSumDateDim gives the sum of transactions on a date, but i want to calculate qty, at the beginning of date, means sum of transactions before given date. Thanks. ________________________________ Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gönderilmi?: Per 10.02.2005 18:56 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Use method InventSumDateDim::newParameters(). BUT! (Take a deep breath) If you have SP3 and happen to cancel production lines from time to time, make sure those fixs are installed otherwise you may get erroneous results: (I got from MBS) CH_421871 CH_421566_1947 The following is not MBS official but that's what I end up adding to make everything work ok. I ask my VAR to ask MBS about those changes and validate that they are needed, but it's taking forever. I've tested it and they are now in production and its fine. Anyway it's only for report. + After that you will have to change line 15 of InventSumDateValueReport::selectInventTransPostingPhysical() to : group by statusIssue,statusReceipt,packingslipreturned,dateInvent and line 17 InventSumDateDim:: selectInventTransPostingPhysical () to : group by statusIssue,statusReceipt,packingslipReturned For more info about all this mess see discussion 11147 on technet. Steeve... -----Message d'origine----- De : Cenk Ince [mailto:[EMAIL PROTECTED] Envoyé : 10 février 2005 09:07 À : Axapta-Knowledge-Village@yahoogroups.com Objet : How can i find the real invent quantity on time t Hi all I just want to find item quantity on a given date and inventLocation. How can i find it. Thanks. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=129nkp1bc/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108141014/A=2532114/R=2/SIG=12kmnkgnn/*http:/clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1108054614302338> ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/> . Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=1294s20ck/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108215910/A=2532114/R=2/SIG=12khb3qm9/*http:/clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1108129510018306> ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/> . Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=129eaejg6/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108219387/A=2532114/R=2/SIG=12kvbdnns/*http://clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1108132987054383> ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/> . ------------------------ Yahoo! Groups Sponsor --------------------~--> What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> 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/
<<winmail.dat>>
