Prevent Updating All SalesLine When Modifying SalesTable Field.

(0) Share

Report

Posted on by HAIRUL HAZRI

1,214

Hi,

I'm working with ShippingDateConfirmed (Confirmed Ship Date) field in SalesTable & SalesLine Table in SalesTable form.

In standard functionality, when Confirmed Ship Date in Sales Order Header is modified and SalesTable.write() method is called, a dialog prompt will appear asking to update the Confirmed Ship Date in all related lines.

If yes is selected, the Confirmed Ship Date value will be copied to all lines.

Our client requested to allow only line(s) which is fully reserved to update the Confirmed Ship Date, otherwise set the value to null.

Can we actually achieve this?

In SalesTable.write() method I noticed SalesTable2LineUpdatePrompt instance is being used so I'm searching around these SalesTable2LineUpdate, SalesTable2LineUpdatePrompt classes but cannot find a suitable place to implement the logic.

I found this article but obviously I'm not going to overlayer these classes so I'm still looking for another way.

Please share your suggestions.

Thank You.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

HAIRUL HAZRI 1,214 on at

Like (0)

Report
Copy link

Link copied!
Subscribing to SalesTable2LineUpdate_Post_update solves this issue.

Note that since this is post update method, what I did was not preventing the update, but re-update the value.

[PostHandlerFor(classStr(SalesTable2LineUpdate), methodStr(SalesTable2LineUpdate, update))] public static void SalesTable2LineUpdate_Post_update(XppPrePostArgs args) { SalesTable2LineUpdate thisBuffer = args.getThis(); QueryRun queryRun; SalesLine salesLine; queryRun = thisBuffer.queryRunLine(); while (queryRun.next()) { if (queryRun.changed(tableNum(SalesLine))) { salesLine = queryRun.get(tableNum(SalesLine)); if(condition) { ttsbegin; salesLine.selectForUpdate(true); salesLine.ShippingDateConfirmed = dateNull(); salesLine.doUpdate(); ttscommit; } } } }

Cheers.

Was this reply helpful? Yes No