Browse By Tags

  • job cost

    I need a report that shows all employees that worked on a certain job on a certain day. Can someone help me?
  • how to know which check form to select

    we either need to know which check form to select for our current stock of checks or how to know which checks to order and then which check forms to select. is there a way to see how each form displays? or how to we make selection?
  • Crystal Reports 2020 Database connection Error

    Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…
  • EEO-1 Reporting

    Can anyone help me wth how to have Sage PR mod compile the EEO-1 report?
  • Sage 300 CRE Payroll - Work Comp Audit Reports

    I am new to this program and cannot seem to find the right reports that I need that would include everything for the auditors. Any suggestions?
  • Sage 300 Employee Information report crash

    We just put the Tax updates for January on our system December 31. We are on version 2021, UP73 product update 30. When we enter all of the parameters on the screen for the Payroll Employee Information Report and hit print, it crashes. By crashes I mean…
  • How can I get a report like the Check Activity Detail report with only YTD Totals for all employees in a specified date range Using Sage 300?

    How can I get A report like the Check Activity Detail report with only YTD Totals for all employees in a specified date range Using Sage 300? The Check Activity detail report is just what I need with just a bit of modifications. The report only need…
  • Sage 2021 PU2, PR 2.21.3 Upgrade - Have to re-add Payroll Custom Reports with PII Wrk table from 2018/2019?

    Howdy - I have had 3 separate upgrades where the client is upgrading from 2018/2019 with fairly recent Payroll updates (2.21.1 and greater) to Sage 2021 PU2 with PR 2.21.3, and after data conversion, if they have any Payroll custom reports from the previous…
  • Union Paygroup Report

    Hello All, We use the Union Paygroup Report (5-1-7-31) in Sage 100 Contractor to pull information for our monthly union remittance. This report can only be run by period end or check date. I'm looking for a way to run it for the entire month (i.e. 1st…
  • NYS EO 162 Workforce Utilization Gross Wages Reporting

    Does anyone have a report that meets the NYS requirements for the EO 162 Workforce Utilization Gross Wages Reporting? https://www.thruway.ny.gov/business/dmwbe/purchasing-eo-162-instructions.pdf
  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
  • Payroll deductions and expenses doubled?

    Hi everyone, I have just come up to something that baffled me terribly and I need your help. Since I started using Sage 50 (back in 2015) I've always printed my Deductions and Expenses Summary report and based my monthly payment to CRA on it thinking…
  • Custom payroll history report never stops running.

    I've tried converting a custom 401k report from v2017 to v2019. In v2019, the new report never stops running. The selection criteria allows the user to specify a beginning and ending check date, and choose a pay cycle. It doesn't seem to matter how…
  • Payroll Deduction Report for a specific date range?

    Prior to payroll 2.0, there was a Consolidated Deduction History report under Payroll -> Reports -> Deduction Reports. This report allowed the user to specify a specific date range for the report. We would use this to report on deductions for a single…
  • Is there any type of payroll report that will show me the distribution to an entity by employee by cost code and show the employee's hours worked?

    This is a standard report in the system we currently use and is called P/R Edit List by Job. We are in the middle of programming the Sage system and have run a mock payroll but it is not yet posted. However the above mentioned edit report is provided…
  • Sage 100 ERP 2013: How to generate a list of all accounts that have special pricing methods set, like price overrides, price discount amounts, etc.

    Hi everyone, I'm wondering if anyone knows how to generate a list of all customers that have special pricing methods set, including: Cost Markup Amount, Cost Markup %, Price Discount Amount, Price Discount % and Price Override. The one that's chiefly…
  • OCIP Reporting Calculations

    Good Day!!! I wanted to understand why the OCIP report and Time Entry Reports would come up with different worked hours and dollar amounts. After further review, I found that the OCIP report is calculating all OT hours at a regular rate. Is this normal…
  • Information on fields from Wrk tables? Needed for Knowledge Sync.

    Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…
  • SQL Table for batch history? AKA Batches not located in GL_CompanyActiveBatch?

    Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…
  • how is the labor burden calculated in the 6-1-2 reports?

    I am having a difficult time trying to figure out how the labor cost is being calculated on the 6-1-2, labor cost reports. they are varying highly for my designer. the same job had one days work at 31.80$ and another days at 75.20$, regular hours, not…
  • My Assistant one page pay statement

    We recently purchased MyAssistant and would like to send out a one page pay statement. We would like a one page statement similair to the Sage report attached to the pre-built task, "Send employees their pay statement (report attached)". I am not able…
  • Historical AP Aging for YE doesn't match GL Balance

    I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…
  • Sage 100 Contractor 2017

    I need a cumulative gross wages report based on custom dates, not quarters. Can anyone point me in the right direction?
  • How to see hours worked in Job Site report after Payroll is submitted?

    I have the 50 Accounting CA version, that allows me access to Job Sites/Time Cards/etc. I recently learned about the Job Site feature; where you can allocate hours worked and materials purchased to a particular project that we have on the go. Currently…