Sage 50 - SQL Query (Sales Order Lines / PO Lines)
Budget: $30 – $250 USD
We Need A Sage50 Query Created That Will Report On Ship Status Of Sales Order Lines (Qty Ordered, Qty Shipped, Remaining Qty To Ship) As Well As The Respective PO Details For Those Sales Orders Showing Qty Ordered, Qty Received and Remaining Qty Received.
The PO Records In the Sage 50 JrnlRow Table Have A Link To The Sales Order Number To Link The Two Together.
The report should show all sales order lines whether they have been partially shipped, fully shipped or not shipped at all. The PO details should show similarly lines that have been partially received, fully received or not received at all.
This SQL (actually a Pervasive database) Query Will Be Used To Run A Report Via ODBC.
The PO Records In the Sage 50 JrnlRow Table Have A Link To The Sales Order Number To Link The Two Together.
The report should show all sales order lines whether they have been partially shipped, fully shipped or not shipped at all. The PO details should show similarly lines that have been partially received, fully received or not received at all.
This SQL (actually a Pervasive database) Query Will Be Used To Run A Report Via ODBC.