How to get Tax Amount and Line Amount in my custom fields?

(0) Share

Report

Posted on by KaryaNavTech

239

Hello everyone, I got stuck in one task where in my Sales Order there are two custom fields I need to populate these fields one by "Line Amount" another field by "Tax Amount". When we create a sales order >> F9 will show "Sales Order Statistics" with the calculated line values these values I need to show in my two custom fields in the Sales order. Please suggest.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

ManishS 86 on at

Like (1)

Report

RE: How to get Tax Amount and Line Amount in my custom fields?

Try to put you code in updatesalesline function in sales line table.

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (1)

Report

RE: How to get Tax Amount and Line Amount in my custom fields?

Hi, I didn't get you clearly. Is your question same as this thread community.dynamics.com/.../281850

If yes then you can follow the solution provided.

Was this reply helpful? Yes No
KaryaNavTech 239 on at

Like (0)

Report

RE: How to get Tax Amount and Line Amount in my custom fields?

Sorry but it wont provide the solution i need. Because the Tax Amount gets calculated based on tax group code , and too only after giving the items. If i give as what mentioned above it will be always Zero it wont calculate the logic for the items in the line.I guess you understood :)

Was this reply helpful? Yes No
CDsilva 4,188 on at

Like (1)

Report

RE: How to get Tax Amount and Line Amount in my custom fields?

Hi Navtech,

Verify the answer if it worked for you.

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (1)

Report

RE: How to get Tax Amount and Line Amount in my custom fields?

These fields are in Sales Line right. OnValidate of Unit Price you can write.

CustomfieldName1:= Line Amount

Same for other field

Was this reply helpful? Yes No