(BRA) Working with Vouchers and Payments for Brazil

This section provides overviews of voucher entry and voucher match, voucher processing, automatic payment processing; and discusses how to:

• Add bar code information to vouchers.

• Processing inbound and outbound payments.

• Enter manual payments.

Understanding Voucher Entry and Voucher Match for Brazil

In Brazil, you must use a three-way voucher match to create a voucher from a nota fiscal. You must locate the receipt records that correspond to the nota fiscal and match them to the nota fiscal. For example, if a supplier sends a nota fiscal for 100.00, you must locate and match the receipt records for the 100.00 worth of items that correspond to the nota fiscal. You can select multiple receipt records to match on a single voucher. When you complete the match process, the system creates two batches if any of the transactions are subject to IPI or ICMS recoverable, or ICMS payable.

The total amount of the receipt records you match to a nota fiscal must equal the amount on the nota fiscal. For example, if two receipt records correspond to a nota fiscal and each receipt record is for 200.00, the nota fiscal amount must equal 400.00 to perform a match. If a nota fiscal reflects a partial order, you can change the quantity or amount of a receipt record to match the nota fiscal. The system leaves the remaining balance of the receipt record open. For example, if a receipt record reflects 100 items but the nota fiscal amount reflects 50 items, you can change the receipt record quantity to 50. You can create a voucher for the remaining 50 items at a later time.

Before creating vouchers:

• Review the processing options for the Standard Voucher Entry program (P0411). You must set the Match Processing processing option on the Voucher Match tab to 1, and must set the Voucher Match Version processing option on the Voucher Match tab to the version of the Voucher Match program (P4314) that you want to use.

• Review the processing options for the Voucher Match program (P4314). You must set the accounts receivable processing option on the Summarization tab to 1 to correctly process Brazilian taxes.

Understanding Voucher Processing for Brazil

The system enables some functions differently for voucher entry for Brazil than for the standard voucher entry process:

• If a voucher has withholding lines, you cannot modify the voucher using the Standard Voucher Entry program (P0411).

  Use the F0411 Taxes Maintenance program (P76B4200) to modify ISS, INSS, and FUNRURAL taxes. These are the only taxes that you can modify.

• The ability to void or delete a line on a voucher is disabled if the voucher has been processed by using the Tax Calculation ISS, INSS, FUNRURAL program (R76B4310) and records exist for the voucher in the Voucher Tax Processed (F76B4012) table.

• When you delete a voucher, the system identifies whether the voucher includes withholding lines for INSS for an individual. If the voucher includes withholding lines for INSS for an individual, the system:

  • Sets the Reprocess INSSPF flag to yes in the Tax Accumulates by AN8 (F76B4016) table to enable the system to reprocess the month and update the accumulated amounts.

  • Deletes the withholding lines from the Voucher Additional Information Brazil (F76B0411) table.

  • Deletes the document from the F76B4012 table.

  If the voucher does not contain withholding line for INSS for an individual, the system deletes the withholding lines from the F76B0411 table and deletes the document from the F76B4012 table.

Understanding Automatic Payment Processing for Brazil

The system processes records differently for Brazilian transactions than for standard transactions.

Considerations for Creating Payment Groups for Brazil

When you create a payment for Brazil, the system validates these conditions:

• The system checks that the (Imposto sobre Serviços) (ISS), Instituto Nacional do Seguro Social (INSS), and Fundo de Assistência e Previdência do Trabalhador Rural (FUNRURAL) taxes of the voucher are included in the first payment of the voucher.

• The system validates the correct setup of all the Brazil tax information to calculate Imposto de Renda (IR), Programa de Integração Social/Programa de Formação do Patrimônio do Servidor Público (PIS/PASEP), Contribuição para Financiamento da Seguridade Social (COFINS), and Contribuição Social sobre o Lucro Líquido (CSLL) withholding amounts.

Additionally, the system ignores vouchers with a document type that exists in the Doc. Types Unaffected Withhold (76B/UW) UDC table.

When the payment is updated, the system accumulates by month, Tax ID of the supplier, tax ID of the company, and tax type (IR, PIS/PASEP, COFINS, CSLL, and INSS) the gross amounts and contributions amounts paid. The system saves this information in the Tax Accumulates by AN8, Company (F76B4017) table.

