[Suzanne White]

?Hi All,

Does anyone have experience in AX2012R3 with setting up terms that are not “out of the box”.  We have a couple of vendors for which we get a discount if paid by the 10th of the month, and net 11th.

If there is any way to set this up in Cash Discounts, I would love to know how.

——————————
Suzanne White
Accounting Manager
Kai USA Ltd
Tualatin OR
——————————

[Zvika Rimalt]

You can try:

Cash Discount setup of “Current Month” , Days = 10, Discount = 2%

Terms of Payment of “Current Month”, Days = 11

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC Canada
——————————
——————————————-

[Jeneé Demski]

We are trying to do the same thing but “current month” is using the following month instead?  For terms 1% 10th, invoice date is 2/5/18 and should pull 2/10/18 as the cash discount date but it’s pulling 3/10/18.  See image for an example.

——————————
Jeneé Demski
Leatherman Tool Group
Portland OR
——————————
——————————————-

[Zvika Rimalt]

what is that payment terms you are trying to set?

Net 5? (from 2/5 to 2/10)?
Anything up to 5th paid on the 10th? anything after the 5th paid on the next month’ 10th?

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC Canada
——————————
——————————————-

[Jeneé Demski]

Good question 1% 10th/25th = 1% 10th of the month (after the 15th of prior month) 2% 25th (after the 1st of current month).  Also tried using the “next discount code” but that only seems to work if you miss the first discount.  So I’m assuming there is no way to make this work without development?

——————————
Jeneé Demski
Leatherman Tool Group
Portland OR
——————————
——————————————-

[Zvika Rimalt]

hard to answer since I still don’t understand this payment term.

If invoice date is 1-15th of the month – 
when is it due?
what is the discount %?

If invoice date is 16th to end of the month
when is it due?
what is the cash discount %?

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC Canada
——————————
——————————————-

[Andrew Jinks]

?We had similar terms before we went live with 2012 but got rid of them because there wasn’t a way to set up in AX.  The issue is that the term we were trying to create (and it sounds like you as well) splits up the month of the invoice date and says do one thing if the invoice is dated before xxth date of month and do something different if it is dated after the xxth date of the month.

——————————
Andrew Jinks
Leggett & Platt, Inc.
Carthage MO
——————————
——————————————-

[Zvika Rimalt]

There is a functionality of Term of Payment of type “Cut-Over” that covers some scenarios of the type “do one thing before DOM… do another thing after DOM”

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC Canada
——————————
——————————————-

[Randy Alexander]

?

Hi Jeneé,

I agree with Zvika that there is something off with those terms. As stated, it would appear as though the greater incentive (2%) would allow you to withhold payment longer than the 1% offering, which is counter-intuitive to the norm. That said, if a date range is required to make them work, for example, 1^st-15^th Due on the 25^th of the same month, 15^th – 31^st Due on the 10^th of the following month, then you will need a mod. We utilize terms that rely on a date range, as well, and found it could not be accomplished in standard AX. I feel this is an oversight on Microsoft’s part, as date range based cash incentives are fairly common practice.

 

Best,

——————————
Randy Alexander
Credit & Accounts Receivable Manager
Tyler Pipe Co., Div. of McWane, Inc.
Tyler TX
——————————
——————————————-

[Suzanne White]

?Thank you.  Works like a charm.

——————————
Suzanne White
Accounting Manager
Kai USA Ltd
Tualatin OR
——————————
——————————————-