on 11-27-2013 7:18 PM
Buenas tardes estimados
Necesito integrar la cuenta contable de costo de ventas que por lo regular toma en cuenta entradas y salidas de materiales, facturas de venta, notas de crédito y asientos.
Alguno ha tenido alguna experiencia que pueda compartir para hacer este reporte?
Se agradece toda orientación
Saludos
Marco
Buenas tardes
con relación al tema, he logrado hacer la consulta que dejo abajo, sin embargo, aun me quedan datos sin cuadrar con la cuenta contable si alguno tiene una idea que me sirva de luz se lo agradeceré.
Saludos
--Devoluciones
SELECT
T0.[DocNum],
T0.[DocDate],
T1.[WhsCode],
T1.[ItemCode],
T1.[Dscription],
-(T1.[Quantity])[Cantidad],
T1.[Price],
-(T1.[LineTotal])[Total]
FROM ORDN T0
INNER JOIN RDN1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.[DocDate] Between [%0] and [%1] and T1.[WhsCode] = [%2]
Union
--Entregas
SELECT T0.[DocNum]
, T0.[DocDate]
, T1.[WhsCode]
, T1.[ItemCode]
, T1.[Dscription]
, T1.[Quantity]
, T1.[Price]
, T1.[LineTotal]
FROM OIGN T0
INNER JOIN IGN1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.[DocDate] Between [%0] and [%1] and T1.[WhsCode] = [%2]
Union
--Factura de clientes
SELECT T0.[DocNum]
, T0.[DocDate]
, T1.[WhsCode]
, T1.[ItemCode]
, T1.[Dscription]
, T1.[Quantity]
, T1.[Price]
, T1.[LineTotal]
FROM OINV T0
INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.[DocDate] Between [%0] and [%1] and T1.[BaseType] Not In ('-1', '15') and T0.[isIns] = 'N' and T1.[WhsCode] = [%2]
Union
--Notas de crédito
SELECT
T0.[DocNum]
, T0.[DocDate]
, T1.[WhsCode]
, T1.[ItemCode]
, T1.[Dscription]
, -(T1.[Quantity])[Cantidad]
, T1.[Price]
, -(T1.[LineTotal])[Total]
FROM ORIN T0
INNER JOIN RIN1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.[DocDate] Between [%0] and [%1] and T1.[WhsCode] = [%2]
Union
--Salidas de mercancias
SELECT
T0.[DocNum]
, T0.[DocDate]
, T1.[WhsCode]
, T1.[ItemCode]
, T1.[Dscription]
, T1.[Quantity]
, T1.[Price]
, T1.[LineTotal]
FROM OIGE T0
INNER JOIN IGE1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.[DocDate] Between [%0] and [%1] and T1.[WhsCode] = [%2]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
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.