NorthScope 2019.08.29

Owned by Emma Greenwood
Last updated: Sept 03, 2019
4 min read

(Software Version: 2019.08.02 Database Version: 2019.08.29)

Release Date: August 29, 2019


New Feature

Fisherman Accounting

Feature Spotlight! NS-4784 New Feature to automate interest payments to Fisherman related accounts

A new feature has been added to calculate and process interest payments on Fisherman accounts that have a credit balance (you owe them money). Users can calculate interest payments on an annual or monthly interest rate, for one or more (Fisherman related) Account Classes. When processed, a single Interest Payment Adjustment transaction will be created containing each Fishing Account that is receiving an Interest Payment.

Users can calculate interest on an annual or monthly interest rate, for one or more (Fisherman related) Account Classes. When processed, a single Interest Payment Adjustment transaction will be created containing each Fishing Account that is receiving an Interest Payment.

To use this new feature the following setup is needed:

  1. Ensure that all included fishing related accounts have an assigned Interest Payment GL Account. This can be done in several ways including:
    1. Configure the “Finance Charges” GL Account on the Fisherman Class(es) and roll them down to the individual Fisherman Accounts. Fisherman Accounting > Configuration > Fisherman Class.
    2. Configure the “Finance Charges” GL Account on each specific Fisherman Account. Fisherman Accounting > Setup > Fisherman & Tenders or Loans.
    3. Configure the “Interest Payment GL Account” Preference. Fisherman Accounting > Configuration > Preferences.
  2. Configure the default Adjustment Transaction Class to be used for the Interest Payment transaction. Fisherman Accounting > Configuration > Preferences > Transaction Class for Interest Payment Transactions.
  3. Optional: Add a new Adjustment Transaction Class to be used for Interest Payment transactions. This will require assistance from NLP Support.
  4. Optional: Configure the ‘Excluded Transactions’ for the Fisherman Classes and/or individual Loan/Fisherman Accounts. This will ensure that only Fishing Accounts you intend can be paid interest.

After the setup is complete, to process interest payments:

  1. Go to Fisherman Accounting > Fisherman Balances, click the “More Actions” icon and select the “Process Interest Payments” option.
  2. Select the Transaction Class – this should default from your preference.
  3. Select the Account Class(es) you wish to include.
  4. Specify the Interest Rate and identify if it’s an Annual or Monthly rate.
  5. Specify the “Beg. Balance as of” date. This is the date that beginning balances will be calculated for.
  6. Optional: Specify the “Add Deposits made thru” date. This is the grace date that deposits received through will be added. Leave blank if you do not give a grace date.
  7. Optional: Specify the “Less Withdrawals thru” date. This is the date that any withdrawals made will be deducted through.
  8. Specify the “Interest Transaction Date”. This is the date that the Interest Payments will be posted to the General Ledger.
  9. Click the “Refresh Data” icon in the header toolbar. This will populate the grid will all eligible fishing accounts based on your setup. This will include all active fishing accounts for the selected Account Class(es) that are open to the interest transaction.
  10. Edit any interest amounts if necessary.
  11. Click the “Validate” icon in the header toolbar. This will test to ensure a transaction can be posted.
  12. Click the “Process” icon in the header toolbar. This will create the Interest Payment transaction for all selected accounts that have an amount in the “Interest Amount” column. The transaction is automatically posted unless there are required attributes setup for the Adjustment Transaction Class, in which case the transaction is created with a Status of “New”. These transactions will not be able to be approved or posted until the required attribute value(s) are entered. Once posted, the fisherman balances are updated accordingly.

The grid contains the following columns:

  • Account – Fishing Account Name (ID)
  • Account Class – The Account Class assigned to the Fishing Account.
  • Beginning Balance – The balance at the beginning of the “Beg. Balance as of” date.
  • Add Deposits made thru– The total deposits received between the “Beg. Balance as of” date and the “Interest Transaction Date”.
  • Less Withdrawals thru – The total withdrawals made from the account between the “Beg. Balance as of” date and the “Interest Transaction Date”.
  • Net Balance – Beginning Balance plus the Additional Deposits minus the Withdrawals Received.
  • Calculated Interest – The system calculated interest amount.
  • Interest Amount – The amount the interest payment will be for. If a user has edited the Calculated Interest it will be displayed here, otherwise it is the Calculated Interest amount.
  • Finance Charge GL Account – The GL Account that will be used on the Interest Transaction for each Fishing Account.
  • Eligible - displays Yes if the account is eligible (not excluded from the specified adjustment transaction class), or No if the account is not eligible (has been excluded from the specified adjustment transaction class). When the account is not eligible no balances will be displayed and the interest amount will not be editable.
  • Includes Calculated Interest - displays Yes when there is calculated interest for an account, otherwise displays No.
  • Includes Interest Amount - displays Yes when there is an interest amount for an account, otherwise displays No.
  • Amount Edited - displays Yes if the interest amount is different to the calculated interest amount, otherwise it is blank.

These transactions can be run as often as needed and there is no warning if a user processes them multiple times for the same dates.

Improvements

Fisherman Accounting

NS-4965 Do not allow Fishermen, Tenders, or Loans to be inactivated if they have an open balance

Any Fishermen, Tenders, or Loans that have an open balance, or are on an open transaction, will display the following message when a user tries to save them as inactive “[VendorName] ([VendorID]) has a balance or is on an open transaction and cannot be saved as Inactive”.

NS-4941 Added new columns to the Ticket Line Stat Area History Inquiry

The following columns have been added to the Ticket Line Stat Area History Inquiry:

  • Tax District – Displays the Tax District associated with the Stat Area for the line item
  • DeliveryTicketLineSK – Displays the unique identifier from the database for the associated Fish Ticket line item, this column is not displayed in the system view

Purchasing

NS-4965 Do not allow Vendors to be inactivated if they have an open balance

Vendors that have an open balance, or are on an open transaction, will display the following message when a user tries to save them as inactive “[VendorName] ([VendorID]) has a balance or is on an open transaction and cannot be saved as Inactive”.

Technical Changes

Please view cumulative schema changes here.