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