SmartList Creator

(0) Share

Report

Posted on by totoes

Hello everyone !!

I am attempting to create a SmartList for Items showing their lot numbers and their AVAILABLE quantities of each lot number currently in stock. Needless to say I am struggling to find a Qty Available field to pull into my list so I suspect there is a calculation involved that I could use some assistance on. In the image below I have 2 receipts into GP with different lot numbers and different quantity available. Is there an out of the box way to pull the Qty Available into my SmartList? Does anyone know what the correct calculation for this would be, if not?

Any help is always appreciate. Thanks in advance for your time. Not sure why the image becomes so small and blurry, could use some advice there as well.

Tables used in the above image

Item Quantities

Item Lot Number Master

Item Creditor Master

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: SmartList Creator

Hi,

Your screenshot is so tiny, that it is not readable..

Are you using SmartList Designer or SL Builder (from eOne) to create that new smartlist?

Sometimes it is easier to create a SQL view from the back-end and then use that for SL Designer or Builder..