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.