Hi,
Does anyone know how to reset line number to 1 in PO641000? The number in my report is starting with number 5 because the previous records were deleted. How do I reset it to 1?
Answer
Report Designer - Reset Line number
Best answer by craig2
Hi
Like Laura said, LineNbr is a rolling number that keeps going. I’ve had luck with just switching that field over to SortOrder in some reports, which is the dynamic numbering of how they show up in the entry screen. Might be worth a try as well.
Good luck!
+8Hi
I'm not aware of a way to reset the line number on the PO screen, but you can adjust the report to number the lines sequentially by using a formula.
Take a look at this post:
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+3Hi
Like Laura said, LineNbr is a rolling number that keeps going. I’ve had luck with just switching that field over to SortOrder in some reports, which is the dynamic numbering of how they show up in the entry screen. Might be worth a try as well.
Good luck!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.