search

bcgov / entity

ServiceBC Registry Team working on Legal Entities
Apache License 2.0
23 stars 57 forks source link

CSO BC Registry Unprocessed transactions #18559

Open Jxio opened 7 months ago

Jxio commented 7 months ago

check reconciliation process for following invoices: '1966568', '1976185', '1994388', '2002349', '2531215', '2531240', '3012456', '3012516', '3012517', '3012524', '3012526', '3012527', '3012528', '3012529', '3012531', '3013002', '3013279', '3024255', '3064925', '3064927', '3064936', '3064939', '3078323', '3099296', '3147099', '3147204', '3169153', '3169503', '3169506', '3234815', '3234956', '3235073', '3235156', '3269106', '3278782', '3280270', '3303161', '3311583', '3319753', '3321395', '3324376', '3325357', '3329692', '3331718', '3332617', '3361552', '3361783', '3371456', '3392922', '3396060', '3404675', '3404677', '3407612', '3407865', '3413812', '3416491', '3420535', '3430236', '3430434', '3473252', '3477328', '3479678', '3485132', '3499704', '3526340', '3527690', '3528345', '3528498', '3545883', '3550134', '3550484', '3553279', '3555129', '3568297', '3571658', '3578372', '3629789', '3630761', '3630807', '3630942', '3648790', '3649489', '3659767', '3684389', '3684468', '3684499', '3684514', '3684930', '3684948', '3685680', '3698681', '3698726', '3698753', '3698905', '3698972', '3699011', '3699029', '3699079', '3699098', '3699155', '3699918', '3700023', '3700054', '3709284', '3709298', '3762519', '3768681', '3769071', '3793629', '3826171', '3826184', '3826239', '3828130', '3828136', '3828230', '3828371', '3828612', '3828814', '3828817', '3829784', '3830282', '3830705', '3830800', '3830905', '3830908', '3831097', '3831477', '3831680', '3831681', '3831687', '3831692', '3831914', '3831921', '3832381', '3832437', '3832465', '3832470', '3833373', '3833472', '3833994', '3834045', '3834124', '3834129', '3834135', '3834193', '3834200', '3834316', '3834342', '3834450', '3834474', '3834788', '3834962', '3835040', '3835055', '3837236'

Jxio commented 7 months ago

all of them suppose to be in refund state, but still in "approved" they are EJV/PAD invoices, and not created on CAS yet

Jxio commented 7 months ago
  1. invoice id 3012526, 3012527, 3012528, 3012529, 3012531, 3013002, 3013279, 3012516, 3012517, 3012524 with Active cas account, stuck at approved state. -> invoice reference number: REG03012505, REG03013002 Other PAD invoices have frozen cas accounts
  2. select * from cas_settlements cs where file_name in ('BCR_PAYMENT_APPL_20230605.csv'); id received_on file_name processed_on
    402 2023-11-07 18:44:58.064 BCR_PAYMENT_APPL_20230605.csv 2023-11-07 18:45:36.177

just double check, they are on "PAID" state at pay-db. I got different results from data warehouse before.

I did refund request for invoices: '3012516', '3012517', '3012524', '3012526', '3012527', '3012528', '3012529', '3012531', '3013002', '3013279' api message back: Private Zenhub Image

seeker25 commented 4 months ago

@Jxio any update on this one?

Jxio commented 4 months ago

After we blocked the NSF payment requests, I haven't heard any stuck APPROVED invoices from CSO for other EJV invoices, I checked the status, they are not stuck I think we can close this ticket. btw I can't find this ticket on our zenhub board, not sure why we missing it.