Invoices Payable - FINA290 - Financial P12

• 01. OVERVIEW
• 02. EXECUTION
• 03. OPERATIONS
• 04. PARAMETERS APPLIED
• 05. MAIN PROCESSES
• 06. BOOKING
• 07. TABLES
• 08. RELATED FEATURES

01. OVERVIEW

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.

02. EXECUTION 

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

03. OPERATIONS

• Select

Use this option to add bills for grouping.

• View

Use this option to view all bill data, regardless of type.

• Search

Use this option to search bills with filter options and by configuring questions (F12).

• Cancel

This operation performs the

...

counterentry of the invoice, reversing the value paid.

• Caption

This displays the caption chart with the status definitions of the bills grouped

...

Image Added

• Print Browser

Use this operation to print the bills displayed in the browser, after adjusting your settings.

04. PARAMETERS

...

List of parameters applied to FINA290 and its processing Âncoracomposition-deck-Parâmetroscomposition-deck-Parâmetros

Deck of Cards
id Parameters effectType fade
Card id 1 label Questions (F12) effectType fade Question Description Consider Stores? This field indicates whether to consider the store of the supplier when filtering records to be selected for invoice composition. No - the bills of all supplier stores are fetched for confirmation of invoice composition. Yes - only bills from the same store of the main bill are displayed for selection. To enable the field to generate bills for another supplier, set the content of this question to No. Display Accounting Entry? Enter whether to display accounting entry when booking online. Book Posting Online? Enter whether to book postings online. Book Posting Canc. Online? Enter whether to book posting cancellation online. Aut. Select Bills? Automatically select bills. Select Branches? Select "Yes" if you want to select branches. Select "No" to use the branch you are logged on. Card id 2 label Parameters (SX6) effectType fade 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; .F. Flag selection remains through routine that calls the booking, out of 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. The System records, in the accounts payable table, the release date and the name of the user responsible for the release. If set to 2 - Competence - the operations of search, view, balance query, bill release, cancellation, superior release, transfer to superior and temporary absence are redefined. 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.

...

05. MAIN PROCESSES

...

Deck of Cards
id Processes effectType fade
Card id 1 label + Select effectType fade Procedures To add an invoice payable: In the Invoices Payable browser, press (F12) to set routine parameters. Set and confirm parameters. Fill out the data in accordance with field help instructions. Check and confirm the data. The system displays a window requesting confirmation of the data. Confirm it. Then, click option + Select. A parameter settings screen opens The system displays a new screen with the bills that belong to the fields entered earlier, already selected. On this screen, the system displays the data for the invoice to be generated, that is, prefix, number, nature and currency. The invoice amount, the amount selected and the total bill amount selected are displayed on the left side of the screen. Note that the value selected changes as the bills are checked. Likewise, the quantity of bills selected is also updated Select and confirm the bills desired for generation of the invoice. The system requests the Payment Term for the Invoice Payable. Enter and confirm the code of the Payment Term.

...

Image Added

...

06. BOOKING

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.

Example:
BILL A – BRL 1,000.00BILL 00
BILL B – BRL 2,000.00BILL 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:

Accounting variables

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;

07. TABLES

The following tables are related to the process:

08. RELATED FEATURES

Automatic Execution: Invoices Payable (FINA290) - Automatic Execution (ExecAuto)