Sage 100

I know this is probably already in here somewhere, but I can't find it. I'm importing into SO invoice entry to ship complete an existing Sales Order. Has anyone figured out perform logic to use the business object to bring in the SO information and ship complete?? @Sage100Routine @Sage100UrgentSupportNeeded @AlnoorCassim

There may be another way but as I was just trying to get this to work myself, I came up with the following. As long as you put the following line on the after assign event of the header's SalesOrderNo column, then the ""var$"" variable should be equal to the value of the current import record's column you are using to source the SalesOrderNo from. _______________________________________________________________ coBusiness'Lines'CopyLinesFromSalesOrder(var$,""YES"") _______________________________________________________________ The attached images show each step of the VI import job.

Why not import into Auto Generate invoice table and then let sage auto ship?

@JohnnyPabian , That would have worked fine for me if I didn't also have other data i was importing into the invoice header from the ODBC data source I'm using since importing into SO_AutoGenerateInvoices only has two fields you can import data into, SalesOrderNo and BatchNo. However, depending on the end user and how you are getting the list of sales orders that need to be invoiced, it may be simpler and less steps to just have them use the Auto Generate Invoices Selection task to invoice. The VI perform I posted uses the same method that the SO Invoice Entry task uses to copy the lines so it just eliminates one more step from the end user's process as they won't have to run the import and then proceed with the Auto Generate Invoices Selection process.

I've looked into the auto-generate as an option as well, but it's an added step to print/update the register and then print/update the invoices. They also want the invoices coded with a certain prefix depending on the source for reporting.

@DavidSpeckII that worked PERFECTLY!! Thank you so much for sharing!