Notifications
Announcements
No record found.
I have a request to change AX to update the sales price to the net after discount. The reasoning is they do not want the customer to know the discount percentage, nor open the doors to a discount being available to them. Is there any way to set up AX to apply the discount to the sales price, round to 2 decimals, and then multiply by the quantity? Currently documents are going out without a discount column on them and so the Sales price is one value and the net amount another.
Hi Kathey,
Instead of making system change, you can just do a report change if that would work for you:
1. E.g. Qty of 3, unit price of $20, discount of $5 = 3 * (20 - 5) = 3 * 15 = 45
on report, where you print the unit price, you should just do (20 - 5 = 15). Your qty and net amount are already correct. Let us know if this would work for you.
Hi Satish,
Thank you for your reply. It works until we get to portions of a cent and shipping incomplete orders. Example: Quantity ordered 2, List price 3326.00 with a Discount of 75.1% = Net amount of 4995.65. If I ship one each on two invoices, it invoices 2497.83 each for a total of 4995.66. If I ship both at the same time it posts 4995.65. If I only change the report, the posting is off by a penny. I do show 3 decimal places on the Unit price on the invoice, since the word "discount" has been banned, but a new acquisition doesn't like this option, and I'm trying to avoid a price group for each item/customer line discount combination that they currently price with. We already have issues with some customers with the invoices not 100% matching their PO for this reason. Thought someone else may have run up against the same thing and have a solution.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
