Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Force Update of Form S...

Force Update of Form Sales Lines Modified through Code

(0) Share

Report

Posted on by Community Member Microsoft Employee

Our users have asked for a custom line number field for Sales Lines. They want a simple integer that would be renumbered whenever new lines are inserted or existing lines are deleted.

I have written code that renumbers lines on the SalesTable form whenever new lines are inserted and deleted. However, only the last line selected gets updated in the database when the user closes the form or steps off the line. Is there any way to force an update on all of the lines when they get renumbered?

Right now, I am doing this with an update event on the SalesLine table, and that works with some minor screen flickering on the SalesLine grid. However, since this is an event on the SalesLine table itself, it will result in a significant performance hit whenever sales lines are bulk loaded.

*This post is locked for comments

All responses (1)

Answers (0)

Sohaib Cheema 46,610 User Group Leader on at

Like (0)

Report

RE: Force Update of Form Sales Lines Modified through Code

There are classes such as SalesLineType >> insert/update methods

Put your logic there before or after super [ .doinsert() ] depending upon requirement. While a line is inserted, you can get the total number of lines with same SalesId where Line.Recid != thisLine.RecId and finally add +1 to it, to get next counter.

However, as you also setting numbers free on deletion of the line, by renumbering all existing lines of that sales Order, this mayn't be great thing for performance.

I would be more interested to know business requirement in such cases, rather than to think about code.