Browse By Tags

  • Cashflow Statement - A/P operating vs investing activities

    Hello, I am trying to produce a reliable and accurate cashflow statement in Sage 50 Quantum Accounting Canada. To me, a cashflow statement should start with net income, then take into account cashflow adjustments from operating activities, investing…
  • AR Tax Group Set up Report

    Does anyone know if there is a AR Tax Group set up report that exists so I can see what tax rates are part the group? Looked in standard reports and KnowledgeBase but have not been able to find anything.
  • Sales report by foreign currency

    Hi, We have sales in US and CAD. For the Sales Report by Customer : Is there a way to have the information in foreign currency, instead of CAD. 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…
  • Run multiple reports at once?

    Is there a way to create a report group? When I make financial statements, I can combine multiple financial statement reports into a financial statement group and by choosing that group to print, it will print all my financial statements for the selected…
  • 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…
  • Sales Reports

    Hi, I'm using Sage 50. Could anyone help me on how to run a sales report which can show Item Description from the invoice? Thanks
  • 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
  • MyAssistant - Job Cost Report - Report Designer

    I have a Job Cost Report that I run task and it will send out to each PM but includes one report with all of their jobs. How do I change the report conditions so it will send a separate PDF report for each job that only contains information for that one…
  • Report Designer - Design Formula does not show up in Conditions

    Greetings, I am following the instructions of KB186526 to create a Date Prompt on a JC report. I am able to create the prompt fields. I can make the design formula (using Accounting Date [JC Transaction] instead of Accounting Date [GL Transaction…
  • Report Designer - Job Cost Report - Exclude Certain Categories

    I am trying to customize a standard job cost report in Report Designer. It currently details the costs by cost codes and categories. It is totaled at the bottom, where then a % is added on to account for overhead. We are now allocating some of the overhead…
  • Project Reporting Only Goes Back 1 Year?

    We have some 'straggler' projects from 2014 that are still active projects. It seems I cannot generate any Project Income report that uses a date earlier than Jan. 1, 2015 now that I have rolled over into 2016. That seriously sucks :( Are there any…
  • 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…
  • Project Budget Detail Report

    I am trying to run my Project Budget Detail Reports - Actual Vs. Budget, however the first line of expenses has minimal amounts listed under "unassigned budget amounts". I am not sure why that is or where to go look for the error or what was missed. Does…