...

Procedure for Utilization

Credit Reversal - With Product Resale

Requirements

• Environment updated to release 12.1.22.10 or above;

...

Section Entry Adjustment Rule Register. Fill in with Rule header data, where we find the fields:

1. CJ9_CODREG* - Rule Code
2. CJ9_DESCR* - Adjustment Rule Description
3. CJ9_VIGINI* - Start Date of Rule Validity
4. CJ9_VIGFIM* - End Date of Rule Validity
5. CJ9_ID** - Which is related to Table CJA - Entry Adjustment Rule Items.

Section Entries. Fill in the fields related to entry, validity and form codes.

1. CJA_CODREG** - Header Rule Code - To be related to Table CJ9
2. CJA_REGCAL* - Calculation Rule - We will have a standard query with Table F2B, in which the user selects the calculation rule that matches the Adjustment Code rule. In this field, instead of having a calculation in the reflection register, they would create their own calculation.      
3. CJA_CODTAB* - Entry Table - In this field, find available 4 entry tables 5.1.1 (CDO), 5.2 (CDY), 5.3(CC6) and 5.3.4(CCK)
4. CJA_CODLAN* - Entry Code - The table selected in field CJA_CODLAN  CODLAN  updates the standard query, returning the entry codes of each table.
5. CJA_VIGINI* - Entry Validity Start Date - The user enters the start date of entry code validity found in the TXT files downloaded from the website http://sped.rfb.gov.br/
6. CJA_VIGFIM* - Entry Validity End Date - The user enters the end date of entry code validity found in the TXT files downloaded from the website http://sped.rfb.gov.br/
7. CJA_GUIA - Generate Form - In this field, select the code with the rule for generating the Tax Payment Form.
8. CJA_TITULO - Generate Bill - In this field, select the code with the Bill rule, to be registered in routine Financial Rule.
9. CJA_GERMSG - Message Type - This field controls how to generate the message for 01 - Entry Code, in which a message is generated for each entry code, or 02 - Entry Code + Product, if a single message is generated for Entry and Product.
10. CJA_OPER - Operation - Enter the rule x entry code operation type to be used: 01 - Inflow; 02 - Outflow; 03 - Return;  
11. CJA_CNTRL - Operation State - Enter the State control of the Operation. This field functions jointly with the Entry Code. Example: SP000207 if you configure the State of Destination, to display the entry, your Customer must be from São Paulo; otherwise, if your Customer is from Rio de Janeiro and the entry is correct, just change the State from Control to Origin.

Section Values. Fill out the fields with values to inform EFD ICMS IPI records.

1. CJA_NFBASE* - Use ICMS Base - This field offers 3 options - Value / Null / Zero, in case the calculation rule requires setting the ICMS Base to Zero, Value or NULL. If needed, record |BLANK| content in SPED.
2. CJA_NFALIQ* - Use Rate - This field offers 3 options - Value / Null / Zero, in case the calculation rule requires setting the ICMS Rate to Zero, Value or NULL. If needed, record |BLANK| content in SPED.
3. CJA_VALOR* - Use ICMS Value - Use this field to control how the rule interprets ICMS value contents when you need to generate field 7 of record C197, to be understood as Value. In this field, we have a standard query in CIN with Tax rule filter with field CJ9_REGCAL.
4. CJA_VLOUTR* - Use Other ICMS Value - Use this field to control how the rule interprets ICMS value contents when you need to generate field 8 of record C197, to be understood as Other. In this field, we have a standard query in CIN with Tax rule filter with field CJ9_REGCAL.
   
   

Section Messages. Enter the message data to be used in records 0460, C195 and C197.

1. CJA_CODMSG - Message Code - In this field, select the message pre-registered in routine FISA178 - Message Register to be used in EFD ICMS IPI Record C197 field 3. 
2. CJA_CODCPL - Complement Text - In this field, select the message pre-registered in routine FISA178 - Message Register to be used in EFD ICMS IPI Record C195 field 2 and field 3.    
3. CJA_TXTDSC - Description Text - In this field, select the message pre-registered in routine FISA178 - Message Register to be used in EFD ICMS IPI Record C195 field 2 and field 3.

Adjustment Rule Code Utilization Example

Follow the steps below to configure how to use the Adjustment Rule register

1. Make the Registrations
    
   1. Register the Tax

b. Register the NCM Rules

c. Register the Tax Status Code

Image Modified

...

2. Make the Profile Registrations

