The aim of this document is to clarify how the postings system containing CIAP currently works and how to update SF9/SFA Tax tables.
Exemplification
1- Fixed asset generated from entry of incoming document (MATA103) generated with CIAP.
Contextualizing the calculation
Scenario 1: Asset fully posted.
TOTAL:
When 100% of the asset is posted, the ICMS value is fully posted
Important:
Scenario 2 partial postings using appropriation routine (MATA906)
When you post an asset proportionally, the calculation is performed thus: Remaining ICMS value and to proportion based on percentage of posting performed.
% of posting on ICMS TOTAL ((REVERSED VALUE + VALUE ALREADY POSTED/POSTED*% of posting)/100)
We have observed that the % value of posting on ICMS is calculated based on the proportional source value of the asset and the factor analyzed by the tax rule.
For further clarification, we offer the spreadsheet below to exemplify the values at issue:
CIAP - example | Reversal | Postings | ICMS Total | 20% of posting |
1183 | 4,612.50 - (Example of 41 installments in the total value reversed 41x112,5) | 0 | 5,400.00 - (rate for the state of SP of 18% on 30,000) | 1,080.00 - (20 on ICMS TOTAL) |
1183 | 922.50 - 20% on reversal | 0 | 5,400.00 | 1080.00 |
1183 | 4612.50 | 157.50 (% of 20 of every reversal already made - % of 20 of ICMS TOTAL) | 5400.00 | 1080.00 |
Analyzing the table, the value left at the end of this process is: ICMS TOTAL - Reversal - Postings = Remaining Value
Exemplifying → 5400 - (4612.50 + 157.50 ) = 630 of remaining ICMS
The value of 157.5 goes to fields N3_BXICMX, FA_VALOR and is increased in field F9_BXICMS
Thus, the ICMS value is always proportional to what remains in table SF9.