Sage 100

We have a new client that has multiple companies and has mutual customers (A/R). They have a need to produce Customer Statements that list all invoices from all companies grouped by company. Does anyone know of an enhancement that would provide for this feature? (The companies' mutual customers' numbers are identical).

Maybe it could be accomplished via a custom report containing multiple silent ODBC sources to pull in the multiple company data.

Thanks Brett, we initially thought about that but didn't want to reinvent the wheel if it already existed in an enhancement.

We have done multi company consolidated reports with Access and Pass Through Queries (Same old song). First create a new ODBC driver for each additional company (use sotamas) for the first company (e.g. xxxsotamas, yyysotamas). Create a PTQ for each table (OpenInvoice, AR_Customer, AR_salesperson??). then create a UNION query to link all the tables together into one table. The create your Crystal report for the customer statement. If you have KS alerts, you could create an alert to e-mail. While it sounds complicated, it is really quite easy and straightforward.

We can do that Jeff, thanks and we do have Alerts, so that will work.

You probably have the alerts set up to use the KLF linked tables (which in IMHO SUCK). So I am not sure how this scenario will run. I do know that Alerts will work under my scenario.