Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

Program Overview

It allows reconciling packing slips and invoices related to the purchase of goods, as well as recording expense notes linked to the packing slip.

...

When the quote value registered in the packing slip differs from the quote registered in the invoice, a stock transfer is performed to adjust the suspense account of suppliers. This transfer may occur two different ways, to be defined via function Receiving User Parameters (RE0101).

Examples

1.Entry of item A, at the cost of USD 100.00, with quote of BRL 2.30 for each dollar. The supplier suspense account receives a credit of BRL 230.00.


When reconciling the document, the currency quote changes to BRL 2.50 for each dollar. In the invoice, USD 100.00 are charged (without foreign currency variation). However, in the local currency, where the bookkeeping occurs, the supplier suspense account receives a debit of BRL 250.00.

...

Against the stock adjustment account, using the direct debit item (white): when the user parameters are not set to perform stock adjustments in the invoice reconciliation.


2. Entry of item A, at the cost of USD 100.00, with quote of BRL 2.30 for each dollar. The supplier suspense account receives a credit of BRL 230.00.

   

When reconciling the document, the currency quote changes to BRL 2.15 for each dollar. In the invoice, USD 100.00 are charged (without foreign currency variation). However, in the local currency, where the bookkeeping occurs, the supplier suspense account receives a debit of BRL 215.00.

...

Online Invoice Reconciliation Screen – Items

Purpose of the Screen:

The base screen of the Online Invoice Reconciliation feature, with the Items option selected, is displayed when the reconciliation of packing slips with the invoice is performed.


Other Actions/Related Features:

Action:

Description:

Add

When enabled, the process of data reconciliation of packing slip with invoice begins, adding the invoice header.

Copy

Generates a copy of the header of the selected invoice, adding the screen RE0994A to perform the needed changes.

Edit

Enables the invoice header maintenance program (RE0994A) to make changes in the document.

Delete

Deletes the current record.

Automatic Generation Through Order

Activates the Automatic Generation of Reconciliation, which allows generating the reconciliation of items and expenses from the entered purchase order.

Trade Bill

Allows handling the data of invoice trade bills before calculation, if needed.

Invoice Calculation

When enabled, the Invoice Calculation Confirmation (RE0994C) screen is displayed, which allows checking document values for their confirmation.

Localization Data

This button is only enabled when the country at issue is Argentina, providing access to specific localization data, for the document, through screen ARG0033.

Taxes Total

Press this button to display screen RE3001L, through which you can view the total by tax before confirming the document.

Mark

When enabled, the item of the selected packing list is marked for reconciliation.

All

When enabled, all items of the selected packing list are marked for reconciliation.

Generate

When enabled, you can select certain packing slip ranges for reconciliation purposes. Refer to screen RE0994G for additional information.

Note: In the case of "Expense" reconciliation, only packing slips that have the same expense code entered on the screen Invoice Maintenance — Expense Folder, and that meet the ranges entered through screen RE0994G, are displayed.

Select Remittance Items

When enabled, the items marked in the Invoice being reconciled are added.

Delete Invoice Item

Enable it to delete the selected item of the Invoice.

Delete All Invoice Items

Enable it to delete all items of the invoice.

Add

Allows adding the reconciliation invoice items, when "Items" is selected for reconciliation. When selecting "Expenses", you can add the item expenses for reconciliation.

Edit

Allows editing the reconciliation invoice item, when "Items" is selected for reconciliation. When selecting "Expenses", you can edit the item expense for reconciliation.

Delete

Allows deleting the reconciliation invoice item.

Ex Appor

Performs the apportionment of document expenses for invoice items. Displayed only when the reconciliation is for "Items".


Automatic Generation Through Orders Screen

Purpose of the Screen:

It allows the automatic generation of reconciliation document through purchase orders. Press the "Automatic Generation Through Order" button to access this screen.


Main Fields and Parameters:

Field:

Description

Order Number

Enter the purchase order number to be used for generating the reconciliation invoice.

Document

Enter the reconciliation document number (invoice number).

