Acumatica Report Designer is what if you are a tech veteran, you'd call a multi banded report generator. Consequently it has headers, potentially multiple levels of them, and then detail items that repeat while they are correct for the headers. What you can do is use variables to keep track of things between these levels and indeed for numbering the detail levels but its not always what you should do, because line numbers in the data schemas in Acumatica are not necessarily sequential for reporting purposes so it depends on what you are trying to accomplish.
TL:DR – This article about how to add sequential line numbering to a report in Acumatica Report Designer.
Contents
Ordering
Ordering tends to use a standard technique in Acumatica to define a variable to represent the line item, and increment it by one each time a new line item is eligible for the report. This is useful if you want sequential numbers on reports but it may not represent reality.
LineNbr variable
=$LineNbr+1
This is a variable named LineNbr which is calculated using the ValueExpr for each line of data in a report. To find it you need to select the detail level itself on the report design, and then over on the properties on the right you will see a Variables collection in the Behavior section of properties. Click (Collection) to open the ReportVariable Collection Editor.
You can see below that if you highlight the LineNbr field on he detailSection1 of so641010 it refers to a variable, so it should always return a sequential number for each detai line in a report.
