Training5 - collected sales duplicate records and portion of it applied to an invoice when reviewing in MXC Collected sales page.

Training5 - collected sales duplicate records and portion of it applied to an invoice when reviewing in MXC Collected sales page.

https://informtraining5.cfahome.com
inform.training200/call58911

MMS page shows everything as expected:

MXC page shows duplicate records and $75 invoice (switch using MMS_Stores_ExternalSite.aspx?url=/Financial/CollectedSales&hideStoreSelector=true)

I was able to delete all the records for store 00215 (entityid 4144)that were populated using 'CFAMX-8864 Training5 - Customer Sales' and then re-running CFAMX-8864 again. It removed the duplicate, so the script just will need to be modified to run for all 600 stores. However, one of the Evangel Christian Center invoices somehow got applied and brought Collected sale amount from 290 down to 215

Here is a script that I used for 00215 account:

begin tran
delete from tbTransactionControlInfo where TransactionControlInfoID in (
select TransactionControlInfoId from tbTransactionControlInfo where entityid = 4144 and
transactiondate between '1/15/2020' and '1/16/2020' and
clerkname like '%Cristobal%' and
controlinfoamount = 290 and
controlinfoid = 150)
--rollback
--commit