A/P - Vendor ACH - Import Banking Info?

SUGGESTED

I can't seem to find this information anywhere. Sorry if this has been asked before. Is it possible to upload vendor's banking information into Sage 100 so that I don't have to enter them all manually for ACH setup?

Thanks,

SP

  • 0
    SUGGESTED

    If you own the Visual Integrator module, you can import Vendor banking information into AP_VendorElectronicPayment file.

    If you do not own the Visual Integrator module, you can setup each vendor by doing the following:

    1. Open Account Payable, Main, Vendor Maintenance
    2. Click the Vendor Number lookup and select applicable vendor
    3. On Main tab, select the Electronic Payment checkbox
    4. Click the More dropdownarrow and select Electronic Payment
    5. In the Vendor Electronic Payment, enter or select the following and click Accept:
      • Bank Account No: 000000000
      • Routing Transit No: 000000000
      • Bank Account Type: Checking or Savings
      • Distribution Method: Percent of Net Amount, Percent of Gross and Fixed Amount.
      • Percent Amount: XX%
      • Pre-Note Sent: Approved -
        • If you want to generate a Prenote file for your financial institute leave this set to NO. You can then run the Prenote Selection Register and update it and generate a ‘PRENOTE’ ACH file for your bank. Once the bank is satisfied with the ACH file, then you will run the Prenote Approval Register to update the Vendor record to Approved.
    6. Click Accept

     

    For more details on setting up A/P ACH, please log into Sage Knowledgebase https://support.na.sage.com and search for KB ID 20983.

  • 0 in reply to Gina Thompson
    Thanks so much for your quick response, Gina! We do have the visual integrator, but I am wondering where I find that import file as an option to add to VI-Job Select. Can you help with that?

    Thanks in advance!

    -SP