• T&M Billing Custom Report

    I created a custom report for T&M Billing, which is grouped by client, then dept. I am not able to create a subtotal line to print for dept. I do have a subtotal for client, however the sales tax column does not subtotal, it pulls the tax amount from…
  • how to link to remote SQL server / Sage Alerts

    We have just upgraded to Sage 2023 Premium, the SQL version. We use a remote database to store metadata about our items. When we were on an older version of MAS 90, we copied the table data from the remote server to a SQL server on our LAN. And we…
  • Drilling down

    In most accounting software programs, when you create a document, you are able to click on any line to drill down. I do not see such an ability with Sage 100. What am I missing?
  • Open Sales Order Report - Filter fields

    The Sage 100 Open Sales Order Report has a list of stock criteria fields, and some fields we added using custom office..see attached. Are we able to add additional standard Sage fields to this list eg; CustomerPO?
  • SY_State when added to InvoiceHistoryHeader duplicates the InvoiceNumbers? And it freezes the report when InvoiceHistoryDetail around 23K records.

    How come when I add SY_State to get the state name it duplicates the InvoiceNo from AR_InvoicehistoryHeader. The only field I use is StateName from SY_State. And when I add AR_InvoiceHistoryDetail it freezes the report around 23,000 records.
  • Crystal Reports 2016 error in custom report after Sage 100 2021.6 update

    First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…
  • how to filter the date range on AR statement printing

    Hi, My client wants to filter the transaction date range within a specific statement date on AR Statement Printing Report. I tried to filter the date range using 'select expert' which set the between from to transaction parameter. If I press F5…
  • Business Insights Explorer won't work for one user

    We have one user when they click on any Explorer view, the window goes to the bottom and is grayed out. If we right-click on the application and choose "Run as Administrator" then log into Sage 100, it works just fine (same machine, same Sage login).…
  • Crystal Reports is not including duplicate amounts in detail listing of transactions.

    I have a crystal report that lists the transactions that were entered into Sage General Ledger. For some reason; I am trying to figure out; whenever a duplicate amount is entered in the GL Transaction it does not show up in my report. Example 2010 ACCTS…
  • CURDATE() function in Sage

    Hi, i’m trying to retrieve date difference from issued date to current date in Sage but somehow I must have my formula wrong, need some help. I’m hoping someone can let me know what I’m doing wrong. PrmChg.chgdte is the date field from Prime Change…
  • COGS

    What report do we run to get the COGS for a certain month?
  • Unable to Print SO_PickingSheet1.rpt

    We have been getting this error when we run the "Picking Sheet Printing" function in SO, it will print a few SO's and then through up this error. The printing stops, we have multiform checked off to print another report for the SO's and that one doesn…
  • Print Copies of Picking List According to Item Quantity Per Order

    Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…
  • Crystal Reports Next() function

    I was trying to use this to get the Next record and compare to the current. In this case if next(ItemCode) =ItemCode then ... When I use it the report wont run and I get the below message. I am guessing this function is just not allowed within Sage…
  • Finding historic periods of zero or negative inventory

    I have been working on making reports for our purchasing staff who do not have a lot of experience with the yearly flux of our inventory They have also been thrown off by the disruptions caused by COVID and the supply chain issues that accompanied it…
  • Database login failed into Crystal KnowledgeSync

    Trying not to duplicate a question that has already been asked. I have a crystal report that can be run from Sage and interactively that does not use any work tables, but when attempting to run it from a KnowledeSync report in 10.5 version I get a Database…
  • Created by User Code - Work Ticket WIP Reconciliation Report - Operations Management

    I am adding the Creator (2 or 3 initials of our team) of a Sales Order/Work Ticket on the WIP Report. It only comes up on part of the Work Tickets listed. I have tried to compare of what has hours applied, what has parts, etc. Is there utility I should…
  • Edit a BIE dashboard

    Is it possible to change the BIE dashboard to display the item code rather than the description in the Top Items dashboard for example? Data comes from the Inventory Sales Analysis Report.
  • Tax Code Table

    Hello it's me again.... Does anyone know what SQL table is the Tax Codes are in?? I need a list of all the tax codes with rates included. When I print the Tax Code from Sales Tax Code Maintenance I just get the codes no rates.. Thanks much ..
  • sage 100 Open sales Orders by Item Report

    how can i generate a report for items needed to fulfill open sales orders?
  • Can you add a url to products so the crystal reports will export hyperlinks to our website?

    We'd like our quotes to display the product codes hyperlinked to their associated webpage on our website. Is there a way to do this with sage 100 and crystal reports? Seems like a very basic thing that should be doable.
  • Crystal Report, Group Item sold from first invoice date for first 3 months

    Hi, I need some help on how i can do this in crystal report, I would like to get each item number and based on their first invoice transaction , i would like to get the quantity sold for the first month, second month and third month in columns. For…
  • User Can Access Report under Business Insights but NOT under Custom Report Section

    I created a report using Business Insights wizard, through which I added it to the Custom Reports section in the SO module and gave access to the certain roles. Our users can run the report when accessing under Business Insights module but get an error…
  • Business Insights Invoice Number Repeating

    I created a sales history report in Business Insights Report Wizard using Invoice History. Objective is a total invoice amount including invoice number, customer number, customer name, invoice date, transaction date. However, the report repeats invoice…
  • Standard item description does not print when Extended Item Description box is checked

    I'd had been having a problem with extended item descriptions not printing in purchase orders and called our vendor for several issues including this one. They checked the form and found nothing amiss, but did find that our check box for extended descriptions…