Sage Integration

The Problem

Our client has a high level of technical expertise, but had been unable to produce bill of materials containing information, in sufficient detail for each of the components, as required by his manufacturers. He had an existing stock control database using Sage Accounts, and was using Crystal reports to produce his own order documentation.

Although he was happy with the way Sage handled the financial side of the business, the Bill of Materials (BoM) module would have been expensive to buy, and was too general for his specific requirement. It could not store the range of information he needed, in a format that he could easily use. Nor was he able to produce the specialist reports necessary for his business.

With good computer skills, our client is competent in producing his own forms and reports. However he lacked the specific skills required to design and build a solid foundation for the project, or to build custom software to integrate Sage with Microsoft Access.

The Solution

We designed and built a Microsoft Access database that enables the client to produce a Bill of Materials easily. He can now supply the information needed by his manufacturers in sufficient detail for each component. We also provided a customised form for easy editing of the BoM information.

With fully integrated software, Microsoft Access now links directly into live product data within Sage, so product and pricing information only has to be updated in one place. Our client has extended the database we developed to create his own custom forms and reports.

PC Access continue to provide ongoing support for Microsoft Access and other technical issues.

Technical

Custom Microsoft Access database with optimised ODBC queries to Sage Line 50