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
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
Have a look a the Sage 100cloud 2018 file layouts.
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.
Thanks Wayne. This is helpful and much appreciated.
Thanks Kevin. Good, usable information.
*Community Hub is the new name for Sage City