• Export Component List

    I am trying to export the component list for parts within Business Works. There is no way to do this through the program, but was told you can do this through a query in excel. Does anyone have experience with this? Can someone provide steps to query…
  • SYSTEM Backup files - SMUSERTASKS - filie is approaching 10 MB on server

    SMUSERTASKS - if this is too technical of a question we can ignore it(delete). As a BW user for 28 years our file SMUSERTASKS has grown to nearly 10MB and takes 4 to 5 minutes to backup or restore (SYSTEM backup) . Should this file be this large and…
  • 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…
  • Any data file changes from BW v2013 to BW v2015, v2017, v2018

    FormerMember
    FormerMember
    I use access to run a bunch of custom reports via odbc for a client of mine. the reports pull from G/L, A/P and Job cost. I want to bring them to v2015 or v2017, but I need to know first if the data file names, field names, etc. have changed? Thanks…
  • Importing Journal Entries affecting cash into the Cash Management module

    I import journal entries (JE) into the General Ledger module, some of which affect cash accounts. However, they do not depict on the Cash Account Register in the Cash Management module. I have to manually re-enter the JEs via the "Enter Bank Transaction…
  • several errors on database connection

    After a few days ago our workstartions frozen after 2-3 minutes , and came up errors about database connection , such this ones: Unable to get Database Names count (7004: Failes to connect to the named server and/or database) And derive to…