I created a smartlist report, but the quantities aren't working quite right. I'm trying to get a breakdown of the quantities in each bin, by lot #. But my report is showing the total quantity of that item for each lot #.
QTY Lot # Item
3.5 1234 A100 (true qty is .50)
3.5 1345 A100 (true qty is 1.5)
3.5 1245 A100 (true qty is 1.5)
Any suggestions for getting the actual quantities by lot #?
I have been working lately on a similar report, which shows the item balances per site per bin along with lot and serial number breakdown details.
I will keep you posted once it is complete,
Mahmoud M. AlSaadi
Dynamics GP Essentials | mahmoudsaadi.blogspot.com