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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |