Description |
Background:
* During "Receipt Verify" process in origin, it validates the invoice for duplicates in apivcmst and aptrxmst
* Since we no longer update apivcmst if the customer is using i21 Purchasing, the receipt verify program will never have a duplicate from apivcmst (no data stored)
* Which means customers will continue to use the same invoice number for the same vendor and increasing duplicates in i21 Purchasing
Requirements:
* Update apivcmst with transactions that are in tblAPBill (posted and unposted)
** apivc_vnd_no
** apivc_ivc_no
** apivc_ivc_rev_dt
** apivc_orig_amt
** apivc_gl_rev_dt
** apivc_comment ---- add comment "Imported Origin Bill - i21 Record"
* If we delete a record in tblAPBill
** Delete the record from apivcmst
|