Browse By Tags

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.

Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?

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…

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…

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'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…

When I run the "JC Receivables Aging by Draw as of Accounting Date" report, I can see all of the outstanding draws by job. However, some job numbers/descriptions show up and some don't. It's a standard report, but I've tried to customize it many times…

On some reports at the end I'm seeing *!! at the end and was wondering why or what it meant

I'm trying to create a formula for a date stamp time condition but cannot seem to figure out the format used for a time constant. For example: Time Stamp > 14:30:00 doesn't work. What is the proper format for a time constant?

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

I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are. So, if a formula is being used, is it used in another formula, report, etc. I have 100's of formulas & reports…

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…

I am looking for a job cost/payroll report that will show the the peak weeks worked on any project by trade or department that can be run by period end dates/specific timeframe. Anyone know of a report that will accommodate this?

I am really stuck, have spent too much time spinning my wheels on this. I have created a new report with values coming from Job cost, Contracts, Billings etc all coming from transactions using Accounting Dates. I am using a Prompt so I have a "Cut-off…

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…

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…

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…