Sage 300 · Crystal Reports
Custom Crystal Reports for Sage 300
Custom reports and forms for Sage 300, formerly Sage 300cloud and Accpac, and fixes for the ones that broke in an upgrade or a move to a new server. You get a fixed price per report before any work starts.
What I build
Reports and forms for Sage 300.
Reports Sage 300 doesn't ship with
Sales by customer and item, margin, open orders, AR and AP, inventory: built on the real Sage 300 tables, with the totals checked against the standard reports.
Invoices, statements, and other forms
Order Entry invoices, statements, purchase orders, and checks with your logo and the fields you need.
Custom Sage formsOptional fields where you need them
Optional fields you've added to customers, items, or documents, shown on the reports and forms your team uses.
Spreadsheets replaced
The report someone rebuilds in Excel from Sage 300 exports every month, built once and run from Sage.
Reports after an upgrade or new server
Custom reports that stopped connecting, ask for a database login, or print differently after an upgrade, a server move, or a new SQL Server driver.
Wrong totals and missing rows
Duplicated amounts, dropped records, and totals that won't tie to Sage 300's own reports.
Crystal report repairWhere the numbers live
Sage 300 is Crystal almost all the way down.
Sage 300 prints nearly every report and form through Crystal Reports; G/L financial statements are the exception and come from Financial Reporter. Customizing them well means knowing the tables and how Sage hands data to the report:
Customers and vendors
ARCUS for customers, APVEN for vendors.
Order Entry
OEORDH and OEORDD for orders, OEINVH and OEINVD for invoices, OECRDH and OECRDD for credit notes.
Inventory
ICITEM for the item itself, ICILOC for quantities by location.
General ledger
GLAMF for accounts, GLPOST for posted transactions.
Datapipes
Some standard reports read through Sage's datapipes rather than straight from the tables, which changes how they're customized.
Customization directories
Sage 300 looks for customized reports in the folders set up in Customization Directories, by user and company, so a custom form can apply to one company without touching Sage's standard report.
Upgrading Sage 300?
An upgrade can replace Sage's standard reports, update the Crystal runtime, and change the database driver a report connects through. Customized reports kept in your customization folders aren't overwritten, but they still need testing on the new version. I check them and fix what changed, starting with invoices and month-end reports.
Tell Me About Your UpgradeHow it works
How a report gets built.
- 01
Show me what it should show
A sample, a sketch, or the spreadsheet you use today is the ideal starting point.
- 02
Get a fixed price
A plain description of what the report will show and what it costs. Nothing starts until you say go.
- 03
Built and checked
Built on your Sage data and checked against numbers you already trust.
- 04
Ready to run
Delivered where your team runs its reports.
Questions
Sage 300 report questions.
- Is Sage 300 the same as Accpac?
- Yes. Sage 300 is the product formerly called Sage Accpac ERP, and more recently Sage 300cloud.
- Is Sage 300 the same as Sage 300 CRE?
- No. Sage 300 (formerly Accpac) is a distribution and financial system. Sage 300 CRE (formerly Timberline) is a separate construction and real estate product with its own data. I work in both.
- Which Sage 300 reports can be customized?
- Nearly all of them. Sage 300 prints its reports and forms through Crystal Reports, except G/L financial statements, which come from Financial Reporter.
- Our custom reports fail after moving to a new SQL Server. Why?
- Often it's the connection. Newer Microsoft ODBC drivers for SQL Server encrypt by default and can fail if the server's certificate isn't trusted, and a report can still point at the old server or a saved login. Tell me the error you see and I'll start there.
- How do you charge?
- A fixed price per report or form, agreed before work starts. There's no retainer and no minimum.
Contact
Tell me what you need.
Tell me about your project or the problem you need solved.