• Error: Field Name: EmpER Fld1-Calc Name when changing fiscal year

    We are currently trying to change our fiscal year from Jan-Dec to Oct-Sep. We have successfully switched over 2 entities (after hours of troubleshooting). Now we are down to our last 2 which have actual employees and have hit a wall. We have started with…
  • Connection to the Sage 50 Accounting 2018 Database

    Good morning everyone I would like to know if it is possible to make a connection to the Sage 50 DB, I currently have the US 2018 version. The reason is because I would like to be able to get information with a separate development and if it is possible…
  • Exporting to Excel

    Is it possible to export Work Ticket information into Excel from Sage 50 Quantum Accounting 2020?
  • Sales Order - Missing?

    A sales order was created, printed out, given to the delivery driver to have signed when material was dropped off, brought it back to complete the invoice process and the system will not pull it up. We clicked on the sales order and it pulls up a blank…
  • What type of data contains in InventoryCosts table in sage 50 ?

    In My Sage 50 database of of the table named 'InventoryCosts' contains the item record number, cost, Quantity, etc.. I just want to know it's a item's real cost Or real Quantity ? if no then what is the purpose of this table ?
  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
  • Cannot open Sage - I did not run Year End Wizard / close year AND I clicked on last open period in Change period window

    Did I lock down the data set? Was trying to trigger launch of End of Year Wizard, it did not launch and I closed program because each time I open program it would prompt to run End of Year Wizard. This is only site I use Peachtree at - all other sites…