Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Trying to write a report that shows Sales Order line items and any Work Orders that have been created for them. I thought I had it when I joined these tables:
SO_SalesOrderDetail to WO1_WorkOrderMaster on SO.SalesOrderNo = WO.MakeForOrderNumber and…