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…
  • 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.
  • Payroll Tax Remittance

    My starting balance is incorrect in my remittance summary. I tried to adjust the payments part so it would zero it out but it didn't clear it out. How can I get it removed or adjusted?
  • 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?
  • 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?
  • I need a report to show me any AR that was billed but not paid

    I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …
  • 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
  • AP Historical Aging

    Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda
  • Custom report: G/L Account and Date Last Used?

    Is there a specific field and/or table to use within Crystal Reports to determine when a G/L account was last used? This would be for the purpose of delete the obsolete account. Please advise and thanks! T. Helm
  • 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…
  • Business Insights Reporter Wizard Payroll Hang

    I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…
  • 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…