Ledger & Fee Sheet error when upgrading from 3.2.0 to 5.0.1

topnoch · January 3, 2019, 8:23pm

Situation
Is there an issue with the ledger and fee sheet when upgrading form openemr 3.2.0 to openemr 5.0.1? It does not carry over all the information.

OpenEMR Version
3.2.0

Browser:
I’m using: Firefox

Operating System
I’m using: osX and Windows 10

Logs
Did you check the logs? Was there anything pertinent in them? Paste them here (surround with three backticks (```) for readability

stephenwaite · January 3, 2019, 10:02pm

hi @topnoch, could you provide more detail on what’s missing and did you upgrade incrementally from 3.2.0 to 4.0.0 then from 4.0.0 to 4.0.1, etc.

topnoch · January 4, 2019, 1:45am

Hi Stephen,
Thanks for writing back.
Yes. We upgraded incrementally following the upgrade guide. OpenEMR Upgrade Guides - OpenEMR Project Wiki

After upgrading some of the patients show incorrect Balance Due in the patient summary page, some payments and charges are not showing up in the patient ledger, and some payments and charges are not showing in the fee sheet.

stephenwaite · January 4, 2019, 3:35pm

hi @topnoch, are they recent payments and charges?

topnoch · January 4, 2019, 8:04pm

Hi Stephen, well it’s some recent and some from a while back.

brady.miller · January 5, 2019, 7:43pm

hi @topnoch ,

Rec trying an upgrade to 4.0 and then running the sl_convert.php script from the web browser. Definitely back up your stuff before doing this.
(and definitely remove that script when you are done)

-brady

brady.miller · January 5, 2019, 7:44pm

Actually, I may of misunderstood. Were you using sql-ledger as the ledger? If not, then disregard my above instructions.

brady.miller · January 5, 2019, 7:46pm

It looks like sql-ledger went away in 2.9 (Getting rid of SQL-Ledger), so just ignore my advice

stephenwaite · January 5, 2019, 8:19pm

hi @topnoch, do you see any patterns with the missing entries? thanks for looking into this @brady.miller

topnoch · January 7, 2019, 4:00pm

Thanks for responding @stephenwaite and @brady.miller. The pattern that i see from the missing entries are some payment entries in the billing table did not get transferred over into the ar_activity table in the database during the upgrade process.

stephenwaite · January 7, 2019, 4:19pm

could you post a couple of the affected rows from the billing table please, thanks @topnoch

topnoch · January 9, 2019, 3:00pm

The affected row is id 19532(COPAY 32.00). This row did not get transferred over to the ar_activity table.

topnoch · January 17, 2019, 5:45pm

Hi Stephen, was just checking in to see if you have any insight.

stephenwaite · January 17, 2019, 6:30pm

hi @topnoch, , is the top table payments from 3.2?

topnoch · January 24, 2019, 4:44am

Hi Stephen,
Yes, 5.0

topnoch · February 8, 2019, 11:12pm

hiya, just checking in to see if there was any further insight. many thanks.

stephenwaite · February 10, 2019, 12:09am

hi @topnoch, could you edit your above photos and provide the name of the sql table and the openemr version please

topnoch · February 17, 2019, 4:15am

hi @stephenwaite

ar_activity and billings table.

openemr 5.0.1

thanks for your time.