Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Sage 300 ERP Payroll time card import

Posted By Bert McAulay over 8 years ago

I need to set up an import for timecards into Sage 300 payroll. I have gone through the process of manually entering a few timecards and then exporting to Excel. Now I need to figure our which fields really need to be populated by the import file that I will create. Does anyone have the short list of "must have" fields for this to work? Thanks!

0 Michael Cramer over 8 years ago

For hours -- Timecard Header -- EMPLOYEE, PEREND, TIMECARD and Timecard Detail -- EMPLOYEE, PEREND, TIMECARD,LINENUM, CATEGORY, EARNDED, EARDEDDATE, HOURS, OTSCHED, DAYS.
For commissions -- Header the same, and Timecard Detail -- drop EARDEDDATE, HOURS, OTSCHED, DAYS and replace with
RATE.
Use the LAST day of the weekly pay period for the EARDEDDATE, use 7 for the DAYS assuming your overtime schedule is 40 reg
and time and a half for over 40 per week.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Sage 300 ERP Payroll time card import

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING