August 22 31 2021 conversion using file provided by Tim
Trux | Navusoft | ||
|---|---|---|---|
Customers | 323 7 Trux customers had no records on CM04 table Validate that 7 customers don't have any sites in trucks | 316 Trucks accounts with no sites not imported | |
Sites | 345334713453 | 3471 | |
AR | pending final billing in Trux | pending final billing in Trux | |
Services | client validation pending | 35273552 | |
Charge codes | client validation pending6429 rate <> 0 | ||
Total recurring revenue | client validation pending | 501500,603836.1254 | |
Routing | client validation pending | Routing converted |
| Tip |
|---|
Customers |
7 customers have not sites on data file provided
...
select count(*) from [JLT_Aug_2131_2021_CM03-Cust]
select count(*) from account where external_id_alpha is not null
...
| Tip |
|---|
Sites |
All Sites imported
AR will be converted after final billing in Trux
...