Skip to main content
Solved

Report Designer - Reset Line number

  • 28 June 2024
  • 3 replies
  • 48 views

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?

The report is currently starting from 5
In the system, the previous records before 5 were deleted.

 

3 replies

lauraj46
Rank
Userlevel 7
Badge +8

Hi @danursha44 ,

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:

https://community.acumatica.com/reports%2Dand%2Dgeneric%2Dinquires%2D115/count%2D1%2Dformula%2Din%2Dreport%2Ddesigner%2D9911?postid=35315#post35315

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*.
craig2
Rank
Userlevel 5
Badge +1

Hi @danursha44 ,

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!

D
Rank

Hi,

SortOrder works. 

Thank you.

Reply


Terms & ConditionsCookie settings