• Connecting to Audit Trail .DAT using SQL?

    I have been using SQL Server to connect to my .DATs without issue and today tried connecting to the AUDITTR.DAT but am getting the message that the object does does not exist. I am certain this isn't a typo or something simple like that, so I'm wondering…
  • Query Sage 50 database and extra basic inventory information

    Can someone provide a general SQL script/statement that I can use to extra basic inventory data from the Sage 50 Accounting (2016) database? All I really need are things like the part number/Item ID, description, Active/Inactive, and price levels (price…
  • 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…