Sage 100

I am importing auto deduction against the employee. Something I have not done in a very long time. It is asking for calc method and type. These should be a file assign against the deduction masterfile. That file is not available for file assign. Am I missing something?

I am not understanding what you are trying to do. Can you be more specific?

If you mean you are doing this as you are importing into Data Entry, there IS a file assign available for PR.DED. If you mean you're importing into the PR4 file, then nope, no file assign. HOWEVER, I think in the non-framework VI jobs you can still create an Export job and add another link to your file, then turn around and use that link in an import.

Sorry, Detail always helps. I am trying to import deductions in a new implementation to the PR3 Employee Deduction Summary. The calculation method and deduction type are in the deduction masterfile but the deduction masterfile is not available to pick when trying to use a file assign in VI import maintenance in Sage 100 ERP Advanced 2014.

Haven't tested the whole thing, but started a test export using Pr.empded. Had to add a field on the Data tab, then back on the Header tab the Link Files was lit. Chose that, linked from PR.EMPDED to PR.DED using key expression RECORD_TYPE+DEDUCTION_CODE. Accepted this and had it prepare for use. Then exited and started up a new import and that link is now available on a File Assign.

Beth, I am trying to import, not export. I need to get the deduction type needed for the PR3 file from the deduction masterfile because it is not in my source file.

I think Beth is telling you how to get the file available as a link in your import job.

Yeah, that's what Beth is trying to say. The only way to add links is via an Export program, but once it's created, you can use it in an import.

First, I meant PR4 not PR3. Ooopps. I did not realize linking in export program made it available in the import program. I thought they were mutually exclusive. I will try this.

Thank you both. How did I not know this method after all of these years. It is a bit obscure to find but so easy. Awesome! Thank you both for your time.

Interesting that you want to bring the YTD information into Sage with only two days to go. I have never been that brave to populate the tables with VI. I always import into PR Data entry

My goal is to import the clients auto deductions for next year. No year to date info at all. I am bring the deduction code, the fact it is automatic, the amount per pay period, and annual goal when applicable. 401K deductions, allowances and such. Then when I import hours, the auto deduction will pull from PR4 during the import process automatically using the default programming that pulls behind the VI import to prompt for auto deductions.

So you just creating the deductions. Gotcha...