lista de precios

[Former Member]

hola a todos

alguien podria ayudarme consulta donde pueda mostrarme

el precios general, vrs el costos del articulo,

gracias de antemano

[Former Member · Accepted solution]

hola sandra!! no te entiendo lo del precio en general , pero tengo esta consulta, que la podrias ajustar tu gusto, donde estan las listas de precios y los costos por bodega

SELECT T0.ItemCode, T0.ItemName,T0.[SuppCatNum],T0.[MinLevel], T0.[MaxLevel],T0.[OnHand],
  'Stock Bodega 1'=(SELECT T2.[OnHand] FROM OITW T2 WHERE T2.ItemCode = T0.ItemCode AND T2.[WhsCode]='01'),
  'Stock Bodega 2'=(SELECT T2.[OnHand] FROM OITW T2 WHERE T2.ItemCode = T0.ItemCode AND T2.[WhsCode]='02'), 
  'Stock Bodega 3'=(SELECT T2.[OnHand] FROM OITW T2 WHERE T2.ItemCode = T0.ItemCode AND T2.[WhsCode]='03'),
 'Stock Bodega 4'=(SELECT T2.[OnHand] FROM OITW T2 WHERE T2.ItemCode = T0.ItemCode AND T2.[WhsCode]='04'),
  'Stock Bodega 5'=(SELECT T2.[OnHand] FROM OITW T2 WHERE T2.ItemCode = T0.ItemCode AND T2.[WhsCode]='05'), 
  'LISTA 1'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='1'), 
  'LISTA 2'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='2'), 
  'LISTA 3'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='3'),
  'LISTA 4'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='4'),
  'LISTA 5'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='5'),
  'LISTA 6'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='6'),
  'LISTA 7'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='7'),
  'LISTA 8'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='8'),
  'LISTA 9'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='9'),
  'LISTA 10'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='10'),
  'LISTA 11'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='11'),
  'LISTA 12'=(SELECT T1.[Price] FROM ITM1 T1 WHERE T1.ItemCode = T0.ItemCode AND T1.[PriceList]='12'),
  'Costo Bodega 1'=(SELECT T2.[AvgPrice] FROM OITW T2 WHERE T2.ItemCode = T0.ItemCode AND T2.[WhsCode]='01'),
  'Costo Bodega 2'=(SELECT T2.[AvgPrice] FROM OITW T2 WHERE T2.ItemCode = T0.ItemCode AND T2.[WhsCode]='02') 
   FROM OITM T0

[Former Member · Accepted solution]

johanna

muchas gracias, asi era

me sirvio muchisimo, lo que en realidad necesitaba

[Former Member]

Hola Sandra

creo que lo que tu necesitas es el analisis de venta por articulos donde te indica el costo la ganancia etc.. por articulo, si lo requieres por marca , y hay variantes entre pedidos, entrega y factura.