Query - Production Order Cost Summary Report
This is an excellent SAP Business One query showing all material and labor issues into a Production Order along with the associated costs. Additionally, all outgoing costs are also listed, providing a good idea of the actual cost of production. No user defined fields are needed. This SAP Business One query can be used straight out of the box. Simply paste into Query Manager and save.
SELECT
'WIP Issue' AS "Direction",
T0."BaseRef" "WO#",
T0."DocDate" "Trans date",
T0."ItemCode" "Item",
T0."Dscription" "Item Desc",
T0."Quantity" "Qty",
T0."unitMsr" "UOM",
T0."Price" "Cost Per Unit",
T0."LineTotal" "Total Row Cost"
FROM IGE1 T0
WHERE T0."BaseRef" =[%0]
UNION
SELECT
'WIP Receipt' AS "Direction",
T0."BaseRef" "WO#",
T0."DocDate" "Trans date",
T0."ItemCode" "Item",
T0."Dscription" "Item Desc",
T0."Quantity" "Qty",
T0."unitMsr" "UOM",
T0."Price" "Cost Per Unit",
T0."LineTotal" "Total Row Cost"
FROM IGN1 T0
WHERE T0."BaseRef" =[%0]