Reconcile Items

Enter whether purchase order items must be reconciled in this document.

Reconcile Expenses

Enter whether purchase order expenses must be reconciled in this document.


Invoice Maintenance Screen - Documents Folder - RE0994A

Purpose of the Screen:

It allows invoice document maintenance for reconciliation of packing slips.


Other Actions/Related Features:

Action:

Description:

Expenses

When activated, it enables the Expenses folder, which allows entering the expenses of the invoice to be reconciled. This button is enabled only when you specify in Purchase Parameters that the system handles Expenses.

Action:

Description:

TIN 1099

Press this button to access/fill in the TIN 1099 data for the United States, through screen USA0001.


Main Fields and Parameters:

Field:

Description

Issuer

Enter the goods supplier code.

Series

Enter the series of the invoice to be reconciled. This information is valid for all countries that use series, except for Argentina.

Issue Point

Enter the Issue Point of the invoice. This information is displayed instead of the Series field, when the country is Argentina.

Invoice Branch

Enter the number of the branch of the invoice entered.

Point of Sale

Enter the number of the sales outlet of the invoice entered.

Stamp

Enter the Stamp number of Paraguayan law for the document.

Due Date

Enter the date when the aforementioned Stamp is due.

Document

Enter the number of the invoice to be reconciled.

Certificate Type


Enter the certificate type of the document.

Operation Type


Enter the document operation type.

Site

Enter the code of the site in which the invoice is being reconciled.

State

Select the state of the site.

Transaction Date

Enter the transaction date. The current date is displayed by default, though you may change it.

UUID

Enter the UUID (Universal Single Identifier) number found in the supplier invoice.

Note:

The button found next to this field lets you select an XML file to automatically fill out the UUID, without having to fill out the 36 characters manually.

Issue Date

Enter the invoice issue date. This must be the date shown in the invoice.

Suspense Account

Select the suspense account of suppliers, for which the transaction is booked.

This field's default setting is the account registered in function Receipt Parameters Maintenance (RE0103).

Suspense Subaccount

Enter the cost center of suspense account, when the account so requires.

Currency

Select the code of the currency with which the Invoice was generated.

Day Quotation

Display the currency quote for conversion of invoice values.
This field is only enabled when you enter a foreign currency in the Currency field.

Future Delivery

When selected, this determines that the purchase has a future delivery.

Linked Nature

Enter the operation nature to be used for generating balance held by third parties, when dealing with a future delivery invoice.

The operation nature must be of type Outflow and its parameters must be set to "Invoicing with Future Delivery" in function Operation Nature Register (CD0609).

Tax base

Enter the tax base value of the document, in case of foreign supplier.

Discount/Surcharge

Indicate whether the value entered is a discount or surcharge. This information is used only to calculate the invoice total and also to generate trade bills.

Discount/Surcharge Value

Enter the discount or surcharge value to be applied to the total document value and also to trade bills.

Bearer/modality

Enter the bearer and modality for the document.

Invoice Maintenance Screen - Note Folder - RE0994A

Purpose of the Screen:

To allow entering various notes for the reconciliation document.


Main Fields and Parameters:

Field:

Description

Note

Enter invoice notes.


Invoice Maintenance Screen - Expenses Folder - RE0994A

Purpose of the Screen:

To allow entering expenses for the reconciliation document.


Other Actions/Related Features:

Action:

Description:

Add

This allows adding expenses for the invoice to be reconciled.

Edit

This allows editing the data entered for the expense selected.

Delete

This deletes the expense selected.

Invoice Maintenance Screen - Document Expense Maintenance - RE0994H

Purpose of the Screen:

This allows the maintenance of reconciliation document expenses. To access this screen, press buttons Add or Edit in tab Expenses of screen Invoice Maintenance.


Main Fields and Parameters:

Field:

Description

Expense

Enter the expense code of document.

Expense Value

Enter the expense value of the invoice.

Note

Enter, if needed, notes pertaining to the expense entered for the invoice.


Invoice Maintenance Screen - Packing Slips Selection - RE0994G

Purpose of the Screen:

It allows selecting packing slips and items to be displayed in the browser, for selecting items to be reconciled in the invoice. To access this screen, press button Generate on screen Invoice Maintenance.


Main Fields and Parameters:

Field:

Description

Total

Enter the total value of the invoice to be reconciled. This field does not interfere in the quantity of items to be selected.

Automatic

When checked, this indicates that all packing slip items pertaining to the selection will be automatically marked and selected for reconciliation.

Document

Enter a range of packing slip numbers to be used for invoice reconciliation.

Operation Nat

Enter a range of packing slip operation natures to be used for invoice reconciliation.

Series

Enter a range of packing slip series to be used for invoice reconciliation.

Issue Date

Enter a range of packing slip issue dates to be used for invoice reconciliation.

Supplier

Enter a range of supplier codes to be used for invoice reconciliation.

This field is enabled when you enter an expense for reconciliation. Use it to filter expenses by supplier.

Order

Enter a range of purchase order codes to be used for invoice reconciliation.


Invoice Maintenance Screen - Purchases Folder - RE0994B

Purpose of the Screen:

It allows adding or editing invoice items.


Main Fields and Parameters:

Field:

Description

Seq

Enter the sequence number of the invoice item.

Item

Enter the code of the item to be reconciled in the invoice.

Supplier Item

Display the item code for the Supplier.

Reference

Enter the item reference code, when controlled by reference.

Order

Enter the purchase order number to be used for adding the item.

Purchase Order

Enter the purchase order number to be used for adding the item.

Installment

Enter the purchase order installment to be used for adding the item.

Service item

When selected, it indicates the item is of service.

Series

Enter the packing slip serial number to be used for adding the item. Enabled only when the system uses series.

Numbr

Enter the packing slip number to be used for adding the item.

Nature

Enter the packing slip operation nature to be used for adding the item.

Sequence

Enter the packing slip item sequence to be used for adding the item.

Day Quotation

Enter the currency quote for conversion of invoice item values.

Issuing Qty

Display the item quantity found in the Invoice.
This quantity is obtained from the purchase order, when entered. If changed, the quantity is matched against the percentage and/or limit of variation allowed for the item. The percentage and variation limit parameters allowed for the item are set through function Item x Receipt Site Maintenance (RE0115) and function Receipt Items Maintenance (RE0106).

Our Qty

Enter the item quantity to be used in the measurement unit of stock control.

Example:

Issuing Qty: The supplier provides 10 Barrels of 200 Liters each.

Our Qty: Stock control is by liter, hence the quantity to be used for the stock is of 2000 Liters (10 x 200).

Supporting Tax Documentation

Enter the number of Supporting Tax Documentation.

Withh Code

Enter withholding code.

Note:

It is required only when no withholding tax is entered.

IVA Included

Enter whether the price of the item includes IVA or not. This information is updated automatically in accordance with the entered packing slip, allowing changes.

Unit Price with IVA

Enter the unit price of goods with IVA included. This field is only enabled when field "IVA Included" is selected. The "Unit Price" is calculated by deducting the tax value in accordance with the tax entered for the item in function Materials Item.

ME Unit Price

Enter the unit price of the item, in the currency of the invoice.

You are not required to enter the unit price for the item when you enter its total price.

When you enter a purchase order, the value entered for the item in the purchase order is displayed. If you change the unit price, this value will be validated against the variation percentage allowed for the item. The variation percentage parameters allowed for the item is set through function Item x Receipt Site Maintenance (RE0115) and function Receipt Items Maintenance (RE0106).

ME total price

Enter the total price of the item, in the currency of the invoice.

You are not required to enter the total price for the item when you enter its unit price.

When you enter a purchase order, the value entered for the item in the purchase order is displayed. If you change the total price, this value will be validated against the variation limit allowed for the item. The variation limit parameters allowed for the item is set through function Item x Receipt Site Maintenance (RE0115) and function Receipt Items Maintenance (RE0106).

ME Discount

Enter the discount to be used for the item, in the currency of the invoice.

Expenses

Enter the item expense value.

Freight

Enter the item freight value.


Items Maintenance Screen - Taxes Folder - RE0994B

Purpose of the Screen:

To allow adding or editing taxes of the invoice item.


Other Actions/Related Features:

Action:

Description:

Add

This allows adding taxes for the item of the invoice to be reconciled.

Edit

This allows editing the data entered for the tax selected.

Delete

This deletes the tax selected.


Main Fields and Parameters:

Field:

Description

Tax Code

Enter the tax code of item.

Rate Perc

Enter the tax percentage.

Base value

Enter the base value of tax.

Tax Value

Enter the total value of tax.

Note:

Changes are not allowed.

MN Tax Value

Enter the total value of tax in local currency. This is automatically calculated in accordance with the percentage entered, though you can change it.

Important

  • You can only associate one tax of type "Added Value" to the document item.
  • There must necessarily be a tax of type "Added Value" when a tax of type "Withholding" exists and the calculation base of said tax is "Regular IVA".
  • You cannot enter taxes for remittance items related to invoices, because they were already entered when the invoices were generated.

...

Items Maintenance Screen - Narrative Folder - RE0994B

Purpose of the Screen:

To allow entering various notes for the reconciliation document item.


Main Fields and Parameters:

Field:

Description

Narrative

Enter the narrative of the invoice item.


Item Expenses Maintenance Screen (Apportionment) - RE3001K

Purpose of the Screen:

You can access this screen by pressing the button Exp Apport of tab Item on screen Invoice Reconciliation. Before running the program, the button automatically calculates the proportional value of freight and of total expenses of the invoice, in accordance with the entered value of the item in the invoice, and then executes the screen Item Expenses Maintenance - RE3001K for the user to check the apportionment and make occasional changes to freight and item expense values.

Informações
titleImportant
:

the apportionment of expenses is performed only when parameter "Consider Expenses as Item Cost" is selected in Receipt Parameters (RE0103), when parameter "Consider Expenses" is deselected or when it is selected but lacks information on the order and purchase order for the invoice item.

This checking is needed because once the handling of expenses for Purchases exists, these expenses are entered in the quotation and automatically considered for the invoice item, composing its cost.


Invoice Expense Addition Screen - RE0994I

Purpose of the Screen:

On this screen you can register expenses of the document to be reconciled. Press the Add button at the footer of the page to access this screen, when reconciliation by Expenses is selected on the Invoice Reconciliation screen.

The expense invoice must reconcile the expense values, posting the estimate that the packing slip created in the AP and generating a new payment document for the expense supplier.

If the expense invoice enters the system before the packing slip, it becomes pending for reconciliation until the packing slip enters it.

On screen RE0994 you can reconcile expenses from other invoices, yet that refer to the same packing slip.

Example:

Reconcile Packing Slip 123.123 of CIA Supplier against

- Invoice 456.456 of CIA Supplier and

- Invoice 789.789 of AIRLINES Supplier.


Main Fields and Parameters:

Field:

Description

Expense

Enter the expense code of the invoice item to be reconciled.

Expense Value

Enter the expense value of the invoice item to be reconciled.

Ledger Account

Select a ledger account of the system, to receive the entry of the expense of the invoice item to be reconciled.

This field is enabled when the expense entered in the field Expense is of type Without Apportionment.

The account entered must not be of type Balance by Stock Group and Do Not Generate Entries.

Cost Center

Enter the cost center of ledger account, when it so requires.

Note

Enter notes related to the entered expense.


Invoice Expense Maintenance Screen - RE0994N

Purpose of the Screen:

On this screen you can edit the expense data of the document to be reconciled. Press the Edit button at the footer of the page to access this screen, when reconciliation by Expenses is selected on the Invoice Reconciliation screen.


Main Fields and Parameters:

Field:

Description

Expense

Display the expense code of the invoice item to be reconciled.

Expense Value

Enter the expense value of the invoice item to be reconciled.

Ledger Account

Enter the ledger account of the system, to receive the entry of the expense of the invoice item to be reconciled.

This field is enabled when the expense entered in the field Expense is of type Without Apportionment.

The account entered must not be of type Balance by Stock Group and Do Not Generate Entries.

Cost Center

Enter the cost center of ledger account, when it so requires.


Invoice Calculation Confirmation Screen - General Folder - RE0994C

Purpose of the Screen:

It allows calculating the reconciliation invoice of the packing slips.


Main Fields and Parameters:

Field:

Description

Payment Term

Enter the payment term for generating trade bills in the Accounts Payable module. If the trade bills are generated through the Trade Bill Maintenance screen, they are not generated again and the ones typed by the user are kept.

Class

Enter the class of document to be generated in the Accounts Payable module.

Expense Type

Enter the expense type code for generating trade bills.

Goods Total Value

Display the total value of the goods.

Discount total

Display the invoice's total discount value.

Taxes Total

Display the invoice's total tax value.

Expense Value

Display the expense value of the invoice.

Round Invoice Total

Display the discount/surcharge for rounding the invoice.

Total Value

Display the Invoice's total value.


Invoice Calculation Confirmation Screen - Taxes Folder - RE0994C

Purpose of the Screen:

To allow querying and performing maintenance on reconciliation invoice taxes before calculating the invoice.


Other Actions/Related Features:

Action:

Description:

Add

This allows adding taxes for the invoice to be reconciled.

Edit

This allows editing the data entered for the tax selected.

Delete

This deletes the tax selected.


Main Fields and Parameters:

Field:

Description

Tax

Enter the tax code to be added to the document.

Base value

Display the base value of invoice goods, which you may change. This value is used for the tax calculation.

Tax %

Display the tax percentage, which you may edit.

Tax Value

Display the tax value in accordance with the site percentage. Allow Change.

Tax Account

Display the ledger account for tax appropriation. Allow Change.

Cost Center

Display the cost center linked to the tax account. It allows editing when account parameters are set to use cost center.

Released %

Display the released value added tax percentage.

Released IVA value

Display the released value added tax value. Its calculation uses the Released % on the Tax Value. You may change it.

Released account

Display the ledger account of Released IVA. Allow Change.

Cost Center

Display the cost center linked to the account of the released tax. It allows editing when account parameters are set to use cost center.

Collection %

Display the collection tax percentage. Allow Change.

Collection Value

Display the collection tax value Its calculation uses the Collection % on the Tax Value. You may change it.

Perception Account

Display the Perception ledger account. Allow Change.

Cost Center

Display the cost center linked to the account of the perception tax. It allows editing when account parameters are set to use cost center.


Invoice Calculation Confirmation Screen - Expenses Folder - RE0994C

Purpose of the Screen:

To allow querying expenses linked to the reconciliation invoice and its respective values.


Document Trade Bills Maintenance Screen - RE0994O

Purpose of the Screen:

This screen is displayed when you activate the button Trade Bills, on screen Invoice Reconciliation. On this screen you can generate, add and/or perform maintenance on trade bills of the invoice.

We must highlight that, to determine the base date to calculate the due dates of the invoice's trade bills, the system operates as follows:

·   Enter the base date for trade bills in invoice calculation;

·   Enter the first due date in invoice calculation;

·   Enter the due dates through special payment term;

·   Register payment terms with trade bill calculation rules.


Other Actions/Related Features:

Action:

Description:

Add

Activate this to display the screen Add Document Trade Bills (RE1001C), in which you can add trade bills of the incoming document.

Edit

Activate this to display the screen Add Document trade bills (RE1001C), in which you can edit trade bills of the incoming document.

Delete

Activate this to delete the trade bill selected.

Generation

Activate this to automatically generate trade bills for the invoice based on the total invoice value and due date code.

Generate Tax

Activate this to automatically generate the taxes of the document trade bills, based on the withheld taxes of the supplier and tax configurator taxes.

Taxes

