Browse By Tags

  • AP invoice and the AP Trial Balance Report compared to the GL

    Hello, I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…
  • How to show Fund (or project) column in General Ledger report

    I'm wondering if there's a way to have a transaction's fund allocation represented in the General Ledger report from Sage 50? My client would like to review all transactions via the General Ledger and see also what fund each is attributed to. Right now…
  • Sage 300 CRE GL system has a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting

    Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?
  • General Ledger Analysis Report- Operational Efficiency Ratios

    We have 3 company codes in our system. The operational efficiency ratio data on the general ledger analysis report populates for one of our companies but not the other. Has anyone experienced this issue before?
  • Is there a way to run a report from Sage 300 that shows ALL unique vendor numbers and transactions for a given period at the G/L level across all entities?

    Report might look like this: Fiscal year: Fiscal period: Due date: Vendor Number: Order no: BS GL code (Header): Expense GL (line): Transaction currency: Gross amount: Tax amount: Net amount:
  • Profit and Loss

    Is there a way or method I can run a Profit and Loss for a specific time period - for example, 7/1/2018 through 6/30/2019?
  • What does *!! at the end of a general ledger report mean?

    On some reports at the end I'm seeing *!! at the end and was wondering why or what it meant
  • 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…
  • 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…
  • Cashflow Statements

    Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.
  • List of previous month's activity

    Hello, I have taken over at a small non-profit association and was given zero information by the previous accountant. I have never used this software. I am trying to simply look at all of the journal entries from the previous month so I can see what…