When you create payment groups for Brazil, the system calculates withholding amounts for IR, PIS/PASEP, COFINS, and CSLL contributions and creates records for the contributions in the temporary tables A/P Payment Detail (F04573) and F04573 Brazilian Temp WH File (F76B473T). After you write and update the payment, the system copies the records from the temporary tables to the Accounts Payable Matching Document (F0413) and Accounts Payable Matching Document Detail (F0414) tables. The system also updates the F76B4017, F76B0411, and F0411 tables.

Review these processing option tabs before running the Create Payment Control Groups program:

Considerations for Voiding Payments

Instituto Nacional do Seguro Social (INSS) tax is assessed by voucher. If a voucher line and the INSS tax line is in the payment being voided, the system verifies that no payments were made for the voucher after the payment being voided was made.

If a payment being voided has PIS/PASEP, COFINS, or CSLL contributions that exceed the minimum, the system checks that no payments were made for that supplier after the payment being voided was made.

To void a payment other than the last payment, you must void all intervening payments. For example, if on January 10 you need to void a payment to a supplier that was processed on January 8, you must first void any payments made to the supplier on January 9.

When you void a payment, the system:

• Subtracts the withholding from the accumulated amounts stored in the Tax Accumulates by AN8, Company (F76B4017) table for Imposto de Renda (IR), PIS/PASEP, COFINS, CSLL, and INSS withholdings.

• Voids the payment of the withholding lines (standard process).

  The system generates in the F0413 and F0414 tables another line with the opposite sign for each withholding line. The withholding is part of the payment.

• Deletes the new lines inserted into the F0411 table and the Voucher Additional Information Brazil (F76B0411) table for the payment of IR, PIS/PASEP, COFINS, and CSLL withholding (localized process).

• If the lines of the withholdings are posted, the system generates new PE lines for the voids in the F0411 table.

Adding Bar Code Information to Vouchers for Brazil

This section provides an overview of bar code information for vouchers and discusses how to:

• Set processing options for Voucher Additional Information - Brazil (P76B04BC).

• Add bar code information to vouchers.

Understanding Bar Code Information for Vouchers

You can add bar code information to domestic currency vouchers that you process for payment. You add bar code information after you enter voucher information and before you create payment groups. Adding bar code information to your vouchers is optional unless you use the outbound automatic payment process. If you use the outbound automatic payment process, you must add bar code information to your vouchers.

A standard bar code contains 44 digits. When you use an optical reader to scan a bar code, the system:

1. Validates the 44 digits.

2. Populates the Bar Code Brazil field (data item BBRCD) in the F76B04BC table with the 44 digits.

You enter 47 digits when you manually enter a bar code. The 10th, 22nd, and 33rd digits are check digits that the validation routine uses to verify that the code that you enter is a valid bar code number. When you manually enter a bar code number, the system performs:

1. Validates each segment of the bar code number.

2. Translates the 47 digits that you entered into the 44-digit machine-entered format.

3. Populates the Bar Code Brazil field in the F76B04BC table with 44 digits.

You can override a machine-entered bar code number with a manually entered bar code number. When you manually enter a bar code for a voucher for which a bar code already exists and then click OK on the Work With Vouchers Bar Code - Brazil form in the Voucher Additional Information - Brazil program (P76B04BC), the system:

1. Validates each segment of the manually entered 47-digit bar code number.

2. Translates the 47-digits that you entered into the 44-digit machine-entered format.

3. Replaces the value for data item BBRCD in the F76B04BC table with the new value.

Form Used to Add Bar Code Information to Vouchers

Setting Processing Options for Voucher Additional Information - Brazil (P76B04BC)

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

Display

Bar Code

Status

Entering Bar Code Information for Vouchers

Access the Work with Voucher Bar Code - Brazil form.

Machine	Select to enable the entry of bar codes by scanning. You can select this option only if the Enable Bar Code Entry Mode processing option is blank.
Manual	Select to enable the manual entry of a bar code. If you select this mode, the system enables the eight segments of the Manual Bar Code field. You can select this option only if the Enable Bar Code Entry Mode processing option is blank.
Unique payment	Select to prohibit the entry of a duplicate bar code.
Bar Code	Enter this code by scanning a bar code with an optical reader or by manually entering the code. When you use an optical reader to scan a bar code, the reader discards the three check digits and populates the appropriate fields in the JD Edwards EnterpriseOne system with 44 digits. When you manually enter a bar code, you enter the entire 47-digit number. The 10th, 22nd, and 33rd digits are check digits. Although the JD Edwards EnterpriseOne system does not use the check digits to validate the bar code, you should enter all 47 digits. The JD Edwards EnterpriseOne system populates the appropriate fields with 44 digits after discarding the 3 check digits. The system displays an error message for each segment of the Manual Bar Code field if the digits that you enter are not valid or if you do not enter the appropriate number of digits for the segment. The system does not display the bar code in the Machine Bar Code field when you add a bar code to a voucher. The system displays bar codes in the Machine Bar Code field only when the bar code already exists in the F76B04BC table, such as when you view an existing voucher that has an associated bar code.

