Query for production order

[former_member685699]

Hi, we are using SAP business one, I would like to create a report to see all the production orders and the components ( such as product description, components details).

Could anyone help?

Thanks

[former_member562014]

Dear May Li,

Following is the very simple query of your requirement.

SELECT T0.[DocNum], T0.[ItemCode], T1.[LineNum], T1.[ItemCode], T3.[ItemName], T1.[BaseQty], T1.[PlannedQty], T1.[IssuedQty], T1.[IssueType], T1.[wareHouse], T1.[OcrCode], T1.[OcrCode2], T1.[OcrCode3], T1.[OcrCode4], T1.[OcrCode5], T1.[Project], T1.[ItemType], T1.[AdditQty], T1.[PickStatus], T1.[PickQty], T1.[ReleaseQty], T1.[StartDate], T1.[EndDate], T1.[StageId], T1.[ReqDays], T1.[Status] 

FROM [dbo].[OWOR] T0 INNER JOIN [dbo].[WOR1] T1 ON T0.[DocEntry] = T1.[DocEntry] 

INNER JOIN OITT T2 ON T0.ItemCode = T2.Code INNER JOIN OITM T3 ON T2.Code = T3.ItemCode

[former_member685699]

Hi, Tariq

Why can't I see "WOR1" under Production order even I have selected "system information"?

[former_member562014]

Will you share some more detail with screen shots.

[former_member685699]

R u able to read? I can see OWOR, but not WOR1.

[kothandaraman_nagarajan]

If you got answer, close this thread by marking correct answer.

[kothandaraman_nagarajan]

Hi,

Try this query,

SELECT T0.[DocNum], T0.[PostDate], T0.[Status], T0.[Type], T0.[ItemCode],T0.[ProdName], T0.[PlannedQty], T0.[CmpltQty], T1.[ItemCode], T1.[ItemName], T1.[PlannedQty], T1.[IssuedQty], T1.[IssueType] FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.[DocEntry] = T1.[DocEntry] GROUP BY T0.[DocNum], T0.[PostDate], T0.[Status], T0.[Type], T0.[ItemCode],T0.[ProdName], T0.[PlannedQty], T0.[CmpltQty], T1.[ItemCode], T1.[ItemName], T1.[PlannedQty], T1.[IssuedQty], T1.[IssueType]

Regards,

Nagarajan

[former_member685699]

Appreciate with your help