The Start CPP Expense Import function enables the user to import payroll expenses such as mileage from a spreadsheet (.CSV) provided by Complete Payroll Processing into the Labor Journal's Other tab. Unlike the CPP Time Import, expenses are imported to a Job, not a Work Order.
The Starter function allows a user to browse to a CPP populated .csv formatted file, open the file and have its contents imported into a data edit screen for review, possible correction and import into the Labor Journal.
When this function is run, it will attempt to derive the appropriate, Payroll Period based on the Effective Date in the .CVS file. If an active Payroll Period is found which includes the Effective Date, the system will use it to generate the Labor Journal entries. If there is not an active Payroll Period that includes the Effective Date, the message Invalid Pay Period will be displayed on the Create CCP Time Expense Entries screen.
Once imported, the expense data will be editable via the Labor Journal just like expenses manually entered into the Labor Journal's Other tab.
The file definition for the .csv (comma separated ASCII) file is as follows. The file should NOT include a header row.
Column 1: Quantity - 999.99 (required)
Column 2: Effective Date- dd/mm/yy (required)
Column 3: Amount (Total) Cost
Column 4: Employee Id
Column 5: Job Id
Column 6: Job Cost Category Id
Column 7: Job Cost Code Id
Column 8: Other Rate Id
Any field that currently defaults when entering expenses into the Labor Journal but not specified in the file layout will continue to default based on current default rules.
Do Skip
Check Do to process this entry; Check Skip to skip this entry.
Emplye Id: - Import Qty: - Import Cost: - Effct. Date: - PayPrd Id:- Import Job Id: - Cost Code: - Cost Cat: - Import Other Rate:
The top row is from the import file, and may not be edited.
Message:
If any problems were encountered with the import file, they will be display here, and the Skip box will be flagged. For example, if the system finds an exact duplicate entry already existing in the Labor Journal, the word “Duplicate” will be displayed on the row and the Do check box will be automatically un-checked.
Emplye Id: - Quantity: - Amount Cost: - Effct. Date: - Pay Period Id:
The bottom row list the SAMPro defaults which will be used for the Labor Journal entries. These fields are display-only and may not be edited.
Job Id: - Cost Code: - Cost Cat: - Other Rate Id:
These fields default from the CCP file, but may be edited if needed.
After verifying the import information and making any necessary corrections, click the GO button. The system will create and post all necessary Labor Journal entries in SAMPro. There will be one Labor Journal Transaction Id for each employee/Payroll Period combination. A message “Successfully imported” will be displayed.