JLT Final conversion results and notes

August 31 2021 conversion using file provided by Tim

	Trux	Navusoft

	Trux	Navusoft
Customers	323 7 Trux customers had no records on CM04 table	316 Trucks accounts with no sites not imported
Sites	3471	3471
AR	pending final billing in Trux	pending final billing in Trux
Services	client validation pending	3552
Charge codes	client validation pending
Total recurring revenue	client validation pending	500,836.54
Routing	client validation pending

Customers

7 customers have not sites on data file provided

select count(*) from [JLT_Aug_31_2021_CM03-Cust]

select count(*) from account where external_id_alpha is not null

Sites

All Sites imported

AR will be converted after final billing in Trux

Notes from Trux CM05.CM05_NOT1 have been imported as service notes. JLT users will move to access notes as appropriate

New Implementations