Is there a way to force the invoice numbers to be assigned based on the way orders appear on the order grid, instead of by order number?

A user sorts their orders grid by customer number, yet when they run auto-generate invoices, the invoice numbers are assigned as if the grid is sorted by order number.

I didn't test it out; is the result any different when importing orders from a CSV or Excel file?

Thanks

Steve

Hello Steve,

The Invoice Orders window does have a Sort by section. If you change the Primary Sort to Customer number, you will get the result that you wanted.

No, there is no difference when the Order List is imported for Auto Invoicing.

I have added a suggestion for a future release of OrderEntry for the Import issue.

We came up with a pretty crazy workaround and I want to share it.

Instead of importing the order list into File | Import | Order List to Invoice, they now import it into File | Import | Update Orders, and the template puts an "X" in the Ship Via field.

Then they use the Order Entry | Auto Invoice Orders function, sort by customer, and filter on the Ship Via field ("X" only). We created a Favorite for this purpose.

Luckily for them they do not use the Ship Via field; the field doesn't have to be Ship Via, but it has to be one that is a) not used, b) available in the Import Update Orders function, and c) available as a filter in the Auto Invoice Orders function.

They are looking forward to a future release of OrderEntry that assigns invoice numbers to imported orders based on the list itself.

Steve

Interesting workaround Steve!

I've appended your comments to the original feature request.