Overview

Once delivery tickets have been posted, they are no longer viewable in the Delivery Ticket List View and cannot be edited. In order to reprice a delivery ticket item the user must choose the appropriate function from the More Actions toolbar drop-down menu in the Delivery Ticket List View and follow the steps laid out below. Using the reprice function will reprice a specific line item based on criteria across all delivery tickets within the criteria parameters.

Understanding the data flow

When delivery ticket items are repriced, upon updating to “Ready to Post,” a NorthScope journal entry will be created and sent to the host system’s Financial module for every affected Delivery Ticket and the affected NorthScope settlement transaction(s) will be updated to reflect the new balance(s).

Step 1: Repricing the delivery ticket item(s).

In order to reprice a delivery ticket item, the user must first expand the Purchasing module in the navigation menu and select 'Tickets'. This will open the Tickets List View.

From this view, open the More Actions drop-down menu in the toolbar and select “Item Reprice.”

This will open the Ticket Reprice window. The header in this window contains the following fields for data entry:

• Accrual Date: This field defaults to today’s date and determines the date the changes will affect the general ledger.
• Comment: This field is for manual entry of any notes regarding the reprice, such as the reason for the reprice.
• Date From: This field defaults to the date a year prior to today’s date and determines the earliest items shown.
• Date To: This field defaults to today’s date and determines the latest items shown.
• Delivery Number: This field is for manual entry of the delivery number to which the item(s) for reprice correspond.
• Fisherman: This field is to select the fisherman to which the item(s) for reprice correspond. This field displays a drop-down menu and offers a list of all active fishermen.
• Gear Type: This field is to select the gear type to which the item(s) for reprice correspond. This field displays a drop-down menu and offers a list of all active gear types.
• Include Tickets: This field is for premium reprice and is not editable when conducting an item reprice.
• Net # Tickets: This field auto-populates once a line item has been selected and validated to display the number of tickets to which the line item applies.
• Premiums: This field is to select the premiums to which the item(s) for reprice correspond. This field displays a drop-down menu and offers a list of all active premiums.
• Season: This field is to select the season to which the item(s) for reprice correspond. This field displays a drop-down menu and offers a list of all active seasons.
• Specie: This field is to select the specie to which the item(s) for reprice correspond. This field displays a drop-down menu and offers a list of all active species.
• Stat Area: This field is to selection the stat area to which the item(s) for reprice correspond. This field displays a drop-down menu and offers a list of all active stat areas.
• Temp Range: This field is for premium reprice and is not editable when conducting an item reprice.
• Tender – Delivered: This field is to select the tender that delivered the item(s) for reprice. This fields displays a drop-down menu and offers a list of all active tenders.
• Ticket Class: This field is to select the ticket class to which the item(s) for reprice correspond. This field displays a drop-down menu and offers a list of all active ticket classes.
• Ticket Number: This field is for manual entry of the ticket number to which the item(s) for reprice correspond.

If the defaulted values remain and no other information is entered, all items within the last year will populate in the Ticket Reprice List View. To filter for certain items, enter as much information as possible in the header fields. Once all the filter criteria has been entered in the header fields, click Refresh Data in the header toolbar. This will display all the applicable items within the parameters of the entered criteria. These items will be grouped by specie, condition, grade, disposition, sold condition and current price. Each of these groupings is a column header along with # Tickets, New Price and Repriced.

To reprice items, find the desired line item(s) and enter the new price of the item in the New Price column. Clicking out of this column will automatically update the Repriced column to display an uneditable “Yes” as the cell’s value.

Once all new prices have been entered, click Validate in the header toolbar. This will refresh the page to show the repriced line items at the top of the list view, update the "Net # Tickets" field to show the number of tickets the reprice is affecting, and enable the Process toolbar icon.

Note: The Net # Tickets field may not equal the sum of all the repriced lines '# Tickets' fields because multiple items can be on the same ticket and therefore may be referencing a shared ticket when displaying the number of tickets the line item is on.

In order to save and complete the changes, the user must click Process in the toolbar header.

After processing, the user may close out or continue to reprice items as the Ticket Reprice window will remain open.

Step 2: Posting the journal entry in the host system.

Upon processing, a NorthScope journal entry is created for each affected Delivery Ticket and each journal entry is then sent to the host system if the Purchasing Preference for “Enable Real Time Integration” is set to “Yes”. The journal entry will appear in the host system's Financial module as a Transaction Entry in the batch titled NS followed by the year, month, and day with the following format: NS: YY_MM_DD. For example, if the reprice was integrated on July 14, 2015, the Batch ID for the transaction entry would be NS: 15_07_14. 

Each Delivery Ticket reprice journal entry description will be the NorthScope journal entry number followed by the NorthScope transaction ID followed by the NorthScope transaction name (i.e. 12345: Ticket Adj: (Ticket Number)-v(version number)).

Journal entries for reduced item prices

If the item reprice reduced the original price of the item, the following journal entry will appear:

One credit line summarizing the difference between the original price and the reprice for each unique “Purchase Account” on the transaction.

One debit line summarizing the difference between the original applicable tax amount and the repriced applicable tax amount for each unique “Taxes” account on the transaction.

One debit line summarizing the difference between the original Delivery Ticket amount and the repriced Delivery Ticket amount less the difference in taxes for the fisherman’s “Settlement Accrual” account.

Journal entries for increased item prices

If the item reprice increased the original price of the item, the following journal entry will appear:

One debit line summarizing the difference between the original price and the reprice for each unique “Purchase Account” on the transaction.

One credit line summarizing the difference between the original applicable tax amount and the repriced applicable tax amount for each unique “Taxes” account on the transaction.

One credit line summarizing the difference between the original Delivery Ticket amount and the repriced Delivery Ticket amount less the difference in taxes for the fisherman’s “Settlement Accrual” account.

Once the user is satisfied that all the GL Distributions are correct, the user can post the batch in the host system.

Note: Although this step is required, it does not need to be done for each transaction. Posting can be done nightly or as needed.

Step 3: Reviewing in NorthScope.

Whether or not Step 2 is complete, the following will occur in NorthScope:

• The settlement transaction(s) for the original Delivery Ticket(s) will be adjusted to reflect the new balance(s).

Once Step 2 is complete, the following will occur in NorthScope:

• The NorthScope journal entries for each affected Delivery Ticket will update from “Ready to Post” to “Posted” and will no longer be visible in the Financial Journal Entries List View.