NorthScope 2020.01.13

Owned by Janice Dannenberg (Unlicensed)
Last updated: Jan 27, 2020
5 min read

(Software Version: 2020.01.13 Database Version: 2020.01.13)

Release Date: January 13, 2020



New Feature

Financial

New Feature! New year, new functionality! We have been working extra hard to create a series of checkbook transaction pages to document and reconcile checkbook balances. Along with these new pages, we’ve included the ability to calculate transactions in foreign currencies to and from home currency using exchange rate tables maintained from System > Setup > Currency Exchanges.

  • Checkbook Transactions List View: The purpose of the Checkbook Transactions List View is to show open transactions and create new transactions that update the Checkbook Balance (bank account balance). All checkbook transactions for Adjustments, Deposits, and Transfers that are in a Status of 'New' or 'Approved' are included. From here, users can add new transactions or delete unposted transactions. When transactions are posted from this list view, the checkbook balances are updated. Each of the following transactions has the potential to make a journal entry when posted.
    • Adjustment: Used to record miscellaneous increases or decreases in the checkbook balance.
    • Deposit: Used to record deposits to the checkbook.
    • Transfer: Used to move funds from one checkbook to another.
  • Checkbook Reconciliations List View: If you’re trying to balance the books, then this page is your friend. The purpose of the Checkbook Reconciliations List View is to show open reconciliation transactions in a Status of ‘New’ or ‘Approved’ and create new transactions to balance a checkbook. From here, users can add new reconciliations, edit existing reconciliations or delete unposted reconciliations. When a reconciliation is Posted, the checkbook balance may be updated and the Checkbook Transaction Inquiry is updated with the reconciliation information. Checkbook reconciliations do not make journal entries when posted.
  • Checkbook Reconciliations Record View: The purpose of the Checkbook Reconciliation Record View is to identify all the checkbook transactions that have cleared the bank. From here, users can start a new reconciliation, assign all the transactions that are being reconciled (cleared), and edit the cleared amount of specific transactions if necessary. When a Reconciliation is Posted, the checkbook balance is updated and the Checkbook Transactions Inquiry is updated with the reconciliation information. Checkbook reconciliations do not make journal entries when posted.
  • Checkbook Transaction Inquiry: We wouldn't think of releasing the Checkbook Transactions functionality without a way to view them historically, so here it is. The purpose of the Checkbook Transaction Inquiry is to view all the transactions that would be on a bank statement, as they appear on a bank statement. All checkbook transactions for Adjustments, Deposits, and Transfers are included.
  • Checkbook Reconciliation Inquiry: From the Checkbook Reconciliation Inquiry, users can view Checkbook Reconciliations. All checkbook reconciliations, both open and posted can be viewed from here.
  • Checkbook Reconciliation - Cleared Transactions Report: We love a good report, don’t you? This report provides a list identifying all the transactions that were included on the selected reconciliations. It can be printed from the Print Dialog launched via the Reconciliation List View, the Reconciliation Record View, or the Checkbook Reconciliation Inquiry.
  • Checkbook Reconciliation - Outstanding Transactions Report: This report shows every checkbook transaction that has not been reconciled for the selected reconciliations. It can be printed from Financial > Reports or from the Print Dialog launched via the Reconciliation List View, the Reconciliation Record View, or the Checkbook Reconciliation Inquiry.
  • Reconciliation Summary Report: This report displays the summarized results of selected reconciliations. It can be printed from the Print Dialog launched via the Reconciliation List View, the Reconciliation Record View, or the Checkbook Reconciliation Inquiry.

Note: We’ve added several Default preferences to allow users to specify Next Checkbook Numbers and Number of Cutoff Days from the Financial > Configuration > Preferences.


Fisherman Accounting

Were you using the Cash Receipt Inquiry? Unfortunately, along with the rest of 2019, it’s a thing of the past. The good news is that we are releasing the Payment Receipt History Inquiry in it’s place. The Payment Receipt History Inquiry includes new columns and is used to display Payment Receipts that are received in the Fisherman Accounting Functional Area. Here users can review Payment Receipts, apply/unapply Payment Receipts, open the Payment Receipt transaction, and/or open the Deposit the Payment Receipt was deposited on. This inquiry is typically used to view posted Payment Receipts but all Payment Receipts, including open (unposted) Payment Receipts can be found here.


Sales

New Feature! We’ve created several Sales pages to aid in the documentation, application and review of payments associated with sales order transactions. Additionally, we’ve included the ability to support Payment Receipts in a foreign currency. We trust this functionality will make “cents” when you use it. #PunIntended  #YesItWasABadJoke

  • Payment Receipts List View: The Payment Receipts List View shows open Payment Receipts (Status of "New" or "Approved"). From here, users can add new Payment Receipts, edit or delete existing Payment Receipts, and/or Post Payment Receipts.
  • Payment Receipts Record View: The purpose of the Payment Receipt Record View is to enter payments received by customers. From here, users can open the 'Apply Documents' window, review the Journal Details, and post the receipt. When receipts are posted, the Customer Balances and Customer Aging are updated, and the receipt becomes available to the Checkbook Deposit transaction. Payment Receipts make a journal entry when they are posted.
  • Apply Sales Documents Page: The Apply Documents Record View can be used to apply open Receipts, Returns, and negative Invoices to open sales transactions. The page header shows information pertaining to the Receipts, Returns, or negative Invoice and the page detail shows all the open sales transactions for the receipt customer, that are in the same currency as the Receipts, Returns, or negative Invoice, and that have an 'Open Amount' greater than 0.00. From here, users can apply the receipt to one or more open transactions, enter a Discount Taken, or record a Write Off Amt. When the application is saved, the Customer Balances and Customer Aging are updated. Applications that have an amount in either the 'Discount Amount' or 'Write Off Amount' will generate a journal entry. Applications where the Receipt is not in the 'Home Currency' have the potential to make a currency gain / loss journal entry.
  • Payment Receipt History Inquiry: We love our inquiries and this one is no exception. This inquiry gives users a way to view all the Payment Receipts that were received in the Sales Functional Area. From here, users can review Payment Receipts, apply/unapply Payment Receipts, open the Payment Receipt transaction, and/or open the Deposit the Payment Receipt was deposited on. This inquiry is typically used to view posted Payment Receipts but all Payment Receipts, including open (unposted) Payment Receipts can be found here.

Note: The Realized Gain Account and Realized Loss Account must be specified from Company > Configuration > Company Currencies List View before Journal Entries can be calculated for Currency Gains and Losses.


 

Technical Changes

Please view cumulative schema changes here.