I know BW generated Pick tickets can be sorted base on as entered, Bin/Location, or Part #,  in the world of Access you would have to see if there is a Sequince # or something of the like in the table

When a line item is entered it is assigned an SKOELineItem record number.  To get the file in the order it was entered you would sort on the SKOELineItem field.

SKOELIneItem does not take into account when a line item is "inserted" on a sales order after the fact.  BW orders line items somehow on invoices and sales orders... but there does not seem to be a simple way to do this outside of BW.

The SKOELineitem will take into account when a line is inserted after the fact.  When you insert a line item on an order after it has been saved it removes the existing SKOELineitem records and writes new ones.  So if you have part A, B and C as line items and they were entered in that order then it would assign say SKOELineitem 291 to part A, 292 to part B and 293 to part C.

Then if you save the order and go back in and insert part D in between part A and B and save it. It will remove SKOELineitem 291, 292 and 293 and assign 294 to part A, 295 to part C, 296 to part B and 297 to part C.  It will always be in the order entered.

When I delete a row in a order, it remain in the sage db.

If i made a select with sql i see in oelineitem the new rows and the deleted rows.

Each line item on the invoice is assigned a surrogate key. (SKOElineItem)  If you order the OELineItem table by the SKOELineItem then they will be in the order they were entered.