Activate this to display the screen Trade Bills Tax Maintenance (RE1001C1), in which you can enter the taxes of the invoice trade bills.


Add Invoice Trade Bills Screen - RE1001C

Purpose of the Screen:

When you press the button Add or Edit on screen Trade Bill Maintenance, screen RE1001C is displayed for you to enter trade bill information.


Main Fields and Parameters:

Field:

Description

Installment

Enter the trade bill installment number you want to add.

Trade Bill Number

Display the invoice number to adopt as trade bill number.

Type

Enter the document class for the trade bill.

Expense type

Enter the expense type code of document trade bill.

Issue Date

Enter the trade bill issue date. The system suggests the document issue date.

Transaction Date

Enter the trade bill transaction date. The system suggests the document transaction date.

Due Date

Enter the trade bill due date.

Invoice value

Enter the document trade bill value.

Discount Percentage

Enter the discount percentage for trade bill.

Discnt

Display the discount value of document trade bill.

Due Date with Discnt

Display the due date of trade bill with discount.

Tax Withholding Code

Display the code of tax withholding on trade bill. Enter the tax on trade bill on screen Add Trade Bill Tax.


Add/Edit Document Taxes Screen - RE1001C1

Purpose of the Screen:

When you press the button Taxes in folder Trade Bills on screen Document Maintenance, screen RE1001C1 is displayed for you to enter tax information.


Main Fields and Parameters:

Field:

Description

Tax Code

Enter the tax code of trade bill.

Class

Enter the code of document class for trade bill tax.

Series

Enter the invoice series related to trade bill tax.

Tax Doc

Enter the document number and the installment related to trade bill tax.

Withh Code

Enter the code of tax withholding, when the tax entered in field "Tax Code" is of Withholding type.


Argentina Localization Data Maintenance Screen - ARG0033

Purpose of the Screen:

To add data specific to location Argentina, linked to the document.


Argentina Localization Data Maintenance Screen - Complementary Data Folder:

Purpose of the Screen:

Enter document complementary data. This folder is enabled only when the document is an invoice.


Main Fields and Parameters:

Field:

Description

T/C AFIP

Enter the AFIP certificate number.

CAI

Enter the Printing Authorization Code of document.

Due Date

Enter the CAI due date.

Issued by CF

Enter whether the document is issued by Tax Controller.

Customs Code

Enter the Customs code for import documents.

Destination Code

Enter the destination code for import documents.

Dispatch No.

Enter the dispatch number of import document.

Verification Digit

Enter the verification digit of dispatch of import document.

Dispatch Date

Enter the dispatch date of import document.

Import Doc Year

Enter the year of import document.

Import Oper Tp

Enter the import type to which the document refers. The options available are: Import from Abroad or Import from Free Trade Zone.


Argentina Localization Data Maintenance Screen - Transport Folder:

Field:

Description

Carrier

Enter the name of the carrier used for document loading.

Transporter

Enter the name of the person responsible for transporting the document.

CUIT

Enter the Single Tax Identification Key of carrier.

Ship-to Add

Enter document delivery information.

Notes

Enter notes on document transport.


Argentina Localization Data Maintenance Screen - Transport Folder:

Field:

Description

Carrier

Enter the name of the carrier used for document loading.

Transporter

Enter the name of the person responsible for transporting the document.


Argentina Localization Data Maintenance Screen - Apportionment Folder:

Purpose of the Screen:

Allows adding document apportionment data. This folder is enabled only when the document nature is of apportionment type, the taxation type is regular and the parameter is set to issue trade bills.

The sum of values: recorded, not recorded and exempt must correspond to the original value of apportionment invoice.


Main Fields and Parameters:

Field:

Description

Customs amount

Enter the customs value of apportionment document.

Value Recorded

Enter the recorded value of apportionment document.

Value Not Recorded.

Enter the value not recorded of apportionment document.

Exempt value

Enter the exempt value of apportionment document.

TRANSLATED DOCUMENT

Spanish

·   Conciliación de factura -RE0994