Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

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

Posted on by 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.

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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'

    PP4.jpg

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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:

    PP2.jpg

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

    PP2.jpg

    The second is the prepayment invoice from a purchase order

    PP3.jpg

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

    Thanks-

    Tom.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans