web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AR Customer Payment Gr...
Microsoft Dynamics AX (Archived)

AR Customer Payment Grouping

(0) ShareShare
ReportReport
Posted on by SU-22040800-0 2,487

In AX, a customer pays a large amount, applicable to e.g. 100 invoices. If you use the AR 'Payment Proposal' it returns each invoice line by line.. this then shows on the bank recon as mulitple lines.. which isnt ideal.

If one uses the 'Functions - Settlement' feature, this then returns a single payment line, but the user has to select each and every invoice (100 invoices) manually.

Is there a way to use a date-range of sorts, in the 'Functions - Settlement' feature? or vice versa, a 'summarise payment' option on the 'Payment Proposal' feature..

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello James Solomon,

    In the methods of payment form there is a parameter 'period'.

    Please try setting this to total.

    Once this is made, create a payment proposal and enter a date value in the total payment date field.

    Once this is done, transfer the payments selected to the journal and all individual payments should be summarized in a single payment line for each customer.

    Best regards,

    Ludwig

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Thanks Ludwig

    This is working perfectly.

    However, do you know if this function is possible at time of proposal..? My issue is that all the invoices have the same method of payment.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi James Solomon,

    Once you change the parameter to 'total' in the method of payments form then it will be picked up the next time a payment proposal is run.

    Yet, if you do not like to change your existing method of payment, then you can switch it in the payment proposal form.

    Simply select enter a different method of payment (manually) in the upper part of the payment proposal form

    or

    make use of the 'multiple change' button that allows you changing the method of payment for multiple payment proposal lines at once.

    Best regards,

    Ludwig

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Thanks a lot Ludwig!

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Hi Ludwig..

    Not sure if this has something to do with the above setup, but the when i carry out this process, it is not processing the settlement discount...

    Is there something I'm missing in my setup?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi James Solomon,

    When you run the payment proposal you can select which invoices shall be included in the proposal (due date, cash Discount date or due date + cash Discount date). Maybe this parameter is set wrong?!

    Best regards,

    Ludwig

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Hi Ludwig

    I have the 'Proposal Type' set as "Due date and settlement discount"

    Anywhere else i can check?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello James,

    In the AP parameters form there are two parameters available

    a) calculate cash Discount for partial payments and

    b) calculate cash Discount for credit notes

    If both of them are set the cash discount postings should work.

    Can you check that the cash discount option at the customer level is set to either 'normal' or 'always' but not to 'never'?

    Best regards,

    Ludwig

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Hi Ludwig

    I see that it's calculating on some, and not others.. I'm just going to check my date range(s)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans