Numbering Lines in Purchase Orders and Sales Orders- Please Help!


My company is currently in the process of implementing Dynamics Nav 2009, and we are currenly in the testing phase- working out all the bugs before we take the system live. I have a major issue with Nav, in that line numbers do not display on Purchase Orders, Sales Orders, etc. - either on the screen, or on the hard copy. This is such an important piece of information, particularly when referencing specific items on documents which contain several lines to our suppliers or internally.

Surely others have also expericenced this issue as well. Am I overlooking the option to display line numbers, or does anyone have any suggestions of how this can easily be done? I am not an IT professional (I’m a Buyer) and do not have authorization to enter or change code, but I could certainly make these suggestions to our administrators.

I’d appreciate any assistance that anyone can provide.

Thank you,

Darlene Tunall

click on sales order subform


Click on the Field Menu - Find “Line No.” (click it once)

go to the form & double click to add it.

Line No’s is a standard Nav field, don’t freak out if it’s not visible …it’s there.

Now you’re making a big issue out of line numbers but you could easily sort reports & invoices in alphabetical order to find items easily.
Or filter on the item numbers in question - you can even mark them & just show those.
Not sure why it’s such an important piece of information, but to your company/industry perhaps it is.

Oh and you posted a question about NAV in the Axapta forum

I appreciate the information. Than you for replying.

I understand that I can easily sort invoices and reports to find items easily within the system. However, when I am looking at a hard copy of a purchase order that contains 100 line items- and I call a supplier (who will also be looking at a hard copy), sorting is not an option. In addition, even if I was looking at the order/invoice within Navision, if I am referring to a specific line item when speaking to a supplier, there is no easy point of reference without a line #. It may be a small detail to some, but to others it is a necessity.

Thanks again for the information.

Darlene Tunall

Navision’s standart Line No field might not be the best to use, because it starts from 10’000 and is incremented by 10’000 for every line. Problem is, that it grows rapidly in length (digit count) and takes too much valuable line space on the printout.

Ask your implementing Partner to add line numbering to corresponding Reports (e.g. PO or Invoice) - it can be achieved even without adding a special field to PO lines table - as long as both sides uses HARDCOPY, not screen.

Adding this as separate field is problematic - what if you delete some line(s), or even worse - want to insert some in between existing? Renumeration is not an option here. BTW this is the reason, why standart Line No is so big number, not 1,2,3 and so on - there is no problem to insert lineno, say, 15’000 between 10’000 and 20’000, and there still remains a plenty of “place” left…

And finally - I’ve never had such a request before from client to enumerate lines on some multiline doc. Many of them had as much lines (100+) as you, even more, but they distinguished them by ItemNo, which usually comes first and in many cases bold on printouts.
The lines can be sorted by this ItemNo and printed out sorted this way - easy to find and no unnecessary additional data, which, as I already mentioned, takes up space.

Again I agree with Modirs.
All our orders have over 100 lines.
If speaking to a customer, we are both looking at the same invoice, I can say look at page 5, 4s line down item # XXXXX.
And if it’s sorted in either Item # order or Description order it shouldn’t be hard to find.

ON the reports you can still add your own field if you wish…

LineNo Type integer
LineNo := 0;
LineNo := LineNo +1;
add a field to the report with sourceexp LineNo

Well i suggest showing Sr No. in the hard copy of the report to solve the problem.