| Description |
select * from tblAPBill where strBillId = 'BL-2420'
select * from tblAPaptrxmst where aptrx_ivc_no = '63018395'
select * from apeglmst where apegl_ivc_no = '63018395'
Invoices are imported from origin, when it is opened to post, the customer sees no detail so the bill screen recalculates to $0.
There are many records that no longer has detail.
Ex: BL-2420
1. Open BL-2420. Notice there is no detail lines.
2. If you run the query above, you will notice that apeglmst and tblAPaptrxmst has the proper detail in order for the transaction to import correctly into i21.
Requirements:
1. Data fix.
2. Figure out if the issue still exists and fix the program.
|