Mapping & Integration
      Back to home
      1. Knowledge Base
      2. Payroll & Employees
      3. Mapping & Integration

      Group Transactions by Location Dimension 

      Overview:   

      • Learn to group payroll transactions by location dimension when importing pay runs into Wiise ERP. 

      Why Group Transactions by Location Dimension?  

      Grouping payroll transactions by location dimensions helps categorise and track payroll costs across different areas of your business. This mapping ensures accurate cost allocation, enables detailed reporting, and supports better analysis of payroll data. 

      5

      Note: This process works only when you’ve enabled Group Transactions by Location Dimension in the Advanced section of the Wiise Payroll Setup. 

      Note: Location-to-dimension mapping applies only when importing a finalised pay run from Wiise Payroll into the payroll journal in Wiise ERP. 

      Note: Dimensions set up in Wiise Payroll must also be manually set up in Wiise ERP. The naming convention must be an exact match.  

      Note: This mapping does not apply to Wiise Timesheets. 

      Before You Begin 

      Complete the following requirements: 

      Once these are complete, proceed with the steps below. 

      How to Group Transactions by Location Dimension?  

      1. In Wiise ERP, select Wiise Payroll on your Wiise landing page. Then, select Locations.   
        3
      2. A list of all locations that you’ve set up in Wiise Payroll is auto synched to Wiise ERP.  
      3. Highlight the location row you want to update.  
      4. Then, select Dimensions from the action menu.  
      5. From the drop-down menu, select either the: 
        1. Dimension-Single: This refers to an individual dimension value that you can assign to the location 
        2. Dimension-Multiple: This refers to multiple dimension values that you can assign to the location 
        3. The Default Dimensions page displays.  

          Note: You can add up to three-dimension codes when you select Dimensions – Multiple.   

        1
      6. Select Edit List to update the default dimensions for your selected location.  
      7. Update the fields: 
        1. Dimension Code: The dimension code is the number or letter series that lets you identify the dimension value. 

          Note: The dimension name must match exactly with what is set in Wiise Payroll and must be created in the Dimensions list in Wiise ERP. 
        2. Dimension Value Code: This represents the category within a dimension.  
        3. Value Posting: Select Code Mandatory.   

          Note: Setting the value posting to Code Mandatory enforces dimension selection on journals and transactions. 
      8. Select OK to continue.   
      9. You've linked Wiise Payroll locations and dimensions to Wiise ERP dimensions. When you import a finalised pay run, payroll transactions will be grouped by the assigned location dimensions. 

      Note: You'll need to repeat this process when you add new locations or dimensions in Wiise Payroll.  You’ll be prompted to assign dimensions to any new locations when you import the pay run.  

      Process a Pay Run 

      Before You Begin 

      Note: When you’ve finalised a pay run in Wiise Payroll, the Pay Run ID gets imported in Wiise ERP

      How to Process a Pay Run with Grouped Transactions? 

      1. Complete steps 1 to 4 from the article Post Payroll Journals. 
      2. Return here to continue the remaining steps. 
      3. Review the payroll journal entries. 
        1 ld2
        Note: You'll need to confirm that the correct dimensions have come through with the imported payroll transactions. 
      4. When you’ve completed your review, select Home. Then, select Post.  
        3
      5. You have the option to either Post, Preview Posting, Post and Print or Test Report.   
      6. A message displays asking if you want to post the journal lines and print the report(s)?  
        4
      7. Select Yes to proceed.  

        Note: Your payroll journals are posted as a debit to PAYG liability and credit to a bank account, which shows the balancing account number. 
      8. You’ve completed the process of posting payroll journals in Wiise.   

      Note: Payroll administrators should verify the accuracy of posted journals by: 

      • Reviewing the G/L account setup against the Pay Run ID and pay amounts. 
      • Checking payroll leave liabilities to ensure the correct dollar value is accrued against each leave category. 

       

      What’s next?  

      Find out how to perform the month-end close.    

        

      If you have any questions, please reach out to support@wiise.com