Processing Inbound and Outbound Payments for Brazil

This section provides an overview of the process for inbound and outbound payments for Brazil, lists a prerequisite, and discusses how to:

• Set processing options for Create A/P Electronic Bank Diskette - Dynamic Formatter (R76B047SE).

• Create the outbound text file.

• Import flat files from your bank.

Understanding Inbound and Outbound Payments for Brazil

You use automatic payment processing to pay vouchers during your usual payment cycle. To process automatic payments, you assign formats to payment instruments. Then, you create payment groups. After you create payment groups, you process automatic payments in the group. When you select the Write function for your payment group, the system determines which payment formats to generate, based on the payment formatting programs that you assign to your payment instruments.

When you set up your system to use the Dynamic Formatter program (P76B474) for electronic payments, you write the outbound flat file in a layout that your bank wants to use, and you write the information that you receive in an inbound flat file in the layout that you want to use.

The outbound process for automatic payments sends records from the following tables to the specified bank:

• F0411 (Accounts Payable Ledger)

• F04571 (A/P Payment Control Group)

• F04572 (A/P Payment Header )

• F04573 (A/P Payment Detail )

The inbound process for automatic payments uploads incoming flat files to the File Upload for Bank Transaction Inbound Process (F76B474I) table, and then to tables F04571, F04572, and F04573. You then continue processing the inbound records, according to your usual procedures.

To use automatic banking for payment processing for Brazil:

• Create the layouts that your banks require for incoming data and assign the layouts to outbound transactions.

• Create the payment instruments that you need.

• Create the versions that you need for the Create A/P Electronic Bank Diskette - Dynamic Formatter program.

• Include program R76B047SE as a print program.

• For outbound payment records, complete the following tasks:

  • Enter bar code information for your vouchers.

  • Create your payment groups.

  • Write your payments.

• Run the Create A/P Electronic Bank Diskette - Dynamic Formatter batch process to write records to the F0457 and F04572OW tables.

• Write records from the F0457 and F04572OW tables to a text file.

For inbound payment records, complete the following tasks:

• Import the flat file that your bank sends to you by using the File Upload for Bank Transaction Inbound Process program.

  This program writes the records from the flat file to the F76B474I table.

• Run the Process Return A/P Electronic Bank Diskette - Dynamic Formatter batch process (R76B047RE) to write records from table F76B474I to tables F04571, F04572, and F04573.

• Continue processing the inbound records according to your existing procedures for payment processing.

Processing Outbound Automatic Payments

Before you process outbound bank records, you must set up bank layouts and associate the layouts to outbound transactions for each payment instrument for each bank with which you work. You then run the Create A/P Electronic Bank Diskette - Dynamic Formatter batch program (R76B047SE) to write records to the F0457 and F04572OW tables.

You use the Bank Transaction Outbound Process program (P76B474O) to write records from the F40457 and F04572OW tables to the text file. When you create the text file, the system writes the file in the correct layout as determined by the Transaction Type, Payment Instrument, and Bank Code that you specified in the Bank Information for Dynamic Formatter program.

The following process flow illustrates the outbound automatic payment process:

Outbound automatic payment process flow

Writing Automatic Payments to the A/P Payment Tape Table (F04572OW)

The system automatically runs the Create A/P Electronic Bank Diskette - Dynamic Formatter program when you run the print process for payment groups. You must set the processing options for the Create A/P Electronic Bank Diskette - Dynamic Formatter program before you run the print process for payment groups. The Create A/P Electronic Bank Diskette - Dynamic Formatter program creates the text file and sets the status for the payment group to Update (UPD).

You can also run the Create A/P Electronic Bank Diskette - Dynamic Formatter program from a menu option.

The Create A/P Electronic Bank Diskette - Dynamic Formatter program does the following:

