A/P-A/R accounting > Payments > Bank posting 

The last posting phase of the payment of the invoices coming from the Purchase, Sales or A/P-A/R Accounting is the bank deposit.

This bank deposit can be performed directly in manual payment entry if no other posting phase is expected (use of the at the bottom of the page) or as an automatic deposit using the function specific to the bank deposit.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Presentation

    The bank deposit is carried out "in bulk" for a selection of recorded payments. The selection criteria are as follows:

    General criteria

    Company

    The bank deposit can be processed for all the companies with payments waiting to be validated. The operation can also be limited to a single company.

    Site

    A selection can be performed on a site. Only the payments recorded for this site are dealt with.

    Selection criteria on payment

    Individual payments/Regroupings

    Payments can be processed individually or, upon requested of the BP, they can be regrouped on deposit slips or paying bank notices.

    The bank deposit process can be limited so as to deal with only one, two or all of these situations.

    Payment transaction

    Since all the payments are organized and sorted by payment transaction, it is possible to limit the selection of the payments to be processed to a single payment transaction.

    Entry batch

    In manual payment entry, or upon automatic payment generation, a batch number can be assigned to a payment.
    This batch number can constitute a selection criterion but it can be applied to the payments only. For the slips and paying bank notices, the slip number is considered in priority, the batch number being as a consequence not taken into account.

    Bank

    A bank must be allocated to each payment. It is a necessary condition for the bank deposit processing to take the payment into account.

    It is then possible to limit the selection to a specific bank.

    User

    The selection can take place at user level. Only those payments that are recorded by the specified user are taken into account.

    Deposit type

    During the generation of the bank deposit slips, the deposit type applied to the BP can be stipulated: Discount, discount in value, open item cash receipt, deadline cash receipt (see documentation Discount entry). It is also possible to limit the selection of the deposit slips to be processed in bank deposit to a single type of deposit.

    Date

    A date range can be determined for payment management.

    Definition of the bank deposit characteristics

    Entry generation

    If the flag is not checked, the started bank deposit process is used to obtain a list (in the log file) of all those payments that will be processed for the chosen selection.

    No journal has been created. If the selected payments match the expected result of the selection, the process must be restarted with this flag being activated.

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    • All companies (field ALLCPY)

    To select the payments regardless of the related companies, check the "All companies" field.
    To select the payments for company XXX, uncheck the "All companies" field and mention XXX in the "Company" field.

     

     

    • All sites (field ALLFCY)

    To select the payments regardless of the related sites, check the "All sites" field.
    To select the payments for site XXX, uncheck the "All sites" field and mention XXX in the "Site" field.

     

    Selection

    • Remittances (field PAY5)

    The user can indicate here the different objects to be posted in bank:

    • deposit slips
    • and/or paying bank notices
    • and/or payments without deposit slips.
    • Paying banks (field PAY7)

     

    • Payments (field PAY9)

     

    • All transactions (field ALLTYP)

    To select the payments regardless of the related transaction, check the "All transactions" field.
    To select the payments for transaction XXX, uncheck the "All transactions" field and mention XXX in the "transaction" field.

     

    • All entry batches (field ALLLOT)

    To select the payments regardless of their related entry batch, check the "All entry batches" field.
    To select the payments for the entry batch XXX, uncheck the "All entry batches" field and mention XXX in the "Entry batch" field. Caution, this filter on entry batches can only be applied to the "payments", which excludes payments on slips or paying banks.

     

    • All banks (field ALLBAN)

    To select the payments regardless of the related bank or cash desk, check the "All banks" field.
    To select the payments for bank or cash desk XXX, uncheck the "All banks" field and mention XXX in the "Bank" field.

    • Bank (field BAN)

     

    • field BANDES

     

    • All users (field ALLUSR)

    To select the payments regardless of which user has carried out the last entry, check the "All users" field.
    To select the payments whose last entry has been carried out by user XXX, uncheck the "All users" field and mention XXX in the "Users" field.
    The user having completed the last entry for a payment is the author of the last modification of said payment or by default his creator.

     

    • All remittance types (field ALLFRMTYP)

    In order to select deposit slips for any type of deposit (Cash, Discount), check the 'All types of deposit' field.
    To select particular deposit slip types, uncheck the 'All types of deposit' field and indicate the deposit type in the 'Deposit type' field.

    • Discount type (field FRMTYP)

     

    • Entry date until (field DATMAX)

    To select the payments regardless of their last entry date, this field should be left empty.
    To select the payments whose last entry was carried out no later than X/Y/Z, mention X/Y/Z in the "Entry date until" field. The last entry date for a payment is the date of the last modification of said payment, or by default the date of its creation.

    • Due date until (field DUDMAX)

    Generation

    • Generate entries (field PRO)

    When unchecking this field, no payment is posted. The log file is forced in order to obtain the list of selected payments concerned by this posting stage.

    Check this field to post the selected payments.

    • Log file (field TRC)

    Check this field to obtain at the end of the processing the list of generated documents (Type and Document Number: Type and Payment number, BP/Account, Accounting date, Bank, Amount and Currency for the payment).

    Block number 4

    • Accounting date (field ACCDAT)

    This field specifies the accounting date to assign to the generated documents, considering following exceptions:

    • the documents generated during the first posting stage of a payment are always generated at payment date.
    • The documents generated during the bank posting for a payment associated with a transaction with open item date management are always generated at payment due date.
    • if there is no date assigned, the posting date is taken from the "Accounting date" formula of the automatic journal associated with the transaction for the current posting stage.
    • Value date (field VALDAT)

    This field specifies the value date to assign to the generated documents.
    If this date is not assigned: 

    • if this is the first payment posting stage, the "Value date" formula of the automatic journal associated with the transaction for the posting stage is evaluated.
    • otherwise, the due date of the generated document is taken by default.

    Close

     

    Batch task

    This function can be run in batch mode. The standard task PAYREMBAN is provided for that purpose.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation