| Description |
Please use Fort Books database
Salesperson id used in tblARInvoice prior to upgrade, this may not have been all salesperson setup in tblARSalesperson
select distinct(intEntitySalespersonId) from tblARInvoice
where dtmShipDate < '2015-05-29 00:00:00.000'
intEntitySalespersonId
0
46
9
32
50
30
19
25
56
34
14
salesperson id after upgrade used in tblARInvoice
select distinct(intEntitySalespersonId) from tblARInvoice
where dtmShipDate > '2015-05-28 00:00:00.000'
intEntitySalespersonId strSalespersonId
1231 VK
1233 TJS
1234 SUP
1236 SP
1237 SKT
1238 SK
1239 SG
1242 RKM
1243 RG
1244 RCS
1245 RBB
1246 NPC
1248 MJN
1249 MJM
1254 MAM
1255 LWC
1256 LGW
1258 KR
1259 KJR
1260 KH
1261 KER
1262 JPS
1263 JMR
1264 JMB
1265 JHK
1266 JER
1267 JEH
1268 JEF
1269 JEB
1271 JAC
1272 GKM
1276 DLP
1279 DJ
1280 CO
1284 CFH
1286 BJK
1287 BAR
1288 ASD
1289 AMT
1290 AK
It looks like when we moved to to salesperson entity, we did not update the tblARInvoice to match the new intEntitySalespersonId.
Requirements:
* I need data fix for Fort Books salesperson id in tblARInvoice and other tables that may have been updated with the old intEntitySalesPersonId.
* Insert this data fix in a patch for all other dbs that require the change as well.
|