• Writes records from the following tables to the F04572OW table:

  • F0411

  • F04571

  • F04572

  • F04573

• Creates a report

Creating the Outbound Text File

You create outbound text files for automatic payments and for automatic receipts. The system writes the text file in the appropriate layout based on the bank code, payment instrument, and transaction type.

For automatic payments, the system writes records from the F0457 and F04572OW tables to a text file.

For automatic receipts, the system writes records from the F04572OW table to a text file.

Processing Inbound Automatic Payments

Before you process inbound bank records, you must set up bank layouts and associate the layouts to inbound transactions for each payment instrument for each bank with which you work. You then run the Bank Information for Dynamic Formatter program (P76B474I) to write records from the flat file that you received from the bank to the F76B474I table.

You run the Process Return A/P Electronic Bank Diskette - Dynamic Formatter program to write records from the F76B474I table to the F0457 table. You can launch the Process Return A/P Electronic Bank Diskette Dynamic Formatter program from a menu option or by clicking Process in the File Upload for Bank Transaction Inbound program.

You process the records in table F0457 according to your usual procedures.

The following process flow illustrates the inbound automatic payments process:

Inbound automatic payment process flow

Importing Flat Files from Your Bank

Before you can use the automatic receipts or automatic payments data that your bank sends to you, you must upload the flat file from the location where it is stored to the F76B474I table. A layout that is associated with the bank code and transaction type for the file you want to upload must exist in your system.

You can set default values for the bank code and transaction type in the processing options, and you can set a processing option to enable changes to the location where the system searches for the flat file.

See Also

Adding Bar Code Information to Vouchers for Brazil

Setting Up Bank Layouts Using the Dynamic Formatter

Processing Inbound Automatic Receipts

Prerequisites

Before completing the tasks in this chapter:

• Verify that a bank transit number exists in the F0030 table for each customer for whom you will process automatic payments.

  See Setting Up Bank Accounts.

• Set the processing options for the Bank Transaction Outbound Process program (P76B474O)

  See Setting Processing Options for Bank Transaction Outbound Process (P76B474O).

Forms Used to Process Inbound and Outbound Payments

Setting Processing Options for Create A/P Electronic Bank Diskette - Dynamic Formatter (R76B047SE)

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

Transfer

Tape

Pmt. Inst. (payment instrument)

Process

Setting Processing Options for Bank Transaction Outbound Process (P76B474O)

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

Display

Creating the Outbound Text File

Access the Tape Creation for Outbound Process form.

Importing Flat Files From Your Bank

Access the Upload File for Bank Inbound Transaction form.

Entering Manual Payments for Brazil

This section provides an overview of the manual payment process for Brazil, lists a prerequisite, and discusses how to enter withholding amounts for manual payments.

Understanding Manual Payments for Brazil

When you enter manual payments for Brazil using the Payment With Voucher Match program, the system launches the Manual Payment Withholding Registration program (P76B4900).

The Manual Payment Withholding Registration program enables you to enter tax amounts for Imposto de Renda(IR), Programa de Integração Social/Programa de Formação do Patrimônio do Servidor Público (PIS/PASEP), Contribuição para Financiamento da Seguridade Social (COFINS), and Contribuição Social sobre o Lucro Líquido (CSLL) withholding amounts when you process manual payments. After you complete the Manual Payment Entry form in the Manual Payment program, the system displays the Manual Payment Withholding Registration form. The form includes the withholding amount, the withholding due date, and the tax formula.

The system updates these tables:

• Creates a line in the F76B0411 table for IR, PIS/PASEP, COFINS, and CSLL contributions.

• Writes two lines to the F0411 table; one that is a positive amount and that is paid to the fiscal authority and one that is a negative amount and that is paid with the voucher.

• Updates the Tax Accumulates by AN8, Company (F76B4017) table.

The system accumulates by month, tax ID of the supplier, tax ID of the company, and tax type (IR, Instituto Nacional do Seguro Social [INSS], PIS/PASEP, COFINS and CSLL) the gross amounts and contributions amounts paid.

Prerequisite

You must process INSS, ISS (Imposto sobre Serviços), and FUNRURAL (Fundo de Assistência e Previdência do Trabalhador Rural) taxes before you process manual payments with IR, PIS/PASEP, COFINS, and CSLL taxes.

Forms Used to Enter Manual Payments

Entering Taxes for Manual Payments

Access the Manual Payment Withholding Registration form.