19 Working With Sales Order Processing for Brazil

This chapter contains the following topics:

Note:

The sales order process is different if you use the São Paulo electronic nota fiscal process to obtain nota fiscal numbers.

See Working With São Paulo Electronic Notas Fiscais.

19.1 Understanding Sales Order Management for Brazil

In Brazil, the government requires that businesses maintain detailed information about all merchandise and associated taxes during the delivery process. The information accompanies shipments in the nota fiscal.

When you use the JD Edwards EnterpriseOne Sales Order Management system in Brazil, you associate applicable Brazilian taxes with your sales orders. You then generate and print notas fiscais for the orders. When you generate the notas fiscais, the system assigns a temporary number to the order. You can use this temporary number when you review or revise your orders. When you print notas fiscais, the system assigns the appropriate number from the numbering sequence that is assigned to your company by the Brazilian government. You set up the Nota Fiscal Next Number - Brazil program (P7600B) with the numbering sequence that is assigned to your company.

The system automatically creates journal entries to account for the notas fiscais that are created during the JD Edwards EnterpriseOne Sales Order Management process.

See Understanding NFe and DANFe Generation

To process sales orders in the JD Edwards EnterpriseOne Sales Order Management system, complete these tasks:

  1. Enter the sales order by using the Sales Order Entry - Header - Brazil (P4210, version ZJDE7002) or the Sales Order Entry - Detail - Brazil (P4210, version ZJDE7001) programs.

  2. Confirm the shipment by using the Shipment Confirmation program (P4205).

  3. Generate the nota fiscal by running the Generate Nota Fiscal - Brazil program (R76558B).

    This program assigns a temporary number to the nota fiscal and calculates Brazil tax amounts.

    Ensure the appropriate Nota Fiscal Type is set in the processing options in the Default section (0 for classical and Sao Paulo notas fiscais and 1 for National NFe and NFCe).

  4. Add additional charges by using the Nota Fiscal Maintenance - Brazil program (P7610B).

    This program lets you add freight, insurance and other expense information to the nota fiscal.

  5. According to the type of Nota Fiscal that your company uses:

    Classical Nota Fiscal

    Print the final nota fiscal by running the Print Nota Fiscal - Ship From program (R76560B).

    This program assigns the nota fiscal number according to the next numbering scheme that you set up, and then prints the nota fiscal.

    Sao Paulo Nota Fiscal
    • Print the final nota fiscal by running the Print Nota Fiscal – Ship From program (R76560B).

    • Generate the XML NFe file running the Nota Fiscal Elec. - Outbound program (R76B560Z1) from a menu option or use processing options so the system can run it in this stage of the process.

    • Use the XML Transaction Review program (P70XMLZ1) to review the data that you wrote to the tables for the outbound transaction.

    • Use the custom program that you develop or that you obtain from a third-party to format in the legally required layout the XML data generated by the JD Edwards EnterpriseOne programs.

    • Use the custom program that you develop or that you obtain from a third-party to send the formatted XML data to the fiscal authority.

    • Use the custom program that you develop or that you obtain from a third-party to receive the data that the fiscal authority sends back.

    • Run the XML Inbound Process program (R70XMLI1) to update your system with the information that you receive back from the fiscal authority.

      Use the XML Transaction Review program to review the data that you receive.

    • Use the Nota Fiscal Elect. Revision program (P76B01TE) to review updated nota fiscal information and release the nota fiscal that was put on hold by the Nota Fiscal Elec. - Outbound program.

    National Nota Fiscal and NFC-e
    • Generate the NF-e XML file by running the NF-e Info Generation program (R76B561), which runs the NF-e Info Generation by Lot UBE program (R76B561L).

      You can run the NF-e Info Generation program from a menu option or from the NF-e Response Process and Contingencies program (P76B12TE).

    • Submit the NFe XML file to SEFAZ.

      You can use a custom, a third-party program, or the NF-e Transmission program (P76B0021) to submit the file to SEFAZ.

      The NF-e Transmission program enables you to select the file, select the service (submit for processing, cancel, or destroy), and transmit the file to SEFAZ. You can view the status of the submission in the NF-e Transmission program.

    • Receive the response from SEFAZ.

    • Upload the final response file from the SEFAZ by running the appropriate version of the NFe XML Response Processing program (R76B525). Use the menu entry for the appropriate XML version.

      The NFe XML Response Processing program retrieves the response XML file from the source folder and updates the JD Edwards EnterpriseOne tables.

      You can also upload the response by using the NF-e Response Process and Contingencies program (P76B12TE), and for unused and cancelled NFes by using the Unused/Cancelled NF-e Numbers program (P76B22TE).

    • Print the DANF-e document from the NF-e Response Process and Contingencies program (P76B12TE).

  6. Update journal entries for Brazil taxes by running the Update Sales - Brazil program (R76B803).

  7. Update other sales files by running the Sales Update program (R42800).

19.2 Understanding the Nota Fiscal for Sales Orders for Brazil

