The line number within Sales Contract is a sequence. So, if you start off with lines 1, 2, and 3 and you make a change and delete line 2, you end up with lines 1 and 3. In reality for the sales contract is only for these two lines, the old line 2 is no longer relevant for this newer revision. Our customer is not happy with this. Has anyone else had customers who did not like this numbering convention or perhaps have found a way around this phenomenon?
Thank you
Patrick
+11Hi
How about below suggestions?
1. Renumbering Logic: Implement an automatic renumbering function that updates line numbers when a line is deleted, ensuring a continuous sequence that reflects the current active lines.
2. Revision History: Consider maintaining a revision history that clearly indicates deleted lines while allowing active lines to be renumbered. This approach preserves the original structure without cluttering the current view.
3. Internal Workarounds: If feasible, consider creating a report or supplementary document outlining changes and reasons for deleted lines, which would help track contract history without affecting the numbering.
Regards
Chanuka
Hi Patrick,
I would be careful with renumbering the Line No or the Item No. These are part of the Primary Key and are used in all related tables and in the different revisions.
For sure if there is an Application For Payment you should not do this, but if nothing has happened on the SC yet, and you would also renumber all revisions, it might be OK
Another alternative might be to add a “Customer Line no” that you use in the various reports? That would contain the renumbered Line No. For sure has less risk and is a lot smother in new releases.
Regards Erik
Hello
I’m aware of ways that could solve or make the problem manageable but they require modification, I don’t think it can be done with a customization. I should have phrased by last question like this:
Has anyone else had customers who did not like this numbering convention or perhaps have found a way around this phenomenon without modifcation?
Thank you.
Patrick
+5Hello
How about a new custom field (e.g., Item No. Sequence) that simply issues the next number in the sequence (without going by the native IFS logic which skips over the numbers belonging to items that are already deleted) when a new item is created and saved under a Sales Contract Revision Line.
Perhaps this will help you to workaround the pain-point without restoring to a modification.
Cheers!
Sachitha D
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
