A/P-A/R accounting > Inquiries > Payments 

The Payment inquiry has as its goal the ability to quickly search the payments referring to the invoices and to be able to consult them.
This inquiry goes hand in hand with the Invoice inquiry: It is possible to switch directly from the payment inquiry to the invoice inquiry.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    The function makes it possible to consult the payments coming from the A/P-A/R Accounting module. It is limited to a single screen.

    Header

    Presentation

    Some search criteria are compulsory:

    • The company,
    • The start and end dates for the payments to be searched for.
    • The other criteria are optional and are used to limit the scope of the data to be searched:
      • Bill-to BP,
      • Pay-by BP,
      • Payment or Invoice Number

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    • Control (field COLLEC)

     

     

     

    Block number 2

     

     

    • Start date (field DATDEB)

     

    • End date (field DATFIN)

     

    • From payment (field REGDEB)

     

    • To payment (field REGFIN)

     

    • From invoice (field FACDEB)

     

    • To invoice (field FACFIN)

     

    Close

     

    Tab number 1

    Presentation

    The grid depends on the requested parameterization. It presents, amongst other things, for each open item payment:

    • the open item payment amount in transaction or company currency,
    • the global amount of the payment,
    • the use of color makes it possible to highlight the payments that do not entirely close the open items,
    • it is also possible to know the "Status" of each payment (in Draft management, in Bank, etc.)

    For all payments carried out and linked to an open item, it is possible to know amongst other information:

    • the initial amount of the open item,
    • the cheque, deposit slip or statement number.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

    • Payment no. (field NUM)

     

    • Order no. (field VCRNUM)

     

    • Paid amount (field AMTLIN)

     

    • Invoice date (field ACCDATFAC)

     

     

    • Payment amount (field AMTCUR)

     

    • Check no. (field CHQNUM)

     

    • Payment date (field ACCDAT)

     

    • Lot no. (field PAYLOT)

     

     

    • Control (field BPRSAC)

     

     

    • Address (field BPAINV)

     

     

     

    • Statement no. (field SOINUM)

     

    • Invoice due date (field DUDDATFAC)

     

    • Source document (field BPRVCR)

     

    • Payment due date (field DUDDAT)

     

    • Slip no. (field FRMNUM)

     

    • Reference (field REF)

     

     

    • Paid amount currency (field PAYCURLIN)

     

    • Company amount paid (field PAYLOCLIN)

     

    • Retained amount (field RITAMT)

     

    • Allocated withholdings (field RITAMT2)

     

    • Inv. BP ctrl. account (field BPRSACINV)

     

     

    • Status (field STA)

     

    • Amount due (field DUDAMTCUR)

     

     

    Close

     

    Action icon

    Payments

    This zoom is always accessible and makes it possible to go to the original payment. Starting from the payment, it is possible to access by tunnel the various accounting journals generated by the payment (inter-BP, inter-site MO etc.).

    Invoice Inquiry

    This zoom is only available if the payment is associated to an open item. If the payment is associated with an accounting journal, it is possible to directly zoom to the latter.

     

    Close

     

    Specific Buttons

    This button is used to refine the header criteria. It is possible to make an additional filter on:

    • the accounts only,
    • search only on payments remitted to the bank.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation