CONTENTS
01. OVERVIEW
FUNDERSUL calculation and withholding implemented in Microsiga Protheus. FUNDERSUL refers to the Road System Development Fund of Mato Grosso do Sul, which purports to contribute to the development of the road system of Mato Grosso do Sul. This contribution is calculated when the rural producer benefits from ICMS deferral, although the responsibility for the collection is transferred to the buyer of the agricultural product.
02. CONFIGURATION PROCEDURE
The system is updated after applying the update package (Patch) of this ticket.
- Apply the patch of the ticket and run the routine MATA103
- In module Configurator (SIGACFG) access Database / Dictionaries / Database and check the following parameters, or create them if they are missing:
Items/Folders | Description |
Name | MV_UFERMS |
Type | Character |
Cont. in Port. | |
Description | Enter in which currency the UFERMS value will be entered (Fiscal Reference Unit of Mato Grosso do Sul) for Fundersul. |
Example of content: 2
Items/Folders | Description |
Name | |
Type | Character |
Cont. in Port. | "FDS" |
Description | Enter the prefix to be used when generating bills payable related to Fundersul of Mato Grosso do Sul. |
Example of content: "FDS"
Items/Folders | Description |
Name | |
Type | Character |
Cont. in Port. | FUNDERSUL |
Description | Enter the nature to be used when generating bills payable related to Fundersul of Mato Grosso do Sul. |
Example of content: FUNDERSUL
Check the fields in file SX3 – Fields:
SF2 Table - Outgoing Invoices Header
Field | F2_VALFDS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 999,999,999.99 |
Title | FUNDERSUL Val. |
Description | Value of Fundersul |
Used | Yes |
Mandatory | No |
Val. System | MaFisRef("NF_VALFDS","MT100",M-> F2_VALFDS) |
Help | Value calculated in item related to FUNDERSUL (Road System Development Fund of Mato Grosso do Sul) |
SD2 Table - Outgoing Invoice Sales Items
Field | D2_VALFDS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 999,999,999.99 |
Title | FUNDERSUL Val. |
Description | Value of Fundersul |
Used | Yes |
Mandatory | No |
Val. System | MaFisRef("IT_ VALFDS","MT100",M->D2_VALFDS) |
Help | Value calculated in item related to FUNDERSUL (Road System Development Fund of Mato Grosso do Sul) |
Field | D2_PRFDSUL |
Type | Numeric |
Size | 12 |
Decimal | 8 |
Format | @E 999.99999999 |
Title | FUNDERSUL% |
Description | Fundersul Percentage |
Used | Yes |
Required | No |
System Val. | |
Help | Percentage of UFERMS (Fiscal Reference Unit of the State of Mato Grosso do Sul) used in Fundersul calculation (Road System Development Fund of Mato Grosso do Sul). |
Field | D2_UFERMS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 999,999,999.99 |
Title | UFERMS |
Description | UFERMS Value |
Used | Yes |
Required | No |
Val. System | MaFisRef("IT_UFERMS","MT100",M-> D2_UFERMS) |
Help | Value of UFERMS (Fiscal Reference Unit of the State of Mato Grosso do Sul) used in Fundersul calculation (Road System Development Fund of Mato Grosso do Sul). |
SF1 Table - Incoming Invoices Header
Field | F1_VALFDS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 999,999,999.99 |
Title | FUNDERSUL Val. |
Description | Value of Fundersul |
Used | Yes |
Mandatory | No |
System Val. | MaFisRef("NF_VALFDS","MT100",M-> F2_VALFDS) |
Help | Value calculated in operation related to FUNDERSUL (Road System Development Fund of Mato Grosso do Sul) |
SD1 Table - Outgoing Invoice Purchase Items
Field | D1_VALFDS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 999,999,999.99 |
Title | FUNDERSUL Val. |
Description | Value of Fundersul |
Used | Yes |
Mandatory | No |
Val. System | MaFisRef("IT_ VALFDS","MT100",M->D2_VALFDS) |
Help | Value calculated in item related to FUNDERSUL (Road System Development Fund of Mato Grosso do Sul) |
Field | D1_PRFDSUL |
Type | Numeric |
Size | 12 |
Decimal | 8 |
Format | @E 999.99999999 |
Title | FUNDERSUL% |
Description | Fundersul Percentage |
Used | Yes |
Mandatory | No |
Val. System | |
Help | Percentage of UFERMS (Fiscal Reference Unit of the State of Mato Grosso do Sul) used in Fundersul calculation (Road System Development Fund of Mato Grosso do Sul). |
Field | D1_UFERMS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 999,999,999.99 |
Title | UFERMS |
Description | UFERMS Value |
Used | Yes |
Mandatory | No |
Val. System | MaFisRef("IT_UFERMS","MT100",M-> D2_UFERMS) |
Help | Value of UFERMS (Fiscal Reference Unit of the State of Mato Grosso do Sul) used in Fundersul calculation (Road System Development Fund of Mato Grosso do Sul) |
SFT Table - Tax Records by Invoice Item
Field | FT_VALFDS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | FUNDERSUL Val. |
Description | Value of Fundersul |
Used | Yes |
Mandatory | No |
Val. System |
|
Help | Value calculated in item related to FUNDERSUL (Road System Development Fund of Mato Grosso do Sul) |
Field | FT_PRFDSUL |
Type | Numeric |
Size | 12 |
Decimal | 8 |
Format | @E 999.99999999 |
Title | FUNDERSUL% |
Description | Fundersul Percentage |
Used | Yes |
Mandatory | No |
Val. System | |
Help | Percentage of UFERMS (Fiscal Reference Unit of the State of Mato Grosso do Sul) used in Fundersul calculation (Road System Development Fund of Mato Grosso do Sul). |
Field | FT_UFERMS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | UFERMS |
Description | UFERMS Value |
Used | Yes |
Required | No |
Val. System | |
Help | Value of UFERMS (Fiscal Reference Unit of the State of Mato Grosso do Sul) used in Fundersul calculation (Road System Development Fund of Mato Grosso do Sul). |
Table SF3 - Tax Records:
Field | F3_VALFDS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | FUNDERSUL Val. |
Description | Fundersul Value |
Used | Yes |
Required | No |
System Val. | MaFisRef("LF_VALFDS","MT100",M->F3_VALFDS) |
Help | Value calculated in operation related to FUNDERSUL (Road System Development Fund of Mato Grosso do Sul). |
Table SF4 - Types of Inflow and Outflow:
Field | F4_CLFDSUL |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | FUNDERSUL Cl. |
Description | Calculate Fundersul? |
Used | Yes |
Mandatory | No |
Val. System | |
Help | Enter whether the operation must calculate FUNDERSUL (Road System Development Fund of Mato Grosso do Sul) in internal acquisitions of agricultural products ( seed cotton, peanuts, paddy rice, oats, millet, corn, soy, sorghum, wheat, bulgur or triticale). The calculated contribution value is deducted from the value of the trade note generated, given that the buyer is assuming responsibility for the collection, which would borne by the rural producer at the time of the sale. |
Table SB1 - Generic Product Description:
Field | B1_ PRFDSUL |
Type | Numeric |
Size | 12 |
Decimal | 8 |
Format | @E 999.99999999 |
Title | FUNDERSUL% |
Description | Fundersul Percentage |
Used | Yes |
Mandatory | No |
Val. System | |
Help | Percentage of UFERMS (Fiscal Reference Unit of the State of Mato Grosso do Sul) used in Fundersul calculation (Road System Development Fund of Mato Grosso do Sul). |
Important!
The size of fields that have group may vary depending on the environment used.
03. UTILIZATION PROCEDURES
Incoming Invoice:
- In the Purchases module (SIGACOM), access Updates/Transactions/Incoming Document and click Add
- Select a supplier from Mato Grosso do Sul (natural person)
- Enter the product with the UFERMS percentage entered
- Select a TIO that calculates the FUNDERSUL.
Outgoing Invoice:
- In the Billing (SIGAFAT) module, access Updates/Orders/Sales Orders and click Add
- Select a customer from Mato Grosso do Sul (natural person)
- Enter the product with the UFERMS percentage entered
- Select a TIO that calculates the FUNDERSUL and bill the order.
Generate ICMS Calculation:
- In the Tax Records (SIGAFIS) module, access Miscellaneous/Calculations/ICMS Calculation
- In Calculation parameters, answer the questions Generate Bill? and Generate Collection Form? as Yes, perform the ICMS calculation for the period, to check the Fundersul value to be collected.
- The calculated FUNDERSUL value is displayed in folder Complementary Information, line 30.
- Confirming the calculation, the collection form (with type FUNDERSUL) and the bill payable (with the nature and prefix set in parameters MV_PFAPUFD and MV_APFUNDS) are automatically generated in accordance with configuration of routine questions.
- Check and confirm the data.
Important!
The FUNDERSUL calculation is performed for Incoming and Outgoing Invoices, in operations involving natural persons within the state. For the FUNDERSUL calculation to occur, MV_ESTADO must be set to MS, the TIO in use must have field Cl.Fundersul (F4_CLFDSUL) set to YES, trade note generation must also be set to yes, the UFERMS percentage entered in field Pr.Fundersul (B1_PRFDSUL) must be in the Product Register and parameter MV_UFERMS must be filled out (Example: MV_UFERMS = 2).
04. TABLES
- SB1 – Products
- SF3 – Tax Records
- SFT - Tax Record Items
- SF4 - TES
- SD1 - Incoming Document Items
- SF1 - Outgoing Document Header
- SD2 - Outgoing Document Items
- SF2 - Outgoing Document Header
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas