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?

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!

Hi This is AX,

You need to write a X++ job.

update_recordset salesTable

setting

DiscPercent=''

where salesTable.SalesId ==_salesId;

Was this reply helpful? Yes No
This is AX 5 on at

Like (0)

Report
Copy link

Link copied!

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..:)

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!

Hi This is AX,

See:

dynamicsaxtipoftheday.com/.../

Was this reply helpful? Yes No