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.
  • Which export/import do I need? (restaurant POS integration)

    I work for an organization that makes a restaurant Point of Sale. We have a customer with Peachtree 2011 and they've sent us information from the help files about importing into that version. We want to import sales information into the G/L but I'm not…
  • 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 HR Employee Name Sync

    How do you change how employee names sync from Sage 50 to Sage HR? Sage 50 lists employees as Last Name, First Name but when synced to Sage HR - the Last Name is showing as the First Name and First Name showing as Last Name.
  • Inventory module

    We recently purchased Sage software to manage inventory items. I have a few questions, 1) is a way to upload inventory items from an excel spreadsheet? If yes, could you please send me instructions? Or do we have an email for support? 2) If we are only…
  • 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
  • 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.
  • Data base engine error

    Is anyone else being asked to pay $900 plus on top of Client care to clean up error history??? Seems fishy to me. I just had 2023 installed and it was working and now i moved my computer to my desk it is not working. But....they can fix it in 2 hours…
  • Using a file on 2 devices

    When using a file on 2 different computers, should we select 'open the last company I worked on' or 'connect to a shared company'? One of our staff mostly uses our Sage files for all bookkeeping and reconciliations while another team member uses it…
  • 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…
  • Impossible d'ouvrir les entreprises partagées

    Bonjour, J'ai acheté un nouveau portable dernièrement, j'ai téléchargé Sage expert comptable comme sur mon ancien portable. Lorsque j'essaie d'avoir accès à mes entreprises partagées, j'ai un message d'erreur comme celui-ci : Nous n'avons pas pu récupérer…
  • Automatic Backups

    Currently in order to do an automatic backup in Sage you must use the Automatic backup tool which uses Windows Task Scheduler in order to do the local backups. This has proved to be very inconsistent and not as reliable as the manual backups of course…
  • 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…
  • Sage 50 CA Premium 2018 UPG

    Hello Everyone, I upgraded Sage 50 CA Premium 2018 from Sage 50 premium 2016 in 2018. The software was working fine till now. My computer broke in Feb and I bought a new one. I installed the version 2018 and restore it from the backup. It was working…
  • 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…
  • Any issue with other app databases in same instance as Sage?

    A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…
  • Anyone else had an issue with the Sage 50 client crashing with a null index error?

    One of my bookkeepers reports that she had her client crash with null pointer error. Looking at the server, found a 0xC0000005 error for the zenengrsvr32.exe . She couldn't quit Sage or navigate off the page she was on. Rebooted her workstation couldn…
  • Database error (operation=LOCATE, error=0).

    Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…
  • Transaction Data Import

    I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…