It allows reconciling packing slips and invoices related to the purchase of goods, as well as recording expense notes linked to the packing slip.
You can use this feature to:
When the invoice calculation is confirmed, the system integrates with the Accounts Payable module, at this point posting the estimates generated upon receiving the packing slip, and deploying the document in accordance with the invoice values and payment terms stipulated in this function.
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).
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.
Thus, the supplier suspense account is left with a debit balance of BRL 20.00.
In accordance with the Receiving User Parameters (RE0101), the adjustment transactions can be:
Directly against the item that has the difference: when the user parameters are set to perform stock adjustments in the invoice reconciliation;
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.
Thus, the supplier suspense account is left with a credit balance of BRL 15.00.
In accordance with the Receiving User Parameters (RE0101), the adjustment transactions can be:
Directly against the item that has the difference: when the user parameters are set to perform stock adjustments in the invoice reconciliation.
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.
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". |
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. |
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 |
|
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. |
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. |
Purpose of the Screen: | To allow entering various notes for the reconciliation document. |
Main Fields and Parameters:
Field: | Description |
Note | Enter invoice notes. |
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. |
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. |
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. |
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. |
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. |
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
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. |
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.
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. |
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. |
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. |
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. |
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. |
Purpose of the Screen: | To allow querying expenses linked to the reconciliation invoice and its respective values. |
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. |
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. |
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. |
Purpose of the Screen: | To add data specific to location Argentina, linked to the document. |
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. |
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. |
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. |
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 |