Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Turn on integration for journal entries and Employee Arrears.
  • Set the Purchasing Preference for “Default Employee Sale Payroll Deduction” 
  • Attributes setup for Employee Sale transaction

Understanding the data flow

...

Note: If payments/refunds are recorded, each payment/refund value must correspond to the overall transaction amount value. For example, if the overall transaction amount is positive, then each payment/refund amount value must also be positive. Alternatively, if the overall transaction amount is negative, then each payment/refund amount value must also be negative. 

Step 3: Assigning transaction properties (Optional)

The transaction GL date can be updated in the Properties tab. Other properties are displaying the transaction details and they are for informational use only and not editable. The GL date defaults to the transaction date, but the date is editable when the transaction status is New. The GL date must be greater or equal to the transaction date and must be within an open fiscal period. Save the transaction record after updating the transaction properties.

Step 4: Assigning Attributes (Optional)

The Attributes tab on the transaction will include all user-defined Attributes assigned to the Sales Order - Employee Sale Transaction.

To setup Attributes for the Sales Order - Customer Sale Transaction, navigate to Company → Attributes → Sales Order → Transactions → Employee Sale.

Step 5: 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.  

...

  • Ensures there is at least one valid line item on the transaction
  • Ensures that all default GL Accounts can be assigned.
  • Ensures that 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.

...

  • 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 NorthScope Employee Deduction journal entry and sends it to the Host System, if the integration is turned on.

Step

...

6: Posting and reviewing the transaction entries.

For every Employee Sale a journal entry will be made in the host system if the Purchasing Preference for “Enable Real Time Integration” is set to “Yes” and the integration setup for Employee Arrears and Journal is set to Timed/Immediate. 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 Employee Sale was integrated on July 14, 2015, the Batch ID for the transaction entry would be NS: 15_07_14. 

...

  • One arrears deduction for each sale line item under the “Payroll Deduction Code” specified on the transaction line item.

Step

...

7: Reviewing in NorthScope.

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

  • The posted Employee Sale(s) will automatically update from “Ready to Post” to “Posted” and will no longer be visible in the Purchasing Sale List View.

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

...