Skip to Content
Author's profile photo Former Member

Informe de Stock por Almacen

Cordial Saludo:

Comparto informe de stock por almacén.

SELECT T2.[WhsName], T3.[ItmsGrpNam],T0.[ItemCode], T0.[ItemName], T0.[InvntryUom], T1.[OnHand] FROM OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode INNER JOIN OWHS T2 ON T1.WhsCode = T2.WhsCode INNER JOIN OITB T3 ON T0.ItmsGrpCod = T3.ItmsGrpCod WHERE

T2.[WhsName] between [%0] and [%1] and T1.[OnHand] > 0 ORDER BY T3.[ItmsGrpNam] asc

A espera de sus comentarios y sugerencias.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.