August 22 2021 conversion using file provided by Tim
Trux | Navusoft | |
|---|---|---|
Customers | 320 7 Trux customers had no records on CM04 table Validate that 7 customers don't have any sites in trucks | 313 Trucks accounts with no sites not imported |
Sites | 3453 | 3453 |
AR | 2,477,421.94 | 2,477,421.94 |
Services | client validation pending | 3527 |
Charge codes | client validation pending | 6429 rate <> 0 |
Total recurring revenue | client validation pending | 501,603.12 |
Routing | client validation pending | Routing converted |
Customers
7 customers have not sites on data file provided
select count(*) from [JLT_Aug_21_2021_CM03-Cust]
select count(*) from account where external_id_alpha is not null
Sites
All Sites imported
AR
Services
Charge codes
Recurring revenue