Don't get lost: Training » Quick Start Guide » Sample Integrations » Sage 300: PJC Timecard Import

PJC Timecard Import

Sage300 PJC Timecard Import (SAMACCPJCTIME)

This imports an Excel file into Sage300 as PJC Timesheets.

The flow of integration:

  1. Read
  2. Hierarchy
  3. Map
  4. Connector

Read

Pulls data from the Excel file.

Hierarchy

Transforms flat dataset into a hierarchical one consisting of the timecard header and the timecard totals.

Map

Adds a single field, Timecard so as to capture the Sage300 Timecard number.

Connector

Maps the data into Sage300.