Batched payments

(0) Share

Report

Posted on by Community Member

When we generate a payment to multiple supplies it transfers to bank as individual payments, so for one item appearing on the bank statement I may have to match off 30 or more separate items.

How do I make all the payments come across as one bank item?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Brandon Wiese 17,788 on at

Like (0)

Report

How is it that you write checks or send wires to different suppliers and they appear on the bank statement as one line? Don't they clear separately at the bank?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm in the UK and the banks offer a batch processing service where we upload a list of account details and amounts and the banks make all the payments but put one entry on our statement.

The same system is used for payroll, one debit to employer bank but multiple payments to employees - I just need to do this from the Purchase Ledger.

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

Sounds like you want the equivalent of the "Use a deposit slip" feature in customer payment journals. After a customer payment journal is posted, you can then combine the Bank account transactions into a single line for that batch, the Bank deposit slip, and the original bank transactions become child records under the deposit slip and are no longer visible directly from the bank account. Then during bank reconciliation, you just have the one line to clear.

This option doesn't appear to be available out of the box for vendor payment journals.

Since the system already does it, it may not be that difficult to add to vendor payment journals, but then a lot of additional testing would have to be done to make sure nothing else is broken by it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you.

Is this such an unusual method of paying suppliers that AX hasn't got it covered? Do you not do anything like it in the States?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Isobel H,

I believe Standard AX can handle your issue. Please try the following:

1) In the vendors methods of payment form select "Total"

2) When you create a payment propsal enter a date in the total payment field

This should summarize all your vendor payments into one single amount that you can transfer and post.

Hope it helps,

Ludwig

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (1)

Report

I don't think the original post is saying that they're getting multiple checks per vendor. Apparently they want the checks across multiple vendors to appear on the bank account once, like a customer deposit slip.

I've never seen that done in the US for disbursement. When using an outside payroll provider, it is common to have a single disbursement to fund the payroll company, and that becomes the single bank transaction for reconciliation later, but then since AX did not write the checks that is not the same situation at all.

Was this reply helpful? Yes No