Páginas filhas
  • FIS0018 MATR914 ISS Template 3

CONTENT

01. OVERVIEW

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.

02. EXAMPLE OF USE

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.

Print

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:
Portrait (Page to Page Printing)
Landscape (group Invoices)

Note 1

Information that will be printed in the report's Notes field. If canceled invoices are present, they will be printed first,
followed by the information entered. For landscape mode only.

Note 2

Information that will be printed in the report's Notes field. If canceled invoices are present, they will be printed first,
followed by the information entered. For landscape mode only.

Note 3

Information that will be printed in the report's Notes field. If canceled invoices are present, they will be printed first,
followed by the information entered. For landscape mode only. 

Print receipt

Enter whether to print tax receipts. If so, tax receipts and any invoices on receipts will be printed.
Otherwise, only invoices on receipt will be printed, considering the tax values of the tax receipt. For landscape mode only.

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.  


03. PARAMETERS CONSIDERED WHEN GENERATING THE REPORT


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).
When this parameter of series for conjugated notes is populated, it selects all records, even non-service ones, to build
the numbering from/to with all documents.

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
with ICMS calculation. 

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

MENU CONFIGURATION

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



04. TABLES

  • SF3 – Tax Records