Upgrade caused all invoices to be $0

1

Recently upgraded from 20.xxx (don’t remember exact version) to the latest 22.1.78 on Windows desktop install. Now all past sales invoices show $0 invoice totals and a status of overpaid. If I open up the invoice details all the information is correct. Also, if I then click the “update” button on the invoice screen (having made no changes) the issues seem to be fixed for that invoice. I’d rather not have to do this for all sales invoices so can you shed some light? I’m also not sure where else this upgrade has broken things.

Well, as I’ve been writing this now I’m noticing that since “fixing” one of the invoices via the method above the summary screen is now broken and I just get this error:

System.Collections.Generic.KeyNotFoundException: The given key 'Manager.Model.SalesInvoice' was not present in the dictionary.
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at Manager.Query.GeneralLedger.GeneralLedger.ConvertSalesInvoicesToCashBasis2(DateTime[] dates) in C:\projects\manager\Manager\Query\GeneralLedger\GeneralLedger.cs:line 912
   at ManagerServer.HttpHandlers.Businesses.Business.Summary.SummaryView.InnerGet2() in C:\projects\manager\ManagerServer\HttpHandlers\Businesses\Business\Summary\SummaryView.cs:line 54
   at ManagerServer.HttpHandlers.Businesses.Business.BusinessTemplate.InnerGet() in C:\projects\manager\ManagerServer\HttpHandlers\Businesses\Business\BusinessTemplate.cs:line 566
   at ManagerServer.HttpHandlers.Template.Get() in C:\projects\manager\ManagerServer\HttpHandlers\Template.cs:line 380
   at ManagerServer.HttpHandlers.HttpHandler.ProcessRequest() in C:\projects\manager\ManagerServer\HttpHandlers\HttpHandler.cs:line 154
   at ManagerServer.Startup.<>c.<b__1_1>d.MoveNext() in C:\projects\manager\ManagerServer\Startup.cs:line 123
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)

So basically a real mess. Any help would be appreciated! Thanks.

2

OK figured it out. After I performed the update, launched the program and clicked my business database the first time Manager seemed to hang at a white screen. I then used task manager to kill the process and re-launch, that time my database opened right up but had the issues I noted above. I think what happened is Manager was working on upgrading my DB during that white screen “hang” situation and when I killed it I was left with a half-upgraded database. Today I restored my database from before the update, relaunched Manager and this time let the process finish (it took a couple of minutes) but everything looks normal now.

So my bad for not letting it finish, although I’d suggest to the developers to include a progress indicator or at least some message about what is going on rather than just a blank white screen.