Sage 100: How to set up ACH Electronic Payments in Accounts Payable

Sage 100: How to set up ACH Electronic Payments in Accounts Payable

Sage 100: How to set up Vendor ACH direct store

Disclaimer

Sage Customer Support doesn't give help to issues connected with outsider items or improvements, equipment, report customizations, state or government charge related questions, or explicit bookkeeping questions.

Goal

• Open Accounts Payable, Setup, Accounts Payable Options
• Click ACH Tab and select the Enable ACH Electronic Payments and Print Vendor Remittance Advice checkboxes.
• In the ACH Electronic Payments Folder field, enter the full way to the envelope where you need to save the electronic installment documents or snap the Browse Directory button to peruse to the envelope.
• Assuming that this field is clear, the electronic installment documents will be saved in the Accounts Payable organization envelope, for instance, ..\MAS_xxx\APxxx (xxx=company code)

Read More-:  Sage 50 User Logging and History

To post the ACH Payments on the Checks tab in Bank Rec, really look at Post to Bank Reconciliation exhaustively. In the event that this isn't checked, the ACH installments will post in synopsis on the Dep/Adjust (Only accessible in rendition 2013 and later).

• Click Accept
• Open Accounts Payable, Setup, ACH Interface Maintenance
• Select Bank Code from the query
• Select the Pre-note Approved really look at box.

Complete the accompanying fields:

• Prompt Destination: (this is the bank's or the Standard Federal Bank's travel steering). Assuming the client enters an invalid number, the message You have entered an invalid steering/travel number. On the off chance that you enter a number other than a directing/travel number (for instance, a Federal ID) this message will continuously show up. Would you like to acknowledge this number? will show up.

• Prompt Origin fields: (this field is the steering/travel number or the Federal Tax ID of the ACH administrator or sending point of the record).
• Beginning DFI (ODFI): (This field is the Originating Depository Financial Institution (ODFI) Routing/Transit number for the bank giving the ACH record for its client. When the Immediate Origin number is placed, the initial 8 digits of the Immediate Origin number will default, yet can be changed).

• Click on the Records tab and enter the accompanying
• Administration Class Code: 200 (The Service Class Code recognizes the arrangement of dollar sections to be traded. Default setting is set to 200)
• Standard Class Entry: PPD (The Standard Entry Class Code distinguishes the exchanges being sent. Default is PPD)

Read Also-: What is a Prenote in sage

On the Additional tab, select the… Include Debit Record checkbox assuming that your bank requires including charge record. In an ordinary execution, you might not need to really take a look at this field. Be that as it may, there are known examples where a Financial Institution might require including the charge record.

• Exchange Code: 00 (This choice will be empowered if Include Debit Record is checked (Yes).
• Getting DFI Identification: 000000000 (check with your Financial Institution for the Receiving DFI ID)
• DFI Account Number: 0000000000000000000000 (check with your Financial Institution for the DFI Account Number)
• Individual ID Number: 00000000000000000000 (check with your Financial Institution for the Individual ID Number)
• Select Yes from the Set Put CR/LF after Each Record dropdown and choose the Include Addenda Record checkbox (in the event that your Financial Institution require it)
• Click Accept
• Open Account Payable, Main, Vendor Maintenance
• Click Vendor Number turn upward and select a pertinent merchant
• On the Main tab, select the Electronic Payment checkbox
• Click the More drop-down bolt and select Electronic Payment
• In the Vendor Electronic Payment, enter or choose the accompanying and click Accept:
• Ledger No: 000000000
• Steering Transit No: 000000000
• Ledger Type: Checking or Savings
• Dissemination Method: Percent of Net Amount, Percent of Gross and Fixed Amount.
• Percent Amount: XX%
• Pre-Note Sent: Approved

If you have any desire to produce a Prenote document for your monetary foundation pass on this set to NO. You can then run the Prenote Selection Register and update it and create a 'PRENOTE' ACH document for your bank. When the bank is happy with the ACH document, then you will run the Prenote Approval Register to refresh the Vendor record to Approved.

• Click Accept
• Open Accounts Payable, Check Printing and Electronic Payment, Invoice Payment Selection
• Click on the Select button
• Feature the principal Invoice for an ACH merchant and snap OK button
• Check the Include Electronic Payment Vendors is set to Yes and snap the Printer symbol
• Click Preview and afterward close the Invoice Payment Selection Register
• Click Yes to Do you need to print checks or potentially settlement counsel?
• In the Select Payment type window, confirm the Both spiral button is chosen and snap OK
• Print the Electronic Payment Remittance Advice
• Click Ok to eliminate hits message and snap Yes to Do you need to print the Check and Electronic Payment Registers?"
• Click the Preview button and close the Check Register
• Click Yes to Do you need to print the Electronic Payment Register?
• Click the Preview button and close the Electronic Payment Register
• Click Yes to Do you need to refresh the Check and Electronic Payment Registers? furthermore, Yes to the brief to refresh the Daily Transaction Register to the General Ledger
• Open Accounts Payable, Check Printing and Electronic Payment, Generate ACH File
• Click Proceed button
• Go to the ACH Electronic Payment Folder made on stage 3 to see ACH record.

NOTE: The ACH interface record isn't naturally transferred to your bank, you should physically transfer the ACH document that Sage 100 made to your bank.

See More-: Sage 50 on Virtual Desktop Infrastructure

Article source: https://article-realm.com/article/Finance/26125-Sage-100-How-to-set-up-ACH-Electronic-Payments-in-Accounts-Payable.html