Define pricing according to payment terms in AX 2012

Hello All

I have a question regarding the sales order pricing, is there a workaround to have the sales item price automatically updated according to due date, as an example lets say:

item X has a price of 10$

This price (charge) need to automatically be updated in order to have additional 20% for each due day.

If invoice date equal 01/02/2014 and due date equal 05/02/2014

Item X price would be equal 10$ + (5 days * 20%) = 10$ + (5 * 2$)

Thank you in advance.

No there is no way of doing this in my opinion unless you added a percentage automatic charge to the customer that referenced the standard terms and applied this to the whole order - have you looked at this option? Basically in your example you would add 100% to the order. My worry is what happens when they pay early or why you are trying to force this.

Thank you Adam for your reply,

Yes I have looked at this option, however this option wont work in my case since charges are allocated using one static percentage while my calculation is based on a percentage that differ according to the number of due dates.

Even if they pay early I would still collect all the invoiced amount (net amount + additional fees per day) , I am forcing this since at the time of selling (invoicing) i have such sort of agreement (due dates vs price) between the salesman and the customer that.

I was looking at the payment fees functionality, however this functionality works on the payment journal level and not the sales invoicing level.

Any other ideas would be much appreciated

Hi …

Here is a ‘thought’ but I haven’t exploded this nor do I intend to as it’s not a requirement for me. You need to make your own mind up where this is a good / bad idea or totally irrelevant.

Thinking out loud, AX has the option to apply settlement discounts based on net/current, months, days and a percentage.

Standard AX does not allow for negative discount percentage values to be entered, however, if you investigate the possibility to change this and allow negative settlement discount percentages, that ‘might’ be a work around with very little customisation,

Otherwise, please ignore this reply and disregard my thoughts totally … J

Regards

Martin

Hi Martin

Thank you for your support,

The above is not a bad idea and it might get in handy for someone who want to allocate the extra fees at the “payment” time, however in my case the extra fees are to be calculated on the “sales invoice” time.

I know the exact functionality is not there as out of the box feature inside AX, but I’m kinda looking for the best place to start a customization from