Sage 100

Sage 100 Std, v2015 PU 2 - Client ran AP ACH last week for 18 vendors. All 18 updated as paid via ACH in check history, but the ACH file only generated for 13. The last five on the ACH check register did not make it. Any thoughts on where to look for the culprit?

Are the pre-notes approved for the 3 missing vendors?

Yep, long time ACH vendor. Looking in the check history header table, the checks are marked as ACH payments. When I regenerate the ACH file, they are missing again. Where is this ACH data stored so I can make the necessary tweaks to regenerate the file????

There is the AP_ACHGenerationDetail and AP_ACHGenerationHeader and AP_ACHGenerationAddenda. You may try comparing a successful record in these tables to an unsuccessful one.

Thanks