Setting up Order Lookup

 

Lookup

 

Id: MageOrderCnt

Desc: "Count of Magento orders in Sage by MAGORDERID"

Select: "COUNT(*) as 'count'"

From: "OEORDHO"

Where: "OPTFIELD = 'MAGORDERID' AND VALUE = '%1'"