Browse By Tags

  • Crystal error when running reports

    Fresh install of Sage 100. I ran the installer as domain admin as well as the WksUpdate Standard file. I have already tried reinstalling the software over 5 times and verified all necessary files were present in the C Drive file path. Is there any other…
  • report error "invalid object name mscfld

    I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.
  • Error in Account Reconciliation with Outstanding Transaction Detail Report

    When I used the Match Bank Transactions function in the Banking module to help with making my lengthy bank statement reconcilable, I matched all the transactions, then look at my reconciliation on the reconcile accounts functions; it says I have no unresolved…
  • PO wont display amount

    When I print my PO to PDF the amount is displayed by #### symbols. Is this a formatting error? I attached a snapshot of what it looks like. Thanks!
  • Does a profit and loss report exist in Sage 50?

    Does a profit and loss report exist in Sage 50? Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage? I would like the report to include income, cost…
  • Additional Reports for Sage 50 Canadian Intelligence Reporting

    Does anyone know what happened to the Additional Reports for Sage 50 Canadian Intelligence Reporting? It seems only US and Pastel reports are available.
  • Process exit code = 259 and proc handle keeps jumping - report stuck executing

    Hi: I am new to Intelligence Reporting. I am trying to run any report (like the Dashboard Analysis) on my Peachtree company. It is at the Executing phase. The process window shows one row. The "proc handle" field on that row keeps changing. The "exit…
  • PO No. & Unit Price not a field for intelligence reporting, can I add this field somehow?

    FormerMember
    FormerMember
    I've been using the Purchase Analysis intelligence report, however I want to add the "Purchase Order No." (not JobID) in the report. Sage has to be storing it somewhere, because we fill it out on every PO we input, same with "Unit Price". It is not…
  • Drill Down Problem

    I'm getting an error when trying to do a drill down: "The drill-down report Report Designer Add-In-GL Transactions 1-0 required to perform the drill-down doesn't exist" I'm using Sage 50 US 2019. We called sage and after speaking with several…
  • Consolidated Designer

    I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…
  • BI Tools in Excel Keeps Disappearing

    I need BI Tools menu in Excel to export reports. It keeps disappearing from the tabs at the top. If it goes away, I have to reboot my whole computer to get it going again. Any help would be much appreciated. There are no warnings or dialogs that pop up…
  • Sage Intelligence Data Limit Reached in Excel

    I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…
  • Error Message When Trial to Run P & L and Balance Sheet

    Hi there, We have a serious issue with our financial statements. They won't run! Thus, we cannot produce monthly statements for July. This is the error message we are getting after trying to RUN these unionized SI reports within Sage Intelligence. It…
  • BI Reporting Manager Error

    Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…
  • Sage 300 2014 Intelligence Report getting an sa login failure

    Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.
  • Reports

    Good morning. I have two visas set up in my accounting and made some simple errors that i then fixed (ex: using wrong card for transaction). that has been fixed. But now when i print out my transactions by account report for each card... the wrong vendor…