• Vendor Reporting YTD LY Results

    How can we do a report to show how much money we spend with each vendor for last year?
  • Export Check Register into Excell

    Is there a way to export a check register using Sage BusinessWorks into Excel.
  • Daily Transaction Register freezes at 97 percent when trying to print or print preview

    Like the subject says. Client prints daily transaction registers at close. When they try to complete this task th porgress bar gets to 97% and hangs. Does with multiple printers and also print to pdf.
  • Do 2023 W-2's need to be processed before updating the forms to file the 4th quarter 941?

    I wanted to file our 4th Quarter 941 report but I have not processed our w-2's yet. If I update the forms through Atrix will this affect w-2 processing? Should I wait until our w-2's are processed then update the forms?
  • Table Mapping

    What is the link between the OESalesOrder table and OELineItem. I'm pulling the data via ODBC and trying to identify the key between the two tables. Any insight or documentation you can direct me towards would be greatly appreciated! (BW 2019)
  • Check Register Report - Voided Skipped Checks

    I ran a check register report today dated for 01/01/2021-03/25/2021 and it showed a lot of voided skipped check numbers, but also showed that same check number with a vendor and a dollar amount (which is correct). Back on our 2/19/2021 check run we had…
  • No currency format in Maintain O/E forms

    Under the Order Entry Module I was redesigning a sales order to use for a commercial invoice. After creating a db calculation it would only display the number with no decimal places unless there happened to be cents in the calculated answer. I wanted…
  • Reporting upgrades made to newer version of Business works

    My company is currently running BW 2013. We are upgrading our operating systems and a number of other customer databases that we use and we want to do the same with business works. Our biggest issue with the current version is its inability to drill down…
  • Does F9 for BusinessWorks work over a VPN connection?

    Can I assume that since BusinessWorks is not supported over a VPN connection that the F9 reporting is also not supported over a VPN connection? Working remotely due to the COVID-19 has drawbacks, but this could be a real killer. Thanks in advance…
  • Negative quantities posting to I/C

    We are currently building a pump, the way we process the job is to charge everything and then at the end we post a negative quantity of the completed pump to balance the numbers. Unfortunately, now that I need to close jobs for the end of January next…
  • Running A/R reports for one salesman

    When I run a a/r detail report for only one salesman, it doesn't list all invoices if the vendor is not assigned to that salesman number. How can I correct that?
  • Part issues report by custom date

    FormerMember
    FormerMember
    Hi, Can anyone help and tell me if there is a report that will tell me how many issues I have for a particular part over a specific time range? Not MTD or YTD and not a dollar total. I need to know how many peices I sold. Thanks
  • Payroll Deduction not showing up on reports

    So we had a fringe benefit that we needed to calculate on the last payroll of the year, which happens to be today's payroll day, and the entered the deduction according to the Sage Support pdf document titled How To Set Up and Process Fringe Benefits…
  • ACA reporting

    Hi I'm using BusienssWorks 2015. Has anyone created a report for keeping track of hours/employees for the Affordable Care Act, ACA? Has Sage developed any ACA specific reporting tools? We are under 50 FTE's this year - but I still think we may have…
  • Account Detail Report shows 1 future transaction that is actually current.

    For some reason on one of our G/L account numbers we have a transaction that is marked with an asterisk on the account detail report that shows up as future transaction. That particular transaction was entered for the month of December on 12/01/14. It…
  • Employee List Reports

    I am customizing the Employee 401K List Report (it has been renamed but no fields have been deleted, just made invisible) and I am having trouble with adding a database field for selection. I get the message "The SQL statement that you have provided is…
  • Employee Hours List Report

    I am having problems printing a good copy of the Employee Hours List Report in BW2013. I am up-to-date with service pack 8 installed. No other printing issues, just this report. It will print after a lengthy amount of time but, it cuts off several columns…
  • Issued AR Invoices Emailed or Printed and mailed?

    Is there a report that will show if an AR invoice was emailed and to what email address? Thanks
  • Created a custom report for Inventory usage and the items repeat in the preview

    I'm trying to help a small company (friend) create a report that shows all inventory usage, receipts, sales. I successfully created the layout, but when I preview the report, the first item repeats many times. How do I fix this?
  • G/L Flash Report not showing cash balance from new cash account

    We recently changed banks and so we reset the defaults to the new account which now appears as account #1 in CM/Maintain cash accounts. The problem is that the G/L Flash report is still showing the $0.00 balance apparently from the account we no longer…
  • Spreadsheet Style Reports

    Does anyone know if BusinessWorks has some reports (already created) that will show Income Statements, Trial Balance or Balance Sheet by month, rather than do a cut and paste?
  • ODBC Tables and Reporting

    I use Microsoft Access to automatically generate pick tickets from BW based on available inventory. My problem is I cannot get the line items to "sort" correctly to match how they print on BW Invoices and Sales Orders. How does BW sort order the line…