I do the work for two separate customers (slightly different ownership).  One company -- Company A -- frequently invoices the second company for various items -- and the A/R invoices have many, many lines.  The second company -- Company B -- wishes to post these invoices to A/P with all of the line details preserved.

I know that we can export the details from the A/R invoices in Company A individually to Excel files, and then import -- one by one -- as A/P invoices in Company B.  This will take a lot of time.

Is there any way to export the details from the A/R invoices in Company A at one time -- with (perhaps) the individual invoice numbers in column A of the bulk export spreadsheet?  I have a colleague who is great at importing data into Sage, but he doesn't know how to export it.

I can't see that a bulk export feature shows up in Sage 300 -- or if it's there it's not obvious to me.

Anyone know how to do this?  Or can someone help us with this for a fee?  Company A and Company B have largely split, so this is expected to be a one-time exercise.  There are 150 or more invoices, each with many lines (some invoices running to five and six pages).

Thanks!

Craig