Table of Contents | ||||||
---|---|---|---|---|---|---|
|
...
- 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 that the preference is set to “Yes”. If the preference is set to “No”, then the events in Step 3 will not occur.
- Turn on the integration for journal entries
- Set Default Cash payment checkbook (Sales Order Preferences)
- Set Default Check payment checkbook (Sales Order Preferences)
- Set Default Credit Card payment checkbook (Sales Order Preferences)
- Attributes Setup for Fisherman - Fisherman Sale Transaction
Understanding the data flow
A fisherman sale transaction can be used to record sales transactions to fishermen and returns from fishermen. When the transaction status is changed to “Ready to Post,” each line item creates a settlement transaction in NorthScope and a NorthScope journal entry is created and sent to the host system. A fisherman sale transaction can be deleted when the transaction status is set to 'New'.
To view the data flow of Fisherman Sale transactions, click here.
...
Click the “New” toolbar icon and select “Fisherman Sale” to open a blank record view.
For more information on the Fisherman Sale transaction fields, refer to the online help here.
Completing the header fields
- Cash: An optional field to enter the amount of cash received from the fisherman and/or tender for the sale.
- Check: An optional field to enter the amount received from the fisherman and/or tender via check for the sale.
- Credit Card: An optional field to enter the amount received from the fisherman and/or tender via credit card for the sale.
- Description: An optional field for describing the fisherman sale.
- Doc Date: Identifies the date of the transaction. This field defaults to today’s date but can be edited.
- Doc No: Identifies the document number for the transaction. This field is not required but, if entered, must be unique by transaction type.
- Fisherman: Identifies the fisherman who purchased or returned the item(s). This field provides a lookup of all active fishermen, fishermen& tenders and fishermen/ tenders.
- Price List: displays a dropdown menu containing all of the available price lists to assign to the transaction. This field is editable, the price list assigned to a fisherman will be displayed if a price list has been assigned to the fisherman selected in the transaction. For more information on price lists, refer to the user guide here.
- Status: This field is to select the status from the following options:
- New - This is the default.
- Approved - Used when there is a two-step process for finalizing transactions. Setting the status to “Approved” disables all editable fields except Status.
- Ready to Post - Used when the user is ready to post the transaction. Setting the status to “Ready to Post” disables all editable fields including status.
- Tax Class: This field is to select the Tax Class to apply to the taxable items on the transaction. This field is enabled only if the Company preference for 'Enable Sales Tax on Fisherman Sales' is set to 'Yes'.
Adding line items
By default, new fisherman sales open with 5 blank rows for data entry. Complete the data entry by adding one line for each transaction.
...
- Description: Offers a description of the line item. This field defaults once the item is selected.
- Extended: This field is read-only and displays the product of the price per UOM and the quantity.
- Item: Identifies the item being sold or returned. This field provides a lookup of all active items.
- Price: Identifies the price per UOM for the line item. Prices must be greater than or equal to 0. This field defaults to 0.
- Quantity: Enter the amount of the line item being sold or returned. This field defaults to 1.
Note: If the fisherman sale is recording a return, the user must use the Quantity field to record the negative (i.e. -1) and enter the absolute value of the price of the item(s) to be returned in the Price field. For example, a return of $500 would be entered by placing a -1 in the Quantity field and a positive 500 in the price field.
- Sale Account: Identifies the sale account to be credited on the line item journal entry. Defaults to the item's sales account.
Note: If the fisherman sale is recording a return, the sale account will be debited.
- UOM: Identifies the unit of measure for the line item. This defaults to the purchasing preference for “Unit UOM”.
Assigning Attributes (Optional)
The Attributes tab on the transaction will include all user-defined Attributes assigned to the Fisherman - Fisherman Sale Transaction.
To setup Attributes for the Fisherman - Fisherman Sale Transaction, navigate to Company → Attributes → Fisherman → Transactions → Fisherman Sale.
Step 2: Recording payments on the transaction. (Optional)
...
To record payments received from the fisherman and/or tender for the sale transaction, open the Payment Details tab. Then, enter the amount received in the Amount column corresponding to the 'Payment Type' through which the money was received - either Cash, Check, or Credit Card. In the reference field, the user has the option to enter a reference for the payment that will appear on the Cash Receipt - however, this is not required. Finally, select the checkbook to receive the payment from the Checkbook drop-down menu. Selecting the checkbook will default the Cash Account field with the cash account assigned to the checkbook. The default checkbook for each payment type can be defined in Sales Order Preferences .
Once the payment has been entered and the transaction is saved as 'Ready to Post,' an invoice for the transaction will be sent to the host system with a cash receipt attached for the entered payment amount.
Note: A payment greater than the amount on the Fisherman Sale can be recorded. The overpayment will apply as a credit to the fisherman's account.
Step 3: Finalizing the transaction in NorthScope.
...
- Ensures there is at least one valid line item on the transaction
- Ensures that all default GL Accounts can be assigned.
- The “Settlement Accrual” account for the fisherman.
- Ensures the Doc Date resides within a valid fiscal period as determined by the host system.
- Ensures the checkbook has a cash account assigned (if a payment was recorded).
Ensures the required Attribute values have been entered.
Once the status has been successfully updated to “Approved”, all the editable fields, with the exception of Status, will be disabled.
...
For every Fisherman Sale an accrual journal entry will be made in the host system if the Purchasing Preference for “Enable Real Time Integration” integration setup for Journal is set to “Yes”immediate or timed. The 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 Fisherman Sale was integrated on July 14, 2015, the Batch ID for the transaction entry would be NS: 15_07_14.
...
- One debit line showing the summarized amounts for the fisherman “Settlement Accrual” account. The GL Account comes from the vendor’s “Settlement Accrual” account or, if missing, defaults from the Purchasing Preference for “Default Account – Settlement Accrual” account.
- One credit line showing the summarized amounts for each unique “Sale Account” on the transaction.
Note: If a payment was recorded on the Fisherman Sale, the fisherman's 'Settlement Accrual' account will be credited for the amount of the payment and the payment's 'Cash Account' will be debited for the amount of the payment.
Journal entries for negative sales line items (Returns)
...
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 5: Reviewing in NorthScope
...
- The NorthScope journal entry will update from "Ready to Post" to "Posted" and will no longer be visible in the Financial Journal Entries List View
...