Skip to Content
author's profile photo Former Member
Former Member

Salida masiva de inventario

Buenas tardes

Necesito sacar todos los productos del almacen y dar entrada con un código diferente, existe una forma de exportar todo lo que hay en existencias con lote, como si estuvieran listos para DTW?? y únicamente cambiar el código y dar entrada nuevamente?

Espero haberme explicado, muchas gracias.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 06, 2010 at 09:53 PM

    Puedes armar un template con un query entre la OITM,la OITW y la OIBT para traer tu relacion de articulos con existencia y numeros de lote

    De esta forma acomodas tus columnas para armar de nuevo tu carga con su nuevo ItemCode

    Apoyate en tus templates de cargas iniciales

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Mauricio Quintana G

      Gracias por la guia, posteo mi consultar por si alguno le sirve, tiene detalle pero sirve para lo que requiero

      TOTALES

      select 1 as 'RecordKey', 0 as 'LineNum', 'xxxxxx' as 'AccountCode', T1.ItemCode,T1.WhsCode,t1.OnHand as 'Quantity',0 as 'UnitPrice' from OITM T0 
      inner join OITW T1 on T0.ItemCode=T1.ItemCode 
      where T0.ItmsGrpCod = 148 and T1.OnHand <> 0
      group by T1.ItemCode,T1.WhsCode,t1.OnHand
      order by LineNum
      
      CANTIDAD POR LOTE Y ALMACEN
      
      select 1 as 'RecordKey', 0 as 'LineNum',T1.InDate as AddmisionDate,rank() over (order by T1.ItemCode) as BaseLineNumber, T1.BatchNum,t1.Quantity,T1.ItemCode,T1.WhsCode from OITM T0 
      inner join OIBT T1 on T0.ItemCode=T1.ItemCode 
      where T0.ItmsGrpCod = 148 and T1.Quantity <> 0
      group by T1.ItemCode,T1.WhsCode,T1.BatchNum,t1.Quantity,T1.InDate
      order by BaseLineNumber
      

      Saludos

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.