Data Import Order

When importing data from templates or external systems, follow this order to ensure proper referential integrity:

Phase 1: Setup & Configuration

1. Payroll Setup – Configure system-wide settings first
2. Number Series – Set up all number series for automatic numbering
3. Departments – Create organizational departments
4. Positions – Create position codes with default settings

Phase 2: Pay, Deduction & Benefit Codes (PDB)

1. Pay Codes – Create pay code master records
2. Pay Code Groups – Create groupings and assign pay codes to groups
3. Pay Code Posting Groups – Set up GL account mappings for pay codes
4. Pay Code Posting Setup – Link pay codes to posting groups
5. Deductions – Create deduction master records
6. Deduction Groups – Create groupings and assign deductions to groups
7. Deduction Posting Groups – Set up GL account mappings for deductions
8. Deduction Posting Setup – Link deductions to posting groups
9. Benefits – Create benefit master records
10. Benefit Groups – Create groupings and assign benefits to groups
11. Benefit Posting Groups – Set up GL account mappings for benefits
12. Benefit Posting Setup – Link benefits to posting groups

Phase 3: Payroll Calculation Rules

1. Processing Functions – Define calculation functions with codeunit IDs
2. Processing Parameters – Configure parameters for each processing function
3. Payroll Ruleset Headers – Create ruleset templates
4. Payroll Ruleset Lines – Define calculation steps and priorities within rulesets

Phase 4: Employee Data

1. Employees (Base BC) – Create or verify employee master records exist
2. Employee Positions – Assign employees to positions and departments
3. Employee Allowances – Configure tax allowances per employee (if applicable)
4. Employee Deposits – Set up bank accounts with priorities for each employee
5. Employee PDB Assignments – Override default pay/deduction/benefit assignments per employee

Phase 5: Pay Schedules & Templates (Optional)

1. Pay Schedules – Define pay cycle frequencies (weekly, bi-weekly, monthly)
2. Pay Batch Templates – Create reusable templates for recurring payroll batches

Phase 6: Transactional Data

1. Time Entries – Import historical or current time entries (if using time tracking)
2. Approved Time Entries – Import pre-approved time entries
3. YTD Values – Import year-to-date values for mid-year implementations
4. Income Tax Worksheets – Import historical tax calculation data

Import Considerations

Critical Dependencies:

• ⚠️ Pay Codes must exist before Pay Code Groups can assign members
• ⚠️ Posting Groups must exist before Posting Setup can create mappings
• ⚠️ Processing Functions must exist before Ruleset Lines can reference them
• ⚠️ Positions must exist before Employee Positions can assign them
• ⚠️ Employees must exist before any employee-specific records (deposits, positions, allowances)

Recommended Import Method:

• Use Configuration Packages in Business Central for bulk imports
• Validate each phase before proceeding to the next
• Test with a small subset of records before full import
• Always backup before importing large datasets

Post-Import Validation:

1. Verify all posting setup records have GL accounts assigned
2. Check that all employees have valid positions and departments
3. Confirm all employee deposits have priorities set correctly
4. Test a sample pay batch calculation with imported data
5. Review Payroll Log for any setup warnings or errors