Routine MATR914 aims to demonstrate the information from the ISS Calculation Record Book Template 3.
The data is taken from table SF3 – Tax Records considering incoming and outgoing invoices, the period, and definitions reported in the report parameters.
To use the checking report, you must access the routine from the Reports/Official Tax Records menu and access the ISS Calculation Record Template 3 option:
In the "Parameters" option, questions that are used in the generation of information will be listed as follows:
Field Name | Description of the content |
|---|---|
Month | Enter the reference month for tax calculation. |
Year | Enter the year relative to tax calculation. |
Record | Enter the number of the record to be used in the calculation. |
Calculation Type | Choose the type of calculation from the following options: Every 10 days, every 15 days, or monthly. |
Break per rate | Set whether the report should be broken by rate. |
Prop.Tax Paym.Form No. | Enter the number of the Proprietary Tax Payment Form |
Paym.Form Date | Enter the delivery date of the Proprietary Tax Payment Form. |
Bank | Enter the number of the Bank where the Proprietary Tax Payment Form value will be paid. |
Withh. Tax Paym. Form No. | Enter the number of the Withheld Tax Payment Form. |
Paym.Form Date | Enter the delivery date of the Withheld Tax Payment Form. |
Bank | Enter the number of the Bank where the value of the Withheld Tax Payment Form will be paid. |
Initial Page | Enter the initial page number. |
No. Bundle Pages | Enter the number of pages per bundle. |
Enter what will be printed from the options: Tax Record, Tax Record and Terms, and Terms. | |
CCM Code | Enter the City Taxpayer Code (CCM). |
Tax Record Number | Enter the number of the Tax Record. |
Print Summary Map | In the obligation of bookkeeping of the book according to the Summary Map. This question is only valid if parameter MV_LJLVFIS is set to 2. |
Print mode | Select the print mode: |
Note 1 | Information that will be printed in the report's Notes field. If canceled invoices are present, they will be printed first, |
Note 2 | Information that will be printed in the report's Notes field. If canceled invoices are present, they will be printed first, |
Note 3 | Information that will be printed in the report's Notes field. If canceled invoices are present, they will be printed first, |
Print receipt | Enter whether to print tax receipts. If so, tax receipts and any invoices on receipts will be printed. |
Select Branches | Enter if you want to consider the branches that will be printed or only the registered branch. |
Group by EIN+IM | Enter if the records should be grouped and generated by EIN and City Registration. |
Parameter name | Description |
|---|---|
MV_MT914SR | Series for issuing a combined invoice in the city of Rio de Janeiro to print the ISS Record Template 3 (Landscape). |
MV_LJLVFIS | Set whether to use a new concept for generating SF3 1= old concept, 2= new concept. |
MV_ALIQISS | The ISS rate in cases of provision of services by using percentages defined by the city. |
MV_914ICM | Indicate whether the MATR914 print routine of the ISS Calculation Record will also show records |
MV_MR914AB | Indicate the name of the .TRM file that contains the template for printing the opening term of the MATR914 record. |
MV_MR914EN | Indicate the name of the .TRM file that contains the template for printing the closing term of the MATR914 record. |
Detail of what is printed in each field/column of the report:
Number Field: It will be filled with the number of the Invoice, and can search for the information of fields F3_NFELETR or F3_NFISCAL depending on the Invoice. Valid for the taxed or untaxed notes section.
Serial Field: It will be filled with the F3_SERIE field information. Valid for the taxed or untaxed notes section.
Column BRL (Taxable Economic Transaction): It will be filled with the sum of the fields F3_BASEICM, F3_ISENICM, and F3_OUTICM. However, if the sum results in zero, the field F3_VALCONT will be sent. Valid for the section of taxed notes.
Column BRL (Exempt or Non-Taxable Economic Transaction): It will be filled with the result of the sum of fields F3_ISENICM and F3_OUTICM
Calculation Basis Field: It will be filled with the F3_BASEICM field information.
Incident Tax Field: It will be filled with the F3_VALICM field information.
Services performed by third parties with Tax Withholding – This column states the value of the ISS of the service tax documents that were issued by third parties. Incoming invoices with taxed ISS. It fetches information from field F3_VALICM.
Deductions field –To complete this information, you need to use the entry point MT914DED. It is an entry point for printing the value of deductions in the ISS Record Template 3 (Matr914). This value is for informational purposes only, and no calculation automatically made by the system when issuing the report is changed. More information on the link: http://tdn.totvs.com/x/wrpc
.
Tax Withheld by Third Parties - Rate Field - Filled by entry point MT914RET
Incident Tax Field (E): It will be filled with the F3_VALICM field information.
Own Tax E + F field: Printed according to the data entered in the report parameters.
N Form Option: Prop.Tax Paym.Form No.
From Option: Paym. Form Date
Bank Option: Bank
Tax Withheld by Third Parties Field: Printed according to the data entered in the report parameters.
N Form Option: Withh. Tax Paym. Form No.
From Option: Paym. Form Date
Bank Option: Bank.
Taxable Economic Transaction Field: Sum of fields A + B
Tax Payable Field: Sum of fields E + F
Notes field: Printed according to the data entered in the report parameters.
Options:
Note 1
Note 2
Note 3
If you need to add the report to the menu:
On the Configuration Tool (SIGACFG), access Environments>Files>Menu (CFGX013). Enter the new menu option of SIGAFIS (Tax Records) by following these instructions:
Registration of the CAT83 calculation routine:
Menu | SubMenu | Routine Name | Program |
|---|---|---|---|
Reports | Official Tax Records | Reg. ISS Template 3 | MATR914 |
