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: 2024.09.27 and newer

Page Header

Toolbar IconsDescription
Delete
Help
Grid Layout
New
Notes
Save
FieldsDescription
Vendor Class

A textbox to identify the Fisherman Class assigned to the record. This defaults from the Fisherman Class assigned to the Loan account, is required and non-editable from here.

 

Database Fields: ERPx_APVendorClass.ClassID, ERPx_APVendor.VendorClassSK 

Vendor Name

A textbox to identify the name assigned to the record. This defaults from the Vendor Name assigned to the Loan account, is required and non-editable from here.

 

Database Field: ERPx_APVendor.VendorName

Vendor Type

A textbox to identify the Vendor Type assigned to the record. This defaults from the Vendor Type assigned to theLoan account, is required and non-editable from here.

Database Field: ERPx_APVendor.VendorTypeEN

Properties Tab

Toolbar IconsDescription
Excel
FieldsDescription
Properties 
Value
Group: ID and Descriptions
Vendor ID

 This is a text box that defaults to blank for new records, is required and must be <= 50 characters. If not assigned, the message "Vendor Processing Failed: ([VendorID]): Vendor ID is required." will be displayed on Save. This value must be unique across all AP Vendor, Fishermen, Tender, and Loan accounts. If not unique, the message "Vendor Processing Failed: ([VendorID]): Duplicate Vendor IDs are not allowed." will be displayed on Save. This is always editable, but only in systems that are not integrating Vendors with a third party system. To be editable, the "Vendor" 'Transaction Type on both the 'Inbound to NorthScope' and 'Outbound from NorthScope' Integration Modes  must be set to "None" on the Integration Configuration page.

Database Field: ERPx_APVendor.VendorID

Vendor Name

 This is a text box that defaults to blank, is required and must be <=100 characters. If not assigned, the message "Vendor Processing Failed: ([VendorName]): Vendor Name is required." will be displayed on Save. This is always editable.

Database Field: ERPx_APVendor.VendorName

Check Name

 This is a text box that defaults to the Vendor Name but is not required. If entered, it must be <=150 characters. This is always editable.

Database Field: ERPx_APVendor.CheckName

Group: Configuration
Vendor Class

A single-select lookup to identify the Fisherman Class assigned to the Loan Account. This defaults to blank but is required. If missing, the message "Vendor Processing Failed: ([VendorID]): Vendor 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 Vendor 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

Attribute Class

A single-select lookup to identify the Attribute Class assigned to the Loan Account. This defaults from the Vendor 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

Checkbook

A single select lookup to identify the default checkbook used for the Loan Account. This defaults from the Vendor 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 'Vendor Class'. This is required and non-editable. 

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_MFDataEntityCompanyCurrency.CurrencySK, ERPx_APVendor.CurrencySK

Payment Terms

A single select lookup to identify the Payment Terms assigned to the Loan Account. This defaults from the Vendor 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

Group: Default Address
1099

 This is a single-select lookup to assign the Address ID that contains the address used for 1099s. 

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 a single-select lookup to assign the Address ID that contains the address used for Statements.

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 a single-select lookup to assign the Address ID that contains the address used for Payments.

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 a single-select lookup to assign the Address ID that contains the address used for the physical location.

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: Other
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 

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

Vendor Account

 This is text box to assign the account number associated with the Loan account. This defaults to blank and is not required, but if entered, it must be <=25 characters. This is always editable. This is not visible until after the record is initially saved. 

Database Field: ERPx_APVendor.VendorAccount

Tax Type

The '1099 Type' for the Loan accountThis defaults to "No 1099", is required, and is always editable. If missing, the message "Vendor Processing Failed: Tax Type is required" will be displayed on Save. This is not visible until after the record is initially saved. The lookup contains the following options:

  • Dividend
  • Interest
  • Misc
  • NEC
  • No 1099

Database Field: ERPx_APVendor.TaxTypeEN 

1099 Type

A single select lookup to identify the box used for the 1099. This is not editable if the 'Tax Type' = "No 1099". 

Database Field: ERPx_APVendor.1099TypeEN

Tax ID

 This is text box to assign the Tax ID associated with the Loan account. This defaults to blank and is not required but if a value is entered it must be <=15 characters. If the 'Mask Tax ID Numbers' preference is set to 'Yes', only the last 4 characters of the value will display with the preceding characters denoted with an '*'. The whole value may be overwritten, but no partial values will be updated.  If the preference is set to 'No', partial or whole values can be overwritten. This is always editable.

Database Field: ERPx_APVendor.TaxID

Tax Registration

 This is text box to assign the tax registration number associated with the Loan account. This defaults to blank and is not required but if a value is entered it must be <=25 characters. This is always editable.

Database Field: ERPx_APVendor.TaxRegistration

Hold

 This is a single-select lookup to identify if the Loan account is on hold or not.

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

 A single-select standard lookup to select if the Vendor's account is active or not. 

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 Vendors 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 IconsDescription
Delete

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." 

Excel
New
FieldsDescription
Checkbox
1099 Default

 This is a non-editable text box that displays as "Yes" for the Address ID assigned as the default '1099' Address ID on the Properties tab of the Record View, all other Address IDs for a Loan account will have a blank value. This field is never editable from here but is set from the 1099 default address field on the Properties tab of the Loan Record View.

Database Field: ERPx_APVendorAddress.Is1099Default

Address 1

 This is a text box to assign/edit the 'Address 1' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=75 characters. This is always editable.

