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-----
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] 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-----
Hi all I just want to find item quantity on a given date and inventLocation. How can i find it. Thanks.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Yahoo! Groups Links
|