Sage 100 · Crystal Reports
Custom Crystal Reports for Sage 100
New reports and forms built on your Sage 100 data, and fixes for the ones that broke in an upgrade. Sage 100, formerly called Sage 100cloud, MAS 90, and MAS 200. You get a fixed price per report before any work starts.
What I build
Reports and forms for Sage 100.
Reports Sage 100 doesn't ship with
Sales by customer and item, margin, commissions, open orders, AR and AP, inventory: built on the real Sage 100 tables, with the totals checked against the standard reports.
Invoices, statements, and other forms
Sales order and AR invoices, statements, purchase orders, and checks with your logo and the fields you need.
Custom Sage formsYour Custom Office fields
User-defined fields you've added in Custom Office, shown on the reports and forms where your team needs them.
Spreadsheets replaced
The report someone rebuilds in Excel from Sage 100 exports every month, built once and run from Sage.
Reports through an upgrade
Custom reports and forms converted for the new Sage 100 version and checked against what they printed before.
Wrong totals and missing rows
Duplicated invoice amounts, dropped customers, and totals that won't tie to Sage 100's own reports.
Crystal report repairWhere the numbers live
Knowing the Sage 100 tables is most of the job.
Most Sage 100 reporting problems come down to picking the right tables and linking them the right way. A few of the ones that come up most:
Invoice history
AR_InvoiceHistoryHeader with AR_InvoiceHistoryDetail. Freight and sales tax sit on the header and repeat on every detail row once the two are joined, so summing them overstates them.
Open receivables
AR_OpenInvoice, limited to invoices that still carry a balance (paid ones stay in the table until they're purged), with customer details from AR_Customer.
Sales orders
SO_SalesOrderHeader and SO_SalesOrderDetail for orders that haven't been invoiced yet.
Items and stock
CI_Item for the item itself, IM_ItemWarehouse for quantities by warehouse.
Purchasing
PO_PurchaseOrderHeader and PO_PurchaseOrderDetail, with vendors from AP_Vendor.
Standard, Advanced, or Premium
Standard and Advanced keep data in Sage's own file format, read through the Sage 100 ODBC driver (the SOTAMAS90 data source). Premium runs on Microsoft SQL Server. Reports connect differently, so it matters which one you have.
Upgrading Sage 100?
A Sage 100 upgrade means converting custom Crystal reports and forms for the new version, and the Crystal Reports Designer you use should match the version Sage installs. I convert and check custom reports and forms as part of the upgrade, or fix the ones that broke after it.
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 100 report questions.
- Which version of Crystal Reports should we use with Sage 100?
- The Crystal Reports Designer that matches your Sage 100 release. A newer retail version isn't automatically better, and a mismatched designer can make a report work on one machine and fail on another. Tell me your Sage 100 version and I'll tell you which one fits.
- Does it matter whether we're on Sage 100 Standard, Advanced, or Premium?
- Yes. Standard and Advanced store data in Sage's own file format, and reports read it through the Sage 100 ODBC driver. Premium runs on Microsoft SQL Server. The finished report looks the same to your team, but it's built and connected differently.
- Can you put our Custom Office fields on a form?
- Yes. User-defined fields you've added in Custom Office can go on Crystal forms and reports.
- Will our custom reports survive the next Sage 100 upgrade?
- They need to be converted for the new version, which is routine when they were saved as custom reports rather than as edits to Sage's standard ones. I can do it as part of the upgrade or afterward.
- 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.