Our client is running Sage 300 Version 2018 with all service packs installed.
I have created a CSV for importing new orders as they do so many every day. The challenge I have is the client want the system to auto create the order number so that all staff can import without asking eash other the last number imported.
When I default the order number to ***NEW*** it imports the first one with number ***NEW*** then it stops that means it is not able to interprete ***NEW*** as auto create a new number.
Which field do I need to add to CSV so that Sage is trigged to auto create an order number?
All responses will be appreciated.
Peter