POS Mapping Tool
  • 16 Jul 2024
  • 5 Minutes to read
  • Dark
    Light
  • PDF

POS Mapping Tool

  • Dark
    Light
  • PDF

Article summary

The POS Account Mapping Tool allows Users to manage all POS Accounts, including the creation of Rules for accounts brought in from the Daily Sales Summary. On the 'POS Accounts' tab, Users can view and filter all Company POS Accounts by their Account Type, Unmapped Status, or a User-defined term. POS Account Settings can also be updated as needed.

POS Account Rules can be created on the 'Rules' tab and, when set to 'Active', will automatically run when a DSS is imported and contains any new unmapped POS Accounts. If the Rule criteria is met, then the POS Account record will be automatically mapped and saved in R365. During the Automatic Rule running process, if all POS Accounts are successfully mapped, the DSS Journal Entry will be automatically recreated. Unmapped Accounts will need to be mapped via new Rules or from the the 'Unmapped' view on the 'POS Accounts' tab. In addition to Automatic Rule running, Rules can be ran manually to initiate the mapping process after a new Rule is created. Click here to learn how to run a Rule.

Default Rules are set up in the system to assist in mapping POS Accounts that are imported from the POS. These will only appear on the Rules tab when the General Ledger has been imported and if the default Rules match the GL Account names. 


Security

Users with the following Permission will be able to access the POS Mapping Tool:

Administration → POS Management → View/Edit POS Mapping Tool


These permissions can be added to custom user roles or individual users. The Permission Access report can be used to determine which user roles or users already have these permissions assigned. For more information, see User Setup and Security.


Navigation

For Users with Accounting Module Access

Navigate to the POS Account Mapping Tool by clicking POS Mapping Tool under Administration in the Accounting module.

For Users with Standalone Operations Access

Navigate to the POS Account Mapping Tool by clicking POS Mapping under Admin in the left navigation menu .

For Users with Standalone Scheduling Access

Navigate to the POS Account Mapping Tool by clicking POS Mapping under Admin in the left navigation menu.


POS Accounts Tab

The POS Accounts tab lists all POS Account records saved in R365 and provides a quick view into their account details.

Field

Description

All

Click to display the list of all POS accounts.

Unmapped

Click to display the list of only unmapped POS accounts.

Sales

Click to display the list of only sales accounts.

Payment

Click to display the list of only payment types.

Job

Click to display the list of only job titles.

Paid Out

 Click to display the list of only paid out types.

Search

This enables the user to filter the selected view by the entered keyword.

Refresh

This icon refreshes the listing when clicked.

Type

The type of POS Account. Options include:

  • Payment Type

  • Sales Account

  • Job Title

Name

The name of the POS account, as entered in the POS.

GL Account

The GL Account assigned to the POS Account. This can be easily updated by clicking into the account line item and managing the POS Account Settings.

Source DSS

The Daily Sales Summary that brought in the corresponding POS Account

If a Source DSS is missing, it is because that DSS was deleted. Follow these steps to regenerate it.

From the listing, a user can view and even update certain details of an account. Click here to learn more about managing POS Accounts.


Rules Tab

The Rules tab lists out the details of every POS account mapping rule in the instance. These rules can be easily filtered by entering in a user-defined term in the search bar.

Field

Description

Run All

This will run all active rules against all unapproved Daily Sales Summary records. Click here to learn more about running a Rule.

+Add

This will enable the user to create a new rule. Click here to learn how to create a new Rule.

Checkbox

Check to select a row. Check multiple checkboxes to enable bulk edit options. 

Type

The type of POS Account. Options include:

  • Payment Type

  • Sales Account

  • Job Title

Status

The status of the rule, which will display as either active or inactive and can be updated individually via the Rule Context Menu (#11) or in mass by checking multiple boxes and clicking Group Apply at the bottom of this page.

Rule

The rule made for this POS account type. 

Created Date

The date this rule was created. 

Created By

The name of the User who created this Rule.

Default Rules will have R365 entered for this field.

Last Modified

The date this rule was last modified. 

Modified By

The name of the user or entity who last modified this rule. 

Rule Context Menu

Click to open the rule's context menu. This menu enables the user to conduct the following actions to this POS account rule:

  • Run - This will run the rule against all unapproved Daily Sales Summary records. This should be clicked after the rule's status (#5) is updated to active. Click here to learn more about running a rule.

  • Clone - This will copy the POS account rule's details and allow the user to update any fields to make a new rule. The user will only be able to save the new rule when at least one field has been modified. Click here to learn how to clone a rule.

  • Activate/Deactivate - Click to mark the rule as active or inactive. This will be reflected in the status column. The modified columns will also update with the User's information.

  • Delete - This will delete the rule.

Refresh

Click to refresh the rules list. 

Search

Use the search bar to type in keywords to filter the POS account rules based on the entered information.


Default Rules

R365 provides default Rules to assist in mapping common POS Accounts imported from the POS. Click here to learn about the Default POS Account Rules.


Create and Edit a Rule

POS Account Rules will need to be created to match the unmapped POS Accounts that are included on the Daily Sales Summary. Click here to learn how to create, clone, and edit a POS Account Rule.


Run a Rule

POS Account Rules are automatically ran when a Daily Sales Summary includes an unmapped POS Account. Rules can also be ran manually after a Rule is created or updated. Click here to learn about running POS Account Rules.


Manage POS Accounts

POS Account Settings can be easily updated from the POS Accounts tab. Click here to learn how to update a POS Account.


Was this article helpful?