Shipment (Sales Orders) Scheduling Report
In SAP Business One, the Open Items List is great for listing all open Sales Orders. But what if you want more? What if you want to see the items to be shipped, inventory availability, and even super user friendly statuses indicating if the Sales Order is ready for Shipment...
Simply copy and past into your Query Generator inside of SAP Business One
SELECT CASE WHEN T1."ShipDate" < CURRENT_DATE THEN 'Late Order' WHEN T1."ShipDate" = CURRENT_DATE THEN 'Ship Now' WHEN T1."ShipDate" > CURRENT_DATE THEN 'Ship Later' ELSE 'No date set' END "When to Ship", CASE WHEN T1."Quantity" <= T2."OnHand" THEN 'Material Available' ELSE 'Material Shortage' END "Material Status", T0."DocNum" "SO No.", T0."CardCode" "BP Code", T0."CardName" "BP Name", T0."DocDate" "Order Date", T1."ShipDate" "Sch Ship Date", T1."ItemCode" "Item", T1."Dscription" "Item Description", T1."Quantity" "Qty to Ship", T2."OnHand" "In Stock", T1."PriceBefDi" "Unit Price", T1."LineTotal" "Line Total" FROM ORDR T0 INNER JOIN RDR1 T1 ON T0."DocEntry" = T1."DocEntry" INNER JOIN OITM T2 ON T1."ItemCode" = T2."ItemCode" WHERE T1."LineStatus" = 'O' ORDER BY T1."ShipDate"