Generating DEMST - Goods Inventory Statement in Tax Replacement (MATA950 - SIGAFIS)

Generating DEMST:

1. In Normative Instructions, click Parameters.

2. Configure data following the instructions below:

Start Date/End Date

Enter the time period for the calculation.

Normative Instruction

Enter the configuration file name without .INI extension. For this magnetic media, enter DEMST

Target File

Enter the destination file name where the information is generated. Example: DEMST.TXT

Directory

Enter the directory's name where the text file created is saved.

3. After configuring the parameters, click Next on the introduction message screen of configuration wizard.

4. Fill out the specific DEMST data based on the following information:

Statement version:

Enter the tax replacement inventory statement version.

Example: 02.

Category:

Select the category of the company that makes the Product Inventory Statement - Tax Replacement:

a) 2 - General;

b) 6 - Simples Nacional.

Replacement:

Select Yes if the statement is corrective.

Area Code of Contact Phone Number:

Enter the area code of contact phone number.

Area Code of Contact Phone Number:

Enter the area code of the statement's accountant.

Contact Phone Number:

Enter the contact phone number.

Stocktaking Date:

Enter the date of goods information gathering, considering the date of System Group Table Survey ST-DE.

Initial product group:

Enter the group of initial products to be considered in the magnetic file. It must be a valid code.

Final product group:

Enter the group of final products to be considered in the magnetic file. It must be a valid code.

5. Check parameters and confirm them.

Instructions:

This file is based on Product Register and ST Stock Balance Register when the table is Exclusive. When the table is Shared, the file is based on Tax Exception Register, Product Register, and ST Stock Balance Register.

1. To generate the magnetic file correctly, check the stock of tax replacement products through the following register, in Tax Records module:

a) Updates -> Registers -> Tax Replacement Balance

2. Groups of products/goods under tax replacement system must also be checked:

3. The fields listed below must be correctly filled out to generate the magnetic file in the records 01 (Product with MVA) and 02 (Product with list price):

c) Group

Required field for correct validation in the program provided by SEFAZ.

d) Percentage of ICMS Solidário in Inflow - MVA

Only products with tax replacement are displayed, that is, products with the field ICMS Solidário in Inflow filled out and used for base calculation.

e) ICMS Rate

Used to calculate ICMS value because the rate applies the Calculation Basis. If this field is blank, the content used is from the parameter MV_ICMPAD, which has the ICMS rate.

f) Last purchase value

Used to calculate the total value at purchase price.

g) Sales price

Used to calculate the calculation basis.

h) Quantity in product stock

It must be filled out with a valid value, that is, higher than zero, because validation in the program provided by SEFAZ does not accept zeroed amounts. Therefore, if this field is filled out with zero, the record is not considered in the magnetic file generation.

4. If the Product Register table (SB1) is shared, Taxation Group fields must be filled out in tax exception register and in product register to generate the magnetic file correctly. The profit margin field is only checked in the Tax Exception table (SF7). Hence, if any product has the margin of ICMS Solidário filled out in Product Register (SB1 table), the information is not considered, since the only margin considered in this case is the one filled out in tax exception.

5. If the Product Register table (SB1) is exclusive, no information from Tax Exception (SF7 table) is checked. Thus, the information used to generate the magnetic file is from Product Register (SB1 table) and ST Stock Balance Register (SFK table).