Function to generate restarting sequential number for each document number
Forums
Hello Everyone,
It's my first time in this wonderful IDEA forum.
I'm blocked in my project since I cannot found a function (or other way) to create a sequential number that restart every time the document number changes. In attachment, a screenshot to better understanding.
So,I want that for document number "1310000000" in the column "POSTING_NUMBER" there will be "1" for all related lines; for document number "13100000001" in the column "POSTING_NUMBER" there will be "2" for all lines; and so in an ascending way for next document numbers.
Many thank to whom will help me and sorry for my bad english. :)
Hi Angelo,
Hi Angelo,
I just posted a video on how to do this. Let me know if you have any questions.
Hi Angelo and welcome to the
Hi Angelo and welcome to the site.
In your case what you are looking for is that for the Posting Number field it would be always 1 for Doc No 131000000, 2 for 1310000001, 3 for 1310000002 and so on? (I didn't bother to make sure all the zeros where there). So don't how it is shown now?