Brazilian Reports
This chapter describes the reports that QAD has developed to meet Brazilian reporting requirements.
Model 3 Report - IPIIntroduces the Model 3 report - IPI requirement and the QAD solution to address this.
Inventory/Shop Floor MovementIntroduces the Inventory/Shop Floor Movement - IPI report requirement and the QAD solution to address this.
Model 7 ReportIntroduces the Model 7 requirement and the QAD solution to address this.
GL Transaction Report – LDDescribes the
Diário reporting guidelines and the QAD solution to address these.
GL Transaction by Account – LD ReportDescribes the
Razão reporting guidelines and the QAD solution to address these.
Withholding Tax AR ReportDescribes the Withholding Tax AR report and how to use it.
Customer Aging Reports - LDDescribes legal document customer aging reports.
Customer Open Item Reports - LDDescribes the customer open item reports.
Subcontract Control ReportDescribes the Subcontract Control Report.
Fiscal Control Report By Effective DateDescribes the Fiscal Control Report by Effective Date.
Model 3 Report - IPI
Business Requirement
In Brazil, companies are legally required to submit a report that displays all movements for both inventory and production transactions. The report must display the inventory and work in process balance for items and sites for each period. Information regarding the transaction cost, the document number, and the type of transaction are also mandatory.
QAD Solution
QAD has developed the Production/Inventory Control report to meet Brazilian Model 3 report - IPI requirements.
Prerequisite
Periodic costing must be calculated for the period before you run the report.
Running the Report
Use Production/Inventory Control (30.5.19.13) to run the report.
Production/Inventory Control Report, Selection Criteria
Item Number
Specify the item number for which you want to report production and inventory details.
Site
Specify the site for which you want to report production and inventory details.
Cost Set
Specify the relevant periodic costing cost set. This field is mandatory.
Print Production Trans
Select Yes to include other operational transactions not directly related to inventory, but that influence product costs.
Select No to exclude other operational transactions and only print inventory transactions.
Tax ID – Federal
Specify the federal tax ID on which you want to report.
For companies, the federal tax ID is the Cadastro Nacional Pessoa Jurídicas, which is the identification number issued to all Brazilian companies by the Ministry of Finance.
For individuals, the federal tax ID is the Cadastro Pessoa Físicas, which is the identification number issued to all Brazilians and Brazil residents who pay taxes or partake in activities that generate revenues.
Tax ID – State
Specify the state tax ID on which you want to report.
Production/Inventory Control Report
