Skip to content

    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 forms

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

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

    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.