Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Customer Discounts

  • 1.  Customer Discounts

    GOLD CONTRIBUTOR
    Posted 11 days ago

    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 11 days ago

    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 days ago
    ​Thank you Cruz.  That  is very helpful

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



  • 4.  RE: Customer Discounts

    Posted 10 days ago

    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
    ------------------------------