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 counterpart 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 Âncora composition-deck-Parâmetros composition-deck-Parâmetros
Questions (F12)
...
Question | Description | Default |
MV_FATOUT | Time out to select user record (in seconds). If the user takes longer, the screen is closed. | 900 |
MV_MSGTIME | Set message display to user in seconds, notifying that the screen will automatically close in a few minutes. The value of this parameter must always be smaller than that of parameter MV_FATOUT, under penalty of locking the screen for selection of bills for invoice composition. | 120 |
MV_BX10925 | Set the time for taxation posting, 1= At Posting or 2= At Issue | 1 |
MV_PABRUTO | Set how to provision AP, whether 1 = gross value or 2 = net value. | 1 |
MV_CTBFLAG | .T. Enables selection of booking flags in transaction control; | .T. |
MV_FINVDOC | Activate control of required documents in routines for releasing bill payable postings/transactions? ("1" = Yes / "2" = No) | 2 |
MV_RNDISS | Enter INSS rounding criterion, whether .T. round the value or .F. fix the main value. | .T. |
MV_FINCTAL | If set to 1 - Simple Release - the operations of search, manual release, automatic release, cancellation and caption are kept. | 1 |
MV_NUMFATP | Used for automatic numbering of invoices payable. | 1 |
MV_MRETISS | ISS withholding mode in acquisition of services, whether 1 = when issuing main bill or 2 = when posting main bill. | 1 |
MV_INSIRF | Define whether to deduct the INSS value from the IRRF calculation in Financials. If 1 = Calculation base value gets deducted from IRRF. If 2 = Not deducted. | 2 |
MV_NGMNTFI | Maintenance Integration (MNT) with Financials (FIN), S = Yes, P = Order or N = No. | N |
MV_MCUSTO | Currency used to verify the credit limit entered in the customer file. | 2 |
MV_1DUP | This field suggests whether the breakdown of bills is alphanumeric = A or numeric = 1. | A |
MV_CTLIPAG | Control postings payable through filled out release date. If .T. the system checks whether field E2_DATALIB is filled out. If .F. it does not control them. | .F. |
MV_VLMINPG | Release of bills for manual or automatic postings in accounts payable. Select .T. for automatic release or .F. for manual release. | .T. |
MV_CTBFLAG | Indicates if the accounting flags of the offline routines are selected through the accounting entry transaction - SIGACTB. | .F. |
...
Âncora | ||||
---|---|---|---|---|
|
...
Tip
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.
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.00BILL B – BRL 2,000.00BILL 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:
...
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)