Páginas filhas
  • Postings ATFA036 Partial posting in asset with CIAP

CONTENTS

  1. Overview
  2. Example of use
  3. Tables


01. OVERVIEW

The aim of this document is to clarify how the postings system containing CIAP currently works and how to update SF9/SFA Tax tables.




02. EXAMPLE OF USE


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: 

  1. Asset fully posted without using the appropriation routine (MATA906): When an asset with ICMS of 5400 is posted, fields F9_BXICMS and N3_BXICMS present the same value;
  2. Asset fully posted using the appropriation routine (MATA906): If the asset has already undergone appropriations via routine Tax (MATA906): What has already been reversed will be evaluated on what is being posted - Reversed Value of Asset - full posting value



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.



05. TABLES

  • SFA – CIAP Monthly Reversal
  • SF9 - CIAP Maintenance  
  • SN1 - Fixed Assets  
  • SN3 - Balances and Values  
  • FN6 - Asset Posting  
  • FN7 - Asset Types Posting