Linking the Order Master to the Sales Master Table in ExactMAX for AutoGenerated Master Scheduled Orders

 

SELECT Order_Master.ORDNUM_10, CM.NAME_23, CM.COMNT1_23, CM.COMNT2_23, CM.UDFREF_23
FROM
Order_Master
INNER JOIN
SO_Master SM
on LEFT(CUSORD_10,8) = SM.ORDNUM_27
inner join Customer_Master CM on SM.CUSTID_27 = CM.CUSTID_23
WHERE – Add anything here that you need to select the proper record set.