Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-204918 - import AP didn't work|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-204918]
Version: 17.3.1130.165
Database: 01
1. Purchasing > Open Payables detail Report > Run as of 10/23/2017 for specific vendor noted below.
2. Purchasing > Open Payables Report > Run as of 10/23/2017 for specific vendor noted below.
3. Bring up voucher BL-75015 in voucher grid, the total for the bill is $21.43
When you compare the voucher against the payables reports, notice the report is showing $42.86 for the voucher.
The detail is doubled in the voucher, but total is only $21.43
I will delete the duplicate detail in 01 so the customer can import vouchers.
begin tran
delete tblAPBillDetail
where intBillDetailId = 239263
commit tran
After fixing the data so AP would balance to GL...I imported voucher from origin.
1. Imported for 11/1/2017 - 11/30/2017.
2. Failed
3. The Import GL from Subledger screen came up.
4. I imported GL for 2017 Period 11 only
5. I imported voucher again 11/1/2017 - 11/30/2017
6. Failed out of balance by 3.21.
7. There was a previous BL already posted (BL-77938), when you open this, the line is now doubled. This BL has the same invoice as the one just imported. I think when you are importing a voucher for the same vendor with the same invoice number, that already exists in voucher grid, it is inserting a new record in voucher plus inserting the detail in the existing one.
Theory:
1. Create an invoice for a vendor that is currently in aptrxmst and apeglmst for the same invoice number. Post.
2. Import Voucher from Origin.
3. Verify the new voucher and the existing one.
I suspect the existing one have the new detail from the voucher just imported.
!pastedImage_d87395_0.png!
!pastedImage_d87395_1.png!
|