Description |
You can use the customer 01 database up until 10/27/2018 for a copy of data. The customer is going live and will be converted on 10/28/2018.
*STEPS:*
1. When converting ssvnd_pay_ctl_ind = 'D' (discount always), we also need to update the vendor as active.
* Ran query to fix converted data.
**
begin tran
update tblAPVendor
set ysnPymtCtrlActive = 1
where ysnPymtCtrlAlwaysDiscount = 1
commit tran
!pastedImage_d107091_0.png!
2. When converting ssvnd_pay_ctl_ind = 'H' (Vendor on Hold), we also need to update the vendor as active.
* Expected results (sample only) - Lanman do not have vendors set to H.
!pastedImage_d107091_1.png!
*ISSUE(S):*
Incorrect conversion of payment control file vendor import
*ACCEPTANCE:*
Conversion of payment control file vendor import should be correct
|