Sage 100

I am working on a payroll data entry import. The employee department number is not part of the import data worksheet. In import job maintenance, the import definition lets you choose Department_No and a file assign, but I am not getting it to work. Has anyone had success with this?

P/R now comes with a bunch of pre-designed VI imports. Chose the Import Jobs task from VI and browse to the PR program folder. You should see a .EXP file with about 5-6 jobs you can import into VI. You can perhaps use one of these as a basis for you own import.

@BillPfahnl I didn't know about the Payroll VI Imports that come with the module.

What version of Sage?

I guess the question becomes how does the VI know what department to file assign when the employee has not been established? Department and employee # are keys to the employee table. I just do see how it is possible to file assign an unknown value.

@JeffSchwenk is right on mark... Is the client using multiple departments? If not, Assign '00' - if so, things get dicey... are the import files for individual departments or a mix of departments? if its a mix, you are either going to have to change the worksheet creation process to add the department, (might not be possible), or someone will need to massage the worksheet before import and add the departments. (probably a PITA) ... programatic solutions might be possible, depending on what info is in the worksheet.