[Ian.T]

Dear All

I’m looking to show transaction item line numbers in a sales order.

Example:

Current Sales order columns:

Items | Quantity | units | Description | Price Level | etc

PC 1 1 Desktop $450

Mouse 1 1 Mouse $5.00

Keyboard 1 1 Keyborad $12.00

Required (Line#) Sales order columns:

Line# | Items | Quantity | units | Description | Price Level | etc

1 PC 1 1 Desktop $450

2 Mouse 1 1 Mouse $5.00

3 Keyboard 1 1 Keyborad $12.00

thanks for reding

Ian .T
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

NS maintains a “Line Sequence ID” field, but I’m not sure that’s available for sourcing. You may need to use scripting. In particular, you will need to consider how you want your sequencing to behave when people insert lines in between 2 existing lines, or if a line is removed.

[jacky071087]

You can create a custom transaction column field to display the line number:

1. Navigate to Customization > Lists, Records, & Fields > Transaction Column Fields > New.

2. Enter a Label (ie. Item Numbering).

3. Type = Free-form or Integer.

4. Uncheck Store Value.

5. Applies To > check Sale.

6. Validation & Defaulting > check Formula and enter {line} in the Default Value.

7. Click Save.

You can also try {linenumber} in case {line} wont work.

[lynale]

On PO, I tried with {linenumber} as {line} does not work. And it does not increment on 2nd or next line, it is always 1.

[lynale]

Update: it is not incrementing in Edit mode.

Once saved, and in View mode, it is incremented. It’s working now. I have to disable the Line# field.

Originally posted by lynale

View Post

On PO, I tried with {linenumber} as {line} does not work. And it does not increment on 2nd or next line, it is always 1.

[Author]

Posts