Sage 100

I need the data file layouts for AccPac version 5.3b. I need to export data so it can be imported to Sage 100 2014. Does anyone have or know where I could get these?

I have the 5.4 version - shouldn't be that different.

@PhilMcIntosh Thanks a million Phil. This should help a lot. Do you happen to know what table(s) contain the open accounts receivable info (Sage 100 equivalent to AR_OpenInvoice and AR_InvoiceTransactionPayment), and also what table(s) contain the invoice history (Sage 100 equivalent to AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail) ?

For history, ARIBH and ARIBD. Open is in AROBL - I think invoices and payments are separate records and you need to sum by doc# to get balance

@Sage300Technical

Thanks guys. You have been a huge help.