Solved

Line number on Sales orders

  • 21 April 2021
  • 1 reply
  • 784 views

We have employees that use the numbering of the lines on a sales order to help ensure accuracy when entering a large SO.

Our employee Lisa entered SO 102812.

The line numbering was not sequential  (I guess the line numbers "skipped" from like 11 to 20 something)

But I look at it today and its varied with line #s missing throughout.

I then looked at the audit history, to see if lines had been deleted or something.  But honestly I can’t really make a lot of sense out of the audit history detail.

 

Would you be able to identify why lines would not remain sequential?

Not only with this specific sales order, but in general, what would cause this?

 

icon

Best answer by Gabriel Michaud 21 April 2021, 17:54

View original

1 reply

Userlevel 7
Badge +10

@Ray Colonero,

The Line Nbr. field is managed by Acumatica and in Sales Orders; there’s a field in SOOrder, LineCntr that contains the last number used. This counter is shared by both SOLine and SOLineSplit (the allocations popup), so the line number that you see on the lines is also impacted by the number of splits you have for each line. Also, keep in mind that when you make changes to the quantity, warehouse, etc. it affects the allocations and new lines may be added/removed automatically by Acumatica.

Here’s a new order that I just created with 4 lines -- I didn’t delete any line, I simply changed quantities and played with the allocations in between the lines:

 

I’m not sure why the developers decided to share the same line counter for both SOLine and SOLineSplit, but I would definitely be careful before changing this configuration through customization as it might have unintended side effects. I think it would be safer to add a new “My Line Nbr.” field that uses a distinct counter, just to be on the safe side...

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved