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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

cash discount in AR not working

(0) ShareShare
ReportReport
Posted on by 1,559

Hi Friends,

We had problem with applying cash discount to customer's payment. Cash discount setup looks right, the table 'custtranscashdisc' has the discount amount recorded, I guess it's populated after sales order invoiced?

when coming to payment, it didn't show up. User has to manually adjust it.

Our process is this, user upload file to create sales order, then manually invoice them, then, user will upload file to create payment, if there is no invoice information for SO, then user will manually put in,  then, manually create payment journal.

My question are, if I do everything manually, the discount should apply when I pick invoice for payment, right? For uploading payment file, there must be code to applying discount when find invoice matching, right? or, discount created when payment journal created.

I am new to this process, any help is greatly appreciated.

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

    Hi River,

    Do you upload cash discount information with the sales order upload that is done?

    What data do you upload there and can you see in the sales order that a cash discount applies to this order?

    Best regards,

    Ludwig

  • Ganriver1 Profile Picture
    1,559 on at

    Hi Ludwig,

    File for SO doesn't have cash discount info. Cash discount is setup based on invoice date and payment date, within certain days, cash discount will apply.

    Hope this answered your question.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    I see.

    I wonder whether the cash discount will be taken if you set the use cash discount parameter to 'always'

    Would that work when you upload and process invoices and payments?

    Best regards, 

    Ludwig

    1680.cd.png

  • Ganriver1 Profile Picture
    1,559 on at

    Hi Ludwig,

    After research, I found it's most likely linked to the third party add-on, we use SK-Soft treasury suite to upload payment file, after we invoiced sales order, once the payment uploaded, it should pick up the discount, but somehow it doesn't.

    Not sure you have experience with it.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Good morning River,

    Personally, I don't have much experience with SK-Soft treasury suite and can't thus help.

    Can you approach one of their support engineers and ask for some help regarding this issue?

    Would be great if you could keep us updated on this issue.

    Many thanks and best regards,

    Ludwig

  • Verified answer
    Ganriver1 Profile Picture
    1,559 on at

    Hi Ludwig,

    Thanks for your help, after working with support from SK-Soft, issue resolved, it's actually not an issue, users just doesn't know how things should work, neither do we.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans