• ODBC based General Ledger report

    I am using ODBC and want a BASIC listing of all transactions. e.g. Date, AccountId, amount. So far I have looked at the tables starting with GENERAL_ (e.g. GENERAL_GL) but have not been able to tie them back to the reports that would be run in the front…
  • Sage 50 Quantum - Import / Export Tool

    I am familiar with Sage 100 and have built a local agent that can communicate via batch import and export and am looking to do a similar thing with Sage 50 Quantum. I have a REST API that would talk to my local agent on the same server where Sage 50…
  • Import material costs

    Hi. I'm new to SAGE and wanted to import material cost data from excel to SAGE material cost in the standard unit cost breakout that I can see in the maintain inventory under the inventory management module. How do I do this? I dont want to manually type…
  • Sage 50 Accountant 2019

    I have Sage 50 Accountant 2019 standalone version installed. I was using it yesterday (July 31, 2023) but today, Aug 1, 2023, when I launch the application, it is trying to find a Sage activation server. It fails to find an activation server, gives an…
  • Importing Sales Journal from CSV - Get duplicate reference warning but import is still successful

    Whenever I import an invoice from csv, the invoice will import completely correctly but I'll always get the "Warning! The reference number has already been used" duplicate reference error at the very end of the import. And the location of the error will…
  • How do I get the "your data is loading" box to close?

    Hello, Can someone please help me fix this issue? I've restarted my desktop twice, and the box continues to load. Control/alt/delete does not fix it either Thanks, Joe
  • Importing General Journal report with debits and credits column

    I need to import a general journal report to Sage 50 US edition. The report I am trying to import has debit and credit columns. However, in the Select Import / Export > General Ledger > General Journal the only option is "amount". How do I bring debits…
  • 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…
  • Import from clover to sage on a daily basis

    I am trying to find a way to import from Clover to Sage on a daily basis. Is there an app capable of doing this?
  • Customer ID issue

    we have an issue with Sage around a "ghost" customer id. Sage is telling us that we have to totally create a new company and just move over beginning balances, but doing this obviously creates an issue with the history. We are hoping to be able to repair…
  • Remove post

    Remove post
  • Backup error with DYNAZIP error 18

    I have now had THREE clients in the past 2 weeks report an inability to run manual backups due to a DYNAZIP error 18. Three different companies, at three different locations, with three different IT support companies troubleshooting this. All have followed…
  • Importing Sales Orders - Unit Price and Amount are coming in as negative values rather than positive values, and what is the Number of Distributions value used for on a Sales Order?

    I am new to Sage 50 and trying to help this small business to import sales order information. I started by identifying the fields that I thought we needed and then I exported that so that I had everything in the right sequence. I don't see a place when…
  • Automatic Backup is failing

    Good morning, The Automatic Backup of all my companies are failing with this error "An unknown error occurred compressing the database files." How do I fix this issue? Thanks Christophe
  • Why Sage 50 2023 cannot export to Excel?

    I've just upgraded Sage 50 to the 2023 version. Now when I try to Export to Excel, I get the message "An unexpected error occurred while copying your report to Microsoft Excel". I have previously used this feature daily. I have restarted my computer several…
  • Importing journals from text or CSV files

    Which version of Sage accounting do I need in order to be able to import journals from text, csv or excel type files? Does Sage50 have that capability? This is only for a small business application, so I'm looking for the minimum version of Sage that…
  • Export Quantity Discounts in bulk

    Hello! We are in the process of building a website solely for our wholesale customers. We need to be able to put in the Quantity Discounts per item/ group of items. How can you export a list of Quantity Discounts including the Minimum Qty for Discount…
  • Looking for advice regarding monthly recurring sales order transactions

    We are on Sage 50 We have monthly sales of a few products (non-inventory) with a varying quantity & unit price but same customers & same repeat products. We use job ids in all of our sales orders (this drives our commission reporting). We are looking…
  • I pause sharing and it flips back to shared in by itself

    I go through the steps to pause, it switches to paused and within seconds it switches back to shared and won't allow me to do anything. I'm also missing transactions on my general journal list, but they are showing in reports for those accounts. I would…
  • Backup

    Anyone else have an issue with backups that have been « saved » and then actually being unable to find those backups or they don’t exist in the computer? I have been using Sage/Peachtree for over 20 years, this is the first time I am having this problem…
  • Maintain Cutomers

    Has anyone else had an issue entering customers, getting a message saying Customer Id already exists in Sage?
  • Error: The company could not be opened because the file 'C:\WORK\SAGE50data\promanse\PERMISS.DAT' is missing or damaged. How to solve this problem?

    Error message was prompted out "The company could not be opened because the file 'C:\WORK\SAGE50data\promanse\PERMISS.DAT' is missing or damaged." How to solve this problem?
  • Maintain Employees - Error Code

    Hi - I have Sage 50 US Addition. As I was editing a new employee's information last week, I got this error code: And now, I can't edit or view the employee's information at all. This has never happened before. I haven't found any guidance on how…
  • Weird issue - sales order blank

    I'm using Sage 50 Quantum Accounting 2022 (build 29.0.00.0086) and I'm having a weird issue. I have a user that creates sales order and prints it out. It saves on the system but when they go back to open it up, it's completely empty. The sales order is…
  • Query on tables no longer working on 2023 version

    Have an Access program that runs queries on the Pervasive/Axiom tables pulled form an ODBC connection. Since updating to 2023 the queries no longer work. ODBC connected and can see all the table in SQL Studio but none of the queries run. Can someone…