How to set up Document Transmittal for Print EFT Remittance

2 minute read time.

Lets look at the steps required to setup document transmittal for Print EFT Remittance.  You must have applied the Sage 500 July 2017 Product Update or newer. Below are the steps broken down into sections  The first three sections are setup and the last three are process.

Setup Document Transmittal Email Server

  1. Common Information, Maintenance, CI Setup, Set Up CI Options

  2. Setup CI options , select transport, select or enter the email server

  3. Save record

  4. Common Information, Maintenance, CI Setup, Set Up Document Transmittal
  5. Select transaction = EFT Remittance (Note, if EFT Remittance is not seen on the dropdown list, confirm July 2017 PU has been installed)
  6. Enter CC, BCC, Subject, Body Text as desired
  7. Provide the appropriate Mailbox information for Exchange or SMTP depending on what is being used
  8. Save record

Setup Bank Accounts

  1. Common Information, Maintenance, CI Setup, Set Up Bank Accounts
  2. Setup the bank account associated to EFT and select that account from Bank Account(checking Corp for example).  Fill out contents on the Main, Offset and EFT tabs, click EFT tab and fill out all of the left side for the Type US

   

Setup AP Vendors

  1. Accounts Payable, Maintenance, Maintain Vendors
  2. Pull up vendor. On Main tab, under primary contact, enter valid email address

  3. Click on the Doc Transmittal button

  4. From the Document Transmittal Configuration screen, select Transaction = EFT Remittance
  5. Place a checkmark next to E-mail. (You can have both Hard Copy and E-mail checked but for doc transmittal, E-mail must be checked)
  6. Select Format that will be used for the remittance.
  7. If you are planning to include Other Contacts, click that checkbox as well. (That will bring up the Maintain Contacts screen)
    1. Place a checkmark next to EFT Remittance for each of the other contacts entered and supply email address and Name as well

  1. Accounts Payable, Maintenance, Maintain Vendors, Main tab
  2. Create other address by clicking the Other Addresses button
  3. Create an address id, for example Address = EFTAddress Name = EFT.  Fill out street address
  4. Click the Defaults tab
  5. Fill out the Bank Name, Account Name, Account No, Routing No. 
  6. Back on the Maintain Vendors form, click Defaults tab, select Payment Method = EFT and click Remit To lookup Select EFT address created from step 3 above
  7. Save information

Create vouchers and Pay

  1. Accounts Payable, Activities, Process Vouchers, create new batch
  2. Select same vendor as setup previously
  3. Add item(s) and save voucher by clicking the green checkmark
  4. Register post voucher batch

Process Invoices for Payment

  1. Accounts Payable, Activities, Process Invoices
  2. Create a new batch and select Payment Method =EFT
  3. Click Select for Payment button
  4. Select vendor from above and click green proceed button
  5. Register Post and make note of the batch (in this example APSC-0000041)

Print / email EFT Remittance

This is the step that will produce the EFT remittance email.

  1. Accounts Payable,Activities, Print EFT Remittance
  2. Select same bank account that has been previously set up for EFT
  3. Check Post date and enter date desired
  4. Double click the specific batch so it has a small print icon next to it
  5. Click the envelope icon at top of form

If you already have Document Transmittal working from another area in the application, you can skip the first section. For more details about Print EFT Remittance, click on the Help icon at the top of the Print EFT Remittance form.