Skip to Content

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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply