Overview

The Settlement Balance keeps Fisherman Balances table keeps a running tab of amounts owed and due to vendors with a “Vendor Type” of Fisherman, Tender, or Fisherman/Tender. The balances are appropriately adjusted automatically by Adjustments, Balance Transfers, Cash Receipts, Credit Memos distributed to fishermen, Delivery Tickets, Fisherman Sales, Invoices distributed to fishermen, Tender Sales, and Transfers. From the Settlement Balance, users may process checks to pay remaining balances.

Prerequisites

Required Prerequisites

• Vendor Setup
• Financial Account setup

...

• Set the purchasing preference for “Default Account – Settlement Accrual”. 
  • This will ensure that transactions will still post if the settlement account has not been manually configured for each fisherman or tender.
  • Set the purchasing preference for “Enable Real Time Integration” to “Yes”. 
    • This user guide assumes the preference is set to “Yes”. If the preference is set to “No”, then the integration components described in Steps 4 and 5 will not occur.

Understanding the data flow

Once payments are processed in Settlement Fisherman Balance, a Payables Transaction Entry is created for each check in the host system’s Purchasing module as an invoice.

To view the data flow of Settlement Check payments, click here.

Step 1: Viewing settlement balances.

From NorthScope, expand the Purchasing module on the navigation menu and select “Settlement Balance“Fisherman Balances.” This will open the Purchasing Settlement Balance a list view, which displays all settlement balances for fishermen, tenders, and fishermen/tenders. These settlement fisherman balances are displayed with the following details:

• Account: Displays the name of the vendor the balance is owed to via a hyperlink.
• Activity: Displays a hyperlink that will open the Fisherman's activity with all transactions that are New, Approved, Ready to Post, or Posted, excluding those that have been voided by default.
• Batch: Displays the batch the payment belongs to. This field auto-populates after a payment has been entered and processed.
• Open PO's: Displays the fisherman's balance resulting from all open Purchase Orders. 
• Open Transactions: Displays the fisherman's balance resulting from all open transactions. Negative balances will appear within parentheses. 
• Payment: Enter the amount to pay the vendor. This is the only editable field.
• Posted Balance: Displays the remaining balance from posted transactions. Negative balances will appear within parentheses. 
• Net Balance: Displays the sum total of the vendor’s balance. Negative net balances will appear within parentheses. 
• Statement: Displays a hyperlink that will open the fisherman's statement report.

To view the detailed transactions producing the displayed settlement balances, click the “Vendor” hyperlink. This will open the vendor’s Settlement Detail view. This view displays all the transactions affecting the vendor’s settlement balance, distinguished by those that have been posted and those that remain open, with the following details:

• Amount
• Date
• Description
• Doc No
• Remaining
• Transaction
• Trans Type

...

• .

Step 2: Entering settlement payments.

From the Settlement Balance Fisherman Balances list view, enter the amount being paid to the vendor(s) in each vendor’s line item “Payment” field. All settlement payments entered must be greater than 0. Once all payments have been entered, click the “Process Checks” toolbar icon.

...

Also, clicking “Process Checks” will open the Process Checks window.If, after entering a payment and clicking “Process Checks,” the vendor’s settlement detail record is opened, the user will see that an open settlement transaction will appear for the pending payment.

Step 3: Processing checks.

The Process Checks window will open with the following header fields:

...

Once all desired payments have been entered, click the “Save” toolbar icon. This will update the header data fields.

Step 4: Approving and/or printing checks.

To create check requests, click the “Check Approval” toolbar icon. This will open check request forms on screen for each of the created checks with the payment amount, payment date, vendor account, payable to, address, GL account, and description information.

...

Clicking the Approve toolbar icon will send the checks to the host system, update the Process Checks status to Approved, and, upon exiting the Process Checks window, will update the Posted Balance(s) to reflect the payment(s) and clear the Batch and Payment fields for new entry. The posted balances will update by first applying the vendor’s “Due From” balances to the “Owed To” balances to get a final balance owed. Then, the approved payment will be applied to the remaining balance(s) by applying to the oldest transaction first.

Note: If the payment pays the Posted Balance in full, the vendor's Settlement Balance line item will no longer appear. 

Clicking the Void toolbar icon will not send the checks to the host system, will update the Process Checks status to Void, and, upon exiting the Process Checks window, will return the Settlement Balance to its original balance before the payments were entered and will clear the Batch and Payment fields for new entry.

Step 5: Posting the check(s) in the host system.

Approving checks in NorthScope will send each individual check as a Payables Transaction Entry in the host system’s Purchasing module as an invoice with a check attached for the full amount of the payment. The transaction entries will appear in the batch titled NS followed by the year, month, and day with the following format: NS: YY_MM_DD. For example, if the payment was integrated on July 14, 2015, the Batch ID for the transaction entry would be NS: 15_07_14. 

...