Routine Invoices Payable is useful to group bills payable from a supplier or to divide them in installments.
Using a Payment Term, the process allows:
You can make these negotiations for the same supplier and generate them only for the store of the main bill or, if desired, to all the stores of the supplier.
These transactions meet companies that receive many tax invoices and only one base invoice.
In this operation, new bills are generated and the system requests the code of the Payment Term that defines the breakdown of the bill, posting the original bills.
Procedure manually performed through routine Invoices Payable (FINA290), with the display of the screens involved in the process - actions/commands from the user are required
Use this option to add bills for grouping.
Use this option to view all bill data, regardless of type.
Use this option to search bills with filter options and by configuring questions (F12).
This operation performs the counterentry of the invoice, reversing the value paid.
This displays the caption chart with the status definitions of the bills grouped
Use this operation to print the bills displayed in the browser, after adjusting your settings.
List of parameters applied to FINA290 and its processing
Standard Entries (LP) available to book the invoice payable:
530 - Accounts Payable - Posting of Bills;
531 - Accounts Payable - Cancellation of Bill Postings;
587 - Accounts Payable - Generation of Invoices Payable;
593 - Accounts Payable - Cancellation of Invoices Payable;
You can use the variable VALUE to book the invoice, to get the total value of the invoice, or to use fields from table SE2. For example, E2_VALOR. You can even access other information from the same table for each installment the invoice generates.
Information
This booking is not offline, because the bill values that compose the invoice are summed so the value booked between the original records and the invoice are equal. In offline booking, you cannot group all bills involved in the invoice to book the posting and then book the invoice generation.
Example:
BILL A – BRL 1,000.00
BILL B – BRL 2,000.00
BILL C – BRL 3,000.00
The accounts payable invoice is generated with the payment method that generates two equal installments, the first 30 days and the second 60 days after the date of negotiation.
The accounting entries would be formed thus:
Item | Debit Account | Credit Account | Value | Note |
1 | 01234 | 3,000.00 | 587 - Tables SE2 and SA2 will be selected and ready for data access. | |
2 | 01234 | 3,000.00 | 587 - Tables SE2 and SA2 will be selected and ready for data access. | |
3 | 01235 | 6,000.00 | 587 - Tables SE2 and SA2 will NOT be selected. Using variable VALUE. |
Some variables available for this booking:
Generation of Invoice LP 587:
DEDUCTION = Deduction of bill, if any
VALUE = Total value of invoice(s)
STRLCTPAD = F290BAIXA
Cancellation of Invoice LP 593:
VALUE = Total value of invoice(s)
CHIST190LA = E5_CLIFOR + E5_LOJA;
Some tables used:
CT1 - Chart of Accounts;
CTH - Value Class;
CTO - Currencies;
CT2 - Accounting Entries;
The following tables are related to the process:
Table | Description |
FK2 | Postings Payable |
FK3 | Calculated Taxes |
FK4 | Withheld Taxes |
FK7 | Auxiliary Table |
FKA | Transaction Tracing |
SA2 | Suppliers |
SE2 | Accounts Payable |
SED | Natures |
Automatic Execution: Invoices Payable (FINA290) - Automatic Execution (ExecAuto)