upgrade from 3.6.1 -> 3.7.3 created some *new* Invoices...
This week I have been working on getting xTuple upgraded, I backed up the database and created a new one 'testupgrade', restored all data and had no errors. I ran the updater and ran 3.6.1 > 3.6.2 > 3.7.0 > 3.7.1 > and so on to get to version 3.7.3. After carefully examining everything I could think of trying, I found 6 new UN-posted invoices with varying date ranges. All seem to have no items listed and where a $0.00 value, except one! It had a shipping charge of $63.04 and a date of 12/21/10 - So I started to dig around and cannot figure out where this came from - I show the SO closed, it appears nothing shipped off that order (not saying something shipped and was returned, I am digging into what actually happened) so I started to dig in External Shipping List and can not find a transaction matching the SO number.
I posted it, it shows up as being due for that customer, but in 3.6.1 they are all paid up.
I am completely stumped where this could have came from. Its not in the current system 3.6.1 but shows up out of the blue after I do the upgrade to 3.7.3. If anybody has any other ideas where I could poke my nose and find where this came from to hopefully suppress it during the "real" upgrade, please feel free to comment.
I am going to delete this test database, do it again, and see what happens if I just delete these extra invoices from the upgraded version.
Thank you!
I found out that someone logged in my testupgrade database right before I started to apply the patches. I have no idea if that has anything to do with it or not. I have since created testupgrade1.
It looks like on the second try with testupgrade1 database (this time i skipped patch 3.6.2 and went, my version, 3.6.1 to 3.7.0 then did the .1, .2.... patches) the strange transaction with only a freight charge is now gone, but the 5 other Invoices with $0.00 totals are still there. I am going to start from scratch again with testupgrade2 just to make sure I am seeing this correctly.
It appears the situation was the SO was created, built, and shipped with the incorrect customer, the item was not returned, but our customer went to the incorrect customers business and picked it up. I am assuming I deleted the Invoice, Returned stock from shipping & closed the line on the SO. Then created a new SO for the correct customer & reshipped it. I can't recall if I did anything with the shipment information (this happened 12/21/10) in the External Shipping List but there are no transactions in there for either SO numbers.
I will run my test one more time, and post the results - Thank you for reading!
My results,
5 New Invoices after the upgrade - all for $0.00 with no lines - all but one seem to be missing there UPS tracking number.
I deleted the New Invoices - canceled them out of Billing Selections - then Looked-Up each PO number, all SO are closed. Shipments by Sales Order though does not seem to have a tracking number or shipment cost.
I am thinking that a link up between xTuple - UPS Worldship - and Postgresql, with those transactions, failed in some way and there is some left over information that gets 'kicked up' performing the upgrade. Who knows... Just sharing my stuff.
I would like to hear if anybody has any thoughts on this.
Thank you all again for taking the time to read this.