(Master File Name)'s are (explain what these are and what their purpose is). They are used in the (identify each functional area these are used in) Functional Area(s) (to support other master files, to support transactions, to support other master files and transactions.).
The Vendor ACH Page is used to configure Vendor Addresses to accept ACH Payments. ACH Payments can only be processed for Vendor Address ID's that have been setup for ACH. The purpose of this page is to add, edit, remove, and activate/inactive these recordsand remove address ID's for ACH.Insert excerpt Def - ACH Payment Def - ACH Payment nopanel true
Software Version: 20192024.MM09.DD 27 and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
| Toolbar Icons | Description | Cancel||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide | Cancel - List View Edit
| Cancel - List View Edit |
| ||||||||||||||
| Delete |
| Edit |
| ||||||||||||||
| Excel |
| ||||||||||||||||
| Favorites |
| ||||||||||||||||
| Grid LayoutGroup By Show/Hide |
| ||||||||||||||||
| Help |
| ||||||||||||||||
| New |
| ||||||||||||||||
| Process Prenote | Generates a .txt file with the bank account information for any selected Vendor(s). The 'SEC Code' must be set to a Prenote type in order to process a prenote for an account. A 'Default Vendor Checkbook ID' must be specified on the Preferences page in order to process a prenote, else the message "A default checkbook must be set in order to create a Prenote. Please navigate to Purchasing → Preferences → Settlement Defaults." will be displayed. Clicking the button will also populate the 'Prenote Sent’ field with the current date and time for the selected eligible Vendor(s). Users will need to manually switch the Vendor(s) out of "Checking - Prenote" or "Savings - Prenote" after the Prenote file has been successfully processed by the bank.
For additional information on how prenotifications work, please click here. | ||||||||||||||||
| Quick Filter |
| ||||||||||||||||
| Save |
| ||||||||||||||||
| Saved Column Layouts |
| ||||||||||||||||
| Fields | Description | ||||||||||||||||
| Checkbox | Used to select one or more records. | ||||||||||||||||
| Account # | The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####. A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####. | Address ID | A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required A text box to store the bank account number that the ACH payments will be deposited into. This defaults to blank, is required, and must be <= 100 characters. If missing, the message "[VendorID]: SEC Code, Bank, Name on Account, and Account # are required." will be displayed on Save. Note: the message is intended to show the complete list of all required, not just the missing ones. This field is always editable.
Database Field: ERPx_APVendorACH.AccountNumber | ||||||||||||||
| Address ID | A single-select load on demand lookup to assign the Address ID that is being configured for ACH. This defaults to blank and is required. If not assigned, the message " (what message is displayed)You have Records that do not have an Address ID value selected." will be displayed on save. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####only enabled when adding a new record, it is not editable for existing records. If you need to change the Address ID, you must delete the record and re-enter it correctly. If users try to add an ACH record for the same Address ID for a Vendor, the following message will be displayed on Save “[Vendor Name] ([Address ID]): An ACH record has already been setup for this Address. You may update the existing record but adding the same address is not allowed.” The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. LinkedThis lookup contains a blank value, the current assigned value, an option for ALL (only if the Vendor has more than one Address), and a list of all the 'Active' (what does it include). | Bank | ' Address ID's that belong to current Vendor. Database Field: ERPx_ #####.#####.A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####. | Default Payee | The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####. A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.APVendorACH.VendorAddressSK | ||||||||||||
| Bank | A text box to identify the name of the financial institution where the account is held. This is required and must be <= 100 characters. If missing the message "[VendorID]: SEC Code, Bank, Name on Account, and Account # are required." will be displayed on Save. This field is always editable. Database Field: ERPx_APVendorACH.BankID | ||||||||||||||||
| Default Payee | A Yes/No lookup to identify whether or not the Address ID is the default address for Payments. This is a looked up value that is not editable from this page. Users can set the Default payment address on the Vendor master file, on the 'Payment' property of the Default Address group. A value of "Yes" means that the Address ID is configured as the 'Payment Default' on the Vendor master file. A blank value means that the Address ID is not configured as the 'Payment Default' Database Field: ERPx_APVendorACH.IsRemitToAddress where IsRemitToAddress = 1 | ||||||||||||||||
| Default Payment Type | A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####.This lookup contains all the values in the (EnumerationClassName) Enumeration Class. | ||||||||||||||||
| Name on Account | The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####. A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####. | ||||||||||||||||
| Routing # | The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####. A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####. | ||||||||||||||||
| SEC Code | A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####. This lookup contains all the values in the (EnumerationClassName) Enumeration Class. | ||||||||||||||||
| Vendor | A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.##### This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include). | ||||||||||||||||
| Vendor Class | The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####. A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####. | ||||||||||||||||
| (Field Name) ID | A text box to add/edit the unique identifier of the (what type of record is this) record. This defaults to blank but is required for all records. If missing, the message "fieldnameID is required." will be displayed on Save. The ID must be unique, otherwise the message "Duplicate Field Name ID's are not allowed." will be displayed on Save. This field must be <= 25 characters. Linked Database Field: ERPx_####.FieldName | ||||||||||||||||
| (Field Name) Description | A text box to add/edit the name associated with the (ID Field Name) ID. This defaults to blank but is required ***OR**** and is not required. If missing, the message "fieldname is required." will be displayed on Save. This must be unique, otherwise the message "Duplicate Field Name's are not allowed." will be displayed on Save. This field must be <= 25 characters. Linked Database Field: ERPx_#####.#####. | ||||||||||||||||
| Inactive | A Yes/No field used to identify if the record is Inactive. If set to 'Yes' then the record is "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then the record is "Active" and can be freely used ('No' values display as blank in the grid). This value is always editable. Linked Database Field: ERPx_#####.#####. | ||||||||||||||||
| Checkbox | Used to select one or more records. | ||||||||||||||||
| Date Field | The date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####. | ||||||||||||||||
| Hyperlink | A hyperlink show the (Field Name) of the transaction. Clicking on the link opens the record view of the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####. | ||||||||||||||||
| Lookup (from an Enumeration) | A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####. This lookup contains all the values in the (EnumerationClassName) Enumeration Class. | ||||||||||||||||
| Lookup (non Enumeration) | A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.##### standard lookup to assign the preferred method of payment for each Address ID. This allows an Address ID to receive Checks, Draft or Wire payments but still have an option to process as ACH when needed. This defaults to Check which is required to process a Prenote for the account and can then be updated to ACH after Save if needed. This is required and is always editable. If the SEC Code is set to a Prenote type (either Checking - Prenote or Savings - Prenote) and the Default Payment Type is set to ACH, on Save the following message will be displayed "[VendorName] (VendorID): Default Payment Type cannot be set to ACH when the SEC Code is a Prenote type.". After processing a Prenote, the SEC Code should be updated to a non-Prenote type and then the Default Payment Type can be saved to ACH if needed. This lookup contains the values: 'ACH', 'Check' 'Draft' and 'Wire'. Database Field: ERPx_APVendorAddress.DefaultPaymentTypeSK | ||||||||||||||||
| Name on Account | A text box to store the name of the bank account that the ACH payments will be deposited into. This defaults to blank, is required, and must be <= 250 characters. If missing, the message "[VendorID]: SEC Code, Bank, Name on Account, and Account # are required." will be displayed on Save. Note: the message is intended to show the complete list of all required, not just the missing ones. This field is always editable. Database Field: ERPx_APVendorACH.AccountName | ||||||||||||||||
| Prenote Sent | Identifies the date and time the prenote verification file is generated. If the 'SEC Code' is set to "Checking - Prenote" or "Savings - Prenote" and this field is not populated, then the user knows they have not attempted a prenote verification. This is a non-editable text box that is not required. It defaults a blank. It is a system assigned value for information only and is never editable. Database Field: ERPx_APVendorACH.PrenoteSentDate | ||||||||||||||||
| Routing # | A text box to store the routing number for the bank that the ACH payments will be deposited into. This defaults to blank and is not required. If entered it must be <= 25 characters and should be a valid routing number to process ACH payments. This field is always editable. Database Field: ERPx_APVendorACH.RoutingNumber | ||||||||||||||||
| SEC Code | A single-select standard lookup to assign what type of ACH transaction the account is configured for. This defaults to blank but is required. The only options that are available on a New record initially are 'Checking - Prenote' and 'Savings- Prenote'. If not assigned, the message "[VendorID]: SEC Code, Bank, Name on Account, and Account # are required." will be displayed on Save. will be displayed. Note: the message is intended to show the complete list of all required, not just the missing ones. If this field is set to "Savings - Prenote" or "Checking - Prenote", then the 'Default Payment Type' cannot be set to "ACH". Else the message "Default Payment Type cannot be set to ACH when the SEC Code is a Prenote type." will be displayed on Save. This field is always editable. This lookup contains all the values in the ACHAccountType Enumeration Class. On new rows, the "Checking" and "Savings" options will not be available until the record has been saved. Database Field: ERPx_APVendorACH.ACHAccountTypeEN | ||||||||||||||||
| Vendor | A single-select load on demand lookup to assign the Fisherman / Loan account that is being configured for ACH. This defaults to blank and is required. If not assigned and other fields have data entered/selected, the message "Vendor is required" will be displayed on Save, else the record will be cancelled on Save. This field is only enabled when adding a new record, it is not editable for existing records. If you need to change the Vendor, you must delete the record and re-enter it correctly. The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. LinkedThis lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include). | Text Field | APVendors with a VendorTypeEN <>1 Database Field: ERPx_ #####.#####.A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). LinkedAPVendorACH.VendorSk | ||||||||||||||
| Vendor Class | A label to identify the the Vendor Class property of the Vendor that is assigned. This is a looked up value that is not editable from this page. Database Field: ERPx_ #####.#####. | Yes/No Lookup | A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime. A value of "Yes" means that... A value of "No" means that...APVendor.VendorClassSK |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
| Expand | ||
|---|---|---|
| ||
Technical Details |