| Description |
select * from tblAPBill where strBillId = 'BL-9652'
This is one example of the issue. There are 14 bills that have the same issue. You will need to use the customer database to verify.
This is a list of vendors, dates & amounts:
Mundy 03/31/2004 $2,500.00 Bill Number BL-9652
Hodges Machine Shop 03/24/2008 $175.00 BL-14964
MB JONES OIL CO 08/18/2014 -$307.20 DM-81, 8/19/2014 $307.20 BL-9760, 8/19/2014 $153.60 BL-10442, 8/18/2014 -$153.60 DM-87, 8/18/2014 -$307.20 DM-88,8/15/14 $307.20 BL-12816
Larry Hohmann 2/20/2004 $1,015.13 BL-14290, 2/6/2004 $23.05 BL-15670
Georgia Natural Gas Services 03/23/2004 $85.70 BL-12274
White Commercial 01/26/2004 $900.00 BL-276
Harris Pest Control 6/25/2013 -$200.00 DM-98 and 12/19/13 $200.00 BL-12551
This is all 14. Thank you.
*SOLUTION:*
Origin could have a data issue and no payment would appear in apchkmst - if a bill is tagged as paid in apivcmst - so.... if there is a "P" paid flag in apivcmst then you should
* create a payment even though there is not one in apchkmst
* use the apivc_chlk_no as the the check no
* use apivc_chk_rev_dt as the check date - [~liz.dorado] please add query you used at agro star.
|