Database Field: ERPx_APVendorAddress.AddressLine1

Address 2

 This is a text box to assign/edit the 'Address 2' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=75 characters. This is always editable.

Database Field: ERPx_APVendorAddress.AddressLine2

Address 3

 This is a text box to assign/edit the 'Address 3' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=75 characters. This is always editable.

Database Field: ERPx_APVendorAddress.AddressLine3

Address ID

 This is a text box to assign/edit the value of the Address ID. This defaults to "Primary" and is required to be unique by account (For example, every Loan can have an Address ID of PRIMARY but that ID can only be used once for each Loan account) and must be <=25 characters. This is always editable.

Database Field: ERPx_APVendorAddress.AddressID

City

 This is a text box to assign/edit the 'City' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=25 characters. This is always editable.

Database Field: ERPx_APVendorAddress.City

Country

 This is a text box to assign/edit the 'Country' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=50 characters. This is always editable.

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

Email

 This is a text box to assign/edit the 'email' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=1,000 characters. This is always editable.

Database Field: ERPx_APVendorAddress.Email

Payment Default

 This is a non-editable text box that displays as "Yes" for the Address ID assigned as the default 'Payment' Address ID on the Properties tab of the Loan Record View, all other Address IDs within a Loan will have a blank value. This field is never editable from here but is set from the Payment default address field on the Properties tab of the Loan Record View. 

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

 This is a text box to assign/edit the value for the Payment Name that will be displayed on payments made to the Loan. This defaults from the Vendor Name entered on the Properties tab but can be overwritten and must be <=150 characters. This is not required but without it the Payment Name field on the Properties tab will be used as the Payee on a printed check or ACH payment, but if both this field and the Payment Name on the Properties tab is blank then the Vendor Name will be used. This is always editable.

Database Field: ERPx_APVendorAddress.CheckName

Phone

 This is a text box to assign/edit the 'Phone' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=25 characters. This is always editable.

Database Field: ERPx_APVendorAddress.Phone1

Physical Default

 This is a non-editable text box that displays as "Yes" for the Address ID assigned as the default 'Physical' Address ID on the Properties tab of the Loan Record View, all other Address IDs within a Loan will have a blank value. This field is never editable from here but is set from the Physical default address field on the Properties tab of the Loan Record View.

Database Field: ERPx_APVendorAddress.IsPhysicalDefault

State

 This is a text box to assign/edit the 'State' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=30 characters. This is always editable.

Database Field: ERPx_APVendorAddress.State

Zip

 This is a text box to assign/edit the 'Zip' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=15 characters. This is always editable.

Database Field: ERPx_APVendorAddress.Zip

Contacts Tab

Toolbar IconsDescription
Excel
FieldsDescription
Contact Type

 This is a non-editable text box to display which department or classification the contact belongs to. Additional Contact Types can only be added by NorthScope support. 

Database Field: ERPx_APVendorContact.ContactTypeSK

Email

 This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=1,000 characters. This is always editable.

Database Field: ERPx_APVendorContact.Email

Fax

 This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=25 characters. This is always editable.

Database Field: ERPx_APVendorContact.Fax

Name

 This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=100 characters. This is always editable.

Database Field: ERPx_APVendorContact.Name

Note

 This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=500 characters. This is always editable.

Database Field: ERPx_APVendorContact.Note

Phone

 This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=25 characters. This is always editable.

Database Field: ERPx_APVendorContact.Phone

Attributes Tab

Toolbar IconsDescription
Excel
FieldsDescription
Attribute

 The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → Vendors). 

Available
Value

Accounts (GL Accounts) Tab

Toolbar IconsDescription
Excel
FieldsDescription
Account Type

This field contains the following account types: 

Settlement Accrual: 

Cash: Not used

Terms Discount Taken The 'Account' lookup for this 'Account Type' is a single-select load on demand lookup that contains a blank value, the current assigned value, and all the 'Active' GL Accounts. This Account is not editable on transactions.

Finance Charges: The 'Account' lookup for this 'Account Type' is a single-select load on demand lookup that contains a blank value, the current assigned value, and all the 'Active' GL Accounts. 

Write Off The 'Account' lookup for this 'Account Type' is a single-select load on demand lookup that contains a blank value, the current assigned value, and all the 'Active' GL Accounts. This Account is editable when applying payments.

Account 

A single-select load on demand lookup to assign the GL Account. This defaults from the value assigned on the Vendor Class and is not required to save the master file record but may be required to post a transaction. This is always editable.

The lookup contains a blank value, the current assigned value, and all the 'Active' GL Accounts.

Excluded Transactions Tab

The excluded transactions tab allows users to specify transactions that a Loan account should be excluded from. If the value is set to "No" then the Loan account will be visible in the transaction lookups (provided they are 'Active'). If they are set to "Yes" then the Loan account will be excluded from the transaction lookups. 

TransactionDescription
AdjustmentAll 'Adjustment' Classes are eligible for including/excluding.
Balance Transfer (From)Do you want to exclude the account from being assigned to the "From" side of a Balance Transfer?
Balance Transfer (To)Do you want to exclude the account from being assigned to the "To" side of a Balance Transfer?
Cash ReceiptDo you want to exclude the account from making payments on their account?
AP Invoice/Credit Memo/Purchase OrderDo you want to exclude the account from being assigned as the 'Distribute To' on an AP transaction?
PaymentDo you want to exclude the account from receiving a payment/settlement? 

Related Topics


Page Definitions



Technical Details