Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Need to pull invoices from AR tables.

Posted By Journeyman2 over 5 years ago

Is there an ERD or easy way to identify the AR Invoice tables. We are using SQL Server as our database and trying to pull the daily invoices to a table. We currently have about 10 companies setup and need the data from all companies.

Thanks

Parents

0 Wayne Schulz over 5 years ago

Have a look a the Sage 100cloud 2018 file layouts.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 5 years ago in reply to Wayne Schulz

There is no ERD that I am aware of. What Wayne linked (the help files) is excellent but knowing what table to look for is sometimes not intuitive.

AR_OpenInvoice is for open invoices (and recently paid invoices). AR_InvoiceHistoryHeader, AR_InvoiceHistoryDetail... are long term tables for posted invoice data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kevin M over 5 years ago in reply to Wayne Schulz

There is no ERD that I am aware of. What Wayne linked (the help files) is excellent but knowing what table to look for is sometimes not intuitive.

AR_OpenInvoice is for open invoices (and recently paid invoices). AR_InvoiceHistoryHeader, AR_InvoiceHistoryDetail... are long term tables for posted invoice data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Journeyman2 over 5 years ago in reply to Kevin M

Thanks Kevin. Good, usable information.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Need to pull invoices from AR tables.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING