Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Customer Discounts

  • 1.  Customer Discounts

    GOLD CONTRIBUTOR
    Posted 10-10-2018 09:12 AM

    I have added a customer discount to one of my customers.  However, I would like for the discount to calculate and reduce the invoice total.

    Is this possible out of the box?

    Right now, I just get a note at the bottom notifying my customer of a date and cash discount if paid by said date.  I noticed that the date does not seem to be calculating correctly.  The customer has Net 30 terms, the cash discount is 2% Net 30.  The cash discount date calculated as 1/16/19 on an invoice dated 10/9/18.  Why would it throw it out so far in to the future?



    ------------------------------
    Michelle Jones
    Staff Accountant
    Redneck Trailer Supplies
    Springfield MO
    ------------------------------


  • 2.  RE: Customer Discounts

    Posted 10-10-2018 11:07 AM

    Hi Michelle

    From your post I understand you're using a cash discount. However, if you're looking at a discount to be immediately applied at the invoice date from the invoice total I would suggest setting up a "Total discount" for the customer.

    ​You should be able to set up "Total discounts" for your customer on the customer window > Sell > Trade agreements > Discounts > Total discount. This is the path on D365FO, but if you're on AX2012 the access should be similar.

    Hope this helps
    Cruz

    ------------------------------
    Cruz Margaix Huerta
    Technical Architect
    LexisNexis Enterprise Solutions
    Leeds
    ------------------------------



  • 3.  RE: Customer Discounts

    GOLD CONTRIBUTOR
    Posted 10-11-2018 09:06 AM
    ​Thank you Cruz.  That  is very helpful

    ------------------------------
    Michelle Jones
    Staff Accountant
    Redneck Trailer Supplies
    Springfield MO
    ------------------------------



  • 4.  RE: Customer Discounts

    Posted 10-11-2018 10:40 AM

    Hi Michelle,

    A couple of quick thoughts. By reducing the amount of the invoiced material or service by the cash discount and displaying it a as a net amount due, it sounds like you are willing to accept the net amount paid regardless of whether the customer actually meets the cash discount due date or not. If so, the previous response is probably something you could employ. You could also look into displaying it as a Misc reduction prior to the total by configuring Auto charge groups>Auto charges or on a much more manual approach by utilizing the Charges function when entering an SO.

    Regarding the cash discount terms not calculating (displaying) correctly on the invoices, first check your Collections>Customer transaction screen and/or a Payment journal and verify that the cash discount and net due dates are correctly calculating there. If they are, then you have a forms (report) issue. If they are not, then you most likely have a Terms code set up issue.

    Just some food for thought. Best of luck on finding the proper solution.



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



  • 5.  RE: Customer Discounts

    GOLD CONTRIBUTOR
    Posted 10-31-2018 11:24 AM
    ​I have gotten the cash discount to work, but we do not offer the discount on any added charges, such as freight, restocking fees, etc.  Is there a way to set the discount to be on sales subtotal only?

    ------------------------------
    Michelle Jones
    Staff Accountant
    Redneck Trailer Supplies
    Springfield MO
    ------------------------------



  • 6.  RE: Customer Discounts

    TOP CONTRIBUTOR
    Posted 11-01-2018 02:26 AM
    "Cash Discount" functionality (if that's indeed what you're using, the thread is a bit confusing) is applied to the open invoice total - it is not linked to the sales order/purchase order, and cannot be excluded from components of the order.

    IT does not sounds like "Cash Discount" is going to serve you well.
    Are you happy with the fact the gross order amount is recorded as revenue, and this is only reduced when the customer pays and the discount is "taken" ?

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------



  • 7.  RE: Customer Discounts

    GOLD CONTRIBUTOR
    Posted 11-02-2018 09:13 AM
    ​Yes cash discounts is what we are using.  We also are fine with the way it records before payment is received.  I was hoping to find a way to exclude added charges from the discount calculation, but it sounds as if that is not possible.  Do you know of a different way to apply a discount that would permit such an exclusion, or is cash discounts the only option?

    ------------------------------
    Michelle Jones
    Staff Accountant
    Redneck Trailer Supplies
    Springfield MO
    ------------------------------



  • 8.  RE: Customer Discounts

    TOP CONTRIBUTOR
    Posted 11-04-2018 09:43 PM
    I am pretty sure Line discount should work for you (since it discounts the item lines, and does not apply to charges).

    I would also try "total discount" to see how it behaves, i don't have time to test it right now, but possibly it may exclude charges.

    If the above 2 options fail, I would look into configuring a "sales tax" code for discount, with rate of, let's say -2%
    because both charges and orders lines have a set up of Item Sales Tax group - you can control whether this negative amount would apply to just the lines, just the charges, or both.

    Special perk of using that last option is that it prints nicely on the out of the box sales invoice layout.

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------