Exibir origem

01. OVERVIEW

FUMIPEQ calculation and withholding implemented in Microsiga Protheus. FUMIPEQ refers to the Municipal Stimulus Fund for Micro and Small Businesses and aims to contribute to the economic and social development of the city of Manaus by granting workers credit to organize labor for the production of goods and services, in accord with the Municipal Plan for Economic Development.

02. DEPLOYMENT PROCEDURE

Access the Billing (SIGAFAT) module, option Sales Orders (MATA410).
Select a customer that has a Nature that calculates Fumipeq, and the other data for the order, such as Products, TIO, etc.
Click the Spreadsheet in which the FUMIPEQ calculation will be demonstrated.
The calculation is also performed through Outgoing Manual Invoices (MATA920) or Incoming Invoices of Return Type.

Indexes and fields

SF2 Table - Outgoing Invoices Header

Field	F2_VALFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Vl.FUMIPEQ
Description	Fumipeq value
Used	Yes
Required	No
System Val.	MaFisRef("NF_VALFMP","MT100",M-> F2_VALFMP)
*Help*	Calculated value of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	F2_BASEFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Base
Description	FUMIPEQ Calculation Basis
Used	Yes
Required	No
Val. System	MaFisRef("NF_BASEFMP","MT100",M-> F2_BASEFMP)
*Help*	Calculated calculation base of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

SD2 Table - Outgoing Invoice Sales Items

Field	D2_VALFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Val.
Description	FUMIPEQ value
Used	Yes
Required	No
Val. System	MaFisRef("IT_ VALFMP","MT100",M->D2_VALFMP)
*Help*	Calculated value of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	D2_BASEFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Base
Description	FUMIPEQ Calculation Basis
Used	Yes
Required	No
System Val.	MaFisRef("IT_BASEFMP","MT100",M-> D2_BASEFMP)
*Help*	Calculated calculation base of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	D2_ALQFMP
Type	Numeric
Size	5
Decimal	2
Format	@E 99.99
Title	Rate FUMIPEQ
Description	FUMIPEQ Rate
Used	Yes
Required	No
Val. System	MaFisRef("IT_ALQFMP","MT100",M-> D2_ALQFMP)
*Help*	Rate referent to FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

SF1 Table - Incoming Invoices Header.

Field	F1_VALFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Val.
Description	Fumipeq value
Used	Yes
Required	No
System Val.	MaFisRef("NF_VALFMP","MT100",M-> F1_VALFMP)
*Help*	Calculated value of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	F1_BASEFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Base
Description	FUMIPEQ Calculation Basis
Used	Yes
Required	No
System Val.	MaFisRef("NF_BASEFMP","MT100",M-> F1_BASEFMP)
*Help*	Calculated calculation base of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

SD1 Table - Incoming Invoice Sales Items

Field	D1_VALFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Val.
Description	FUMIPEQ value
Used	Yes
Required	No
Val. System	MaFisRef("IT_ VALFMP","MT100",M->D1_VALFMP)
*Help*	Calculated value of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	D1_BASEFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Base
Description	FUMIPEQ Calculation Basis
Used	Yes
Required	No
Val. System	MaFisRef("IT_BASEFMP","MT100",M-> D1_BASEFMP)
*Help*	Calculated calculation base of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	D1_ALQFMP
Type	Numeric
Size	5
Decimal	2
Format	@E 99.99
Title	Rate FUMIPEQ
Description	FUMIPEQ Rate
Used	Yes
Required	No
Val. System	MaFisRef("IT_ALQFMP","MT100",M-> D1_ALQFMP)
*Help*	Rate referent to FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

SFT Table - Tax Records by Invoice Item

Field	FT_VALFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Vl. FUMIPEQ
Description	FUMIPEQ value
Used	Yes
Required	No
Val. System	MaFisRef("IT_ VALFMP","MT100",M->FT_VALFMP)
*Help*	Calculated value of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	FT_BASEFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Base
Description	FUMIPEQ Calculation Basis
Used	Yes
Required	No
Val. System	MaFisRef("IT_BASEFMP","MT100",M->FT_BASEFMP)
*Help*	Calculated calculation base of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	FT_ALQFMP
Type	Numeric
Size	5
Decimal	2
Format	@E 99.99
Title	Rate FUMIPEQ
Description	FUMIPEQ Rate
Used	Yes
Required	No
Val. System	MaFisRef("IT_ALQFMP","MT100",M-> FT_ALQFMP)
*Help*	Rate referent to FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Table SF3 - Tax Records

Field	F3_VALFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Vl.Fumipeq
Description	Fumipeq value
Used	Yes
Required	No
Val. System	MaFisRef("LF_VALFMP","MT100",M->F3_VALFMP)
*Help*	Calculated value of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	F3_BASEFMP
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Fumipeq Base
Description	FUMIPEQ Calculation Basis
Used	Yes
Required	No
Val. System	MaFisRef("LF_BASEFMP","MT100",M->F3_BASEFMP)
*Help*	Calculation base of FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

Field	F3_ALQFMP
Type	Numeric
Size	5
Decimal	2
Format	@E 99.99
Title	Aliq.Fumipeq
Description	Fumipeq Rate
Used	Yes
Required	No
Val. System	MaFisRef("LF_ALQFMP","MT100",M->F3_ALQFMP)
*Help*	Rate referent to FUMIPEQ Municipal Stimulus Fund for Micro and Small Businesses - Manaus

SE1 – Accounts Receivable

Field	E1_FMPEQ
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Val.
Description	Fumipeq value
Used	Yes
Required	No
*Help*	Value of FUMIPEQ tax.

Field	E1_PARCFMP
Type	Character
Size	1
Decimal	0
Format	@!
Title	Parc.FUMIPEQ
Description	Fumipeq tax installment.
Used	Yes
Required	No
*Help*	FUMIPEQ Installment.

SE2 – Accounts Payable

Field	E2_FMPEQ
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	FUMIPEQ Val.
Description	Fumipeq value
Used	Yes
Required	No
*Help*	Value of FUMIPEQ tax.

Field	E2_PARCFMP
Type	Character
Size	1
Decimal	0
Format	@!
Title	Parc.FUMIPEQ
Description	Fumipeq tax installment.
Used	Yes
Required	No
*Help*	FUMIPEQ Installment.

Table SED - Natures

Field	ED_CALCFMP
Type	Character
Size	1
Decimal	0
Format	@!
Title	FUMIPEQ Calc.
Description	Calculate FUMIPEQ
Used	Yes
Required	No
*Help*	Enter whether this nature calculates FUMIPEQ.

Field	ED_PERQFMP
Type	Numeric
Size	5
Decimal	2
Format	@E 99.99
Title	Rate FUMIPEQ
Description	FUMIPEQ Rate
Used	Yes
Required	No
*Help*	Enter the FUMIPEQ rate.

The Calculation is performed for Incoming Invoices or Return Invoices, in which a customer is used with Nature having field FUMIPEQ Calc. (ED_CALCFMQ) set to YES, FUMIPEQ Rate (ED_PERQFMP) greater than zero, and the state of Destination is AM.

03. TABLES

SF2 - Outgoing Invoices Header
SF1 - Incoming Invoices Header
SD2 - Outgoing Invoice Sales Items
SD1 - Incoming Invoice Sales Items
SFT - Tax Records by Invoice Item
SF3 - Tax Records
SED - Natures