Páginas filhas
  • MSFUNDOS - FUNDERSUL - Road System Development Fund of Mato Grosso do Sul

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

CONTENTS

Índice
excludeCONTENTS

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.

  1. Apply the patch of the ticket and run the routine MATA103
  2. 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

MV_PFAPUFD

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

MV_APFUNDS

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). 

Informações
titleImportant!

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.


Informações
titleImportant!

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