In Brazil, the government requires companies to maintain additional sales order information for tax calculation purposes. This information includes:

  • Transaction nature.

  • Tax code.

  • Fiscal classification.

  • Whether the item is subject to ICMS Substitution.

  • Origin of the item.

  • Type of purchase (from a client's perspective).

  • Fiscal message.

  • And, if the item has imported content:

    • Imported Content percentage (CI)

    • Imported Content Form (FCI)

    • EX-TIPI

When you use the JD Edwards EnterpriseOne Sales Order Management system, you include this additional information in the header and detail portions of your sales order.

After you enter sales orders, generate the nota fiscal to have the system run validations and tax calculations, then you print notas fiscais by fiscal company and series. When you print notas fiscais, the system creates the notas fiscais that you ultimately send to your customers with each shipment. Notas fiscais include the following detailed information:

  • Merchandise price.

  • Applicable tax amounts.

  • How the merchandise will be used.

  • Origin and destination of the shipment.

  • Any other expense that is associated with the transaction.

At times, you might need to create a nota fiscal that it is not directly attached to a purchase or sales order. In such cases, you can generate the standalone nota fiscal.

19.2.1 Prerequisites

Before you can use fiscal notes for sales orders you must complete the required setup.

19.3 Entering Additional Sales Order Information for Brazil

This section provides an overview of additional sales order information, lists prerequisites, and discusses how to:

  • Set processing options for Sales Order Brazilian Additional Information - Brazil (P4210BR) program.

  • Enter additional information for Brazilian sales orders.

19.3.1 Understanding Additional Sales Order Information

When you enter new sales orders and the country that is specified in the user display preferences is Brazil, the system automatically runs the S.O. Brazilian Information program and displays these additional information forms to complete:

  • S.O. Brazilian Additional Information Header.

  • S.O. Brazilian Information Detail.

The system automatically uses the version of P4210BR that corresponds to the version of the Sales Entry program. If a corresponding version of P4210BR is not set up, the system uses version ZJDE0001.

19.3.2 Prerequisites

Before you complete the tasks in this section:

  • Verify that the processing options in the Sales Order Entry program are set up to display header information before the detail information.

  • To determine the transaction nature default, indicate whether the item was manufactured or purchased.

    For Brazil, this information can be stored in an item master category code. Use user-defined code (UDC) table 76/CN to determine which category code you can use by entering SRP6, SRP7, SRP8, SRP9, or SRP0 for the code NATUR. For example, one data dictionary option for NATUR is SRP6. Data dictionary item SRP6 has values in UDC 41/06, so it is ready for you to use when you enter sales orders.

  • Verify that you have set up the processing options for the Sales Order Brazilian Additional Information program (P4210BR).

19.3.3 Forms Used to Enter Additional Information for Brazilian Sales Orders

Form Name Form ID Navigation Usage
Work With Sales Order Headers W4210H Sales Order Processing - Brazil (G76B4211), Enter Sales Orders Header Review and select sales order header records.
Sales Order Header W4210G Click Add on the Work With Sales Order Headers form. Add and revise sales order header information.
Sales Order Detail Revisions W4210A Click OK on the Sales Order Header form. Add and revise item information in the detail portion of the form.

Enter line default information in addition to item information when you do not enter sales order headers.

Order Acceptance W42232A Click OK on the Sales Order Detail Revisions form. Click the appropriate button to place the order or to revise the order.
S.O. Brazilian Information Header W4210BRL Click Place Order on the Order Acceptance form. Add and revise the transaction nature code and transaction nature suffix.
S.O. Brazilian Information Detail W4210BRQ Click OK on the S.O. Brazilian Additional Information Header form. Add and revise additional detail information for the Brazilian sales order.

19.3.4 Setting Processing Options for Sales Order Brazilian Additional Information - Brazil (P4210BR)

Access the processing options using interactive versions.

19.3.4.1 Defaults

1. Transaction Nature Code

Enter the three-character code for the transaction nature. You set up transaction nature codes in the Transaction Nature program (P7615B). Enter the Transaction Nature code using this convention: XYY, where X defines the origin of the transaction (inbound or outbound) and YY defines the transaction as a whole, such as a sales transaction. Values for X are:

1: Inbound, inside the state.

2: Inbound, other states.

3: Inbound, import.

5: Outbound, inside state.

6: Outbound, other states.

7: Outbound, export.

Examples of transaction nature codes include: 511 (In-state sale) and 611 (Out-of-state sale). If you leave this processing option blank, the system uses 511 for the transaction nature.

2. Transaction Nature Suffix

Enter the default transaction nature suffix. Complete this two-character field in conjunction with the transaction nature code to identify the complementary implications of a type of transaction. For example, the suffix might indicate that a certain type of transaction represents an inventory change or that a transaction is assessed a certain type of tax. Transaction Nature suffixes are set up using the Transaction Nature - Brazil (P7615B) program. If you do not complete this field, the system uses a value of 00. Values include:

01: Bonus

02: Demo

03: Sample

04: Return merchandise

05: Back order

06: Donation

These examples are Transaction Nature codes with suffixes: 511 01 is In state sale, bonus and 511 05 is In state sale, back order.

3. Presence Indicator

Enter a code from the Presence Indicator UDC (76B/PR) table to specify the preferred value for the Presence Indicator field. This field is used to indicate the customer presence at the time of the operation.

19.3.4.2 Edits

1. Branch A/B Number Validation (branch address book number validation)

Specify whether the system uses the address book number or the Inventory Constants file to validate the branch address book number. Values are:

Blank: Use the Inventory Constants file (F41001) for validation.

1: Use the address book number to validate the branch address book number.

19.3.5 Entering Additional Information for Brazilian Sales Orders

Access the S.O. Brazilian Additional Information Header form.

Figure 19-1 S.O. Brazilian Information Header form

Description of Figure 19-1 follows
Description of ''Figure 19-1 S.O. Brazilian Information Header form''

Add and revise the transaction nature code and transaction nature suffix.

Code - Taxpayer Classification

This field is required when you enter sales orders and it retrieves the taxpayer type from the Taxpayer Class field in the Address Book Regional Information program with the taxpayer type value for the Ship To entity. The system uses this information to determine if the sales order prints detailed information about applicable taxes. Values are:

  • 1: Taxpayer - The system does not print detailed information about applicable taxes in the Sales Order.

  • 2: Consumer - The system prints detailed information on applicable taxes in the Sales Order.

  • Blank: If the retrieved value from the Address Book Regional Information is a 3 that identifies the Taxpayer Classification as Taxpayer/Consumer, the system replaces that value with a 2 for Consumer.

Presence Indicator

This field retrieves the preferred value from the processing options or you can enter a value from the Presence Indicator (76B/PR) UDC table. The system uses this information to indicate the customer's presence at the time of the purchase. If the selected value has a 1 in the Special Handling Code, it means that the customer is present at the time of the transaction. The system uses this information to validate if the nota fiscal is for an end consumer.

When you are finished, click OK to access the S.O. Brazilian information Detail Form. Complete any necessary information, and then click OK.

Figure 19-2 S.O. Brazilian Information Detail form

Description of Figure 19-2 follows
Description of ''Figure 19-2 S.O. Brazilian Information Detail form''

Note:

If you work with imported items (as determined by the item origin), the information on Import Content, FCI, and Ex TIPI fields is required. This data is retrieved from the Item Master or the Item Branch program.

Note (Release 9.2 Update):

The system does not automatically populate the Customer PO Item Line Number field. You must enter a value for that field to save it to the Sales Order Details Tag File-Brazil table (F76422).

19.4 Working with Import Declarations and Electronic Notas Fiscais

This section provides an overview of import declarations and discusses how to:

  • Set up import declarations.

  • Set up processing options for import declarations.

  • Create relationships between import declarations and notas fiscais.

19.4.1 Understanding Import Declarations

An import declaration is a certificate that contains information about imported goods. Each good detailed in an import declaration is called an addition. Use the Import Declaration program (P76B016) to create import declarations for foreign items. An item is marked as foreign by entering 1 in the Item Origin field. A NFe can be related to one or many import declarations and each import declaration number can have more than one addition. The system stores import declarations information in the Import Declaration (F76B016) and Import Declaration – Additions (F76B017) tables.

Use the Stand Alone Nota Fiscal program (P7611B) to add and review the import declaration relationship with the NFe. When working with import declarations in the Stand Alone Nota Fiscal program, the system interacts with the following tables:

  • Nota Fiscal Header - Brazil (F7601B)

  • Nota Fiscal Detail - Brazil (F7611B)

  • Import Declaration (F76B016)

  • Import Declaration - Additions (F76B017)

  • Nota Fiscal Import Relationship (F76B018)

  • Import Declarations Legal Number (F76B022)

Use the Nota Fiscal Maintenance program (P7610B) to add and review import declaration relationship with a generated NFe. When working with import declarations in the Nota Fiscal Maintenance program, the system interacts with the following tables:

  • F7601B

  • F7611B

  • F76B016

  • F76B017

  • F76B018

  • F76B022

SEFAZ requires businesses to report certain information related to import declarations. The XML file requested by SEFAZ includes two group tags with import information; the Import Declaration Group Tag and the Import Tax Group Tag. To review these group tags, refer to the Reviewing New NFe Header and Detail Elements in the XML File section in this document.

Note:

Review additional information about import declarations in the documentation for the applicable release.

19.4.2 Forms Used to Work with Import Declarations

Form Name Form ID Navigation Usage
WorkWith Import Declarations W76B016A
  • StandAlone Nota Fiscal - Brazil (G76B4321), Import Declarations
  • Brazilian Localization Setup (G76B41B), Import Declarations

Review and select import declarations.
Import Declarations Revisions W76B016B
  • Click Add on the Work With Import Declarations form.
  • Select Create Declaration from the Row menu on the Import Declarations Relationships Revisions form.

Set up import declarations.
Work with Stand Alone Nota Fiscal Header W7611BA
  • Stand Alone Nota Fiscal - Brazil (G76B4321), Stand Alone Nota Fiscal - Outbound
  • StandAlone Nota Fiscal - Brazil (G76B4321), Stand Alone Nota Fiscal - Inbound by Company

Review and select standalone nota fiscal records.
Work with Stand Alone Nota Fiscal Header W7611BJ Stand Alone Nota Fiscal - Brazil (G76B4321), Stand Alone Nota Fiscal - Inbound by Supplier Review and select standalone nota fiscal records.
Nota Fiscal Detail Revision W7611BF Select a record and select Detail Revision from the Row menu on the Work with Stand Alone Nota Fiscal Header form. Review the detail information for a nota fiscal.
WorkWith Nota Fiscal Headers W7610BG Sales Order Processing - Brazil (G76B4211), Nota Fiscal Inquiry-Header Browse Review and select generated nota fiscal records.
Nota Fiscal Detail Revision W7610BE Select a record and select Detail Revision from the Row menu on the Work With Nota Fiscal Headers form. Review the detail information for a nota fiscal.
WorkWith Import Declarations Relationships W76B016C On the Nota Fiscal Detail Revisions form, select a record with an Item Origin of 1 and select Import Declaration from the Row menu. Review and select import declarations associated with an NFe number or item number.
Import Declarations Relationships Revisions W76B016D Click Add on the Work With Import Declarations Relationships form. Create relationships between import declarations and NFe.

19.4.3 Setting Up Import Declarations

Access the Import Declarations Revisions form.

19.4.3.1 Header

Import Declaration Number

Enter a value that identifies the import declaration document. The value must be unique for each import declaration type. The system does not use next numbering in this field.

Import Declaration Type

Enter a value from UDC table 76B/ID that identifies the type of import declaration. Values are:

DI: Import declaration

DSI: Simplified import declaration

DA: Customs clearance

Registration Date

Enter a value that identifies the date of registration of the import declaration document.

Place of Discharge

Enter a value from UDC table 76B/PD that identifies the place of discharge of the goods.

Customs State

Enter a value from UDC table 76B/UF that identifies the state of the customs clearance.

Customs Date

Enter a value that identifies the date of the customs clearance.

Exporter Code

Enter a value from UDC table 76B/EC that identifies the code of the exporter involved in the import declaration.

Transportation Mode

Enter a value from the UDC table 76B/TW that identifies the nature of the carrier used to transport items to the customer (some examples are by seaway, by air, by road, and so on).

Freight Surcharge for Merchant

Enter a value that identifies the additional freight amount for the renewal of merchant navy services.

This field is required when the transportation mode is by seaway.

Imp. Dd. Mode (Import Declaration Mode)

Enter a value from the UDC table 76B/IQ that indicates the import type according to who buys the items and for whom.

Ordering Party

Select an Address Book record that identifies the ordering party.

This field is required whenever the value selected for the import Declaration Mode field is marked with a 1 in the Special Handling Code field in UDC table 76B/IQ.

Currency Code

Specify the currency that the system includes in the report when you generate an import declaration.

This field is required when you complete the Freight Surcharge for Merchant Renewal field.

19.4.3.2 Grid

Addition Number

Enter a value that identifies the number of the addition in the import declaration.

Foreign Manufacturer Code

Enter a value from UDC table 76B/MC that identifies the code of the foreign manufacturer.

Item Disc. Amount - Addition (item discount amount - addition)

Enter an amount that identifies the discount amount associated with the item in the addition section.

19.4.4 Setting Processing Options for the Import Declarations Program (P76B016)

Processing options enable you to specify the default processing for programs and reports.

19.4.4.1 Validations

Import Declarations Limit

This processing option enables you to define the quantity of import declarations that you can associate to a single note fiscal. If this field is not completed, the value by default is 100.

Additions Limit

This processing option enables you to define the quantity of additions that you can associate to a single import declaration. If this field is not completed, the value by default is 100.

19.4.5 Creating Relationships Between Import Declarations and Nota Fiscais

Access the Import Declarations Relationships Revisions form.

Select the import declarations that you want to associate with the inbound or outbound NFe and click Select.

A single Nota Fiscal can have a maximum of 100 Import Declarations associated. If the quantity of import declarations associated to a NFe exceeds 100, an error message is displayed. Even though this validations is currently set to 100 due to legal requirements, it is configurable.

Each import declaration can have a maximum of 100 additions associated. If the quantity of additions associated to an import declaration exceeds 100, an error message is displayed. This value is also configurable.

To set up an import declaration, select Create Declaration from the Row menu on the Work With Import Declarations Relationships form and the system displays the Import Declarations Revisions form.

If a nota fiscal corresponds to a sales order, you must run the Generate Nota Fiscal report (R76558B) before you can create a relationship between an import declaration and a nota fiscal. For a standalone nota fiscal, you can create a relationship between the import declaration and nota fiscal when you enter the standalone nota fiscal.

The system creates a record in the Nota Fiscal Import Relationship table (F76B018).

19.4.6 Updating Import Declaration Numbers

Due to legal requirements, as of November 2011 the system includes a table (F76B022) that relates the current Import Declaration Number (B76IDOC) with a data item named Import Declaration Legal Number (B76IDLN). The Import Declaration Number (B76IDOC) is therefore considered as the internal declaration number.

19.5 Working with NFe Export Information

This section provides an overview export information and discusses how to set up export information.

19.5.1 Understanding Export Information

You can add export information only if the customer is foreign and is an outbound NFe. Use the Stand Alone Nota Fiscal program (P7611B) or the Nota Fiscal Maintenance program (P7610B) to enter export information on the Export tab. The system displays the Export Information tab only if the customer is foreign (the Ship To country is different from the Fiscal Company country). The system stores export information in the Nota Fiscal Header - Export Information table (F76B019).

When working with export information in the Stand Alone Nota Fiscal program or the Nota Fiscal Maintenance program, the system interacts with the following tables:

  • Nota Fiscal Header - Brazil (F7601B)

  • Nota Fiscal Detail - Brazil (F7611B)

  • Nota Fiscal Header - Exports Info (F76B019)

Note:

Review additional information about exporting information in the documentation for the applicable release.

19.5.2 Forms Used to Work with Export Information

Form Name Form ID Navigation Usage
Work With Nota Fiscal Headers W7610BG Sales Order Processing - Brazil (G76B4211), Nota Fiscal Inquiry - Header Browse Review and select NFe records.
Nota Fiscal Header Revision W7610BD
  • Select a record and click Select.
  • On the Work With Nota Fiscal Headers form, select Header Revision from the Row menu.

Set up export information.
Work with Stand Alone Nota Fiscal Header W7611BA Stand Alone Nota Fiscal - Brazil (G76B4321), Stand Alone Nota Fiscal - Outbound Review and select standalone nota fiscal records.
Nota Fiscal Header Revision W7611BD
  • Select a record and click Select.
  • On the Work with StandAlone Nota Fiscal Header form, select Header Revision from the Row menu.

Set up export information.

Note:

The system displays the Export Information tab only when the ship to country is different from the fiscal company country and the transaction is outbound.

19.5.3 Setting Up Export Information

Access the Export Information tab on the Nota Fiscal Header Revision form.

Product Abroad Shipment

Enter a value from UDC table 76B/UF that identifies the state code associated with the product abroad shipment.

Abroad Shipment place

Enter a value from UDC table 76B/AS that identifies the place name of the abroad shipment.

Access the Detail Revision form from the Row exit of Stand Alone Nota Fiscal program (P7611B) and the Nota Fiscal Maintenance program (P7610B).

Drawback Number 1

Enter the drawback number of the corresponding line item associated with the foreign transaction nota fiscal document.

Drawback Number 2

Enter the drawback number of the corresponding line item associated with the foreign transaction nota fiscal document.

19.6 Working with NFe Import Tax Information

This section provides an overview of import tax information and discusses how to add import tax information to notas fiscais.

19.6.1 Understanding Import Tax Information

For each line of a NFe, you can enter import tax information consisting of customhouse charges and financial operations tax. Use the Nota Fiscal Maintenance program (P7610B) to enter these values after the system generates the NFe. For a standalone nota fiscal, you also have the option to enter this information in the Stand Alone Nota Fiscal program (P7611B) when you enter the item.

The system stores import tax information in the Nota Fiscal Detail - Import Tax table (F76B014).

When working with import tax information in the Stand Alone Nota Fiscal program or the Nota Fiscal Maintenance program, the system interacts with the Nota Fiscal Detail - Brazil (F7611B) and Nota Fiscal Detail - Import Tax (F76B014) tables.

Note:

Review additional information about importing tax information in the documentation for the applicable release.

19.6.2 Forms Used to Add Import Tax Information to Nota Fiscais

Form Name Form ID Navigation Usage
Work with Stand Alone Nota Fiscal Header W7611BA Stand Alone Nota Fiscal - Brazil (G76B4321), Stand Alone Nota Fiscal - Inbound by company Review and select standalone nota fiscal records.
Inbound Nota Fiscal Detail Revision W7611BF Select a record and select Detail Revision from the Row menu on the Work with Stand Alone Nota Fiscal Header form. Review the detail information for a nota fiscal.
Inbound NF Additional Information W7611BE Select a record and select Detail Add Info from the Row menu on the Inbound Nota Fiscal Detail Revision form. Add import tax information to notas fiscais.
Work With Nota Fiscal Headers W7610BG Sales Order Processing - Brazil (G76B4211), Nota Fiscal Inquiry-Header Browse Review and select generated notas fiscais.
Nota Fiscal Detail Revision W7611BF Select a record and select Detail Revision from the Row menu on the Work With Nota Fiscal Headers form. Review the detail information for a nota fiscal.
Nota Fiscal Taxes Additional Information W7610BB Select Taxes Add Info from the Row menu on the Nota Fiscal Detail Revision form. Add import tax information to notas fiscais.

19.6.3 Adding Import Tax Information to Nota Fiscais

Access the Inbound NF Additional Information form.

Customhouse Charges Amt. (customhouse charges amount)

Enter a value that identifies the amount applied to the customhouse charges.

Financial Ops. Tax Amnt. (financial operations tax amount)

Enter a value that identifies the tax amount applied to the financial operations related to the import declaration.

19.7 Processing PIS/PASEP and COFINS Taxes for Brazil

This section provides overviews of how to process Programa de Integração Social/Programa de Formação do Patrimônio do Servidor Público (PIS/PASEP) and Contribuição para Financiamento da Seguridade Social (COFINS) for sales order transactions, PIS/PASEP and COFINS for ship-to-sales returns, PIS/PASEP and COFINS for ship-from sales returns, and PIS/PASEP and COFINS for reversed and voided transactions.

19.7.1 Understanding PIS/PASEP and COFINS for Sales Order Transactions

When you run the Generate Nota Fiscal program, the system creates the outbound nota fiscal with the temporary nota fiscal number and calculates taxes. The system uses this logic to determine whether to calculate PIS/PASEP and COFINS tax credits:

  1. The system compares the Purchase Use Code for each line item on the nota fiscal to the Purchase Use Codes in the Purchase Use Tax Setup - Brazil table (F76B003).

  2. If the system finds a match between the purchase use codes, the system reads the record in the F76B003 table to determine if a tax code for PIS/PASEP tax credits (data item BTPIS) or COFINS tax credits (data item BTCOF) is associated with the purchase use code.

    If a tax credit code is associated with a purchase use code in the F76B003 table, the system calculates PIS/PASEP or COFINS taxes if the Apply field for the tax specifies that the tax is to be applied. If a tax credit code is associated with the purchase use code in the F76B003 table and the Apply field for the tax does not specify that the tax is to be applied, the system does not calculate the tax for the line.

  3. If the system does not find a match between the purchase use code for a line item and the purchase use codes in the F76B003 table, the system retrieves the tax information for PIS/PASEP and COFINS tax credits (data item BRTAX1 through BRTAX8) from the supplier's address book entry from the Address Book Brazilian Tag File table (F76011) and calculates the tax, based on the code in the address book entry.

    If the supplier's address book entry does not contain a tax valid tax code for PIS/PASEP or COFINS tax credits, the system does not calculate these withholding taxes for the line.

    Note:

    Tax codes for PIS/PASEP and COFINS tax credits are valid only if the Retention/Aggregation/Credit field in the Tax Code table (F76B0401) (data item BRRTA) contains a C. The Generate Nota Fiscal program ignores PIS/PASEP and COFINS tax codes that do not contain a C in the Retention/Aggregation/Credit field.

When it calculates PIS/PASEP and COFINS taxes, the system follows these steps for notas fiscais in the JD Edwards EnterpriseOne Sales Order Management system:

  • Calculates the tax by using this formula: (Nota Fiscal Line Extended Amount + Freight + Insurance + Expenses - Discount Amount) * Rate of PIS/PASEP or COFINS tax.

  • Writes records to the Nota Fiscal Taxes Header - Brazil table (F76B001) and the Nota Fiscal Taxes Detail - Brazil table (F76B011), and marks the records as unprocessed.

19.7.2 Understanding PIS/PASEP and COFINS for Ship-To Sales Returns

You process ship-to sales returns when a customer returns merchandise to you after the client processes the receipt of the merchandise. The customer sends a sales return nota fiscal for the inbound transaction.

When you create a credit memo for a Ship-To sales return, the system:

  1. Retrieves the tax information from the original, outbound nota fiscal from the F76B011 table.

    The system does not calculate PIS/PASEP or COFINS taxes based on the credit order.

  2. Writes records to the F76B011 table to reverse the tax information from the original nota fiscal.

    The new records contain the nota fiscal number from the sales return nota fiscal that the customer sent to you and are marked in the table as "not processed". The amount that the system writes is based on the original tax amount.

  3. Marks the records as processed when you run the PIS COFINS Netting Process program (R76B9011).

19.7.3 Understanding PIS/PASEP and COFINS for Ship-From Sales Returns

You process ship-from sales returns when a customer returns merchandise to you before the client processes the receipt of the merchandise. You produce a nota fiscal for the inbound transaction.

When you create a credit memo for a Ship From sales return, the system:

  1. Retrieves the tax information from the original nota fiscal from the F76B011 table.

    The system does not calculate PIS/PASEP or COFINS taxes based on the credit memo.

  2. Writes records to the F76B011 table to reverse the tax information that appears on the original nota fiscal.

    The new records contain the nota fiscal number from the sales return nota fiscal that you printed during the ship-from sales return process. The system marks the records as not processed. The amount that the system writes is based on the original tax amount.

  3. Marks the records as processed when you run the PIS COFINS Netting Process program.

19.7.4 Understanding PIS/PASEP and COFINS for Reversed and Voided Transactions

To cancel a sales order after generating the nota fiscal but before printing it, you must reverse the nota fiscal by using a version of the Reverse/Void Nota Fiscal program (R76559B) that is set up for reversing not-printed notas fiscais. Version XJDE0001 exists for reversing not-printed notas fiscais. When you use version XJDE0001 or a copy of it, the system deletes the records that are associated with the notas fiscais which you reversed from the nota fiscal tables.

When you use version XJDE0001 of the Reverse/Void Nota Fiscal program to reverse a transaction, the system deletes the tax records for PIS/PASEP and COFINS information from the F76B011 table.

To cancel a sales order after printing it but before running the Update Sales - Brazil program (R76B803), you must reverse the nota fiscal by using a version of the Reverse/Void Nota Fiscal program that is set up for reversing printed notas fiscais. Version XJDE0002 exists for reversing printed notas fiscais. When you use version XJDE0002 or a copy of it, the system retains the records that are associated with the notas fiscais which you reverse in the nota fiscal tables. You must retain these records for fiscal book reporting.

When you use version XJDE0002 of the Reverse/Void Nota Fiscal program to reverse a transaction, the system processes PIS/PASEP and COFINS records in this order:

  1. Retrieves the tax information from the original nota fiscal from the F76B011 table.

  2. Changes the processed code from not processed (0), to processed (1).

    The system does not process these records when you run the PIS COFINS Netting Process program.

See Setting Up Supplier Withholding for Brazil.

19.8 Entering Additional Charges for Nota Fiscais

This section provides an overview of entering additional charges, lists prerequisites, and lists the forms used to enter additional charges for notas fiscais.

19.8.1 Understanding Additional Charges

The Brazilian localizations for the JD Edwards EnterpriseOne Sales Order Management system enables you to enter standard sales order information, such as item and quantity of goods, and lets you enter Brazil-specific information, such as the transaction nature. You also need to enter information about freight, insurance, and other charges into the system. You enter these additional charges for items after running the Generate Nota Fiscal program (R76558B) but before running the Print Nota Fiscal - Sales - Brazil program (R76560B) in final mode. The system adds the additional charges that you enter to the nota fiscal.

You can enter additional charges in the nota fiscal inquiry programs or in the Apply Additional Charges program (P7610B, version ZJDE0003). All of these entry methods use the Nota Fiscal Maintenance - Brazil program (P7610B), but the versions that you use are different. If you enter the additional charges in the Apply Additional Charges program, the system updates the nota fiscal to the next status code when you click OK. If you enter the additional charges in the nota fiscal inquiry programs, the system does not update the status of the nota fiscal; you must update it at a later step in the entry process.

19.8.2 Prerequisites

Before you complete the tasks in this section:

  • Set the processing options for Apply Landed Costs - Purchasing (P7610B, version ZJDE7004) to specify the additional charges parameters that you want to use.

  • Generate notas fiscais.

19.8.3 Forms Used to Enter Additional Charges for Notas Fiscais

Form Name Form ID Navigation Usage
Work With Nota Fiscal Headers W7610BG Sales Order Processing - Brazil (G76B4211), Nota Fiscal Inquiry - Header Browse Review and select nota fiscal records.
Nota Fiscal Header Revision W7610BC Select a nota fiscal and select Header Revision from the Row menu on the Work With Nota Fiscal Headers form. Add and revise nota fiscal header information.
Nota Fiscal Header Additional Information W7610BH Select Header Addl (Additional) Info (Information) from the Form menu on the Nota Fiscal Header Revision form. Add and revise additional information for nota fiscal headers.

19.9 Working with Print Messages for Notas Fiscais

This section provides overviews of printing messages for notas fiscais and entering preference profiles, and discusses how to revise print messages for nota fiscal text.

19.9.1 Understanding Printing Messages for Notas Fiscais

As you work with master tables, you might enter messages in the tables that you want to print on the nota fiscal for specific customers, items, or customer/item combinations. For example, you might enter in the Customer Master table (F0301) a message that is pulled into the Sales Order Header File table (F4201) and which the system accesses when you run the Generate Nota Fiscal program (R76558B).

This list shows the tables in which the system stores messages that are used by the Generate Nota Fiscal program:

  • Sales Order Header File (F4201).

  • Sales Order Detail File (F4211).

  • Sales Order Detail Tag File - Brazil (F76422).

  • IPI Taxes (F76B18).

  • Transaction Nature - Brazil (F7615B).

  • Preference Profile - Print Messages (F40305).

This graphic shows how print messages flow from source tables into the tables that the system reads when you run then Generate Nota Fiscal program:

Figure 19-3 Nota fiscal print messages

Description of Figure 19-3 follows
Description of ''Figure 19-3 Nota fiscal print messages''

When you run the Generate Nota Fiscal program, the system calls messages from these tables and writes them to the Nota Fiscal Print Message - Brazil table (F7612B). You can revise messages in this table by using the Nota Fiscal Text Revisions - Brazil program (P7612B). Additionally, you can enter a message that you want to appear on the nota fiscal in the processing options for the Generate Nota Fiscal program. Before you run the Generate Nota Fiscal program, set the print message processing options to specify the messages to print on the nota fiscal and the order in which the messages print. Then, when you run the Print Nota Fiscal - Sales - Brazil program (R76560B), the system prints the messages that you specified on the nota fiscal.

You can set up print messages by customer/item combination, item group/customer group combination, and by item. You must set up preference profiles before you can use these messages.

19.9.2 Understanding Preference Profiles for Print Messages

You can set up different messages for various customer/item and item group/customer group combinations, and by item. Before you can use these messages, you must set up preference profiles for print messages.

To set up preference profiles for print messages, perform these tasks in this order:

  1. Set up the Documents Using Text Messages UDC (40/OR).

    You must set up a code for the Generate Nota Fiscal program (R76558B) before you can use preference profiles for print messages.

  2. Set up messages.

  3. Set up the Preference Master.

  4. Select preference processing for Sales Order Entry in the processing options for the Sales Order Entry program.

19.9.3 Forms Used to Revise Print Messages

Form Name Form ID Navigation Usage
Work with Nota Fiscal Text W7612BA Sales Order Processing - Brazil (G76B4211), Nota Fiscal Text Revision Review and select nota fiscal records to which you want to attach a message.
Nota Fiscal Text Revision W7612BC Select a nota fiscal on the Work with Nota Fiscal Text form. Add and revise text messages for the nota fiscal.

19.9.4 Revising Print Messages for Nota Fiscal Text

Access the Nota Fiscal Text Revision form.

When you run the Generate Nota Fiscal program, the system writes text messages from other tables to the Nota Fiscal Print Message - Brazil table (F7612B). The Nota Fiscal Text Revision program (P7612B) enables you to maintain the text messages that the system stores in this table. You can access the Nota Fiscal Text Revision program from a menu, or from a Form menu in the Nota Fiscal Maintenance - Brazil (P7610B) program.

19.10 Entering the Correction Letter (CC-e) for the Nota Fiscais (Release 9.2 Update)

This section provides an overview of the electronic correction letter, and discusses how to enter the correction letter information for an outbound nota fiscais.

19.10.1 Understanding an Electronic Correction Letter (CC-e) for Nota Fiscais

An electronic correction letter (CC-e) is an NFe event that informs the government and NF-e recipients about any incorrect information contained in an NFe that is already authorized by the government. The event author for an electronic correction letter is the NF-e issuer. In Portuguese, the NFe event is known as Carta de Correção eletrônica (evento: Carta de Correcao).

The Brazilian government allows the generation of an XML file for the correction letter.

The correction letter is intended to communicate any errors present in invoices. It is a commercial document that has no legal enforcement by the ICMS (Imposto Sobre Operações Relativas à Circulação de Mercadorias e Serviços de Transporte Interestadual de Intermunicipal e de Comunicações) legislation. The tax authorities informally admit the Correction Letter to correct some secondary information that is not relevant (for instance, minor corrections on the address).

The Correction Letter is accepted to correct the data that are not values or dates.

19.10.2 Prerequisites

Before you complete the tasks in this section, you must set up the following:

  • Correction Letter Issue Period (76B/CL)

    Set up this UDC to specify the number of hours valid for issuing a correction letter from the time the NFe was authorized, for each state. The system considers the NFe processed time from the NFe status log (F76B12TE) table as the NFe authorized time. When the UDC value is not specified for a state, the system considers the default value of 720 hours.

  • CCe Email Prevention List (76B/EL)

    The UDC table (76B/EL) allows the NFe issuer to optionalize sending email notifications. If the NFe issuer decides not to send automated emails to particular address numbers, then the specific address numbers need to be mentioned in the UDC table (76B/EL). The system considers the address numbers added in this UDC table and eliminates them from receiving email notifications.

  • Brazil Legal Disclaimer Setup (P76B601)

    You must set up the legal disclaimer text for Brazil before you submit the Correction Letter to SEFAZ for authorization.

19.10.3 Forms Used to the Enter Correction Letter

Form Name Form ID Navigation Usage
Work with Nota Fiscal Headers W7610BG Sales Order Processing - Brazil (G76B4211), Nota Fiscal Inquiry - Header Browse - Work With Nota Fiscal Headers, select a record, and then select Correction Letter from the Row menu. Review, generate, and respond to the correction letter.
Work With Stand Alone Nota Fiscal Header W7611BA Stand-Alone Nota Fiscal - Brazil (G76B4321),Work With Stand Alone Nota Fiscal Header, select a record, and then select Correction Letter from the Row menu. Review, generate, and respond to the correction letter.
Work with NFe Correction Letter W76B600A Select a record from the Work With Nota Fiscal Headers form or Work With Stand Alone Nota Fiscal Header form, and then select Correction Letter from the Row menu. Review, generate, and respond to the correction letter.

19.10.4 Setting Up the Work with Nota Fiscal Headers for Correction Letter

Access the Work with Nota Fiscal Headers (P7610B) form.

The P7610B application allows the system to process the correction letter event for the selected NFe. The correction letter is eligible only for the electronic nota fiscals that are accepted by the SEFAZ and that are originated by the company.

19.10.5 Setting Up the Work With Stand Alone Nota Fiscal Header for Correction Letter

Access the Work With Stand Alone Nota Fiscal Header (P7611B) form.

The P7611B application allows the system to process the correction letter event for the selected NFe. The correction letter is eligible only for the electronic nota fiscals that are accepted by the SEFAZ and that are originated by the company.

19.10.6 Entering the Correction Events in the Work with NFe Correction Letter

Access the Work with NFe Correction Letter (P76B600) form.

The P76B600 application allows you to add the correction letter information for an NFe. The correction letter is intended to communicate errors on the electronic nota fiscals that were authorized by the SEFAZ. The correction information is manually entered in the correction text field.

While creating the correction letter, the system performs the following validations:

  • You need to check if there are existing events for the same NF-e. If yes, check if you are allowed to issue another event. (A new CC-e cannot be issued as long as there is a pending response from the tax authority for another CC-e.)

  • The default limit of CC-e for one NF-e is 20. You can set up the limit in the NFe Correction Letter - Brazil - 76B (P76B600) processing option.

  • The UDC table (76B/CL) is used to enter the number of hours allowed from the authorization date to issue the correction letter for an NFe.

The table below describes each status of the correction letter.

Status Descriptions
Initial (I)
  • When a correction letter is added, the status is designated as Initial.
  • You can edit the correction letter. However, new correction letters cannot be added for the NFe until the existing correction letter has been processed by the SEFAZ.

Generated (G)
  • When the XML file is generated in the Final mode, the CCe status is designated as Generated.
  • You cannot edit the correction letter.

  • No new correction letters can be added for the NFe until the existing correction letter has been processed by the SEFAZ.

  • The system allows the deletion of a correction event at Initial and Generated status.

Accepted (A)
  • You need to populate the Response information for the CCe from the Brazilian tax authorities. The fields Correction Authorization Date and Time are displayed only for Accept Response.
  • The CCe status is Accepted when the fiscal authority has accepted or approved the CCe file.

  • NFe is eligible to add a new correction letter if there are no pending or open correction letters.

  • After the Response is added and you click OK, the system updates the information in the F76B600 table, and sends the automated email notification to the users.

Error (E)
  • You need to populate the Response information for the CCe from the Brazilian tax authorities.
  • The CCe status is Error if the fiscal authority has found errors in the XML validation.

  • NFe is eligible to add a new correction letter if there are no pending or open correction letters.

  • Once the Response is added and clicked OK, the system updates the information in the F76B600 table.

Rejected (R)
  • You need to populate the Response information for the CCe from the Brazilian tax authorities.
  • The CCe status is Rejected if the fiscal authority has denied or rejected the CCe.

  • NFe is eligible to add a new correction letter if there are no pending or open correction letters.

  • Once the Response is added and clicked OK, the system updates the information in the F76B600 table.


NFe Correction Letter Text

Enter the correction letter text. It can include 15 - 1000 characters; special characters are not allowed, except space and dot. The correction letter information is retained in the NFe Correction Letter Details - 76B (F76B600) table. When you try to add a new correction letter, the system extracts the previous correction information from the last correction letter.

19.10.7 Setting Processing Options for Correction Letter Generation -BRA -76B (R76B611)

Processing options enable you to specify the default processing for programs and reports.

19.10.7.1 Default

Environment Identification

Enter a value to specify the type of processing for an event. Values are:

1: Production (default value)

2: Certification

Code of the Reception of the Event

Enter a value to specify the code of reception of the event. If left blank, Description 02 is assigned based on the issuer state code from the UDC 76B/UF.

Specify Layout Version Number

Enter the version number of the file. Versions are sequential. The default version is 1.0.

Indicate index number in the system 76B to assign the Lot number

Enter the element number retrieved in the Next Number Revisions program. The default value is 4.

Specify Event Version Number

Enter the version number of the file. Versions are sequential. The default version is 1.0.

19.10.7.2 Process

XML Generation Mode

Enter an option that specifies the type of processing for an event. Values are:

Blank: Proof

1: Final

19.10.8 Setting Up the Processing Option for NFe Correction Letter - Brazil - 76B (P76B600)

Processing options enable you to specify the default processing for programs and reports.

19.10.8.1 Default

Enter the number of correction events allowed for a NFe

Enter a value to specify the maximum number of correction events allowed for an NFe. The default value is 20.

19.11 Reviewing Outbound Notas Fiscais

This section provides an overview of outbound notas fiscais review and discusses how to review outbound nota fiscal information.

Note:

If the nota fiscal is for the sale of a service, you can modify or add PIS, COFINS, and CSLL withholding information.

See Working with Sales Orders and Notas Fiscais with Withholding for Services Sold (Release 9.2 Update)

19.11.1 Understanding Outbound Notas Fiscais Review

After you generate and print (in proof mode) outbound notas fiscais, you can review the documents online to verify that the information is correct. If some data is incorrect, you can make changes online. Review notas fiscais by order number or by nota fiscal number.

Note:

If you review notas fiscais documents after printing in proof mode; a unique, system-generated next number represents the nota fiscal number for each document. If you review notas fiscais after printing in final mode, the nota fiscal number is the official, government-assigned number.

19.11.2 Forms Used to Review Outbound Nota Fiscal Information

Form Name Form ID Navigation Usage
Work With Nota Fiscal Headers W7610BG Sales Order Processing - Brazil (G76B4211), Nota Fiscal Inquiry - Header Browse Review and select nota fiscal records.
Nota Fiscal Header Revision W7610BD Select a record, and select Header Revision from the Row menu on the Work With Nota Fiscal Headers program. Review nota fiscal information for freight, service tax, merchandise tax.
Nota Fiscal Detail Revision W7610BE Select Detail Revision from the Form menu on the Nota Fiscal Header Revision form. Review and revise detail information for the nota fiscal record.
Nota Fiscal Detail Additional Information W7610BJ Select a record, and select Detail Addl Info (Additional Information) from the Row menu on the Nota Fiscal Detail Revision form. Review additional information for the nota fiscal record, like the calculated amounts for different concepts applicable to the fiscal note. You can only revise and manually override limited pieces of information on this form.

19.11.3 Reviewing Outbound Nota Fiscal Information

Access the Nota Fiscal Header Revision form.

Figure 19-4 Nota Fiscal Header Revision form

Description of Figure 19-4 follows
Description of ''Figure 19-4 Nota Fiscal Header Revision form''

Substitution Code

Review this code to determine whether a client or product is subject to tax substitution. Values are:

Y: Use list price.

Z: Use net price.

N: No.

Substitution Tax

Review the ICMS Substitute amount that the customer must remit in advance if they are subject to Tax Substitution Mark-up.

ICMS Basis

Review the amount on which ICMS taxes are assessed.

Substitution Basis

Review the amount on which ICMS Substitute tax is assessed. Products that are eligible for ICMS Substitute tax are listed in ICMS government directive 14.

IPI Rate

Enter a number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.

Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.

The IPI (Imposto sobre Produtos Industrializados) is a Brazilian federal excise tax the government levies on manufactured products. The tax rate varies and is payable at the point of production

IPI Tax

Review the IPI tax amount that is printed on the nota fiscal.

IPI Code

Review this code, which indicates how IPI tax is assessed. This code determines in which column of the Inbound/Outbound Fiscal Book the system prints the IPI tax amount. You must enter a code that already exists in the IPI Code Fiscal Value (76/IP) UDC table. Values are:

1: Taxable.

2: Exempt or not taxable.

3: Other.

IPI Basis

Review the amount on which IPI taxes are assessed.

NF Discount

Review the amount of the discount amount available for the nota fiscal.

19.12 Printing Outbound Notas Fiscais

This section provides an overview of outbound notas fiscais and discusses how to:

  • Run the Print Nota Fiscal program.

  • Set processing options for Print Nota Fiscal (R764560B).

19.12.1 Understanding Outbound Notas Fiscais

You can print the outbound (sales) notas fiscais that you send to the customers. After you generate and review the outbound nota fiscal, you can print notas fiscais to include in the shipments.

You can print notas fiscais in proof or final mode. When you print the documents in final mode, the system updates each system-assigned document number with the appropriate official nota fiscal number, based on the information that you set up in the Nota Fiscal Next Number Control - Brazil table (F7600B).

Note:

If you use the electronic nota fiscal process, the system obtains the nota fiscal number by sending a file to the government through a transmission software, and returning the number to you.

19.12.1.1 Tax Transparency and Printed Notas Fiscais

In compliance with the Consumer Protection Code regulations, the fiscal notes printed for final consumers must include:

  • The approximate total amount of federal, state, and municipal taxes levied for each good or service sold, showing on each line in the detail section

  • The approximate total amount of taxes for all items and services sold, detailed in the footer

The information for each item sold listed in the detail area includes:

  • The taxable basis amount, which is calculated according to the following rules (the system retrieves values from table F7611B)

    • The taxable basis for goods is calculated by multiplying the Unit Sales Price of the item by the quantity sold plus any freight, insurance, and other accessory expenses, minus discounts, and adding the applicable taxes (State ICMS and IPI taxes).

      Taxable basis for Goods = (Unit Sales Price X Quantity) + Freight + Insurance + Other Accessory Expenses - Discounts + ICMS-ST + IPI.

    • The taxable basis for services is calculated by multiplying the Unit Sales Price of the item by the quantity sold plus any accessory expenses, minus applicable discounts.

      Taxable basis for Services = (Unit Sales Price X Quantity) + Other Accessory Expenses - Discounts.

    • The calculations use the following fields from the Nota Fiscal Detail - BRA table (F7611B):

      • Unit Sales Price (UPRC)

      • Quantity (UORG)

      • Freight (BFRT)

      • Insurance (BSEG)

      • Expenses (BDFN)

      • Discount (BDES)

      • ICMS (BICM)

      • ST (BVIS)

      • IPI (BIPI)

  • The applicable rate, which is the taxable basis multiplied by a rate. Depending on the Item Origin the calculation uses the National Rate (aliqNac) or the Import rate (aliqImp) that are stored in the IBPT and IPI Tax Revisions program (P76B18).

    The Item Origin is defined on UDC 76/IO and if the special handling code includes a "1" in the second position, it indicates that the item is imported.

    The system uses the Nota Fiscal printed date to validate the rate effective date.

  • The approximate total of taxes.

  • The source of the tax information.

19.12.2 Running the Print Nota Fiscal Program

Select Sales Order Processing - Brazil (G76B4211), Print Nota Fiscal.

19.12.3 Setting Processing Options for Print Nota Fiscal (R76560B)

Processing options enable you to specify the default processing for programs and reports.

19.12.3.1 Select

1. Next Status Code - From (Required)

Enter a UDC (40/AT) to specify the beginning of the range of the next status of the notas fiscais that you want to select. You select a status from the Activity/Status UDC (40/AT). The status you select must be set up in the order activity rules based on the order type and the line type of the notas fiscais that you want to select. The combination of codes that you select for this processing option and the Next Status Code - To processing option in this program must be a valid last status/next status combination in the Order Activity Rules table (F40203).

2. Next Status Code - To (Required)

Enter a UDC (40/AT) to specify the end of the range of the next status of the notas fiscais that you select. You select a status from the Activity/Status Codes UDC (40/AT). The status you select must be set up in the order activity rules based on the order type and the line type of the notas fiscais that you want to select. The combination of codes that you select for this processing option and the Next Status Code - From processing option in this program must be a valid last status/next status combination in the Order Activity Rules table (F40203).

19.12.3.2 Defaults

1. Invoice Document Type

Enter a UDC (00/DI) to identify the invoice document type. The value that you enter must exist in the Document Type - Invoices Only (00/DI) UDC. The same code must also exist in the Document Type - All Documents (00/DT) UDC. If you leave this processing option blank, the system uses RI for the invoice document type.

2. Issue Date

Enter the date that the system uses for the issue date of the nota fiscal. If you leave this field blank, the system date is used.

3. Next Status Code - Sales Order

Enter a code (UDC 40/AT) to specify the beginning of the range of the next status of the notas fiscais that you want to select. You select a status from the Activity/Status UDC (40/AT). The status you select must be set up in the order activity rules based on the order type and the line type of the notas fiscais that you want to select. The combination of codes that you select for this processing option and the Next Status Code - To processing option in this program must be a valid last status/next status combination in the Order Activity Rules table (F40203).

4. Next Status Code - Nota Fiscal

Enter a code from the Activity/Status UDC (40/AT) table to specify the beginning of the range of the next status of the notas fiscais that you want to select. The status you enter must be set up in the order activity rules based on the order type and the line type of the notas fiscais that you want to select. The combination of codes that you select for this processing option and the Next Status Code - To processing option in this program must be a valid last status/next status combination in the Order Activity Rules table (F40203).

19.12.3.3 Process

1. Mode

Specify whether to run the program in proof or final mode. Values are:

Blank: Print the notas fiscais in proof mode.

1 Final mode.

2. Summarize Nota Fiscal (Future)

Specify whether the system prints an ICMS and IPI tax summary on the nota fiscal. Values are:

Blank: Do not print an ICMS and IPI tax summary on the nota fiscal.

1: Print a tax summary.

19.12.3.4 Print

1. ICMS and IPI Tax Summary

Specify whether the system summarizes nota fiscal detail line by item and lot. Value are:

Blank: Do not summarize nota fiscal detail lines by item and lot.

1: Summarize by item and lot.

2. Data Edits

Specify whether the system prints the total of the nota fiscal in words at the end of the nota fiscal. Values are:

Blank: Print the total of the nota fiscal in words at the end of the nota fiscal.

1: Do not print the total in words.

3. Withholding Error Message

Enter the text to print on the notas fiscais for services sold to a corporate entity that are not subject to withholding. The system uses the values in the F76B427 and F76B428 tables to determine if the service is subject to withholding.

19.12.3.5 NFe

These processing options determine whether the system calls the Nota Fiscal Elec. - Outbound (R76B560Z1) program to process electronic notas fiscais.

Generate NFe Information (Generate electronic nota fiscal information)

Enter 1 to generate the output file for the electronic nota fiscal process. When you enter 1, the system calls the Nota Fiscal Elec. - Outbound program to convert the nota fiscal to an XML version, and saves the data to the XML Transaction Interface (F70XMLZ1) table.

Enter the Version for R76B560Z1

Enter the version of the Nota Fiscal Elec. - Outbound program to run, if you specified to run the Nota Fiscal Elec. - Outbound program after the Print Nota Fiscal program. If you leave this processing option blank and have selected to run the Nota Fiscal Elec. - Outbound program, the system uses version ZJDE00001.

19.13 Entering Transfer Orders for Brazil

This section provides an overview of transfer orders for Brazil and lists the forms used to enter transfer orders.

19.13.1 Understanding Transfer Orders for Brazil

You enter a transfer order to ship inventory between branch/plants within the company, maintain an accurate on-hand inventory amount, and provide tax information for notas fiscais. The transfer order program:

  • Creates a sales order for the shipping location that represents the supplier.

  • Creates a purchase order for the receiving location that represents the customer.

  • Processes the inventory amounts on the transfer order as a formal purchase and sale of goods.

  • Creates documents, such as pick slips or invoices, that are necessary to complete the transfer.

You enter transfer orders to input information about inventory that you move from one location to the other. Transfer orders are used in two situations:

  • One location needs inventory from another location within the same branch plant.

  • One branch plant needs inventory from another branch plant within the same company.

    Note:

    When you generate a transfer order, the system automatically creates a purchase order with its corresponding Brazilian tag file information. The system creates this Brazilian tag file information with default values.

19.13.2 Forms Used to Enter Transfer Orders for Brazil

Form Name Form ID Navigation Usage
Customer Service Inquiry W4210E Purchase Return (G76B4212), Transfer Orders Review and select orders.
Sales Order Detail Revisions W4210A Click Add on the Customer Service Inquiry form. Add and revise orders.
S.O. Brazilian Information Header W4210BRL Enter a sales order and click OK on the Sales Order Detail Revisions form. Enter transaction nature information for Brazil.
S.O. Brazilian Information Detail W4210BRI Enter the Brazilian Header information and click OK on the S.O. Brazilian Information Header form. Review the detail information about the order.

19.14 Working With Returns, Reverses, and Cancellations in Brazil

This section provides an overview of sales order returns, reverses, and cancellations; an overview of how to process recoverable tax amounts for purchase order returns in Brazil; lists prerequisites; and discusses how to:

  • Run the Reverse/Void Nota Fiscal program.

  • Set the processing options for Reverse/Void Nota Fiscal (R76559B).

  • Set processing options for Sales/Purchase Returns - Brazil (P76B805).

  • Enter nota fiscal information for ship-to order returns.

19.14.1 Understanding Sales Order Returns, Reverses, and Cancellations

Occasionally, you need to cancel sales orders or process the return of products. You process cancellations and returns differently, depending on the processing stage at which the cancellation or return occurs. This table describes the actions that you must take at different processing stages:

Sales Order and Nota Fiscal Action Effect
You enter a sales order, but a nota fiscal is not generated. You cancel the order by changing the order status to canceled. None. No accounting entries were created.
You generate a nota fiscal, but it is not printed. You reverse the nota fiscal using the version for nonprinted notas fiscais in the Reverse/Void Nota Fiscal (R76559B) program. The system deletes the records from these tables:
  • Nota Fiscal Header - Brazil table (F7601B) and its tag file (F76B1001).

  • Nota Fiscal Detail - Brazil table (F7611B) and its tag file (F76B1010).

  • Nota Fiscal Print Message - Brazil (F7612B).

  • Nota Fiscal Taxes Header - Brazil table (F76B001).

  • Nota Fiscal Taxes Detail - Brazil (F76B011).

  • Authorized Persons by Nota Fiscal - Brazil (F76B1020)

The records are not reported in the fiscal books.

You print the nota fiscal but have not run the Sales Update program, and you have not shipped the products. You reverse the nota fiscal, using the version for printed notas fiscais in the Reverse/Void Nota Fiscal program. Close the sales order. The system does not delete nota fiscal records from the F7601B, F7611B, F7612B, F76B001, and F76B011 tables. These records are reported in the fiscal books by using the status code that you specified in the processing options for the Reverse/Void Nota Fiscal program.
You print the nota fiscal and run the Sales Update program. You ship the products, and the products are returned to you before the buyer receives the products. You create and print an inbound nota fiscal by using the Sales Return - Ship From program (version ZJDE7004). The system creates reversing entries for items and expenses as determined by processing options, and updates inventory records.
You ship the products, and they are received by the buyer. The buyer returns some or all of the products to you. The buyer issues an inbound nota fiscal to you. You use the Sales Return - Ship To program (version ZJDE7003) to enter the information from the nota fiscal that the buyer issued into the system. You do not print a nota fiscal for the return. The system creates records in the nota fiscal tables for reporting in the fiscal books.

To cancel a sales order before you generate the nota fiscal, you cancel the sales order by using the Sales Order Entry program to update the sales order to a closed status. Since no records are created in the nota fiscal tables until you generate the nota fiscal, you do not create any reversing accounting entries.

19.14.1.1 Nota Fiscal Reversals

To cancel a sales order after generating the nota fiscal but before printing it, you must reverse the nota fiscal by using a version of the Reverse/Void Nota Fiscal program that is set up for reversing nonprinted notas fiscais. Version XJDE0001 exists for reversing nonprinted notas fiscais. When you use version XJDE0001 or a copy of it, the system deletes the records that are associated with the notas fiscais which you reversed from the nota fiscal tables.

To cancel a sales order after printing it but before running the Update Sales - Brazil program (R76B803), you must reverse the nota fiscal by using a version of the Reverse/Void Nota Fiscal program that is set up for reversing printed notas fiscais. Version XJDE0002 exists for reversing printed notas fiscais. When you use version XJDE0002 or a copy of it, the system retains the records that are associated with the notas fiscais which you reverse in the nota fiscal tables. You must retain these records for fiscal book reporting.

In addition to reversing the nota fiscal, you must either reuse or close the sales order. It is strongly recommended that you close the sales order.

Note:

When you cancel a nota fiscal for which a record exists in the Nota Fiscal Taxes Detail - Brazil table, the system changes the processed flag in the record to 1 to indicate that the record is closed. When you run the PIS COFINS Netting Process program (R76B9011), the system does not process the record.

19.14.1.2 Ship-To Sales Returns

To process the cancellation of an order after you have run the Update Sales - Brazil program, you must process the cancellation as a sales return. You must consider the price for the merchandise, and the taxes and other fees charged on the original printed nota fiscal when you process the return so that the appropriate reversing entries are made to the financial and inventory systems.

You use the Ship-To sales return process when the company to which you shipped the merchandise returns the merchandise after receiving it into its inventory. The returning company must send a nota fiscal with the returned merchandise.

Brazil requires that a nota fiscal accompany all products that are shipped. If the company to which you shipped the merchandise returns the merchandise after receiving it into its inventory, the company must create a nota fiscal to accompany the return. This type of a return is referred to as a "ship-to" sales return. When you receive the returned merchandise, you must complete these steps in this order:

  1. Use the Sales Return - Ship To program (version ZJDE7003) to enter the information for the nota fiscal into the system, create detail lines for the returned items, and associate the original nota fiscal with the nota fiscal that is sent with the returned merchandise.

    Note:

    The P4210 program calls the Sales/Purchase Returns - Brazil (P76B805) and Sales Order Brazilian Additional Information - Brazil (P4210BR) programs. These programs enable you to enter either the legal number for a paper nota fiscal or the electronic nota fiscal number for end consumer notas fiscais and national electronic notas fiscais. National electronic notas fiscais are those that are not specific to Saõ Paulo.
  2. Run the ZJDE7002 version of the Shipment Confirm program (P4205).

  3. Generate the return nota fiscal by running the version of the Generate Nota Fiscal program (R76558B) that you set up for ship-to sales returns.

    Note:

    Make a note of the value that the system provides for the Order Number field on the Create Sales Ledger Details form. You will use this number later in the return process.

    To complete the ship-to return process, you must ship confirm the order and then generate the nota fiscal.

This table lists some considerations for the ship-to sales return process:

Program Considerations
Sales Ledger Inquiry (P42025) These considerations apply:
  • The Sales Ledger Inquiry program must have a version that matches the version that you use in Sales Order Entry.

    If you use version ZJDE7003 (Sales Return - Ship To) in Sales Order Entry, you must set up version ZJDE7003 in the Sales Ledger Inquiry program.

  • For the Order Type processing option on the Default tab, select the code that represents a nota fiscal batch return.

  • Consider making the range of statuses that is specified by the Status Code - From and Status Code - Thru processing options on the Default tab as wide as possible.

    For example, if you enter 520 for the Status Code - From processing option and enter 999 for the Status Code - To processing option, the system searches over a wide range of notas fiscais when it uses the Sales Ledger Inquiry program.

  • For the Enter Status Code processing option on the Credit Memo tab, enter the next status of the nota fiscal that was sent with the merchandise that is now being returned.

    For example, if 999 is the next status of an order for which the sales update is run, enter 999 for this processing option.

  • You do not need to enter a value for the second processing option on the Credit Memo tab.

  • You do not need to enter values on the Versions tab because the Sales Ledger Inquiry program is called from the Sales Order Entry program.

Sales/Purchase Returns - Brazil (P76B805) These considerations apply:
  • The Sales/Purchase Returns - Brazil program must have a version that matches the version that you use in Sales Order Entry.

    If you use version ZJDE7003 (Sales Order Entry - Return Order - Ship To) in Sales Order Entry, you must set up version ZJDE7003 in the Sales/Purchase Returns - Brazil program.

  • Consider making the range of statuses that is specified by the Next Status Code - From and Next Status Code - Thru processing options on the Select tab as wide as possible.

    For example, if you enter 520 for the Next Status Code - From processing option and enter 999 for the Next Status Code - To processing option, the system searches over a wide range of notas fiscais when it uses the Sales/Purchase Returns - Brazil program.

Sales Return - Ship To (P4210/ZDJE7003) These considerations apply:
  • For the Order Type processing option on the Defaults tab, enter the code that represents sales order returns.

  • For the Line Type processing option on the Defaults tab, enter the code that represents a ship-to credit.

  • For the Beginning Status, enter the status that represents Enter Sales Order.

  • For the Sales Ledger Inquiry processing option on the Version tab, enter the version that matches the version of Purchase Order Entry that you are using.


19.14.1.3 Setting Up Ship-To Return Versions

Set up the Sales Ledger Inquiry program (P42025) with a version that corresponds to the version of Sales Order Entry program (P4210) that you use to process the return. For example, version ZJDE7003 of the Sales Order Entry program in the base JD Edwards EnterpriseOne Sales Order Management software is set up for processing sales order returns when the buyer receives and then returns merchandise. If you use this version for processing the return, you must set up a version ZJDE7003 in the Sales Ledger Inquiry program.

Set up the Sales/Purchase Returns - Brazil program (P76B805) with a version that corresponds to the version of the Sales Order Entry program that you use to process the return. For example, version ZJDE7003 of the Sales Order Entry program in the base JD Edwards EnterpriseOne Sales Order Management software is set up for processing sales order returns when the buyer receives and then returns merchandise. If you use this version for processing the return, you must set up a version ZJDE7003 in the Sales/Purchase Returns - Brazil program.

You can create "Sales Return Ship to" fiscal notes when working with Classic notas fiscais, National NF-e or NFC-e.

19.14.1.4 Ship-From Sales Returns

To process the cancellation of an order after you have run the Update Sales - Brazil program, you must process the cancellation as a sales return. You must consider the price for the merchandise, and the taxes and other fees charged on the original printed nota fiscal when you process the return so that the appropriate reversing entries are made to the financial and inventory systems.

You use the Ship-From sales return process when the company to which you shipped the merchandise returns the merchandise before they received the merchandise into their inventory. You must create a nota fiscal to account for this type of transaction. When you process this type of sales return, you must process the return in this order:

  1. Use the Sales Order Entry - Return Order - Ship From program (version ZJDE7004) to create detail lines for the returned items and associate the original nota fiscal with the nota fiscal that you create for the return.

  2. Run the ZJDE7002 version of the Shipment Confirm program.

  3. Generate the return nota fiscal by running the XJDE0003 version of the Generate Nota Fiscal program.

  4. Print the nota fiscal for the return in final mode by using the Print Nota Fiscal - Ship From program (R76560B).

  5. Update the sales for Brazil by running the Sales Update - Brazil program (R76B803).

This table lists some considerations for the ship-from sales return process:

Program Considerations
Sales Ledger Inquiry These considerations apply:
  • The Sales Ledger Inquiry program must have a version that matches the version that you use in Sales Order Entry.

    If you use version ZJDE7004 (Sales Return - Ship From) in Sales Order Entry, you must set up version ZJDE7004 in The Sales Ledger Inquiry program.

  • For the Order Type processing option on the Defaults tab, select the code that represents a nota fiscal batch return.

  • Consider making the range of status that is specified by the Status Code - From and Status Code - Thru processing options on the Defaults tab as wide as possible.

    For example, if you enter 520 for the Status Code - From processing option and enter 999 for the Status Code - To processing option, the system searches over a wide range of notas fiscais when it uses the Sales Ledger Inquiry program.

  • For the Enter Status Code processing option on the Credit Memo tab, enter the next status of the nota fiscal that was sent with the merchandise that is now being returned.

    For example, if 999 is the next status of an order for which the sales update is run, enter 999 for this processing option.

  • You do not need to enter a value for the second processing option on the Credit Memo tab.

  • You do not need to enter values on the Versions tab because the Sales Ledger Inquiry program is called from the Sales Order Entry program.

Sales/Purchase Returns - Brazil (P76B805) These considerations apply:
  • The Sales/Purchase Returns - Brazil program must have a version that matches the version you use in Sales Order Entry.

    If you use version ZJDE7004 (Sales Return - Ship From) in Sales Order Entry, you must set up version ZJDE7004 in the Sales/Purchase Returns - Brazil program.

  • Consider making the range of status specified by the Next Status Code - From and Next Status Code - Thru processing options on the Select tab as wide as possible.

    For example, if you enter 520 for the Next Status Code - From processing option and enter 999 for the Next Status Code - To processing option, the system searches over a wide range of notas fiscais when it uses the Sales/Purchase Returns - Brazil program.

Sales Return - Ship From (P4210/ZDJE7004) These considerations apply:
  • For the Order Type processing option on the Defaults tab, enter the code that represents sales order returns.

  • For the Line Type processing option on the Defaults tab, enter the code that represents a ship-to credit.

  • For the Beginning Status processing option on the Defaults tab, enter the status that represents Enter Sales Order.

  • For the Sales Ledger Inquiry processing option on the Versions tab, enter the version that matches the version of Sales Order Entry that you are using.


19.14.1.5 Setting Up Ship-From Return Versions

Set up the Sales Ledger Inquiry program with a version that corresponds to the version of the Sales Order Entry program that you use to process the return. For example, version ZJDE7004 of the Sales Order Entry program in the base JD Edwards EnterpriseOne Sales Order Management software is set up for processing sales order returns when the buyer did not receive the merchandise. If you use this version for processing the return, you must set up a version ZJDE7004 in the Sales Ledger Inquiry program.

Set up the Sales/Purchase Returns - Brazil program with a version that corresponds to the version of the Sales Order Entry program that you use to process the return. For example, version ZJDE7004 of the Sales Order Entry program in the base JD Edwards EnterpriseOne Sales Order Management software is set up for processing sales order returns when the buyer did not receive the merchandise. If you use this version for processing the return, you must set up a version ZJDE7004 in the Sales/Purchase Returns - Brazil program.

19.14.2 Understanding How to Process Recoverable Tax Amounts for Purchase Order Returns in Brazil

The Sales Update – Brazil program (R76B803) enables you to process recoverable tax amounts for purchase order return transactions. You run the Sales Update – Brazil program to update the Sales Order Header File (F4201) and Sales Order Detail File (F4211) tables after you enter the credit order in the Sales Order Entry program (P4210). The Sales Update – Brazil program uses the nota fiscal number of the purchase return to access the Purchase Use (76/PU) UDC table to verify if amounts for specific tax types are recoverable.

This table shows the values that must exist in the Special Handling Code field of the 76/PU UDC table to indicate that amounts for a tax type are recoverable:

Tax Type Value and Position in Special Handling Code Field
IPI Value of 1 in position 1.
ICMS Value of 1 in position 2.
ICMS Substitution Value of 1 in position 3.
PIS Value of 1 in position 5.
COFINS Value of 1 in position 6.

If the position for the tax type in the Special Handling Code field is blank or includes a value other than 1, the system does not process the tax lines as recoverable when you process purchase order returns.

A processing option in the Sales Update – Brazil program enables you to specify the line type to process as recoverable tax.

To set up your system and reverse taxes for purchase order returns:

  1. Verify that AAIs 4220 and 4240 are set up to process IPI, ICMS, ICMS substitution, PIS, and COFINS recoverable taxes.

  2. Set up a line type in the Order Line Types program (P40205) to use to identify recoverable tax lines on purchase order returns.

    You must clear the A/R Interface and A/P Interface options, and select the G/L Interface and Inv. Interface options on the Line Type Constants Revision form for the line type that you set up for the recoverable tax lines.

  3. Set up order activity rules for the purchase return document with the line type that you set up for recoverable tax lines.

    The order activity rules for the purchase return should include two steps; one to generate tax lines when you run the Sales Update-Brazil program and another to run the Sales Update program (R42800). The statuses for these purchase return steps should be the same as the statuses for the processing of the tax lines when you run the Sales Update – Brazil program.

  4. Set up two versions of the Sales Update program.

    You set up a version to update accounts receivable records and one to omit the update to accounts receivable records. You use the version that does not update accounts receivable records to reverse the tax lines for the purchase return.

    Note:

    For most transactions, you use a version of the Sales Update program that updates the accounts receivable records. You might have an existing version that you can use. The version that you must set up that does not update accounts receivable records is specific for purchase order returns.
  5. Enter the line type that you assigned to the recoverable taxes in the Line Type processing option in the Sales Update - Brazil program.

  6. Enter a purchase return order, confirm shipment, generate the nota fiscal, and print the nota fiscal.

  7. Run the Sales Update - Brazil program to create records for the purchase return in the Detail Sales Order table (F4211).

    When you run the Sales Update – Brazil program, the system adds new lines for recoverable taxes to the F4211 table using the line type that you specified in the Line Type for purchase return recoverable tax lines processing option. The lines for the recoverable taxes do not have an invoice date, type, or number assigned. The purchase return document has an invoice number assigned in a previous step, but the new lines do not have this information because the lines do not affect the accounts receivable records; they only impact Cardex and general ledger records. This process updates item costs. The system retrieves the recoverable taxes amounts from the original purchase order.

  8. Run the version of the Sales Update program that updates accounts receivable records to process the non-tax lines in the purchase return and update the item history, item cost, and the F4211 table.

    Set the data selection so that the Document (Voucher, Invoice, and so on) (F4211) is not equal to Zero, and the Status Code – Next (F4211) is not equal to 999.

  9. Run the version of the Sales Update program that does not update accounts receivable records to process the tax records in the F4211 table.

    This version updates general ledger records with the recoverable taxes amount.

    Set the data selection so that the Document (Voucher, Invoice, and so on) (F4211) is equal to Zero, the Status Code – Next (F4211) is not equal to 999, and the Document Type is equal to the document type of the purchase return document.

19.14.2.1 Setting Processing Options for Sales Update (R42800) to Update Accounts Receivable Records

Set up a version of the Sales Update program that will update accounts receivable records. You run this version to process all lines except the recoverable tax lines.

Note:

Running a version that updates accounts receivable records is a standard process. No changes are made to this process.

This table shows the processing options that affect the processing of purchase order returns in Brazil:

Tab Processing Option Description
Defaults 2. Select Date Value as A/R Invoice Date Enter 1 in this processing option.
Defaults 4. Select Date Value as G/L Date Enter 1 in this processing option.
Update 2. Bypass Update to Accounts Receivable (F0311) Leave this processing option blank.

19.14.2.2 Setting Processing Options for Sales Update (R42800) to Omit the Update of Accounts Receivable Records

Set up a version of the Sales Update program that will not update accounts receivable records. You run this version to process the recoverable tax lines for purchase order returns.

This table lists the processing options that affect the processing of purchase order returns in Brazil:

Tab Processing Option Description
Defaults 2. Select Date Value as A/R Invoice Date Enter 3 in this processing option.
Defaults 4. Select Date Value as G/L Date Enter 3 in this processing option.
Update 2. Bypass Update to Accounts Receivable (F0311) Enter 1 in this processing option.

19.14.3 Prerequisites

Before you complete the tasks in this section:

  • Verify that a corresponding version of the Sales Order Entry program exists in the Sales Ledger Inquiry program. For example, if you use version ZJDE7004 of the Sales Order Entry program to process sales order returns, version ZJDE7004 must exist for returns in the Sales Ledger Inquiry program.

  • Verify that a matching version of the Sales Order Entry program exists in the Sales/Purchase Returns - Brazil program. For example, if you use version ZJDE7003 of the Sales Order Entry program to process sales order returns, version ZJDE7003 must exist for returns in the Sales/Purchase Returns - Brazil program.

  • Verify that the processing options and version are set up for the Sales Ledger Inquiry program (P42025).

    See "Setting Processing Options for the Sales Ledger Inquiry Program (P42025)" in the JD Edwards EnterpriseOne Applications Sales Order Management Implementation Guide.

  • Verify that the processing options and version are set up for the Sales Order Entry program (P4210).

    See "Setting Processing Options for Sales Order Entry (P4210)" in the JD Edwards EnterpriseOne Applications Sales Order Management Implementation Guide.

  • Verify that the processing options and version are set up for the Sales/Purchase Returns - Brazil program.

  • Verify that the processing options and version are set up for the Sales Return - Ship To program (P4210/ZJDE7003).

  • Verify that the processing options and version are set up for the Sales Return - Ship From program (P4210/ZJDE7004).

  • Verify that supplier master and purchasing instruction records exist for the client who is returning the merchandise you are processing.

19.14.4 Forms Used to Enter Ship-To Sales Returns and Ship-From Sales Returns

Form Name Form ID Navigation Usage
Sales Order Detail Revisions W4210A Sales Order Processing - Brazil (G76B4211), Sales Return - Ship To

Click Add on the Customer Service Inquiry form.

Access Customer Service Inquiry form
Ship To Nota Fiscal Number W76B805B Select Credit Memo from the Form menu on the Sales Order Detail Revisions form. Enter information from the nota fiscal that the buyer sent with the returned merchandise.
Create Sales Ledger Details W76B805E Click OK on Ship To Nota Fiscal Number. Enter the nota fiscal number from the nota fiscal that accompanied the order when you shipped it to the customer
Nota Fiscal Selection W76B805G Select NF Selection from the Form menu on the Create Sales Ledger Details form. Populate the Create Sales Ledger Details form with data from the original sales nota fiscal
Work With Sales Ledger Inquiry W42025A Select Credit Memo from the Form menu on the Sales Order Detail Revisions form. Enter the order number the system displayed on the Create Sales Ledger Details form.
S.O. Brazilian Information Header W4210BRL Click OK on the Sales Order Detail Revisions form. Verify that header information is correct
S.O. Brazilian Information Detail W4210BRA Click OK on the S.O. Brazilian Information Header form. Verify that the detail information is correct
Sales Order Detail Revisions W4210A Sales Order Processing - Brazil (G76B4211), Sales Return - Ship From

Click Add on the Customer Service Inquiry form.

Access the Sales Order Detail Revisions form.
Create Sales Ledger Details W76B805E Select Credit Memo from the Form menu on the Sales Order Detail Revisions form. Enter data about the return including order type, branch/plant, and customer.
Nota Fiscal Selection W76B805G Select NF Selection from the Form menu on the Create Sales Ledger Details form. Populate the Create Sales Ledger Details form with data from the original sales nota fiscal.
Work With Sales Ledger Inquiry W42025A Click OK on the Create Sales Ledger Details form. Enter the new order number that was previously generated by the system, and select the lines for which you process a return.
Sales Order Detail Revisions W4210A Click Close on the Work with Sales Ledger Inquiry form. Review the lines you process for return and note the new order number.
S.O. Brazilian Information Header W4210BRL Click OK on the Sales Order Detail Revisions form. Verify header information.
S.O. Brazilian Information Detail W4210BRA Click OK on the S.O. Brazilian Information Header form. Verify detail information.

19.14.5 Running the Reverse/Void Nota Fiscal Program

Select Sales Order Processing - Brazil (G76B4211), Reverse/Void Nota Fiscal.

19.14.6 Setting the Processing Options for Reverse/Void Nota Fiscal (R76559B)

Processing options enable you to specify the default processing for programs and reports.

19.14.6.1 Select

1. Generated Nota Fiscal Status Code (Required)

Enter a UDC from 40/AT to specify the status of the notas fiscais that the system selects to reverse. You must select a code from the Activity/Status Codes UDC (40/AT) table. The code you select must be set up in the order activity rules for the order type and the line type of the notas fiscais that you want to process.

2. Printed Nota Fiscal Status Code (Required)

Enter a UDC (40/AT) to specify the status code for the printed notas fiscais. The system selects and processes the notas fiscais with this status code.

19.14.6.2 Defaults

1. Sales Order Next Status Code (Required)

Enter a UDC (40/AT) to specify the status code for the printed notas fiscais. The system selects and processes the notas fiscais that are at the status you specify.

2. Nota Fiscal Next Status Code (Required)

Enter a UDC (40/AT) to specify an override next status for the sales order. If you leave this processing option blank, the next status reverts to the previous status.

19.14.7 Setting Processing Options for Sales/Purchase Returns - Brazil (P76B805)

Use these processing options to set display values, specify a reverse sign for purchase orders, specify status code ranges, and set system defaults and edits.

19.14.7.1 Display

Nota Fiscais

Specify whether the system processes sales or purchasing notas fiscais. Values are:

Blank: Sales notas fiscais.

1: Purchasing notas fiscais.

19.14.7.2 Process

Reverse Sign

Specify that the sign should be reversed when processing purchase orders.

19.14.7.3 Select

Range of Status Codes

Specify the range of status codes to use when retrieving records. To make this range as wide as possible set these values to 520 and 999.

19.14.7.4 Defaults

Use these processing options to set system default values. These processing options are not important for sales returns.

Inventory Location

Specify the default inventory location. Values are:

Blank: Blank location.

1: Ship to address book.

2: Ship to nota fiscal series.

3: Original location.

Return Branch

Specify the return branch.

Document Type

Specify the document type.

Nota Fiscal Type

Specify the nota fiscal type to use as the default value for the return nota fiscal.

19.14.7.5 Edits

Use this processing option to validate the Ship To document number. This processing option is important for ship-to sales returns.

Validate Ship to Document Number

Specify whether the system validates the Ship To document number. Values are:

Blank: Do not validate.

1: Validate the Ship To document number.

Use this value when processing ship-to sales returns.

19.14.8 Entering Nota Fiscal Information for Ship-To Sales Returns

Access the Ship To Nota Fiscal Number form.

Nota Fiscal Type

Enter a value that exists in the Transaction Type (70/TY) UDC table to specify the type of notas fiscais. The system enables or disable fields on forms, and performs validations based on the value that you enter. You can specify a default value in the processing options for the Sales/Purchase Returns - Brazil program (P76B805).

For ship-to sales returns, only these hard-coded values are valid:

BRNFI-CL: NF Transaction Classical

BRNFI-CF: NFC-E End Consumer

BRNFI-NA: NFe Transaction National

Note:

The system uses the values in the Special Handling Code field of the UDC value when you automatically process outbound sales transactions.
Nota Fiscal Legal Number

Specify the electronic nota fiscal number generated by the fiscal authority. For ship-to sales returns, you obtain this number from the nota fiscal that your customer sends to you with the returned goods. For national electronic notas fiscais and end consumer fiscal notes, this number has 9 digits.

Series Number

Specify the nota fiscal series number for national electronic notas fiscais (NFe) and for end consumer fiscal notes (NFC-e). For ship-to sales returns, you obtain this number from the nota fiscal that your customer sent to you with the returned goods. For national electronic notas fiscais and end consumer fiscal notes, the number is 3 characters.

Access Key

Enter the access key that is used to verify that the electronic nota fiscal number is valid. For ship-to sales returns, you obtain this number from the nota fiscal that your customer sent to you with the returned goods.

The Access Key field accepts the 44-digit numeric key for the national NFe and the end consumer NFC-e. The system validates your entry based on the nota fiscal type that you select.

For ship-to sales returns, the system enables the Access Key field only when you select BRNFI-NA or BRNFI-CF as the nota fiscal type.

N.F. Number (nota fiscal number)

For paper notas fiscais, enter the 6-character nota fiscal number for a classic nota fiscal. For ship-to sales returns, you obtain this number from the nota fiscal that your customer sent to you with the returned goods.

The system enables this field only when you select BRNFI-CL (classic nota fiscal) as the nota fiscal type.

For notas fiscais with a nota fiscal type of BRNFI-NA or BRNFI-CF the system automatically completes this field using the value from the Nota Fiscal Legal Number field.

N.F. Series (nota fiscal series)

Enter the 2-character nota fiscal series number for a classic nota fiscal. For ship-to sales returns, you obtain this number from the nota fiscal that your customer sent to you with the returned goods.

The system enables this field only when you select BRNFI-CL (classic nota fiscal) as the nota fiscal type.

For notas fiscais with a nota fiscal type of BRNFI-NA or BRNFI-CF the system automatically completes this field using the value from the Series Number field.

Document Type

Enter a value from the UDC 00/DT to specify the document type of the return nota fiscal. For example, you might set up the value of ND for this type of nota fiscal. The system uses the document type that you specify when it creates the record for the sales return in the Nota Fiscal Detail (F7611B), Nota Fiscal Header (F7601B), NFEs Header (F76B01TE), and Sales Return Ship To- Fiscal Note Numbers (F76B425) tables. The value that you enter must exist in UDCs 00/DT and 00/DI.

If you leave this processing option blank, the system uses NS for the document type.

Issue Date

Enter the date of the nota fiscal that is given to you with the returned goods.

19.15 Reviewing NFe Information for Ship-to Sales Returns

You use the Work With Sales Return Ship To- Fiscal Note Numbers program to review nota fiscal information for ship-to sales returns. You cannot modify any information; you can only review it.

This section lists the forms used to review electronic nota fiscal information.

19.15.1 Forms Used to Review NFe Information

Form Name Form ID Navigation Usage
Work With Sales Return Ship To- Fiscal Note Numbers W76B425A Sales Order Processing - Brazil (G76B4211),Work With Sales Return Ship To- Fiscal Note Numbers. Search for existing ship-to nota fiscal records.
Sales Return Ship To - Fiscal Notes Numbers W76B425B Select a record on the Work With Sales Return Ship To- Fiscal Note Numbers form and then click Select. Review nota fiscal information for a ship-to sales return.

19.16 Updating Sales in Brazil

This section provides an overview of sales update for Brazil, lists prerequisites, and discusses how to:

  • Set processing options for the R42800BR program.

  • Run the Sales Update - Brazil program.

  • Set processing options for Sales Update - Brazil (R76B803).

19.16.1 Understanding Sales Update for Brazil

After you print notas fiscais in final mode, you can update the customer sales information. When you update customer sales information, the system creates Accounts Receivable records.

When you process sales updates in Brazil you:

  1. Set up the processing option values in the version of the Sales Update program (R42800) that you use for Brazilian transactions.

  2. Set up the processing option values in the Sales Update - Brazil program (R76B803)

    In addition to other processing options, you specify whether to automatically run the R42800 program after the R76B803 program, and specify the version of the R42800 program to run automatically.

  3. Set up the processing option values in the R42800BR program.

    You access the R42800BR program from Batch Versions. The program does not appear on a menu.

    To use a specific version of the R42800BR program, set up a version of the R42800BR with the same version name as the version of the R42800 program that you use. If you do not set up a version of R42800BR with a version name that corresponds to the version name of the R42800 program, the system runs the XJDE0001 version of the R42800BR program.

  4. Run the Sales Update - Brazil program (R76B803).

  5. Run the R42800 program manually if you did not set the processing options in the R76B803 program to automatically run the R42800 program.

When you run the R42800 program for Brazilian transactions, the system uses the values in the processing options of the R42800BR program for transaction processing. The system uses the values in the R42800BR program whether you automatically or manually run the R42800 program.

Note:

The system does not process tax lines for PIS/PASEP and COFINS tax credits when you run the Sales Update - Brazil program.

You must update customer sales information after you print notas fiscais in final mode so that the accounts receivable (AR) records include the official nota fiscal document numbers that are required by the Brazilian government.

When you run the Sales Update - Brazil program, the system generates reports that include summary or detail information about:

  • Updated information about customer sales.

  • Accounts receivable and general ledger (GL) entries.

  • Sales for different categories, such as stock sales and freight, cost of goods sold, and profit percentages.

  • Errors that result from running the program.

Depending on how you set the processing options, the system updates the F4211 and the Sales Order Detail History (F42119) tables from information that is stored in the F7611B table.

Note:

If you do not set the processing options to update tables F4211 and F42119, you must run the Sales Update program after you run the Sales Update - Brazil program.

You must select the appropriate version of the Sales Update - Brazil program to update the tables. Select one of these versions, based on the company's process:

  • Sales Update

    You can use the proof or final mode of this version when the sales order has been processed through Invoice Print and contains a document number and type in the Sales Order Detail file.

  • Assign Invoice Numbers

    You must use the proof or final version when the sales order has not been processed to print invoices in the Print Invoice program. The program assigns an AR number.

    Note:

    Because of the number of transactions that occur when you run the Sales Update - Brazil program, you should run the program in proof mode first to detect and correct any errors before you run it in final mode.

19.16.2 Prerequisites

Before you complete the tasks in this section:

  • It is strongly recommended that you run the sales update when no one is on the system.

    When you run the program during non-business hours, you can accurately update the history files. The system does not lock records.

  • Notify the system operator before you run the sales update, or consider running the program during non-business hours.

  • Verify that the appropriate line types are set up and that the processing options are set to correctly interface with the general ledger (GL) and accounts receivable.

  • Verify that the status code for sales update and any status codes that follow are set up in the order activity rules.

  • Verify that the automatic accounting instructions (AAIs) are set up for Brazilian taxes and additional charges.

19.16.3 Setting Processing Options for the R42800BR Program

The R42800BR program does not appear on a menu. Access the processing options from the Batch Versions program.

19.16.3.1 Defaults

1. Enter the Status code for reversed Nota Fiscal.

Enter a value from the Activity/Status Codes (40/AT) UDC table to specify the status code that you use for reversed nota fiscal.

2. 2. Tax Line Type

Specify the line type for the records that the system creates when it writes journal entries for Brazilian taxes. If you do not specify a value, the system uses BX as the default value.

You must set up this processing option and the Tax Line Type processing option in the R76B803 program with the same value.

3. 3. Line Type for purchase recoverable tax line

Enter the line type that you use to identify recoverable tax lines for purchase order return transactions. If you do not specify a value, the system uses BR as the default value.

You must set up this processing option and the Line Type for purchase return recoverable tax lines processing option in the R76B803 program with the same value.

19.16.4 Running the Update Sales - Brazil Program

Select Sales Order Processing - Brazil (G76B4211), Sales Update - Brazil.

19.16.5 Setting Processing Options for Sales Update - Brazil (R76B803)

Processing options enable you to specify the default processing for programs and reports.

19.16.5.1 Defaults

1. Tax Line Type (Required)

Specify the line type for the records that the system creates when it writes journal entries for Brazilian taxes.

2. Sales Reverse Defaults

Specify the document type that the system assigns to the records it creates when you process sales reverses or sales returns. You select a code from the Document Type - All Documents UDC table (00/DT). The code you select must also exist in the Document Type - Invoices Only UDC table (00/DI).

19.16.5.2 Select

1. Beginning Status (Optional)

Enter a UDC (40/AT) to specify the current status of the notas fiscais that you want to select. You select a status from the Activity/Status UDC (40/AT). The status you select must be set up in the order activity rules based on the order type and the line type of the notas fiscais that you want to select. The combination of codes that you select for this processing option and the Next Status Code - To processing option in this program must be a valid last status/next status combination in the Order Activity Rules table (F40203).

2. Next Status Code - From (Required)

Enter a UDC (40/AT) to specify the beginning of the range of the next status of the notas fiscais that you to select. You select a status from the Activity/Status UDC (40/AT). The status you select must be set up in the order activity rules based on the order type and the line type of the notas fiscais that you want to select. The combination of codes that you select for this processing option and the Next Status Code - To processing option in this program must be a valid last status/next status combination in the Order Activity Rules table (F40203).

3. Next Status Code - To (Required)

Enter a UDC (40/AT) to specify the end of the range of the next status of the notas fiscais that you select. You select a status from the Activity/Status Codes UDC (40/AT). The status you select must be set up in the order activity rules based on the order type and the line type of the notas fiscais that you want to select. The combination of codes that you select for this processing option and the Next Status Code - From processing option in this program must be a valid last status/next status combination in the Order Activity Rules table (F40203).

4. Override Next Status (Optional)

Enter a UDC (40/AT) to select an alternate status for the next step in the order process. You select a status from the Activity/Status (40/AT) UDC table. The status that you select must be set up in the order activity rules based on the order type and the line type of the notas fiscais that you want to select. The override status is another allowed step in the process.

19.16.5.3 Process

1. Sales Update

Specify whether the system runs the Sales Update program (R42800) after running the Sales Update - Brazil program (R76B803). Values are:

Blank: Do not run sales update.

1: Run the Sales Update program after running the Sales Update - Brazil program.

2. Sales Update Version

Specify the version of the Sales Update program that the system runs when you set the Sales Update processing option in the Sales Update - Brazil program to 1. If you leave this processing option blank and enter 1 for the Sales Update processing option, the system uses version XJDE0001.

3. Sales Update Purge

Enter 1 to run a version of the Sales Update program to purge sales order records from the Sale Order Detail File table. The system writes the purged records to the Sales Order History File table. If you leave this processing option blank, the system does not run the sales update purge.

4. Sales Update Purge Version

Specify the version of the Sales Update program to run. If you leave this processing option blank, the system runs version XJDE0001.

19.16.5.4 Freight

1. Freight

Specify whether the system creates reversing accounting entries when you process a reverse or return for notas fiscais that contain freight charges. Values are:

Blank: Do not create reversing entries.

1: Create reversing accounting entries when you process a reverse or return for notas fiscais that contain freight charges.

2. Insurance

Specify whether the system creates reversing accounting entries when you process a reverse or return of notas fiscais that contain insurance charges. Values are:

Blank: Do not create reversing entries.

1: Create reversing accounting entries when you process a reverse or return for notas fiscais that contain insurance charges.

3. Additional Expenses

Specify whether the system creates reversing accounting entries when you process a reverse or return for notas fiscais that contain additional expenses. Values are:

Blank: Do not create reversing entries.

1: Create reversing accounting entries when you process a reverse or return for notas fiscais that contain additional expenses.

4. Freight Line Type

Specify the line type that the system assigns to the accounting entries it creates for freight charges. The system uses the value you enter in this processing option only when you enter 1 for the Freight processing option in the Sales Update - Brazil program.

5. Insurance Line Type

Specify the line type that the system assigns to the accounting entries it creates for insurance charges. The system uses the value you enter in this processing option only when you enter 1 for the Insurance processing option in the Sales Update - Brazil program.

6. Additional Expenses Line Type

Specify the line type that the system assigns to the accounting entries that it creates for additional expenses. The system uses the value that you enter in this processing option only when you enter 1 for the Additional Expenses processing option in Update Sales - Brazil.

19.16.5.5 Purchase Return

1. Line Type for purchase return recoverable tax lines

Enter the line type that you use to identify recoverable tax lines for purchase order return transactions.