1. 1. Product Profile
      
      Image Modified
      
      
   2. Operation Profile
      
      
      Image Modified
      
      
      
   3. Participant Profile
      
      Image Modified
      
      
      
      
   4. Origin and Destination Profile
      
      Image Modified
      
 Tax
2. 1. 
      

 3. Tax Document Calculation Rules

1. 1. Calculation Base Rule
      
      

      1. ICMS Base Example
         
         Image Modified
         
         
         

      2. ICMS Base Exempted via Formula Example.
         
         Image Modified

iii. IPI Base Example
Image Modified

b. Rate Rule

Image Modified

c. Bookkeeping Rule

Image Modified

d. Calculation Rule - Tax Documents

In this register, we link the above relationship registers to be used in invoice calculations.

1. 1. 1. ICMS Rule
         
         Image Modified
         
         
      2. FECP Calculation Rule
         
         Image Modified
         
         
      3. Exempted ICMS Calculation Rule
         
         
         Image Modified
         
         
         
      4. IPI Calculation Rule
         Image Modified
 Entry

4. Entry Adjustment Rule

1. 1. Message Rule
      Image Modified
      
      Message with Specific Formula:
      Image Modified
      It is not enough to create the message. The next step is binding the message registered to an entry adjustment rule.
   2. Entry Adjustment Rule
      
      

i. ICMS Example - Entries Tab

Image Modified

The proposal of the register is to centralize the entry codes in the widest adjustment rule possible, so there is no need to create multiple entry adjustment rule registers for similar profiles; therefore, for release 12.1.2210, we have added two fields not illustrated in the example above, in which the user can choose when to use the entry code:

Image Modified

Field Operation - Valid Values (01-Inflow| 02-Outflow| 03-Return)
Field Operation Type - Valid Values (01-Origin State| 02-Destination State)

In the illustration above, we can see that several entry codes have been attributed even from another state, the branch of the example being SP.
Through fields Operation and Operation Type, the user can define when to use the entry code. In the example, an entry code was registered for the State of Rio de Janeiro, in which the fields Operation and Operation Type are respectively configured as "Outflow"|"State of Destination"; that is, the entry code is only displayed when an outgoing invoice is issued with RJ as its State of Destination.

In tab Entries, we also have the field "Message Type" with 3 possible options:

01- Entry Code by Period - In this configuration for EFD ICMS/IPI file creation purposes, the entry codes are grouped by period in accordance with the block in which a specific entry code fits the SPED.
02- Entry Code by Invoice - In this configuration for EFD ICMS/IPI file creation purposes, the entry codes are grouped by invoice in accordance with the block in which a specific entry code fits the SPED. Example: Block C195 and C197.
03- Entry Code by Item - In this configuration, for EFD ICMS/IPI file creation purposes, the entry codes do not have grouping; that is, they are detailed by item, as the record was originally recorded in CDA table.

ii. Tab Values

In tab Values, define how values are displayed in accordance with the entry code. This tab is very useful for the composition of block C197 and similar blocks in SPED FISCAL.

Image Modified

Example of Entry Configuration highlighting the value Other.

Image Modified

iii. Tab Messages

Use this tab to bind the messages registered in routine FISA178 (Message Register). In the example below, the fields are used in various ways:

Image Modified

Note: Fill out the field "Complement Msg Code" to correctly display it in SPED FISCAL.

iv. IPI Example

The IPI dynamic is similar to ICMS.

Image Modified

5. Applying the Invoice Entry Adjustment Rule

1. 1. Rule TRIB03, created with Exempted ICMS, was used in the Entry Adjustment register and will be stated in TAB Entry of the Financial Spreadsheet. This rule aims to calculate the values needed for display in the Entries indicated.
      
      Image Modified
      
      

   2. Rule IPI001 was created for generating "Other Credits" adjustment entry for IPI verification and also for its reflex in block E531 of EFD ICMS/IPI.
      
      
      
      Image Modified
      
      In the IPI verification, the IPI adjustment values from the tax configurator remain separate from values that come through TIO adjustment entries. The example below shows how the verification becomes with both entry types:
      
      Image Modified
      Manual entries keep the current behavior.

...

This register aims to define how to generate financial bills of generic tax verification, linking a financial bill rule to a tax through fields:

Tax: In this field, we define the tax to be processed in generic tax verification, which will need to generate a financial bill with the debit balance of the verification.

Bill Rule: In this field, enter the bill rule to be executed in verification, when generating the financial bill. For further information on how to register a financial rule, refer to https://tdn.totvs.com/x/NBu9Gg

...