Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

Cordial Saludo:

Comparto informe de ordenes de producción:

SELECT T0.[PostDate], T0.[DueDate], T0.[DocNum], T0.[Type] as Tipo, T0.[Status] as Estado, t0.[Series], T3.[SeriesName], T0.[CardCode], T4.[CardName], T0.[ItemCode], T2.[ItemName],T0.[Uom] as UM,  T0.[PlannedQty], T0.[Warehouse], T0.[CmpltQty], T1.[ItemCode], T2.[ItemName], T1.[BaseQty], T1.[PlannedQty], T1.[IssuedQty], T1.[wareHouse], T1.[Project], T0.[Comments] FROM OWOR T0  left JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry left JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN NNM1 T3 ON T0.Series = T3.Series left JOIN OCRD T4 ON T0.CardCode = T4.CardCode WHERE T0.[PostDate] between [%0] and [%1]

A espera de sus comentarios e inquietudes.

Labels in this area