on 10-31-2009 2:06 AM
holas
Alguien me puede colaborar informandome como saco un informe de rotacion de inventarios o si tiene un query
Gracias
hola
esto te puede servir
select T1.Itemcode,T1.Dscription,t1.price,T1.Quantity,T1.Docdate,T1.whscode, T1.Docdate,T1.[Dias Rotacion] from ( select T1.Itemcode,T1.Dscription,t1.price,T1.Quantity,T1.Docdate,T1.whscode, datediff(day,Docdate,getdate()) 'Dias Rotacion' from (select T1.Itemcode,T1.Dscription,t1.price,sum(T1.Quantity)Quantity,max(T1.Docdate) docdate,T1.whscode from (select T0.Itemcode,T0.Dscription,T0.Quantity,t0.price,T1.Docdate,T0.whscode from ign1 T0 inner join oign T1 on T0.DocEntry=T1.DocEntry union select T0.Itemcode,T0.Dscription,T0.Quantity,t0.price,T1.Docdate, T0.whscode from pdn1 T0 inner join opdn T1 on T0.DocEntry=T1.DocEntry union select T0.Itemcode,T0.Dscription,T0.Quantity,t0.price,T1.Docdate ,T0.whscode from wtr1 T0 inner join owtr T1 on T0.DocEntry=T1.DocEntry)T1 group by T1.Itemcode,T1.Dscription,t1.price,T1.whscode ) T1) T1 inner join oitw T2 on T1.Itemcode = T2.Itemcode and T1.whscode= T2.whscode where T2.Onhand >0 order by 2,8
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola.
El indicador de rotación de inventario lo puede calcular así:
Indice de Rotación = Ventas del Periodo / Stock Medio
Donde:
- Ventas del Periodo son las ventas en el periodo de tiempo a analizar, reflejadas de acuerdo a las condiciones del negocio, por facturas o netas (Fact, - Nota Cred. + Nota Deb).
- Stock Medio = (Saldo inicial del periodo + Saldo final del periodo)/2.
Intente construir el query y le vamos ayudando.
Fuentes de consulta externas:
Gestión de stocks - Francisca Parra Guerrero - 2005
Gestión de stock - Mikel Mauleon Torres - 2008
Saludos.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
97 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.