| Anchor | ||||
|---|---|---|---|---|
|
...
If Open Database Connectivity (ODBC) is used to import data directly to the WSWHSE table, a text note can be entered for a transaction. Two fields, Warehouse Note String and Warehouse Note String2 are used to enter a note. Each field holds a maximum of 255 characters.
| Table of Contents |
|---|
| Anchor | ||||
|---|---|---|---|---|
|
...
Up the Time Sheet Import File
If you are not using ODBC to import data directly to the WSWHSE table, the import file must be created as a tab-delimited or comma-delimited text file. Following is the order required for data entered in the import file. Each record in the file must be entered in the order listed. The text file containing the following fields, including blank fields, must be entered in the order listed, for the system to populate the WSWHSE table and make that data available to TimeTrack.
...
A field must be created for each item listed here. If a field is not used, create a column for it in the timesheet import file and leave it empty. The empty column will be skipped when the file is imported into TimeTrack. Additionally, the import text file should not include the field names. The file should contain just the data to be imported.
| Note | ||
|---|---|---|
| ||
If you create the comma-delimited file with Excel (.csv) and you do not enter the batch ID and week-ending date, Excel does not add commas for those columns and you will have to add them manually. In addition, if you have cost codes that precede with a 0 and start the cost code in Excel with an apostrophe, it will save with the preceding zero. If you open the .csv file back up in Excel it strips out the preceding zero so you will have to be careful about reopening a .csv import file if using Excel. |
...
Perform the following setup procedures before importing a timesheet file.
Step 1: Select TimeTrack Options
- Select Microsoft Dynamics GP > Tools > Setup > TimeTrack > Setup Options.
- Select the following options:
- Under Third Party, mark the Integrate to Fixed Asset Management checkbox if you want to import fixed asset transactions.
- Under Create a GL Journal Entry For, mark the Unbilled Transactions checkbox if you want to create a journal entry for unbilled transactions.
- Under Miscellaneous Items, mark the Create Expense/Travel Transactions checkbox. Fields for importing expense and travel data will be available in TimeTrack.
Step 2: Create a Batch File in Microsoft Dynamics GP
Select Transactions > Payroll > Batches. If a batch is not created, TimeTrack creates a single-use batch file. The message, Created from TimeTrack import, is displayed in the batch comment area.
Step 3: Select Payroll Options in Microsoft Dynamics GP
- Select Setup > Payroll > Payroll > Options.
- Under the Options section, mark the Edit Financial Fields checkbox and the Display Pay Rate on Trx checkbox. When these options are marked, a pay rate amount can be imported. If the options are not marked, the value for the pay code is used as the default value.
...