AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

(0) Share

Report

Posted on by Community Member Microsoft Employee

We are using the prepayment functionality of Purchase Orders in Dynamics AX 2012 R3 CU8. The process works very well until we go to generate an AP Payment proposal. If a vendor has a combination of Final Invoices and Prepayment invoices, AX will consolidate the Final invoices into a single payment and consolidate all prepayment invoices into another payment. Is there something I'm missing in a setup that will consolidate these all into a single payment?

Thanks in advance,

Tom.

*This post is locked for comments

All responses (8)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

Hello Ludwig -

Thank you for the suggestion. We use the functions > settlement method when we are paying a small handful of vendors and it does summarize the payment properly. We use the payment proposal when we do our large AP run to pay vendors - so that will be used more often than the settlement method. While it's inconvenient, having two payments for the vendor isn't the 'end of the world' but it will be annoying to my users.

Thank you for looking over my shoulder on this.

Have a great weekend,

Tom.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

Hello Tom,

I cannot identify any 'mistake' in the screenprints above. All seems ok and AX should actually summarize all payments into a single line.

The only workaround that I can suggest to overcome this issue this time is entering the vendor directly in the vendor journal and selecting the invoices you want to pay manually through the functions=>settlement form. If you mark all 4 invoices, AX should summarize them into one single payment line.

Yet, this will not guarantee that you will run into the same issue again next time. Probably also try talking to somebody from the development team and/or SK global whether they can identify something else that might cause this interesting system behavior.

Hope this helps,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

Ludwig -

The only financial dimension that we have is Department. The department is the same on all of the invoices - both Invoices and prepayment invoices.

The EFT_ method of payment is part of the SK Global eBanking module. That is used to create and send the ACH file to our bank. Independent of this we have the same result whether we are generating a Check, ACH or Wire. So, it doesn't appear to be the cause of this issue.

Tom.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

Hello Tom,

Your setup does actually look ok.

What I could imagine prevents the summary are different ledger account-financial dimension combinations for the different payments (invoices vs. prepayment invoices).

Can you check whether this is the case?

In addition, do you know what the parameter 'EFT+method of payment' does?

This is not a standard parameter.

Can it be responsible for what AX does with the payments?

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

Yes, the Method of payment is set as 'Total'
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

Hello Tom,

Your method of payment 'EFT-ACH' does it have the value 'total' selected in the period field? If not, can you test whether changing this value summarizes your payments?

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

We select the Method of Payment as part of the criteria due to our ebanking integration. Here are the parameters used in this last test and the resulting two payments:

Payment proposal form:

This criteria pulled up the following two payments - the first are 3 final invoices from our Purchase orders

The second is the prepayment invoice from a purchase order

I expected that these all should have been consolidated into a single payment for this vendor.

Thanks-

Tom.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments

Hi Tom.

Can you let us know how your method of payment is setup and what you selected in the payment proposal selection form?

Ludwig