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?
  • EEO-1 Reporting

    Can anyone help me wth how to have Sage PR mod compile the EEO-1 report?
  • Automated Inventory Reports

    Hello, I am looking at sending an automated monthly report to a customer with a list of the items they supply us. If possible, I also wanted to provide a breakdown of any work orders, inventory adjustments, etc against each item. Is this report possible…
  • 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…
  • Inventory Summary vs Group Inventory and services

    I am trying to get a download of inventory ready for our Year End. I have categorized and noticed there are discrepancies in value. Through Reports 1) Inventory and services summary approx. $450.00/Inventory icon same 2) Inventory and services list…
  • 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…
  • 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
  • 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…
  • RECEIVED PO / MISSING INVOICE #

    Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…
  • Is there a way to calculate the commission by item sold?

    Hello, I have a warehouse of items that are are sold by sales reps. I need to compute commission earnings by sales rep; linking customer invoice detail to vendor costs. How can this be done for warehouse items? Thank you in advance. Ellen
  • Inventory Report - Duplicating Items

    I have ran the inventory report multiple times for multiple reasons and have the same issue. When I ran the inventory report and downloaded into excel I am finding that it is duplicating many of the items. I am updating list pricing and am checking for…
  • 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…
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…
  • 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…
  • Item Sales Report Sorting

    I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…
  • 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…
  • 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…
  • 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…