Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Overview
Once delivery tickets have been posted, they are no longer viewable visible in the Delivery Ticket List View and cannot be edited. In order to correct a delivery ticket, 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 correct function will reopen the delivery ticket for edits.
Understanding the data flow
When a delivery ticket is corrected, if the component that is corrected affects the total price of the delivery ticket (i.e. price, weight, weight modification, line item additions or deletions), then once the correction is updated to "Ready to Post”, the original a new settlement transaction for the delivery ticket will be adjusted created to reflect the new balance the summed amount to settle for all versions of the ticket and a NorthScope journal entry is created and sent to the host system as an unposted transaction entry in the Financial module.
Step 1: Correcting the delivery ticket.
In order to correct a delivery ticket, the user must first expand the Purchasing module in the navigation menu and select “Delivery Tickets”“Tickets”. This will open the Delivery Ticket Tickets List View.
From this view, open the More Actions drop-down menu in the toolbar and select “Void/Correct.” This will open the Void/Correct window.
...
- Account: This field offers a drop-down menu of all fisherman to limit the delivery tickets shown to those that are connected to the selected account.
- Action: This field offers the options of Void and Correct from a drop-down menu. Select “Correct”.
- Date From: This field defaults to the date a year prior to today’s date and determines the earliest delivery tickets shown.
- Date To: This field defaults to today’s date and determines the latest delivery tickets shown.
- GL Accrual Date: This field defaults to today’s date and determines the date the changes will affect the general ledger.
- Transaction: This field displays a blank text box for the user to search for a specific transaction.
- Transaction Type: This field defaults to Delivery Ticket and offers no other options.
...
Once all desired data has been entered into the header fields, select Refresh Data on the header toolbar. This will open a list view in the Void/Correct Grid View of all applicable delivery tickets within the entered criteria. The list view will contain the following columns: select, Account ID, Account Name, Transaction, Amount, Trans Date, GL Date, GL Accrual Date, and Permit Holder.
Within the list view, select the check box corresponding to the line item(s) to correct and click Process in the header toolbar.
Clicking Process will change the selected Delivery Ticket(s) to a status of New, making it available in the Delivery Ticket List View, allow for edits to the Delivery Ticket as Version 2, and create a second Settlement Transaction for the same Delivery Ticket with a status of "Open"do the following:
- Correcting a ticket creates a new version of the ticket in the Ticket List View.
- The Version # of the new ticket will be incremented by 1 from the originating ticket. The user must then go into the ticket and make any corrections necessary.
- The original Ticket is set to a status of Replaced.
- The new ticket becomes the active ticket.
To make edits to the delivery ticket, select Delivery Tickets from the Purchasing module and select the delivery ticket to correct.
Make the desired changes and Save. This will change the Delivery Ticket’s integration status to Pending Changes.
Note: If the Fisherman Account is changed on the ticket correction, a voided version of the old ticket with the old fisherman account will be created and then the corrected ticket will be created with the new fisherman account. This is to ensure that the settlement balance for the old ticket is appropriately removed from the old fisherman account and applied to the new fisherman account.
Step 2: Finalizing the transaction in NorthScope.
Changes can be made to a transaction until it is finalized. To finalize a transaction, the user will need to change the status to “Ready to Post”. In some companies, posting is a two-step process where transaction(s) are “Approved” by one person and posted by another.
Approving the transaction
This step is optional and is used for companies that require a two-step process where there the person who approves the transaction cannot be the same person that posts the transaction.
...
Once the status has been successfully updated to “Approved”, all the editable fields, with the exception of Status, will be disabled.
Finalizing the transaction
When the transaction is ready to be finalized, the user must open it and change the status to “Ready to Post” and save the transaction. Setting the adjustment to “Ready to Post” does the following:
- Validates the same conditions as the approval status and locks down all editable fields including status.
- Updates the transaction status to Posted and removes it from the list view
- Creates the NothScope NorthScope journal entry and sends it to the Host System.
- Adjusts the settlement transactions.
Once the changes are ready to be posted, change the status to "Ready to Post" and click Save. This will open the delivery ticket in non-edit mode with the status of "Posted".
Step 3: Posting the journal entry in the host system.
For every corrected Delivery Ticket where corrections affected the Delivery Ticket amount, a journal entry will be made in the host system if the Purchasing Preference for “Enable Real Time Integration” is set to “Yes”integration for journal entries is turned on. 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 correction was integrated on July 14, 2015, the Batch ID for the transaction entry would be NS: 15_07_14.
Each Delivery Ticket Adjustment correction 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: C123 45678 Ticket Adj: (Ticket Number)-v(version number) ).
Journal entries for reduced amount corrections
If the correction reduced the amount of a delivery ticket line item, the following journal entry will be created:
...
One debit line summarizing the difference between the original applicable tax amount and the corrected applicable tax amount for the line item “Taxes” account.
Journal entries for increased amount corrections
If the correction increased the amount of the delivery ticket line item, the following journal entry will be created:
...
One credit line summarizing the difference between the original applicable tax amount and the corrected applicable tax amount for the line item “Taxes” 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 4: Reviewing in NorthScope.
Whether or not Step 3 is complete, the following will occur in NorthScope:
- The posted Delivery Ticket will automatically update from “Ready to Post” to “Posted” and will no longer be visible in the Delivery Ticket List View.
- The Delivery Ticket’s original settlement transaction will be adjusted to reflect the new balance.balance will reflect the summed amount to settle from both versions of the ticket.
Once Step 8 3 is complete, the following events will happen in NorthScope:
...