Browse By Tags

  • 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.
  • 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…
  • 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…
  • 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.
  • Cashflow Statements

    Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.
  • national account sales report

    How do you create a report to show the sales for a national account if the customer numbers are not contiguous?
  • Total by territory

    I have successfully added the territory field to my sales report is Sage Intelligence, but I cannot get the field to total correctly. If I put the field before the customer number it total, but only for each customer. If I place the field to the left…