Open Forum

Expand all | Collapse all

Vendor Payment creates multiple Vendor Ledger Entries

  • 1.  Vendor Payment creates multiple Vendor Ledger Entries

    TOP CONTRIBUTOR
    Posted 16 days ago
    Edited by Samuel Champoux 16 days ago
    ​Hi,
    When we make a payment for multiple invoices, we have one line per invoice and one line for the bank account.
    This works well however it creates one line per invoice in the vendor entries.
    This confuses AP staff when talking with vendors because there are multiple lines with the same check number and no easy way to sum them.

    If we make a payment, and then apply the entries afterwards, we only have one payment in the vendor entries that has multiple applied entries.
    However, if we do that the check stub has no invoice details, only one line with the total amount paid.

    Would there be a way to have a mix of the two?
    One check with invoice details, One ledger entry, multiple applied entries.

    Thanks,

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------


  • 2.  RE: Vendor Payment creates multiple Vendor Ledger Entries

    SILVER CONTRIBUTOR
    Posted 15 days ago
    When we use the Suggest Vendor Payments function, and check the Summarize by Vendor option, the payment comes into the journal as one line.  And already applied to the entries.  It prints out the detail on the check but posts the check to the vendor ledger as one entry.

    ------------------------------
    Patti Parrish
    Finance Project Manager
    EthosEnergy Power Plant Services
    Alpharetta, Ga
    ------------------------------



  • 3.  RE: Vendor Payment creates multiple Vendor Ledger Entries

    TOP CONTRIBUTOR
    Posted 13 days ago
    ​Hi Patti,

    I found that by oing that it works like we want, so thanks for that!
    However, the problem we have now and why we weren't doing it like this was that they choose what to pay manually, and it doesn't have a link with the due date.
    So we haven't found a way to select or exclude what we want to pay by something else than the due date alone.

    Thanks,

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------



  • 4.  RE: Vendor Payment creates multiple Vendor Ledger Entries

    SILVER CONTRIBUTOR
    Posted 10 days ago
    Have you tried using the Apply Entries in the payment journal ribbon bar?  You can add a vendor to a payment journal line, then open up the Apply Entries window, and choose the invoices to pay.   This will default the payment amount in the Amount field as a total.  Then it will work just like Suggest Vendor payments.  The check prints all the invoices and it's already applied to the appropriate invoices.  And only one line is posted to the vendor ledger.

    ------------------------------
    Patti Parrish
    Finance Project Manager
    EthosEnergy Power Plant Services
    Alpharetta, Ga
    ------------------------------



  • 5.  RE: Vendor Payment creates multiple Vendor Ledger Entries

    TOP CONTRIBUTOR
    Posted 2 days ago
    ​Hi Patti,

    We tried that too but that will only set the "Applies to date" field, which will apply entries until a date.
    If you have a "hole" in your entries that you want to apply, it will only apply up until that one and the rest won't take into account.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------