Loan Record View 3.0
The Loan Record View shows all the details for a single Fishermen or Tender Loan Account. From here, users can add, edit, remove, and activate/inactive these records.
Software Version: 2025.04.21 and newer
Page Header
Toolbar Icons | Description |
|---|---|
Delete | |
Help | |
Grid Layout | |
New | |
Notes | |
Save | |
Fields | Description |
Fisherman Name | A textbox to identify the name assigned to the record. This defaults from the Loan Name assigned to the Loan account, is required and non-editable from here. Database Field: ERPx_APVendor.VendorName |
Properties Tab
Toolbar Icons | Description |
|---|---|
Column Filter Show/Hide | |
Excel | |
Group By Show/Hide | |
Quick Column Filter | |
Saved Layouts | |
Fields | Description |
Properties | |
Value | |
Group: ID and Descriptions | |
Loan ID |
Database Field: ERPx_APVendor.VendorID |
Loan Name |
Database Field: ERPx_APVendor.VendorName |
Payment Name |
Database Field: ERPx_APVendor.CheckName |
Group: Configuration | |
Loan Class ID | A single-select lookup to identify the Loan Class assigned to the Loan Account. This defaults to blank but is required. If missing, the message "Vendor Processing Failed: ([VendorID]): Loan Class is required." will be displayed on Save. This field is always editable but changing it will not update any of the default Properties or Accounts that are assigned on the new Loan Class. The lookup contains a blank value, the current assigned value, and a list of all the 'Active' records in the Fisherman Class master file. Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APVendor.VendorClassSK |
Loan Attribute Class | A single-select lookup to identify the Attribute Class assigned to the Loan Account. This defaults from the Loan Class and is not required. However, without it, attribute values cannot be assigned or edited for this account. This is always editable. The lookup contains a blank value, the current assigned value, and a list of all the 'Attribute Classes' with an 'Attribute Type' of "Vendors". Database Field: ERPx_APVendor.AttributeClassSK |
Payment Terms | A single select lookup to identify the Payment Terms assigned to the Loan Account. This defaults from the Loan Class, is not required, and is always editable. The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Payment Terms. Database Fields: ERPx_MFPaymentTerms.PaymentTermName, ERPx_APVendor.PaymentTermSK |
Checkbook | A single select lookup to identify the default checkbook used for the Loan Account. This defaults from the Loan Class, is not required, and is always editable. This is informational only. Database Field: ERPx_MFCheckbook.CheckbookID, ERPx_APVendor.CheckbookSK This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Checkbooks |
Currency | A single select lookup to identify the home currency of the company. This defaults from the Currency assigned to the 'Loan Class'. This is required and non-editable. Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_MFDataEntityCompanyCurrency.CurrencySK, ERPx_APVendor.CurrencySK |
Loan Account |
Database Field: ERPx_APVendor.VendorAccount |
Master Account | A single select lookup to identify the 'Master Account' assigned to the Loan account. This defaults to blank, is not required, and is always editable. The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Loan accounts with a Vendor Type of Loan. Loan accounts cannot be master accounts for fishermen or Tenders. The Master Account is a way to associate more than one account together. It is most often used to associate a Loan to a Fisherman Account or to link accounts that share the same CFECID. Database Field: ERPx_APVendor.MasterVendorSK |
Group: Default Address | |
1099 |
This is not editable on new records until they are initially saved. Then, this defaults to 'PRIMARY' but is always editable. The lookup contains the current assigned value and a list of all the 'Active' vendor Address IDs for the current Loan account. Database Field: ERPx_APVendorAddress.Is1099Default |
Statement |
This is not editable on new records until they are initially saved. Then, this defaults to 'PRIMARY' but is always editable. The lookup contains the current assigned value and a list of all the 'Active' vendor Address IDs for the current Loan account. Database Field: ERPx_APVendorAddress.IsStatementDefault |
Payment |
This is not editable on new records until they are initially saved. Then, this defaults to 'PRIMARY' but is always editable. The lookup contains the current assigned value and a list of all the 'Active' vendor Address IDs for the current Loanr account. Database Field: ERPx_APVendorAddress.IsPaymentDefault |
Physical |
This is not editable on new records until they are initially saved. Then, this defaults to 'PRIMARY' but is always editable. The lookup contains the current assigned value and a list of all the 'Active' vendor Address IDs for the current Loan account. Database Field: ERPx_APVendorAddress.IsPhysicalDefault |
Group: Tax | |
1099 Type | A single select lookup to identify the box used for the 1099. Database Field: ERPx_APVendor.1099TypeEN |
Tax ID |
Database Field: ERPx_APVendor.TaxID |
Tax Registration |
Database Field: ERPx_APVendor.TaxRegistration |
Tax Class | A single select lookup to assign the Tax Class to the Loan account. This defaults to blank for new records, is not required and is always editable. Tax Classes are used to calculate sales tax on Fisherman Sale & Tender Resale transactions. This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Tax Class records. Database Fields: ERPx_MFTaxClass.TaxClassSK, ERPx_APVendor.TaxClassSK |
Group: Other | |
Hold |
The lookup contains the values 'Yes' or 'No' and defaults to 'No'. If set to 'Yes' then new transactions can be entered for the account but payments cannot be issued to them. If set to 'No' then the record is not on hold and can be freely used. This field is always editable. Database Field: ERPx_APVendor.IsOnHold |
Inactive |
The lookup contains the values 'Yes' or 'No' and defaults to 'No'. 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. This field is always editable. Only Loan accounts with no open transactions/ balances can be set to Inactive, otherwise the message "Vendor Name([VendorID]) has a balance or is on an open transaction and cannot be saved as Inactive" will be displayed. This is not visible until after the record is initially saved. Database Field: ERPx_APVendor.IsInactive |
Addresses Tab
Toolbar Icons | Description |
|---|---|
Add Item | |
Column Filter Show/Hide | |
Excel | |
Group By Show/Hide | |
Quick Column Filter | |
Remove Items | When attempting to delete a Loan address configured for ACH, the message "[Vendor Name]: has an address, [Address ID], that has been used for ACH. Please navigate to the Fisherman ACH configuration page (Fisherman Accounting > Configuration > Fisherman ACH) to remove the record prior to deleting the address record." will be displayed when Remove Items is clicked. When attempting to delete a Loan Address that is set as a default address, the message "[Vendor Name] [Vendor ID]: Address [AddressID] is the [Default address type] address and cannot be deleted." will be displayed when Remove Items is clicked. Additionally, when attempting to delete a Loan Address that has been used on a check, the message "[Vendor Name] [Vendor ID]: Address [AddressID] has been used on Checks and cannot be deleted." |
Saved Layouts | |
Fields | Description |
Checkbox | |
1099 Default |
Database Field: ERPx_APVendorAddress.Is1099Default |
Address 1 |
Database Field: ERPx_APVendorAddress.AddressLine1 |
Address 2 |
Database Field: ERPx_APVendorAddress.AddressLine2 |
Address 3 |
Database Field: ERPx_APVendorAddress.AddressLine3 |
Address ID |
Database Field: ERPx_APVendorAddress.AddressID |
City |
Database Field: ERPx_APVendorAddress.City |
Country |
Database Field: ERPx_APVendorAddress.Country |
Default Payment Type | A single-select standard lookup to assign the default payment type for the corresponding address. The lookup contains the values "ACH" or "Check" and defaults to "Check". If set to Check, a physical check will be printed when payments are processed for this Vendor, using this address. If set to ACH, an ACH record will be created as part of an ACH batch when payments are processed for this Vendor, using this address. To change from Check to ACH, the Address ID must be configured for ACH in the Vendor ACH list view, otherwise the message "Vendor Name (VendorID): Address ID [AddressID]: The Default Payment Type cannot be changed to ACH because the address has not been configured for ACH. Go to Purchasing > Configuration > Vendor ACH to configure this Address." will be displayed. Additionally, once configured for ACH, the SEC Code on the Fisherman ACH List View must not be set to a Prenote type (either Checking - Prenote, or Savings - Prenote), else the message "[VendorName] (VendorID): Default Payment Type cannot be set to ACH when the SEC Code on the Fisherman ACH List View is a Prenote type." will be displayed on Save. This field is required. Database Field: ERPx_APVendorAddress.DefaultPaymentTypeSK |
Database Field: ERPx_APVendorAddress.Email | |
Payment Default |
Database Field: ERPx_APVendorAddress.IsPaymentDefault |
Payment Description | An editable text box to enter the value that will display on the memo line of manual payments for the corresponding Address ID. This field is not required but if a value is entered it must be <=250 characters. This is always editable. Database Field: ERPx_APVendorAddress.CheckDescription |
Payment Name |
Database Field: ERPx_APVendorAddress.CheckName |
Phone |
Database Field: ERPx_APVendorAddress.Phone1 |
Physical Default |
Database Field: ERPx_APVendorAddress.IsPhysicalDefault |
State |
Database Field: ERPx_APVendorAddress.State |
Zip |
Database Field: ERPx_APVendorAddress.Zip |
Contacts Tab
Toolbar Icons | Description |
|---|---|
Column Filter Show/Hide | |
Excel | |
Group By Show/Hide | |
Quick Column Filter | |
Saved Layouts | |
Fields | Description |
Contact Type |
Database Field: ERPx_APVendorContact.ContactTypeSK |
Database Field: ERPx_APVendorContact.Email | |
Fax |
Database Field: ERPx_APVendorContact.Fax |
Name |
Database Field: ERPx_APVendorContact.Name |
Note |
Database Field: ERPx_APVendorContact.Note |
Phone |
Database Field: ERPx_APVendorContact.Phone |
Attributes Tab
Toolbar Icons | Description |
|---|---|
Column Filter Show/Hide | |
Excel | |
Group By Show/Hide | |
Quick Column Filter | |
Saved Layouts | |
Fields | Description |
Attribute |
|
Available | |
Value |
GL Accounts Tab
Toolbar Icons | Description |
|---|---|
Column Filter Show/Hide | |
Excel | |
Group By Show/Hide | |
Quick Column Filter | |
Saved Layouts | |
Fields | Description |
Account Type | This field contains the following account types: Settlement Accrual: |