Go to main content
1/88
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Information
Conventions
Part I Setup Requirements
1
Overview
1.1
Overview to Business in Brazil
1.1.1
Financial Reports
1.1.2
Fiscal Books
1.1.3
Nota Fiscal
1.1.4
Banking Requirements
1.1.5
Tax Requirements
1.2
Setup Requirements
2
Set Up User Display Preferences
2.1
Setting up User Display Preferences
3
Set Up Alternate Chart of Accounts and User Defined Codes
3.1
Setting up an Alternate Chart of Accounts
3.2
Setting Up User Defined Codes for Brazil
4
Work with Next Numbers for Brazil
4.1
Working with Next Numbers for Brazil
4.1.1
Setting up Standard Next Numbers for Brazil
4.1.1.1
Setting up standard next numbers
4.1.1.2
Setting up Next Numbers for Nota Fiscal
4.1.1.3
Setting up next numbers for Nota Fiscal
4.1.2
Setting up Next Numbers for Fiscal Books
4.1.2.1
Setting up next numbers for fiscal books
4.1.3
Processing Options
5
Set Up Cross References and Generic Function Key Exits
5.1
Setting Up Company and Plant Cross References
5.2
Setting Up Generic Function Key Exits
5.2.1
What You Should Know About
6
Set Up Order Line Types
6.1
Setting Up Order Line Types
7
Set Up Order Activity Rules
7.1
Setting Up Order Activity Rules
7.1.1
Before You Begin
7.1.2
What You Should Know About
8
Set Up Distribution Messages
8.1
Setting Up Distribution Messages
8.1.1
What You Should Know About
8.1.2
Defining a Message
8.1.3
Messages in Other Languages
8.1.4
Defining Documents on Which to Print Messages
8.1.5
What You Should Know About
8.1.6
Defining Document Type Exceptions
9
Set Up PIS, COFINS, and ISS Taxes
9.1
Overview of PIS, COFINS, and ISS Taxes
9.2
Setting Up UDCs
9.2.1
76B/BC (Base Calculation)
9.2.2
76B/CP (Taxes Concepts)
9.2.3
76B/SO (COFINS Situation Tributary Code)
9.2.4
76B/TT (Tax Types)
9.3
Setting Up Tax Groups
9.4
Setting Up Tax Type Definitions
9.5
Setting Up Tax Type Preferences (Optional)
9.6
Setting Up Tax Values
10
Set Up Transaction Nature Codes
10.1
Setting up Transaction Nature Codes
10.1.1
Understanding Transaction Nature Code Defaults
10.1.2
Before You Begin
11
Set Up Tax Codes
11.1
Setting Up Tax Codes
11.1.1
Before you Begin
12
Set Up ICMS and IPI Tax Rates
12.1
Setting Up ICMS Tax Rates
12.2
Setting Up IPI Tax Rates for Brazil
12.2.1
Before You Begin
13
Enter Additional Address Book Information
13.1
Entering Additional Address Book Information for Brazil
13.1.1
Before You Begin
13.2
Entering Address Book - Customer Master Information
13.3
Entering Address Book - Supplier Master Information
14
Set Up Advanced Pricing for Repasse
14.1
Setting up Advanced Pricing for
Repasse
14.1.1
Verify that Advanced Sales Pricing is Active
14.1.2
Verify User Defined Codes
14.2
Setting Up a Preference Master for Repasse
14.3
Defining a Pricing Hierarchy for
Repasse
14.3.1
Before You Begin
14.3.2
What You Should Know About
14.4
Setting Up Price Groups for
Repasse
14.4.1
Customer and Item Groups
14.4.2
Before You Begin
14.5
Setting Up Customer Price Groups for Repasse
14.5.1
What You Should Know About
14.6
Setting Up Item Price Groups for Repasse
14.6.1
What You Should Know About
14.7
Defining Order Detail Groups for Repasse
14.7.1
What You Should Know About
14.8
Setting Up Price and Adjustment Definitions for Repasse
14.8.1
What You Should Know About
15
Setup AAIs for Brazil Localization Programs
15.1
Setting Up AAIs for Brazil Localization Programs
15.1.1
Before You Begin
Part II Inventory Management and Procurement Requirements
16
Overview to Inventory Management Requirements
16.1
About Inventory Management Requirements
16.2
About Inventory Management
16.3
Address Book
16.4
General Accounting
16.5
Procurement
16.6
Sales Order Management
17
Enter Additional Item Master Information
17.1
About Items with Imported Content
17.2
Entering Additional Item Master Information for Brazil
17.2.1
Before You Begin
17.2.2
What You Should Know About
17.3
Entering Additional Branch/Plant Information for Brazil
17.3.1
Before You Begin
17.4
Setting Up Category Code for Transaction Nature Retrieval
17.5
Setting Up SPED Fiscal Information
18
Obtain and Upload FCI Numbers from SEFAZ
18.1
Overview
18.1.1
Process to Obtain FCI Numbers from SEFAZ
18.1.2
Before You Begin
18.2
Generate the FCI TXT File in Test Mode
18.2.1
Item Data Included in Report and TXT File
18.2.2
Processing Options
18.2.3
Reviewing the Test File Report
18.3
Generate the FCI TXT File in Final Mode to Submit to SEFAZ
18.3.1
Data Included in the TXT File
18.3.2
FCI Statuses
18.4
Upload Returned FCI TXT File
18.4.1
Create a Workfile on Your iSeries Machine
18.4.2
Transfer the Fiscal Authority TXT File to Your iSeries Machine
18.4.3
Review Your PC FCI File in Your iSeries Library
18.4.4
Copy the Content of the PC FCI File to Your Workfile
18.4.5
Review the Copied Workfile for Accuracy
18.5
Update Database Files
18.5.1
Batch Process
18.5.2
Manual Process
18.5.3
Processing Options
19
Overview to Procurement Requirements
19.1
About Procurement Requirements
20
Enter Purchase Orders for Brazil
20.1
Entering Purchase Orders for Brazil
20.1.1
Item Origin and Imported Content Information in Purchase Orders
20.1.2
Processing Options
20.1.3
To enter header information for purchase orders
20.1.4
What You Should Know About
21
Work with Receipts for Procurement
21.1
Working with Receipts for Procurement
21.1.1
Import Information in Purchase Order Receipts
21.1.2
What You Should Know About
21.2
Entering Receipts for Brazilian Procurement
21.2.1
What You Should Know About
21.3
Entering Reversing Receipts for Brazilian Procurement
21.3.1
What You Should Know About
21.3.2
Processing Options
22
Enter Landed Costs Title
22.1
About Landed Costs for Brazil
22.2
Entering Landed Costs During the Receipt Process for Brazil
22.2.1
Before You Begin
22.3
Entering Stand-Alone Landed Costs for Brazil
23
Review and Print Inbound Nota Fiscal
23.1
Reviewing Inbound Nota Fiscal
23.1.1
Processing Options
23.2
Printing Inbound Nota Fiscal
23.2.1
Processing Options
Part III Sales Order Management Requirements
24
Overview to Sales Order Management Requirements
24.1
About Sales Order Management Requirements
25
Enter Additional Information for Sales Orders
25.1
Entering Additional Information for Sales Orders for Brazil
25.1.1
Item Origin and Import Content Information in Sales Orders
25.1.2
Before You Begin
25.1.3
Entering Additional Header Information
25.1.4
Entering Detail Lines
25.1.5
What You Should Know About
25.1.6
Processing Options
26
Confirm Shipments
26.1
Confirming Shipments
26.1.1
Before You Begin
26.1.2
What You Should Know About
26.2
Confirming an Order
26.2.1
Processing Options
27
Generate Outbound Nota Fiscal - Paper Nota Fiscal Type 1
27.1
Generating Outbound Nota Fiscal - Paper Nota Fiscal
27.1.1
Processing Options
28
Review Outbound Nota Fiscal
28.1
Reviewing Outbound Nota Fiscal
29
Revise the Nota Fiscal
29.1
Reviewing Nota Fiscal Text
29.2
Entering Additional Charges
29.2.1
About Additional Charges
29.2.2
Processing Options
30
Print Outbound Nota Fiscal
30.1
Printing Outbound Nota Fiscal
30.1.1
Processing Options
31
Reverse and Void Nota Fiscal
31.1
Processing Reverse and Void Nota Fiscal
31.1.1
Processing Options
32
Updating Sales
32.1
Sales Update - Brazil
32.2
Updating Customer Sales
32.2.1
Before You Begin
32.2.2
What You Should Know About
32.2.3
Processing Options
33
Sales Returns
33.1
Processing Sales Returns
33.1.1
Processing Options
33.2
Sales Order Reverse
33.2.1
Processing Options
34
Additional Order Processes
34.1
Purchase Return
34.2
Entering Transfer Orders for Brazil
34.2.1
Before You Begin
34.2.2
What You Should Know About
34.2.3
Processing Options
Part IV Processing Electronic Nota Fiscal (NFe) Type 3
35
Understanding the Electronic Nota Fiscal Process
35.1
Overview
35.2
Overview of the Electronic Nota Fiscal (NFe) XML File
35.2.1
Legal Access Key
35.2.2
Source of Data for the XML File
35.3
Overview of the Electronic Nota Fiscal (NFe) XML File - Normal Process
35.4
Documento Auxiliar da Nota Fiscal (DANFE) Layout
35.5
Overview of the Electronic Nota Fiscal (NFe) XML File - Contingency Process
35.6
Nota Fiscal Process
35.7
Overview of the NFe and NFCe XML Auxiliary Processes
36
Setup Requirements for Electronic Notas Fiscais
36.1
Set Up Document Types for Notas Fiscais
36.1.1
Document Type (00/DT)
36.2
Set Up Next Numbers
36.3
Set Up Statuses and Order Activity Rules
36.4
Set Up User Defined Codes for Electronic Notas Fiscais
36.4.1
Taxpayer Class (76/CC)
36.4.2
Credit Card Type (76B/A1)
36.4.3
Event Type (76B/ET)
36.4.4
Freight Mode-Tipo do Frete (76B/FM)
36.4.5
Import Declaration Mode(76B/IB)
36.4.6
IBGE - Municipal Code. Brazil (76B/MU)
36.4.7
Distribution Namespace (76B/NE)
36.4.8
Sequence Process (76B/OP)
36.4.9
BCB - Country Code. Brazil (76B/PA)
36.4.10
DANFE Format Fit (76B/PF)
36.4.11
Presence Indicator Code (76B/PR)
36.4.12
Payment Instrument Relationship (76B/PY)
36.4.13
Response Status Code (76B/RS)
36.4.14
IPI Tributary Situation Codes (76B/SI)
36.4.15
ICMS Tributary Situation Codes (76B/SM)
36.4.16
COFINS Tributary Situation Codes (76B/SO)
36.4.17
PIS Tributary Situation Codes (76B/SP)
36.4.18
Nota Fiscal Electronic Status (76B/ST)
36.4.19
Issue Type (76B/TE)
36.4.20
Tax Types (76B/TT)
36.4.21
Transportation Mode (76B/TW)
36.4.22
UTC - Univ. Coordinated Time (76B/TZ)
36.4.23
Branch Plant State (76B/UF)
36.4.24
Layout Version Number (76B/VN)
36.5
Set Up Authorized Persons (Optional)
36.5.1
Processing Options for Authorized Persons
36.6
Address Book Considerations
36.6.1
Set Up IBGE UF Codes (State Codes)
36.6.2
Review Address Book Information
36.6.3
Enter Email Information
36.7
Set Up Distribution Lists and Templates for EPEC
36.7.1
Set Up Address Book Records
36.7.2
Create Distribution Profile
36.7.3
Set Up Transformation Templates
36.7.4
Set Up Database Export Parameters
36.8
Technical Considerations
36.8.1
Set Up Integrated File System (IFS)
36.8.2
Set Up Dream Writer Batch Export Parameters
36.8.2.1
Valid Export File Names
36.8.3
Set up Electronic Nota Fiscal Status Update Trigger
36.8.3.1
Before You Begin
36.8.4
Set up Generic Text Application Windows
36.8.5
Setup for DANFE Barcode
36.8.6
Sales Order Detail (F4211) and Sales Order Detail History (F42119) Data Conversion
36.8.7
Menu Overview
37
Work with Electronic Nota Fiscal (NFe)
37.1
Entering a Sales Order
37.2
Validations for Electronic Notas Fiscais for Final Consumers
37.3
Generating Electronic Nota Fiscal (NFe)
37.3.1
Additional NFe Processes
37.4
Understanding How the XML File Is Created
37.4.1
XML File Names
37.4.2
XML Layout
37.4.3
Before You Begin
38
Entering Fiscal Authority Response (Inbound Information)
38.1
Updating Electronic Nota Fiscal Status Using a Third Party Software
38.1.1
Before You Begin
38.2
Updating Electronic Nota Fiscal Status Interactively
38.2.1
Processing Options
38.3
Checking the Status of an Electronic Nota Fiscal
38.4
Printing the DANFE -- Documento Auxiliar da Nota Fiscal Electrónica
38.4.1
Processing Options
39
Processing Electronic Nota Fiscal (NFe) in Normal Mode
39.1
Generating NFe XML File to be Sent Through Electronic Nota Fiscal (NFe) Normal Process
39.1.1
Before You Begin
39.2
Receiving the Response from the Fiscal Authority
39.2.1
Processing an NFe XML that has been denied by the fiscal authority
39.2.1.1
Updating the NFe Status to Denied (3)
39.3
Processing an NFe XML with Errors
39.3.1
Updating the NFe Status to Error (2)
39.4
Generating a Complete NFe XML Without Numbering (XML Generator Without (P76B601/ZJDE0002)
39.4.1
Before You Begin
39.5
Processing an NFe XML That Has Been Accepted/Approved by Fiscal Authority
39.5.1
Updating the status of the NFe XML to Accepted (1)
39.6
Using Nota Fiscal-e Status Update (P76B650) to review Nota Fiscal Statuses
39.7
Printing the DANFE
39.7.1
Before You Begin
39.8
About Updating Statuses to Cancel or Unused
39.9
Generating a Cancel NFe or Cancel NFCe Request
39.9.1
Before You Begin
39.10
Updating the Status of the NFe or NFCe XML to Cancel
39.11
Generating the Cancel NFe or Cancel NFCe Request
39.11.1
Before You Begin
39.11.2
Generating an Unused NFe or Unused NFCe Request through Cancelled/Unused Nota Fiscal (P76B671)
39.11.2.1
Before You Begin
39.12
Generating an Unused NFe XML through Unused NF-e Numbers (P76B678)
39.12.1
Before You Begin
40
Processing Electronic Notas Fiscais in Contingency Mode
40.1
Processing Electronic Nota Fiscal Using SEFAZ Virtual Contingency
40.1.1
Updating the Status to Contingency SVC-AN (6) or SVC-RS (7)
40.1.2
Generating the SVC-XX NFe XML File (ZJDE0006)
40.1.2.1
Before You Begin
40.1.2.2
XML Output for SVC-XX
40.1.3
Entering the Fiscal Authority Response
40.1.4
Print the DANF-e for SVC-XX
40.2
Processing Electronic Nota Fiscal through Contingency SCAN (Sistema de Contingência do Ambiente Nacional)
40.2.1
Updating the Status of the NFe to SCAN (5)
40.2.2
Generating the SCAN NFe XML File (ZJDE0003)
40.2.2.1
Before You Begin
40.2.3
Entering Fiscal Authority Response
40.2.4
Printing a DANFE Approved through Contingency SCAN
40.2.4.1
Before You Begin
40.3
Processing Electronic Nota Fiscal through Contingency Form (Formulario de Seguranca/Security Form)
40.3.1
Updating the Status of the NFe Form (6)
40.3.2
Changing Electronic Nota Fiscal Number to FS Form Number
40.3.3
Generating Contingency Form XML - XML Generator without Numbering (P76B601/ZJDE0002)
40.3.3.1
Before You Begin
40.3.4
Printing the DANFE through Contingency Form (FS Form) - Pre-printed form
40.3.4.1
Before You Begin
40.4
Processing Electronic Nota Fiscal through Contingency FSDA (Formulario de Seguranca-DA/Security Form DA)
40.4.1
Updating the Status of the NFe to Contingency FSDA (Option 9)
40.4.2
Changing Electronic Nota Fiscal Number to FSDA Form Number
40.4.3
Generating FSDA xml - XML Generator without Numbering (P76B601/ZJDE0002)
40.4.3.1
Before You Begin
40.4.4
Printing the DANFE through Contingency FS -DA
40.4.4.1
Before You Begin
40.4.5
Change NFe Number to Form Number Processing Options
40.5
Processing Electronic Nota Fiscal through Contingency DPEC
40.5.1
Updating the Status of the NFe to DPEC (Option 7 or Option 8)
40.5.2
Generating DPEC-7 or DPEC-8 NFe XML
40.5.2.1
Before You Begin
40.5.3
Updating the Status of an Accepted/Approved DPEC XML
40.5.4
Print the DANFE Processed in Contingency DPEC
40.6
Processing an NFCe through Contingency Offline
40.6.1
Updating the Status of the NFCe to Contingency Offline
40.6.2
Generating the Contingency Offline NFCe XML File
40.6.3
Updating the Status of an Accepted/Approved Contingency Offline XML
40.7
Processing an NFe or NFCe through EPEC Contingency
40.7.1
Updating the Status of the NFe or NFCe
40.7.2
Generating the XML
40.7.3
Updating the Status of an Accepted/Approved Contingency EPEC XML
40.8
Post Contingency Processes
40.8.1
Generating a Complete NFe XML to Send to SEFAZ Fiscal Authority
40.8.2
Updating the Statuses of the NFe Sent through SEFAZ Prior to the Contingency
41
Generating Stand-Alone Nota Fiscal
41.1
Overview
41.2
Entering Header and Detail Information on the Nota Fiscal
42
Understand the Import Electronic Nota Fiscal Process
42.1
Overview
42.1.1
Prerequisites
42.2
Setting Up the System
42.3
Entering the Stand-Alone Imported NFe
42.4
Reviewing Import Electronic Nota Fiscal
42.5
Processing Import Electronic Nota Fiscal
42.6
Generate the XML
42.6.1
Before you Begin
42.7
Nota Fiscal-e Status Update
42.8
Printing the DANFE -- Documento Auxiliar da Nota Fiscal Eletronica
42.8.1
Before you Begin
43
Sales Stand-Alone Electronic Nota Fiscal Process for Brazil
43.1
Understanding the Electronic Sales Stand-Alone Nota Fiscal Process
43.2
Entering the Stand-Alone Sales Order NFe
43.3
Setting Up the System
44
Tax Netting Process
44.1
Processing Tax Netting
44.2
Process Flow for Final Mode
44.2.1
Required Setup
44.2.2
Processing Options
Part V Banking Requirements
45
Overview to Banking Requirements
45.1
About Banking Requirements
46
Maintain Additional Invoice Information for Brazil
46.1
Maintaining Additional Invoice Information for Brazil
46.1.1
Revising Additional Bank Information
46.1.1.1
Before You Begin
46.1.1.2
Alternate Inquiry Forms
46.1.1.3
Processing Options
46.1.1.4
Reviewing the Bank Duplicata
47
Process Automatic Receipts
47.1
Processing Automatic Receipts
47.2
Remitting Bank Data
47.2.1
Before You Begin
47.3
Loading Bank Tape Information
47.3.1
Before You Begin
47.3.2
Releasing the Lock on the System
47.4
Maintaining Bank Tape Information
47.5
Receiving Bank Data
47.5.1
Before You Begin
48
Understanding the Boleto Bar Code Process
48.1
Setting Up the System
48.2
Boleto Bar Code: Document Selection
48.2.1
Opt 01: Bar Code Assignment
48.2.2
814E - Pay Status invalid for Bar Code
48.2.3
Boleto Bar Code - Bar Code Assignment
48.2.4
Boleto Bar Code - Validations
48.2.5
Gross Amount, Due Date and Currency
48.2.5.1
Manual Bar Code:
48.2.5.2
Machine Bar Code:
48.2.6
Create Payment Groups
48.2.7
Work with Payment Groups
48.2.8
Manual Payment with Voucher Match
48.2.9
Inquiry of Supplier Bar Code
49
Work with Payment Terms
49.1
Overview
49.2
Setting Up Due Date Rules
49.2.1
Due Date Ranges
49.3
Setting Up Workday Calendars
49.3.1
What You Should Know About
49.4
Setting Up Payment Term Codes
49.4.1
Payment Term Codes
49.4.2
Simple Payment Terms
49.5
Setting Up Installment Payments
49.5.1
Verifying Installment Payments
50
Work with Automatic Payments
50.1
Working with Automatic Payments
50.2
Assigning Formats to Payment Instruments for Brazil
50.2.1
Before You Begin
50.2.2
Program Versions
50.3
Creating a Payment Group
50.4
Working with Payment Groups for Automatic Payments
50.4.1
Presetting Values for Additional Search Criteria
Part VI Fiscal Reports
51
Fiscal Books
51.1
Overview
51.1.1
Tasks
51.2
Fiscal Books
51.3
Fiscal Note Conversion
51.3.1
Fiscal Note Online - Enter Input/Output Fiscal Note
51.3.1.1
Processing Options
51.4
Fiscal Note Batch Conversion
51.4.1
Process Input Fiscal Note
51.4.1.1
Processing Options
51.4.2
Process Output Fiscal Note
51.4.2.1
Processing Options
51.5
Generate Reports
51.6
Industry
51.6.1
Output Transaction Register Model 2
51.6.1.1
Processing Options
51.6.2
Input Trans. Register Cat. 21
51.6.2.1
Processing Options
51.6.3
Input Transactions Register
51.6.3.1
Processing Options
51.6.4
Output Transactions Register
51.6.4.1
Processing Options
51.7
Commerce
51.7.1
Input Transactions Register
51.7.1.1
Processing Options
51.8
Municipal
51.8.1
DIPAM Declaration
51.8.1.1
Processing Options
51.8.2
DECLAN Declaration
51.8.2.1
Processing Options
51.8.3
Statement Register Complement
51.8.4
ICMS/IPI Statement Report
51.8.4.1
Processing Options
51.9
GIA
51.9.1
Tax Collection Report
51.9.1.1
Processing Options
51.10
ICMS by State
51.10.1
Input Transactions
51.10.1.1
Processing Options
51.10.2
Input Transactions
51.10.2.1
Processing Options for Statement of ICMS - Exits (P76B6051)
51.10.3
Fiscal Note with Retained ICMS
51.10.4
DIPI Register Summary
51.10.4.1
Processing Options
51.10.5
DIPI Register
51.10.5.1
Processing Options
51.10.6
GIA ICMS - Input Transactions
51.10.6.1
Processing Options
51.10.7
GIA ICMS - Output Transactions
51.10.7.1
Processing Options
51.10.8
Create Tape
51.10.8.1
Build ICMS Outfile
51.10.8.2
Processing Options
51.10.9
Interstate Transactions
51.10.9.1
Processing Options
51.10.10
Collection National Guide
51.10.10.1
Setting up Collection National Guide
52
Fiscal Reports Set Up
52.1
As Of Generation
52.1.1
Processing Options
52.2
Fiscal Report Folio Next Number
52.2.1
Setting up fiscal reports folio next numbers
52.3
Opening/Ending Messages
52.3.1
Setting up opening/ending messages
53
Stock Reporting
53.1
Monthly Processes
53.1.1
Generate Inventory Stock Balances
53.1.1.1
What You Should Know About
53.1.1.2
Processing Options
53.2
Generate Fiscal Reports
53.2.1
Generate Inventory Stock Report
53.2.1.1
What You Should Know About
53.2.1.2
Processing Options
53.2.2
Inventory Register by MCU
53.2.2.1
What You Should Know About
53.2.2.2
Processing Options
53.2.3
Stock Production Register
53.2.3.1
What You Should Know About
53.2.3.2
Processing Options
53.2.4
Goods Coding Table
53.2.4.1
What You Should Know About
54
Financial Reports
54.1
About Financial Reports
54.2
General Ledger
54.2.1
Printing the General Ledger
54.2.1.1
Required Setup
54.2.1.2
Processing Options
54.3
Transaction Journal
54.3.1
Printing the Transaction Journal
54.3.1.1
Processing Options
54.4
Account Balance
54.4.1
Printing the Account Balance
54.4.1.1
Processing Options
54.5
Review Account Balance Transaction Journal
54.5.1
Reviewing the Account Balance
54.6
A/R Transaction Ledger
54.6.1
Printing the A/R Transaction Report
54.6.1.1
Required Set-Up
54.6.1.2
Processing Options
54.7
A/P Transaction Work File and A/P Transaction Journal
54.7.1
Printing the A/P Transaction Report and Creating the Work File
54.7.1.1
Required Setup
54.7.1.2
Processing Options for Auxiliary Journal of Accounts Payable (P76B417)
Part VII IN86
55
Work File Creation
55.1
Overview
55.1.1
Accounting Transactions
55.1.1.1
Processing Options
55.1.2
Monthly Account Balance
55.1.2.1
Processing Options
55.1.3
Accounts Receivable
55.1.3.1
Processing Options
55.1.4
Accounts Payable
55.1.4.1
Processing Options
55.1.5
Goods Registers
55.1.5.1
Processing Options
55.2
Merchandise/Service F.N. Issued by Company
55.2.1
Processing Options
55.3
Service F.N. Issued by Company - Non ICMS
55.3.1
Processing Options
55.4
Merchandise/Service F.N. Issued by Other
55.4.1
Processing Options
55.5
Stock Checking
55.5.1
Processing Options
55.5.2
Inventory Register
55.5.2.1
Processing Options
55.6
Bill of Material
55.6.1
Processing Options
55.6.2
Export Transactions
55.6.2.1
Processing Options
55.6.3
Import Transactions
55.6.3.1
Processing Options
56
IN86
56.1
Overview
57
Work Files Maintenance and Inquiry
57.1
Overview
57.2
Main Files
57.2.1
Accounting Transactions
57.2.2
Monthly Account Balances
57.2.2.1
Processing Options for Maintenance for Monthly Balance File (P76B115)
57.2.3
Vendors / Customers
57.2.4
Goods Register
57.2.5
Merchandise/Service Fiscal Note Issued by Company
57.2.6
Services Fiscal Note Issued by Company
57.2.7
Merchandise/Service Fiscal Note Issued by Other
57.2.8
Stock Checking
57.2.9
Inventory Registry
57.2.10
Bill of Material
57.2.10.1
Processing Options
57.3
Complementary Files
57.3.1
Physical / Juridic Person
57.3.2
Chart of Accounts
57.3.3
Cost Center / Branch Plant
57.3.4
Operation Type
57.3.5
Merchandise and Services
57.3.6
Profit and Discount Codes
57.4
Non JD Edwards System Transactions
57.4.1
Export Transactions
57.4.1.1
Processing Options
57.4.2
Import Transactions
57.4.2.1
Processing Options
57.4.3
Payment Sheet
57.4.3.1
Processing Options for Maintenance of Payment Sheet (P76B645)
57.4.4
Employee Register
57.4.4.1
Processing Options for Employee Register Maintenance (P76B655)
58
Text Files Creation and Editing
58.1
Overview
58.2
Main Files
58.2.1
Accounting transactions
58.2.1.1
Processing Options
58.2.1.2
Data Structure
58.2.1.3
Accounts Plan Outfile - Record Length 124 - F76B720
58.2.1.4
Business Unit/Expenditure TXT File - Record Length 81 - F76B740
58.2.2
Monthly Account Balances
58.2.2.1
Processing Options
58.2.2.2
Data Structure
58.2.3
Vendors / Customers
58.2.3.1
Processing Options
58.2.3.2
Data Structure
58.2.4
Goods Register
58.2.4.1
Processing Options
58.2.4.2
Data Structure
58.2.5
Merch/Serv F.N.Issued by Comp
58.2.5.1
Processing Options
58.2.5.2
Data Structure
58.2.6
Services F.N. Issued by Company
58.2.6.1
Processing Options
58.2.6.2
Data Structure
58.2.7
Merch/Serv F.N. Issued by Others
58.2.7.1
Processing Options
58.2.7.2
Data Structure
58.2.8
Stock Checking
58.2.8.1
Processing Options
58.2.8.2
Data Structure
58.2.9
Inventory Register
58.2.9.1
Processing Options
58.2.9.2
Data Structure
58.2.10
Bill of Material
58.2.10.1
Processing Options
58.2.10.2
Data Structure
58.3
Complementary Files
58.3.1
Physical / Juridic Person
58.3.1.1
Processing Options
58.3.1.2
Data Structure
58.3.2
Chart of Accounts
58.3.2.1
Processing Options
58.3.2.2
Data Structure
58.3.3
Cost Center / Branch Plant
58.3.3.1
Processing Options
58.3.3.2
Data Structure
58.3.4
Transaction Code
58.3.4.1
Processing Options
58.3.4.2
Data Structure
58.3.5
Merchandise / Services
58.3.5.1
Processing Options
58.3.5.2
Data Structure
58.3.6
Profit/Discount Codes
58.3.6.1
Processing Options
58.3.6.2
Data Structure
58.3.7
Export Transactions
58.3.7.1
Processing Options
58.3.7.2
Data Structure
58.3.8
Import Transactions
58.3.8.1
Processing Options
58.3.8.2
Data Structure
58.3.9
Payment Sheet
58.3.9.1
Processing Options
58.3.9.2
Data Structure
58.3.10
Employee Register
58.3.10.1
Processing Options
58.3.10.2
Data Structure
Part VIII Working with SPED Accounting in Brazil
59
Overview to the SPED Accounting Process
59.1
About SPED Accounting
59.1.1
Blocks, Registers, and Records
59.1.1.1
Blocks
59.1.1.2
Registers
59.1.1.3
Records
60
Set Up SPED Accounting
60.1
Setting Up the System for SPED Accounting
60.1.1
Next Unique ID Number
60.1.2
Set Up User-Defined Codes
60.1.3
Setting up Legal Company Information
60.1.4
Adding Inscription Information to Address Book Records
60.1.5
Assigning Group Type Codes to Your GL Accounts
60.1.6
Entering a Referential Chart of Accounts for SPED Accounting
60.1.6.1
Importing the Government Referential Chart of Accounts
60.1.7
Associating Your GL Accounts with the Referential Accounts
60.1.8
Setting Up Related Accounts (Contas Correlatas)
60.1.9
Defining the Books for SPED Accounting
60.1.10
Specifying Blocks, Sequences and Versions
60.1.11
Setting Up SPED Register Rules
60.1.12
Set Up an IFS Area
61
Extract and Review Data for SPED Accounting
61.1
Generating SPED Jobs
61.1.1
New Job
61.1.2
Book Type
61.1.3
Add a Job
61.1.4
Processing Options
61.2
Modifying Records Before Running a Job
61.3
Deleting Job Records
61.3.1
Understanding the Execution Process
61.3.2
Order of Execution
61.4
Re-running a Block
61.4.1
Generating the TXT file
61.4.2
Export of the XML File to the IFS Area
62
Working With SPED Fiscal in Brazil
62.1
Understanding the SPED Fiscal Process
62.1.1
Understanding the SPED Fiscal Process
62.1.2
Prerequisites
62.1.2.1
Setting Up the System
62.1.2.2
Category Code
62.1.2.3
User Defined Codes
62.1.2.4
Set Up an IFS Area
62.2
Setting up Information for Constants to Block 0 Program (P76B520)
62.3
Company Information
62.3.1
Additional Address Book Information
62.4
Setup for Block 0
62.4.1
Additional Item Information
62.5
Setup for Block H
62.5.1
Processing Options for Contact Phone Numbers
62.6
SPED Fiscal Block Setup
62.6.1
Process ID for SPED Fiscal
62.6.2
Setting up SPED Fiscal Block Control Rules
62.7
Setting Up ICMS Period Balances
62.8
Setting Up IPI Period Balances
62.9
SPED Fiscal Jobs
62.9.1
Set Up SPED Job
62.9.2
Block Revisions/Running Block Programs
62.9.2.1
Export of the TXT file to the IFS area
62.9.2.2
SPED Fiscal Programs
63
SPED Fiscal Additional Block/Record Information
63.1
Block 0 Records
63.1.1
Source Files
63.1.2
Block 0 - Address Book
63.1.3
Block 0 - Address Book -Participant Data
63.1.4
Block 0 - Items and Unit of Measure
63.1.5
Block 0 - Fixed Assets
63.1.5.1
Account Information
63.1.6
Block 0 - Nature or Operations
63.1.7
Block 0 - Observation Fiscal Books
63.1.8
Contents of Block 0 Records
63.2
Block C Records
63.2.1
Source Files
63.2.2
Contents of Block C Records
63.3
Block D Records
63.3.1
Source Files
63.4
Block E Records
63.4.1
Source Files
63.4.2
Contents of Block E Records
63.5
Block G Records
63.5.1
Technical Notes:
63.5.2
Contents of Block G Records
63.6
Block H Records
63.6.1
Technical Notes:
63.6.2
Source Files
63.6.3
Contents of Block H Records
63.7
Block 1 Records
63.7.1
Records That Are Populated
63.8
Block 9 Records
63.8.1
Contents of Block 9
Part IX Processing Options
64
Setup Requirements Processing Options
64.1
Processing Options for Next Number Journal Entry (P7602B)
64.2
Processing Options for Print Messages/Item Notes (P4016)
64.3
Processing Options for Transaction Nature Master (P7615B)
64.4
Processing Options for Sales Order Entry - Brazil (P4211BR)
64.5
Processing Options for Purchase Order Entry - Brazil (P4311BR)
64.6
Processing Options for AAIs - General Accounting (P00121)
65
Inventory Management and Procurement Processing Options
65.1
Processing Options for Purchase Orders (P4311)
65.2
Processing Options for Purchase Order Entry - Brazil (P4311BR)
65.3
Processing Options for Receipts by PO/Item/Account (P4312)
65.4
Processing options for Receive Nota Fiscal P4312ABR
65.5
Processing Options for Stand-Alone Landed Costs for Brazil (P76295B)
65.6
Processing Options for Nota Fiscal Inquiry (P76211B)
65.7
Processing Options for Nota Fiscal Entry - Detail (P76111B)
65.8
Processing Options for Nota Fiscal Print for Purchasing (P76500B)
65.9
Processing Options for FCI Txt File Generation (P76B4170)
65.10
Processing Options for Update Files from Flat File (P76B4176)
66
Sales Order Management Requirements Processing Options
66.1
Processing Options for Sales Order Entry (P4211)
66.2
Processing Options for Sales Order Entry - Brazil (P4211BR)
66.3
Processing Options for Shipment Confirmation (P4205)
66.4
Processing Options for Generate Outbound Nota Fiscal (P76558B)
66.5
Processing Options for Landed Costs Additional Charges (P76295B)
66.6
Processing Options for Print Outbound Nota Fiscal (P76560B)
66.7
Processing Options for Reverse-Void Nota Fiscal (P76B559)
66.8
Processing Options for Reverse-Void Nota Fiscal (P76B803)
66.9
Processing Options for Update Customer Sales (P42800)
66.10
Processing Options for Sales Return (P76B805)
66.11
Processing Options for Sales Order Entry (P4211)
67
Electronic Nota Fiscal (Type 3) Processing Options
67.1
Processing Options for Authorized Person Setup (P76B0112)
67.2
Processing Options for Authorized Person by NF (P76B1020)
67.3
Processing Options for XML Generator (P76B601)
67.4
Processing Options for Contingency EPEC (P76B627)
67.5
Processing Options for Nota Fiscal-e Status Update (P76B650)
67.6
Processing Options for Nota Fiscal Update (P76B651)
67.7
Processing Options for Trigger Program for the File F76B652 (X76B653)
67.8
Processing Options for DANFE Generation - Brazil (P76B660)
67.9
Processing Options for Cancelled/Unused Nota Fiscal (P76B670)
67.10
Processing Options for Unused NF-e Numbers (P76B678)
67.11
Processing Options for Tax Netting Process (P76B4011)
68
Banking Requirements Processing Options
68.1
Processing Options for A/R Brazilian Tag Maintenance (XT0311Z1BR)
68.2
Processing Options for Bank Data Remit - Standard (P76550B)
68.3
Processing Options for Auto Cash Processing - Load Bank Tape (P03551)
68.4
Processing Options for Bank Data Receipt - Standard (P76551B)
68.5
Processing Options for Create Payment Groups (P04570)
68.6
Processing Options for A/P Payments - Work with Payment Groups (P04257)
69
Fiscal Reports Processing Options
69.1
Processing Options for Nota Fiscal of Input (P76B0411)
69.2
Processing Options for Exit Review Fiscal Note Online (P76B0421)
69.3
Processing Options for Conversion Program (Input) (P76B591)
69.4
Processing Options for Conversion Program (Output) (P76B592)
69.5
Processing Options for Output Transaction Ledger - Model 2 (P76B45111)
69.6
Processing Options for Entry Registry (P76B45041)
69.7
Processing Options for Entry Registry - Proof Mode (P76B45031)
69.8
Processing Options for Output Transactions - WO IPI Rate Break (P76B45131)
69.9
Processing Options for Entry Registry - Proof Mode (P76B45021)
69.10
Processing Options for Statement of DIPAM (P76B4911)
69.11
Processing Options for Statement of DECLAN (P76B49111)
69.12
Processing Options for Notas Fiscais with Detailed ICMS (P76B4711)
69.13
Processing Options for Notas Fiscais with Detailed IPI (P76B4711)
69.14
Processing Options for GIA Report Generation (P76B4741)
69.15
Processing Options for Statement of ICMS - Entry (P76B6001)
69.16
Processing Options for Statement of ICMS - Exits (P76B6051)
69.17
Processing Options for DIPI Report - Entries (P76B4881)
69.18
Processing Options for Relatorio da DIPI - 20 Maiores (P76B4871)
69.19
Processing Options for GIA ICMS - Annual Entries (P76B4801)
69.20
Processing Options for GI/ICMS - Outputs (P76B4802)
69.21
Processing Options FOR Interstate Operations - Tape File (P76B45711)
69.22
Processing Options for Fiscal Books As Of Generation (P761BA)
69.23
Processing Options for Average Cost and Beginning Balance Calculation (P76B1301)
69.24
Processing Options for Generate Movements for Book Model 3 (P76B3011)
69.25
Processing Options for Inventory Register (P76B460)
69.26
Processing Options for Inventory Register by MCU (P76B461)
69.27
Processing Options for Transaction Report of Model 3 (P76B3021)
69.28
Processing Options for General Journal (P76B415)
69.29
Processing Options for Transaction Journal (P76B420)
69.30
Processing Options for Four Columns Balance Sheet (P76B4121)
69.31
Processing Options for Auxiliary Journal of Accounts Receivable (P76B416)
69.32
Processing Options for Auxiliary Journal of Accounts Payable (P76B417)
69.33
Processing Options for Fiscal Note Transp. Reg. 75 - C/Units Fed (P76B0601)
70
IN86 Processing Options
70.1
Processing Options for Accounting Projections (P76B100)
70.2
Processing Options for Filter for Monthly Balance File (P76B110)
70.3
Processing Options for Filter of Accounts Receivable (P76B210)
70.4
Processing Options for Suppliers/Customers (Accounts Payable) (P76B201)
70.5
Processing Options for Asset Registry Filter (P76B630)
70.6
Processing Options for Fiscal Note Issued by Company (P76B300)
70.7
Processing Options for Service Note Issued by CO - Non ICMS (P76B400)
70.8
Processing Options for NF Goods/Serv. Emitted by Third (P76B350)
70.9
Processing Options for Stock Checking (P76B500)
70.10
Processing Options for Stock Registry (P76B510)
70.11
Processing Options for Bill of Material (P76B600)
70.12
Processing Options for Filter for Export File (P76B440)
70.13
Processing Options for Filter for Import File (P76B450)
70.14
Processing Options for Maintenance for Monthly Balance File (P76B115)
70.15
Processing Options for Maintenance for Export File (P76B445)
70.16
Processing Options for Maintenance for Import File (P76B455)
70.17
Processing Options for Maintenance of Payment Sheet (P76B645)
70.18
Processing Options for Employee Register Maintenance (P76B655)
70.19
Processing Options for Bill of Material Maintenance (P76B605)
70.20
Processing Options for Create G/L Transactions TXT file (P76B108)
70.21
Processing Options for Chart of Account TXT File Generation (P76B728)
70.22
Processing Options for Create Cost Center TXT file (P76B748)
70.23
Processing Options for Final Generat. for Monthly Balance File (P76B118)
70.24
Processing Options for Final Generation of Accounts Receivables/Payables (P76B208)
70.25
Processing Options for Address Book Registry (P76B708)
70.26
Processing Options for Asset Registry TXT Creation (P76B638)
70.27
Processing Options for Fiscal Notes issued by Company TXT File (P76B308)
70.28
Processing Options for Address Book Registry (P76B708)
70.29
Processing Options for Transaction Nature Code TXT Outfile (P76B768)
70.30
Processing Options for Item Master TXT Outfile (P76B788)
70.31
Processing Options for TXT Service Notes Without ICMS Issued by Co (P76B408)
70.32
Processing Options for Address Book Registry (P76B708)
70.33
Processing Options for Item Master TXT Outfile (P76B788)
70.34
Processing Options for TXT Creation Fiscal Notes Issued by Thirds (P76B358)
70.35
Processing Options for Address Book Registry (P76B708)
70.36
Processing Options for Transaction Nature Code TXT Outfile (P76B768)
70.37
Processing Options for Item Master TXT Outfile (P76B788)
70.38
Processing Options for Stock Transactions TXT Creation (P76B508)
70.39
Processing Options Item Master TXT Outfile (P76B788)
70.40
Processing Options for Generate TXT File of Stock Registry (P76B518)
70.41
Processing Options for Item Master TXT Outfile (P76B788)
70.42
Processing Options for Bill of Material TXT Creation (P76B608)
70.43
Processing Options for Item Master TXT Outfile (P76B788)
70.44
Processing Options for Address Book Registry (P76B708)
70.45
Processing Options for Chart of Account TXT File Generation (P76B728)
70.46
Processing Options for Create Cost Center TXT File (P76B748)
70.47
Processing Options for Transaction Nature Code TXT Outfile (P76B768)
70.48
Processing Options for Item Master TXT Outfile (P76B788)
70.49
Processing Options for Profit / Discount Codes TXT Creation (P76B798)
70.50
Processing Options for Generation of Export Final File (P76B448)
70.51
Processing Options for Generation of Import Final File (P76B458)
70.52
Processing Options for Payment Sheet (P76B648)
70.53
Processing Options for Employee Register TXT Creation (P76B658)
70.54
Processing Options for Employee Register TXT Creation (P76B658)
71
SPED Accounting Processing Options
71.1
Processing Options for SPED Jobs (P76B153)
71.2
Processing Options for General Information - Generation - SPED (P76B161)
71.3
Processing Options for Block J - Signatories Generation - SPED (P76B168)
Part X Appendices
A
Alternate Chart of Accounts
A.1
Data Integrity
A.1.1
Example: Account Defined Only in the Account Master Table
A.1.2
Example: Account Defined Only in the Alternate Chart of Accounts
A.1.3
Example: Account Deleted from the Alternate Chart of Accounts
A.1.4
Example: Reorganization of Accounts in the Chart of Accounts
B
SPED Fiscal File Example
B.1
SPED Fiscal File Example
C
Translation Issues
C.1
Multi-Language Environments
C.2
Other Translation Capabilities
C.3
Account Descriptions
C.4
Business Unit Descriptions
C.5
Automatic Accounting Instruction (AAI) Descriptions
C.6
Payment Terms Descriptions
C.7
User Defined Code (UDC) Descriptions
C.8
Delinquency Notice Text
Scripting on this page enhances content navigation, but does not change the content in any way.