Skip to content

    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 forms

    Your 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 repair

    Where 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 Upgrade

    How it works

    How a report gets built.

    1. 01

      Show me what it should show

      A sample, a sketch, or the spreadsheet you use today is the ideal starting point.

    2. 02

      Get a fixed price

      A plain description of what the report will show and what it costs. Nothing starts until you say go.

    3. 03

      Built and checked

      Built on your Sage data and checked against numbers you already trust.

    4. 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.

    Add project details (optional)Company, phone, Sage product, and type of request2 added

    Sage product

    Optional. Skip it if your request isn't about Sage.

    What do you need?

    No retainer, no obligation. You'll get a scope and price before any work starts, and I never contact your current Sage partner without your permission.