Background info:
Sage 50 Quantum v.2016
Non-for-profit organization
Years working on: 2015 and 2016 Calendar years
First year using SAGE (entered 2014 history)
Before I rolled over to a new year, my inventory subledger matched the GL. However, after I had rolled over to a new year, the inventory subledger no longer matches and is showing some negative QTYs and Values. After clicking the transaction detail for the items with negative values, I can see they had an opening balance and no INs, but there were OUTs. Would this be the source of the problem? Or have I linked something wrong? Also note that I recorded inventory using the "Adjust inventory" function, as it was already months after their yearend, so to save time I just made one big entry for all purchases and sales for the year. I checked the corresponding COGS and Sales GLs in the transaction detail report, and they were all recorded properly.
I had only noticed this after inputting about 3 months worth of data in the new year (the NPO currently records everything on MS Excel and then I input the transactions into SAGE, as the SAGE software is still quite new to them). I didn't make any entries related to inventory, however, so I thought this was quite odd. I then went back to my 2015 backup before the roll over, and rolled it over again (saved under another file name), to see if it happened right after or if I had done something in the new year that made it go out of balance. Turns out that right after I changed the session date to 01/01/2016 and checked my Inventory Summary report, the total was now lower than it had been in the 2015 file. GL balance is still intact. Why did this happen?
2015 is the first year using SAGE. Historical data was inputted for 2014 ending balances and were successfully closed. Data Integrity Check says everything is fine.
PLEASE HELP! [:(]