Previous	Next		Contents		Library

General Information

The following Oracle Financials for Brazil features are used throughout Oracle Applications:

Company Information

You can define specific information that a Brazilian company needs for business transactions within Oracle General Ledger, Oracle Payables, and Oracle Receivables. Company Information includes establishment type, board of trade inscription information, ledger information, and book number controls.

Business Day Calendar

You can define state and local holidays for a specific location. You can also specify how non-working days are treated when a transaction date (such as a due date) falls on a holiday. You can specify whether Oracle Applications should keep that date or use the next or previous working day as the transaction date.

Oracle General Ledger

General Daily Book and General Ledger Book Reports

You can generate Brazilian General Daily Book and General Ledger Book reports within Oracle General Ledger.

General Daily Book – shows all debit and credit transactions by journal entry date and account printed in chronological order. The entries are reported in the local currency, in a predefined format and pagination, with opening and closing pages.

General Ledger Book – provides periodic journal entry reporting for each active account in the company’s portfolio printed in sequential order. The report shows all debit and credit transactions and account balances, with opening and closing pages.

Oracle Payables

Consolidated Billing

Brazilian Consolidated Billing lets you enter shipping invoices with all associated physical, tax, and financial information at the time that goods are received. You can enter consolidated invoices with interest information and associate one or more shipping invoices to a consolidated invoice. You can also import shipping invoices, disassociate shipping and consolidated invoices, and cancel shipping and consolidated invoices.

Bank Transfer

Brazilian Bank Transfer provides support for the most common Brazilian payment methods: Bank Collection and Credit-to Account. You can enter bank collection documents manually or via bank file, and you can associate the bank collection documents with corresponding trade notes. You can do this association either manually or automatically with an automatic association method that you specify. You can disassociate bank collection documents from trade notes as well as view the trade notes that are not associated in the system. In addition, you can print the payment batch information with the Bordero format.

Interest Treatment

Brazilian Interest Treatment lets you define interest parameters at vendor level, vendor site level, or payment schedule level. When you pay an overdue invoice, Oracle Payables automatically creates an interest invoice for the overdue invoice and creates a corresponding payment. Oracle Payables calculates interest based on the business day calendar and shows the interest value and number of days late. If the due date is a weekend or a holiday, Oracle Payables lets you anticipate, postpone, or keep the due date used for interest calculation. You can also define a penalty fee when you pay an overdue invoice.

Tax Treatment

Brazilian Tax Treatment lets you enter multiple taxes for an invoice and automatically calculates a tax amount for a tax name that you enter on an invoice. Oracle Payables handles tax reductions and exemptions in the calculation base and rate, and automatically creates invoice distributions for tax charges with the rates and expense accounts you define for your tax names. When you import invoices, you can automatically load the Brazilian fiscal attributes and tax information associated with the invoice.

You can now define the Tax Functional Matrix, including the company business type, supplier type, and item transaction nature, to determine if the ICMS calculated base is IPI inclusive or exclusive. You can enter and account for multiple taxes on an invoice, including compounded tax, VAT and withholding tax, tax reductions, and exemptions.

Subledger Reports

Brazilian subledger reports generate the following subledger reports for Brazil that show legal information in a standard format:

Supplier Subsidiary Journal – Oracle Payables prints all debit and credit transactions by journal entry date, book account, and vendor. Oracle Payables also generates opening and closing pages.

Supplier Subsidiary Ledger – Oracle Payables prints all debit and credit transactions by book account and vendor name. Oracle Payables also generates opening and closing pages.

Oracle Purchasing

Tax Treatment

Oracle Purchasing automatically calculates Brazilian VAT taxes (IPI and ICMS) for purchase orders and releases through the manual and auto-create processes. You can set up Brazilian federal and state tax exceptions; Oracle Purchasing handles tax reductions and exceptions to the calculated base and rate. You can enter fiscal attributes at both item and supplier levels.

Oracle Inventory

Tax Treatment

To facilitate tax treatment, Oracle Inventory lets you enter Brazilian fiscal attributes that are related to inventory items.

Oracle Receivables

Bank Transfer

Brazilian Bank Transfer lets you create a remittance batch and send the batch to your bank for collection. You can select the invoices (trade notes) that you want to include in the remittance batch by specifying selection criteria and business rules, such as document amount limits for each remittance batch. Remittance batches are sent to the bank for collection either on paper or magnetic media. You can also assign different remittance formats to your banks.

When you import the returned bank file, Oracle Receivables validates these entries, creates the receipts, and applies the receipts to the original invoices. Oracle Receivables also automatically creates adjustments and debit memos for interest and abatement according to tolerance limits that you can define during set up. Oracle Receivables generates the appropriate accounting when you send the invoice for collection and when you receive the payment from your bank.

Interest and Penalty Fees

Brazilian Interest and Penalty Fees lets you define the parameters used to calculate the interest at system option, customer profile class, and invoice level. You can also define the interest account when you define the receipt method.

Oracle Receivables calculates the interest amount and penalty fees whenever a receipt is applied by considering the business day calendar. You can choose to apply or cancel the interest amount or create a debit memo. If the customer pays less interest than the calculated interest, Oracle Receivables creates a debit memo for the interest that is not received. If the customer pays the same interest as the calculated interest, Oracle Receivables creates an adjustment for the interest received.

Billing

Brazilian Billing lets you print invoices that are controlled by a gapless document sequence assigned when printed. The invoice print date determines the payment schedule due dates. You can define legal messages to automatically print on the invoice. Packaging attributes are available in Oracle Inventory to get an invoice item’s default weight. You can define Fiscal Attributes such as Federal, State, and City Inscriptions, as well as Freight Carrier, Operation Fiscal Code (CFO), Insurance Amount, and Other Accessory Expense Amount.

Tax Handling

Brazilian Tax Handling handles tax inclusive (item amounts inclusive of tax) and tax exclusive (item amounts exclusive of tax) when you manually enter an invoice or when you use the auto-invoice process. The tax accounting generated is also deducted according to the tax value. You can assign multiple tax rates and tax accounts to each invoice line. Oracle Receivables determines the default tax code based on the specific tax hierarchy.

Legal Reports

These Brazilian subledger reports show legal information in a standard format:

Customer Subsidiary Journal – Oracle Receivables prints all debit and credit transactions by journal entry date, book account, and customer. Oracle Receivables also generates opening and closing pages.

General Ledger Book – Oracle Receivables prints all debit and credit transactions as well as customer account balances. Oracle Receivables also generates opening and closing pages.