Pick List Location
Hello,
Using Postbooks 3.4 and having some difficluty with the pick list printing locations. I found a link in the formum that has a PDF that displays the report with the problmem that is all information is printed except for LOCATION which is blank. Location information is filled in for all of the items in the BOM. "use default location" is checked and a location number is entered for all items.
Any Suggestions?
Pick ListFile Format: PDF/Adobe Acrobat - Quick View
Provided you have default locations for all your items (as you stated), this query will work to produce the information. You still have to match a field with the location on the printout - this is just the query. I'm not sure if this will help for postbooks as this was done in OpenMFG.
SELECT item_number,
uom_name,
item_descrip1,
item_descrip2,
item_type,
womatl_notes,
formatQty(womatl_qtyreq) AS qtyreq,
formatQty(womatl_qtyiss) AS qtyiss,
formatQty(noNeg(womatl_qtyreq - womatl_qtyiss)) AS qtybalance,
itemsite_location_id,
location_name,
CASE WHEN (womatl_issuemethod='S') THEN text('Push')
WHEN (womatl_issuemethod='L') THEN text('Pull')
WHEN (womatl_issuemethod='M') THEN text('Mixed')
ELSE text(womatl_issuemethod)
END AS f_issuemethod
FROM womatl, item, uom, location INNER JOIN itemsite ON location.location_id = itemsite.itemsite_location_id
WHERE ((item_picklist)
AND (womatl_itemsite_id=itemsite_id)
AND (itemsite_item_id=item_id)
AND (womatl_uom_id=uom_id)
AND (womatl_wo_id=%1));