Sage 100

is it possible to add the Quantity on SO and Quantity on PO fields to the Item Inquiry / Maintenance ALE lookup?  I know these fields are in IM_ItemWarehouse which is not one of the available tables in the lookup.  I seem to recall that @David Speck II or someone else posted a solution to this issue.  Something about creating a VI export or something like that and doing so will expose the new fields.  Was I hallucinating again?
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Here you go.  (David's).
For IM_ItemWarehouse, you have to hard-code the warehouse code, and multiples don't work (...at least I could only make the first link work).


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Perfect.  Thanks @Kevin Moyes  ! 
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Original Message:
Sent: 08-09-2022 10:48
From: Kevin Moyes
Subject: Item Inquiry / Maintenance ALE Fields

Here you go.  (David's).
For IM_ItemWarehouse, you have to hard-code the warehouse code, and multiples don't work (...at least I could only make the first link work).


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------