Browse By Tags

I need to build a Client Average Days to Pay Report. Has anyone built one? Any suggestions? Thanks,

I have multiple selection criteria for my report but instead of pulling data that fits all selection criteria it is pulling in all data that fits any of them. I know there is a box that says enable or logic but it is not checked and even if I do check…

Our monthly union benefit payment is split and 9 of the benefit calculations get paid to one place and 3 get paid to another. As far as I can see the Union Reports (for ex. 5-1-7-31) total the benefits by paygroup and unfortunately the report is not modifiable…

How can I change the calculation for Yr-to-date Gross Wages on a pay stub to include Calculation Add ons? I've tried a few different calculations & modifications but can't seem to find the correct one, so on our pay stubs it's not reflecting the additional…

We have purchased Sage 100 Contractor - Canada about a year ago. it was an upgrade from Sage 50. we had great support setting up Sage 100 and transferring our account information from Sage 50. the person used for this has since retired and we are…

Custom reports and report forms in Sage 100 Contractor have been "infected" with this "field" rptclc^clc001, 002, etc. I have seen this before but not to this extent. It is massive. Has anyone else seen this before? Or know what causes this…

In this webinar, we'll show you how to streamline your payroll reporting by creating Report selections, to run batch reports all in one go. We also explain how to use Custom Report settings to tailor the payment information in your reports. This session…

I need to print a payroll summary, by employee, that shows gross payroll and overtime paid over a specific time period. For instance, For the period 1/1/13 - 4/30/13 Employee Gross Wages OT Wages John Doe 10000 425 Jane Doe 6500 0 Johnny Doe…

Hello, We've switched to a cost plus billing model and have struggled to find the "perfect" reports to present to clients to show the work completed. For those of you who also do so...what report version are you using for clients and do you show them…

I'm looking to add a custom report to Sage 200 that I've designed within the Sage 200 Standard environment rather than in a separate installation of Sage 200 Professional. I've reviewed the help file on adding custom reports but either this isn't possible…

We need a simple way to query a report for on hold accounts and their outstanding payment amounts. I thought I could use some of the data provide from the AR Customer Inquiry table, but I can't seem to find what that table is called? We need - Customer…

When there are several check form designs with different bank accounts is there a way to review the check form designs (template) before printing to ensure the template with the correct bank account has been selected? In addition, I would like to…

I have created a custom paycheck stub and everything works great except I can't find the reprint check stub checkbox to add the to the report. I started with a copy of the system report and modified it, but this option seems to have disappeared and I…

Report 6-1-12-51 Committed Cost-Developer. How does this report for Developer differ from regular reports? There are asterisks after some items, but no description of what the * means.

Hello, i am trying to figure out how to add the task name to the purchase order. We have our system set up to export P.Os. by task but without the task name on the PO it makes it a bit difficult to determine what it is for. Any suggestions on what to…

Hey Everyone, I updated to version 22.4.44.0 from version 19.8 recently. Everything was going well until I tried to run a custom form/report....My columns are all out of place could anyone give me some guidance please. Thank You!

In December of 2020 two long term liability accounts were added however the store debit activity was not selected in set up. These two accounts are not being included in the balance sheet statement. Is there a way to manually put in the initial debit…

I am a long time user of Sage 100 Contractor (formerly Master Builder). I need more flexibility in data reporting from the system. I have read that Sage Intelligence Reporting and Liberty Reports are two add-in options. If you have experience with either…

Error: Knowledgebase article says: "Error: Exception of type System.OutOfMemoryException was thrown running the 6-1-2 report (version 19 and earlier) Enhance export to MS Excel engine Exception of type System.OutofMemoryException was thrown Job…

hello everyone I designed a custom claim report on ess i need help on how to design a custom report on pastel payroll or hr to pull data from the submitted claim report I want to export it ou for import

Any help for creating a custom report from scratch? Its very specific, so I don't think I would be able to customize an already exiting report... I think I would have to start from scratch. Not much for help on the KB! I need a report that breaks…

I am looking to see if this is possible on the built in reporting, or if it possibly is something that Intelligence Reporting offers ( which we do not have )- Run a report of invoices, with a column with the COGS for each invoice line. The invoice register…

I must start with, I know very little about this software. I am working with a colleague who works with Sage, but I am trying to help research this issue. I have a very specific need and am wondering if there is a way to do this within the software. Ultimately…

We sometimes have multi page AR invoices. Prior to my joining the company, reports for specific number of pages were created so our terms and total print on the last page.I'm making some changes that will result in having different invoices for different…

Hello, I am trying to retrieve a list of projects with associated company. (for example: i am trying to do the very same thing where when you find your company and click on 'People' tab then youll get all people associated with this company.) So…