• Vendor Reporting YTD LY Results

    How can we do a report to show how much money we spend with each vendor for last year?
  • ODBC Connections and Intergrations with Business Works

    Hi, We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations. We have a few questions: Can we use SQL to set up an ODBC connection? …
  • 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…
  • Previous Year's Employee Hours Missing

    Hello, I've been working on a custom export where I need a list of employees that have worked over 500 hours for 2019. While testing, I run the report in my current year company and everything is great. I go back to my 2019 company file to run the custom…
  • Calculation Field in Custom Reports

    Businessworks 2017 SP2 I want to calculate job margin on a custom report using JCjobs fields as follows: ((Billings-ActualCost)/Billings)*100 Is a calculation like the above possible in the report? Any help would be greatly appreciated!
  • Subreport does not export to excel as data (in a data document) - Is there a way to make that happen?

    I have a custom BW report which grabs invoices with a particular due date. I wanted the invoice detail with it which I can easily get, but the key is, I did not want a row for each line item. I wanted this information to be all comprised in a single field…
  • Link JCJob database field for selection in Report Builder

    Is it possible to link fields, specifically Job ID (on time card entry) or make available for choosing, from JCJob database when customizing the Check Register Detailed Report in Payroll? A report has already been created and customized under a different…
  • 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…
  • Need a report for sales for prior month or two

    I'm trying to create a custom report that lists ID, product name, prior months sales, YTD sales, on hand, on order and lead time. The only item I can't figure out is "prior months sales" How can I get this? I would also like to be able to put in a date…
  • Custom Reports Export / Column Sum

    I am using BW v12 SP8. I created a custom report and need to sum the columns. Since I do not know how to sum columns in a custom report, I tried exporting the report to Excel to sum the columns there. I found out I also do not know how to export custom…