RE: Copy Purchase & Sales Invoices from another Comapny
What version of BC are you using? There is a feature released recently to copy data across companies
I'd suggest to do the following if in case you do not have a latest version:
1. Create a configuration package with tables Sales Header, Sales Line, Purchase Header, Purchase lines - selected in the lines section
2. Since you won't be exporting all the records from these tables, I'd suggest place a filter on all the 4 tables (by selecting each line) on "Document Type" Invoice
3. Export the excel, check the data. Delete lines which you do not want
4. Create a similar package on your new company, Import excel & apply data from configuration package
It is important to have the Financial setups in place in the new company if you successfully want to import your invoices. You also need the same set of customer/vendors created along with line items
