My other thought is to just reset the database to zero and start over. There aren't may transactions,and we could avoid entering inventory at all this way. I checked online and can only find this option for Sage X3. I'm using Sage 50 Premium, Canadian. Does anyone know if I can start over but still keep the business info, customers and vendors?

You would normally use the Inventory Adjustments module to Adjust the inventory quantities and dollars to zero because,... that's what it is for.  By going back to the original purchase invoices, you have altered the original transactions but if your file is not set up on FIFO, then you most likely have average cost issues that is leaving dollars in the items.

Have you checked the Inventory Summary report to see if any items still have quantity and dollars?  If there are still items showing up, you can tell the account total by using the option to run Inventory By Asset and only picking the one asset account.  Generally, but not always, the dollars match.

Therefore by using the Inventory Adjustment module you can remove the quantities and the total dollars to an expense account for each item.

Make sure you run the Inventory Summary report without any Filtering and for the correct date to be sure you have all the correct information before you adjust.

If you ultimately then end up with dollars in your Linked Asset accounts but nothing showing on the Inventory Summary report or on each applicable item's ledger for quantity and value on the Quantities tab, you can use your Accountant's Edition of the program to make changes to the balances of the Linked Asset accounts using the General Journal.

A database reset like you are talking about is not technically possible with the current Sage 50 programming.  To do that it would have to be done by data repair techniques outside of Sage 50.

It is possible to create a brand new file without a chart of accounts, then export all your ledgers from your current file, to text files, then import them into the new file.

You will then have to go through all the options on the Setup menu to make the program functional by entering the proper linked accounts for every module, setting up the sales tax system from blank, etc.  It can take anywhere from a half hour to a few hours depending on the complexity of the file.

When creating a new file without a Chart of Accounts, you would select the last option when selecting the List of Accounts (Let me build myself).  It will give you a warning like "Are you nuts!!!  Don't you know how much work that is?"  I think I am paraphrasing here.  However, you can continue and it will work if you set the settings properly.  I've done it so I know it works ok, it is just tedious and takes some time.

Richard thank you so much! I ran the inventory Summary report like you suggested and was able to determine that I was showing amounts on the trial balance because the original adjustments were made with the current year's date. Once I discovered how these adjustments affect reports, I was able to properly implement the adjustment and bring my totals to zero on the trial balance. Yo have saved me much time and effort. Thanks again