• Sage Intelligence Consolidated Job Cost reports

    I feel like the Not Equal join used in Crystal in order to combine the Company file in a report to be able to get the company name/code would not work in SI. Is there a way of adding the company code for NON-FINANCIAL reports?
  • Check transmittal template

    I would like the Check Transmittal to print by Invoice number (lowest to highest) rather than by invoice amount (lowest to highest). Does anyone know how to do this?
  • Days to pay report or query?

    I'm looking for which tables to use for creating a report or query to calculate the average days to pay per client. Any feedback is appreciated.
  • production management

    Where do the budgeted numbers on the work ticket come from?
  • 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?
  • How can I run an Open S/O report that shows Profit Margin?

    I would like to run an Open Sales Order Report that show Profit and Profit Margin. I realize that this may not be an exact number, but I would like to see the profitability of upcoming jobs.
  • AR Aged Invoice Report

    Hello, I'm just trying to set up auto delivery for this report but it looks like it is only available in the stock Crystal Report form. Does anyone know if it's available in Sage Intelligence or if there is a way to convert Crystal Report reports to Sage…
  • 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?
  • Cash Flow Statement

    Is there a standard cash flow statement out there?
  • Salesperson Commission Report debit memo

    Hello.. this one is a totally new one, never have dealt with commission report. Sorry if the question might be to vague because not how to state it. So why doesn't the commission rate show on report for a debit memo... for one salesperson he was a…
  • Suggestions on best way to tie Salesperson to Vendor

    A client of mine is trying to understand how much of each vendors products their salesmen sold in the previous year. I've been attempting to connect reports in PBI & Excel to garner the information, but haven't had any luck. Any suggestions on reports…
  • Beginning Balance wrong on GL Detail Report

    It appears that the beginning balance for period 1 is coming into the reports without regard to the beginning period selected. The subordinate transactions come into the report correctly, but the balances are all off because of the incorrect beginning…
  • 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.
  • Credit Memos

    Is there anywhere in Sage 100 - where I can print out all of our A/R credit memos for 2023. It is year-end and our auditors are requesting and it is way to many to scan and email. Any help would be much appreciated
  • Purchase History Explore / Report question

    I have a question regarding how to look at bits of data from a certain vendor. Using the explorer views we are trying to figure out how to find a certain item from a certain vendor and how much we paid for the individual item for the past 5 years.
  • Receipt of goods is not asking to print all reports

    Receipt of goods is not asking to print all reports it is just automatically printing the Goods register and the Daily Transaction register. It is not printing or offering to print the back order register. If do a preview it does ask to print all but…
  • Consolidation Report on Vendor with Company Code

    I am trying to build a report that will show me what companies a particular vendor is set up in. We have 53 companies. I am not sure how to join the company code with the vendor table to show on one consolidation report. Nothing seems to link well, any…
  • Scheduling IRP's to run in the evening

    We have to schedule 4 different IRP types to run in the evening. Can this be done under Library Master > Task Scheduler? And how can we schedule them?
  • Missing reports after migration

    After migrating. to a new server, all the custom reports are missing. The reports are in the company directory\reports but do not show up when selecting the report in the modules. I can manually re-add them, but this is time consuming. Any suggestions…
  • Sales Journal update

    How do I stop a script from triggering during the Sales Journal update on the Sales Order header pre-write?
  • facing a problem managing distribution instructions

    I need your kind help please, I am facing a problem managing distribution instructions for Sage reports, I believe it is a common problem and you have had it before, do you have any advice on how to fix it please. Hiding part of the screen.
  • Why are the C:\ProgramData\Sage Software\Cache\MAS 200\Reports folders created on a multi user RDS Sage client environment?

    Does anyone know if the creation of these cached reports is dependent on the configuration of the RDS server itself, or is there programming within the application that defaults to this location? The reason I'm asking is because I'm upgrading a client…
  • Using AP PII information in Custom Crystal Report

    How to display AP PII information in a Crystal Report?
  • 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…
  • NEGATIVE QUANTITY I REPORT, BUT IN "ITEM INQUERY"

    Hello all again, I've been getting some very good advice here lately, thank you all! I create a custom report in the "Item List" that includes "Total Quantity On Hand". The issues I have is when the report shows a negative qty, however the Item Detail…