Smartlist builder and lot #'s by bin

(0) Share

Report

Posted on by Community Member

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 #.

For example:

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 #?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report

Hello CharC

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,

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Did you come up with a solution to this one? I was wondering if you didn't pull the 'all sites' quantity instead of calculating the quantities using the data in the IV00300 table.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Harry is correct, You can calculate the lot quantity from IV00300 table itself.

Was this reply helpful? Yes No