You’re offline. This is a read only version of the page.
15
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
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..
Share
Report
All responses (
Answers (
