Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-209386 - import did not work last night|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-209386]
Version: 17.3.0129.267
Database: 99
Steps to Recreate:
1. The data has already been imported from aptrxmst and apeglmst into tblAPaptrxmst and tblAPapeglmst.
2. You may need to copy the data from the backup tables and re-insert into aptrxmst and apeglmst to retest the import of voucher.
The following query shows the records missing from the import into voucher.
select * from tblAPaptrxmst where dtmDateImported = '2018-02-14 14:52:39.903'
and intBillId is Null
select * from tblAPapeglmst where apegl_ivc_no in ('203702022018', '203702042018')
Issue: Import Voucher Error- Not all records imported
Acceptance: Vouchers that are not imported belongs to non-existing vendor in i21. This vendor should be created automatically before importing vouchers.
|