Browse By Tags

  • Power BI

    We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.
  • cannot access database (error=40960) sage 300

    I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?
  • Sage 300 2024 w/PU1 Sage 300 Cannot Connect to Signon Manager - Resolution

    Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…
  • Sage BusinessVision 2023 SBE Bug Report - Broken indexes (Actian v15)

    Hi ClarkM and Erzsi_I I see that that a similar question was posted by slacka 6 months ago, and remains unfixed. I don't understand why this issue hasn't been taken seriously. This seems to be a critical issue in the way a client is able to, or in…
  • missing main.db?

    I turned my timeslips 2017 and the main.db was missing. i now can't find it to access my data. can someone please call me at 310-556-1001 or refer me to someone who can find it? I found my tseg.fdb file but that is it.
  • Order Confirmation Creation Time

    Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you
  • move Sage 50 2024 to a new computer

    Hello. I bought a new laptop with Windows 11, and I want to move my 2 companies to the new computer. Do i just install Sage 50 - 2024 edition on the new computer, then backup (on the current, working old one), and restore to the new one and all should…
  • Upgrade Sage 300 ERP v2018 to Sage 300 2204.1 in a New Server - Vault and Store DBs

    Hi everyone, Im going to install new Sage 300 2024.1 in a new server but going to migrate Sage 300 ERP 2018 data to this. I already reviews information about new security enhancement through move ISM files to new databases (Vault and Store) and changes…
  • updating Sage Pro Accounting from 2023.2 to 2024

    Will updating Sage Pro Accounting from version 2023.2 to 2024 allow me to still open company files where they are sending me backups which was made in the 2023.2 version? I am hesitant due to previous experience as if I save the file and send it back…
  • Unable to complete Database Load - Error 59104

    Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.
  • Sage 50 company files will not open from remote workstations after update to 2024, "Sage 50 cannot map the network share to a local drive path on the computer *servername*. Check the network share's registry information."

    Hello everyone, I just updated our server and a few users to the new Sage 50 Canadian 2024 update, and we are now experiencing an issue with opening company files from the server. We have 6 users that have a mapped drive on their local client that points…
  • How long does an upgrade take from BW 2021 to BW 2023?

    This weekend i upgraded our systems from BW 2021sp14 to BW 2023 sp2. But how long did it take? My system is network of 15 desktops running Win 10 and Win11, on Server 2016 ( Dell T550 with RAIDed SSD drives ) all gigabit network connections Our…
  • How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
  • Sage 500 Specialist needed

    Hello, I am looking for a Sage500 specialist to help me with upgrading a client from Sage500 v 2017 to v2023. This client also has a small customization. I need to figure out if it would need to be upgraded or if it can continue working without issue…
  • Server and OS Upgrade

    Hello, I have a client on Sage 500 v 2017. This is was the main ERP for a smaller company that was bought by a larger one. I am being asked to upgrade the server - both the Windows OS and the Sql Server. (I am reluctant to upgrade the sage 500 version…
  • Sage 2018 and Fixed Assets 2023

    Just upgraded Fixed Assets to 2023 for a client and they are still using Sage 2018 (in the process of upgrading to 2023 just waiting for a new server) and now they cannot print in Sage or in Fixed Assets. Getting this error. Report file C: ProgramData…
  • VI Import Job Unable to open [wdx][odb]<dsn_name>

    I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…
  • OEORDD.UNITPRICE

    Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?
  • Sage 300 - Database is locked

    Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
  • General Journal Posting - duplicating

    Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
  • History and Upgrade Suggestions

    Here are a few friendly suggestions that you might want to park in the back of your minds that could help out with some yearly maintenance and upgrading. These are not day-to-day type things but can help out over time. There is a table in the system…
  • V11 to V12 upgrade timeline

    Approximately how long should it take to upgrade from V11 to V12?
  • Tips before upgrading to 2023

    Thinking of upgrading to Sage BusinessWorks 2023? Things you need to know before you begin. Sage BusinessWorks 2023 is upgrading the database engine from Pervasive 10.3 to Actian Zen 15.1 Ensure compatibility with any software that may use Pervasive…
  • 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…
  • cannot create new System database on Sage 300 v 2023

    Hi all, On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below. I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible. Anyone know…