on 03-12-2019 8:01 AM
Hola , me podrian ayudar con esta query , quiero mostrar las ordenes de compra que vienen por detalle la primera parte esta ok , pero quiero unirla con las entradas de mercaderias asociadas y que me muestre las cantidadades recepcionadas con monto.
SELECT DISTINCT CAST(T0.DocNum AS INT) AS 'Numero de Documento', T0.[CardCode], T5.[SeriesName] ,T0.[CardName], isnull(T0.[NumAtCard],'') as Referencia, T0.[TaxDate], T0.[DocDate], T0.[DocStatus], T0.[DocDueDate], T3.[OcrCode4] as 'LineaNegocio', isnull( T3.[OcrCode5],'') as 'ItemGasto', T3.[ItemCode], T3.[Dscription], T3.[Quantity], T0.[DocCur], T3.[PriceBefDi], T3.[LineTotal], T0.[Comments], T0.[DocCur], T0.[DocTotal] - T0.[VatSum] as 'Monto Neto Documento', T0.[VatSum] as Impuesto,T0.[DocTotal] as Total, T2.[Docnum] as 'N° Entrada de mercadería aplicada', CONVERT(VARCHAR(10),T2.[DocDate],126) as 'Fecha de contabilización entrada de mercadería', T2.[Doctotal] - T2.[VatSum] as 'Monto Neto en $ Aplicado o Cerrado', T0.[Doctotal] - T2.[Doctotal] - T0.[VatSum] + T2.[VatSum] as 'Saldo neto orden de compra', FROM OPOR T0 INNER JOIN OCRD T1 ON T0.[CardCode] = T1.[CardCode] INNER JOIN OPDN T2 ON T1.[CardCode] = T2.[CardCode] INNER JOIN POR1 T3 ON T0.[DocEntry] = T3.[DocEntry] INNER JOIN PDN1 T4 ON T2.[DocEntry] = T4.[DocEntry] INNER JOIN NNM1 T5 ON T0.[Series]=T5.[Series] where T0.DocEntry=T4.BaseEntry and T0.DocStatus=T2.DocStatus and T0.DocStatus in ('O','C') and T5.SeriesName='OC_SMI' union all SELECT DISTINCT CAST(T0.DocNum AS INT) AS 'Numero de Documento', T0.[CardCode], T5.[SeriesName] ,T0.[CardName], isnull(T0.[NumAtCard],'') as Referencia, T0.[TaxDate], T0.[DocDate], T0.[DocStatus], T0.[DocDueDate], T3.[OcrCode4] as 'LineaNegocio', isnull( T3.[OcrCode5],'') as 'ItemGasto', T3.[ItemCode], T3.[Dscription], T3.[Quantity], T0.[DocCur], T3.[PriceBefDi], T3.[LineTotal], T0.[Comments], T0.[DocCur], T0.[DocTotal] - T0.[VatSum] as 'Monto Neto Documento', T0.[VatSum] as Impuesto,T0.[DocTotal] as Total, T2.[Docnum] as 'N° Entrada de mercadería aplicada', CONVERT(VARCHAR(10),T2.[DocDate],126) as 'Fecha de contabilización entrada de mercadería', T2.[Doctotal] - T2.[VatSum] as 'Monto Neto en $ Aplicado o Cerrado', T0.[Doctotal] - T2.[Doctotal] - T0.[VatSum] + T2.[VatSum] as 'Saldo neto orden de compra', FROM OPOR T0 INNER JOIN OCRD T1 ON T0.[CardCode] = T1.[CardCode] INNER JOIN POR1 T3 ON T3.[DocEntry]=T0.[DocEntry] INNER JOIN NNM1 T5 ON T0.[Series]=T5.[Series] where T0.DocStatus='O' and T5.SeriesName='OC_SMI'
User | Count |
---|---|
82 | |
8 | |
7 | |
6 | |
6 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.