Sage 100

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…

I need to reopen a closed fiscal year, but I can't find any instructions on how to accomplish this.

Is there an ERD or easy way to identify the AR Invoice tables. We are using SQL Server as our database and trying to pull the daily invoices to a table. We currently have about 10 companies setup and need the data from all companies. Thanks

A VI Job was created to import and update some data in a few fields on Customer Maintenance. Something in the VI job was wrong that wasn't caught and it ended up creating a bunch of bogus customers. Is there any utility that can delete all of…

I have 7 out of 11 invoices from a Sales journal that are "not on file" when searching in A/R Invoice History. The invoices are listed in their respective Customer Inquiry Invoices tab- but doesn't open a view of the invoice. The entire Sales Journal…

I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…