Microsoft Dynamics AX (Archived)

Discount fields

(0) Share

Report

Posted on by sri17

340

Hi All ,

Listed below two fields available In the custtrans table.

Discount used

Discount granted .

Could i know the difference between them ? Would be great ,if you can explain with an example.

*This post is locked for comments

All responses (4)

Answers (2)

Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: Discount fields

Hi sri17!

You also can use the help text for the field.

As example:

Discount granted - the help text is Cash discount granted when payment is made before a given date.

Discount used - the help text is Cash discount received.
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Discount fields

Hello sri17,

Thank you for this update and the link.

You refer to the customer transactions form that one can access from the AX client.

This is different from the custtrans table especially when it comes to the fields you are asking for.

That is mainly because those fields are not held in the custtrans table but calculated through a method.

You can see this from the next screenprint.

Irrespective of that, I assume that you already found the difference in those fields.

The one shows the theoretically possible discount that your customer can take and the other field shows the discount your customer actually used when making the payment and settling the open invoice amount.

Best regards,

Ludwig
sri17 340 on at

Like (0)

Report

RE: Discount fields

Hi Ludwig ,

The fields available in the Custtrans table in AX 2012 R3 .

technet.microsoft.com/.../aa634902.aspx
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Discount fields

Hi sri17,

What are the exact table names of those fields?

Is it possibly that they have been added (modified) to the custtrans table?

Best regards,

Ludwig