Description |
If this is quick fix, let's go ahead and add in 15.2.
If we fix in 15.3, I will have to make sure to run the scripts below before they import origin bills until they move to 15.3 (every day). If we don't get them the fix asap, they are waiting for me everytime they import. And if they get excited and import in before I run the script below, these two things happen.
1. DM come in without detail, then I have to go in and fix it.
2. The detail sits in apeglmst and does not move to tblAPapeglmst
I run this query to check how many records are different transaction types:
select aptrx_vnd_no, aptrx_ivc_no, aptrx_ivc_rev_dt, aptrx_orig_amt from aptrxmst
inner join apeglmst on aptrxmst.aptrx_ivc_no = apeglmst.apegl_ivc_no
where aptrx_trans_type <> apegl_trx_ind
Then I run this query to update:
--UPDATE billDetail
-- SET billDetail.apegl_trx_ind = header.aptrx_trans_type
-- FROM apeglmst billDetail
-- INNER JOIN aptrxmst header
-- ON billDetail.apegl_ivc_no = header.aptrx_ivc_no
-- AND billDetail.apegl_vnd_no = header.aptrx_vnd_no
-- WHERE apegl_vnd_no = aptrx_vnd_no
-- AND apegl_ivc_no = aptrx_ivc_no
-- AND (apegl_trx_ind != aptrx_trans_type OR apegl_cbk_no != aptrx_cbk_no)
|