August 22 31 2021 conversion using file provided by Tim
Trux | Navusoft | |||||||
|---|---|---|---|---|---|---|---|---|
Customers | 320323 7 Trux customers had no records on CM04 table Validate that 7 customers don't have any sites in trucks | 313316 Trucks accounts with no sites not imported | ||||||
Sites | 345334713453 | 3471 | ||||||
AR | 2,477,421.94 | 2,477,421.94 | Services | Charge codes | Total recurring revenue | Routing | 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 |
| 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
...
| Tip |
|---|
AR |
...
AR will be converted after final billing in Trux
| Info |
|---|
Services |
| Tip |
|---|
Service Notes |
Notes from Trux CM05.CM05_NOT1 have been imported as service notes. JLT users will move to access notes as appropriate
...
| Info |
|---|
Charge codes |
| Info |
|---|
Recurring revenue |