AX Dynamics Sales Order "Discount %" in "Sales Order Header"

(0) Share

Report

Posted on by This is AX

We have 100 Sales Orders in the system, we need to put the total "discount %" in "Sales Order Header" by opening and editing a single one of them. Is there any solution/sql-query to put the total discount % in one go? How to get rid of this manual activity which take hours? How can we automate it?

All responses (4)

Answers (1)

WillWU 22,352 on at

Like (0)

Report

RE: AX Dynamics Sales Order "Discount %" in "Sales Order Header"

Hi This is AX,

See:

dynamicsaxtipoftheday.com/.../
This is AX 5 on at

Like (0)

Report

RE: AX Dynamics Sales Order "Discount %" in "Sales Order Header"

Thank you for your response. I'm pretty sure that we'll be able to do that if you may please dive a bit deep in x++ skills required for this particular task.

Some documentation links (with a little demo) will really be appreciated..:)
WillWU 22,352 on at

Like (0)

Report

RE: AX Dynamics Sales Order "Discount %" in "Sales Order Header"

Hi This is AX,

You need to write a X++ job.

update_recordset salesTable

setting

DiscPercent=''

where salesTable.SalesId ==_salesId;
Verified answer

Mea_ 60,278 on at

Like (0)

Report

RE: AX Dynamics Sales Order "Discount %" in "Sales Order Header"

There is no way to do a mass update from UI, it's possible to do it via X++ job, but it's a development task and you need to have x++ skills.