Dynamics 365 Mexico Finance ajuste anual por inflación ledger posting and offset Mexico annual tax adjustment ledger postings due to inflation and index INPC indicators

Wish there is an option to easily setup maintain ledger posting along with offsets accounts when calculating annual inflation due to liabilities annual average ledger main accounts and annual average assets debit accounts factor and amounts multiplied by INPC factors. Wish there is an option to easily calculate Mexico anual tax adjustment due to inflation INPC indicators and as of result of ledger main account average balances. 1. Average annual balance of credits or liabilities ONLY if the average annual balance is greater then the debt debit annual factor, then the originated result WILL BE a annual tax deductible inflation. 2. Average annual balance of debits or assets. ADJUSTMENT CALCULATION (INPC Last month of the fiscal period/INPC of last month) Annual adjustment for inflation deductible-juste anual por inflacion deducible: Average balance of annual credits or liabilities - minus average annual balance of debts or assets). Annual adjustment for inflation liabilities: Ajuste anual por inflación acumulable=Average balance of annual debts AJUSTE ANUAL POR INFLACION ACUMULABLE: Si el saldo promedio anual de las deudas es mayor que el saldo promedio anual de los créditos. La diferencia entre ambos se deberá multiplicar por el factor de ajuste anual y el resultado se considerará Ajuste Anual por Inflación Acumulable. AJUSTE ANUAL POR INFLACION DEDUCIBLE Si el saldo promedio anual de las deudas es menor que el saldo promedio anual de los créditos. La diferencia entre ambos se deberá multiplicar por el factor de ajuste anual y el resultado se considerará Ajuste Anual por Inflación Deducible. REFERENCE: Articulo 45 y 46 LISR Articulo 44 Articulo 18 Fracc. II Art 44 LISR EXAMPLE: CREDITS LEDGER MAIN ACCOUNTS: January: February: March: April: May: June: July: August: September: October: November: December: Total: 438,000 DEBTS LEDGER MAIN ACCOUNTS: January: February: March: April: May: June: July: August: September: October: November: December: Total: 357,000 Annual average credit balances: 438,000/12=36,500 Annual average debt balance: 357,000/12=29,750 Adjustment factor: (INPC 130.813/INPC 122.515)-1= 0.0677 Annual average deductible inflation: (36,500-29,750) * 0.0677 INPC factor of adjustment = $456.97 deduction for inflation amount.