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

Parents
  • 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.

Reply
  • 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.

Children