Buen día grupo,
En vista de no recibir mencones y la premura de mi entrega, les compartire el query al cual llegue por si en algun momento necesitan generar un reporte similar, para que inviertan menos tiempo en su generación.
/Activos Fijos/
SELECT
T7.[BalanceAct] AS ‘Balance AF’,
T1.[ItemCode] AS ‘Num. Activo Fijo’,
T1.[ItemName] AS ‘Asset’,
T7.[Code] AS ‘Grupo AF’,
T7.[Descr] AS ‘Desc Grupo AF’,
T7.[ClrAcqACt] AS ‘Compensacion AD’,
T7.[OrdDprAct] AS ‘Amortizacion Normal’,
T7.[OrdDprAcc] AS ‘Amortizacion Acumulada OR’,
T1.[CapDate] AS ‘Acquisition Date’,
T9.[LineTotal] AS ‘Acquisition Value MX’,
Cast(T9.[U_TCHistorico] AS FLOAT) AS ‘RateH’,
T8.[Rate] AS ‘Rate’,
CASE T7.[Code] WHEN ‘Eq Computo’ THEN .30
WHEN ‘Equipo Transp’ THEN .25
WHEN ‘Gastos Inst’ THEN .20
WHEN ‘Herramientas’ THEN .35
WHEN ‘Maquinaria y Eq’ THEN .10
WHEN ‘Mob y Equipo’ THEN .10
ELSE 0 END AS ‘DRate’,
T6.[AcctDtn] AS ‘CuentaGrupo’,
T3.[DocDate] AS ‘Fecha de Compra’,
T2.[Price] AS ‘Costo’,
T4.[DprStart] AS ‘Fecha de Dep_Inicio’,
T4.[DprEnd] AS ‘Fecha de Dep_Final’,
T4.[UsefulLife] AS ‘Vida Util’,
T4.[RemainDays] AS ‘Dias Util’,
T4.[DprType] AS ‘CI. Amortización’,
T5.[APC] AS ‘Valor’,
SUM(T6.[OrdDprAmt]) AS ‘Dep.Acumulada’
FROM [dbo].[OITM] T1
LEFT JOIN [dbo].[PCH1] T2 ON T1.[ItemCode] = T2.[ItemCode]
LEFT JOIN [dbo].[OPCH] T3 ON T2.[DocEntry] = T3.[DocEntry]
LEFT JOIN [dbo].[ITM7] T4 ON T1.[ItemCode] = T4.[ItemCode]
LEFT JOIN [dbo].[ITM8] T5 ON T1.[ItemCode] = T5.[ItemCode]
LEFT JOIN [dbo].[DRN2] T6 ON T1.[ItemCode] = T6.[ItemCode]
LEFT JOIN [dbo].[OADT] T7 ON T1.[AssetClass] = T7.[Code]
INNER JOIN [dbo].[ORTT] T8 ON T1.[CapDate]= T8.[RateDate]
INNER JOIN [dbo].[ACQ1] T9 ON T1.[ItemCode]= T9.[ItemCode]
WHERE T1.[ItemType]=‘F’ AND T4.[PeriodCat]=2018
GROUP BY T1.[ItemCode], T1.[ItemName], T3.[DocDate] , T2.[Price] , T1.[CapDate] , T4.[DprStart], T4.[DprEnd],
T4.[RemainDays], T6.[AcctDtn], T4.[UsefulLife], T4.[DprType] , T5.[APC], T7.[Code], T7.[Descr], T7.[BalanceAct],
T7.[ClrAcqACt], T7.[OrdDprAct], T7.[OrdDprAcc], T8.[Rate], T9.[LineTotal], T9.[U_TCHistorico]
ORDER BY T1.[ItemCode], T1.[ItemName]
Saludos desde México.