Sage 100

In DFDM, I can change pay rate 1 on an employee to 4 decimal places and it works during data entry. However, I cannot import 4 decimal places through VI - it will truncate to 3. Is there any way to use VI to import 4 decimal places on the pay rate?

Try changing the mask in VI for example ####.#### so that you have 4 places after the decimal

Thanks Lisa, but you will need to tell me how to do that. The only fields I see that have masks are account type fields.

This is probably a data dictionary tweak in order for VI to allow it. What version of MAS? You could try importing the total extended pay field to be what you want and not mess with the hourly rate...

Jeff, it is v2013. Unfortunately, importing the extended pay rate will not be an option for us. We are pulling in hours from SWK Timekeeper, but we need to total amount to match a pre-defined number. We need to adjust pay rate 1 with a VI job based on the number of hours in the period (semi monthly). There's more to it, but that's the gist. Is there any way to tweak the data dictionary?

@AlnoorCassim is our group's resident data dictionary hacker. SWK is not of assistance? So you are paying salaried folks and you need to back into the vacation/sick/ personal and then back into the remaining pay as regular earnings?

To change the number of digits to the right of decimal place for the RATE filed in PR.DATAENT 1. Make a backup of SY0DCT.SOA 2. DFDM SY0DCT.SOA and type in PR.DATAENT 3. Click the Next Record button (or Ctrl-F7) until you find PR.DATAENTB046 4. This is the RATE field for me. If this is not it for you or your field is entirely different, then navigate to the B record you want. 5. Look at screenshot. Where you see the ""53"" is the digits to the left and right of the decimal place 6. Edit Field 1, Start Posn = 38, Len=1 7. Change the 3 to a 4 8. Close the file in DFDM 9. File / Run / SVCMPL to compile 10. Import Job Maintenance 11. Open your job, go to the Data tab. 12. Delete the Rate field (or whatever it was) and add it back. 13. Click Accept and try importing.

And if I remember correctly @AlnoorCassim , don't you have to tweak the DD everytime you install MAS or do a PU upgrade???

If you reinstall the module for which you've tweaked the dictionary for OR install a PU that involves a dictionary change, then yes you have to reapply your dictionary tweak (unless your dictionary tweak was supposed to a one-time deal)

Alnoor, I have followed your instructions carefully but no luck. Everything followed exactly as you described. I am thinking I need to change the dict for the Employee Masterfile (PR1) not data entry. Does this change your instructions?

Maybe you need it in both. I rarely work with P/R so I don't know from an application point of view. DFDM Same SY0DCT but on PR.EMPL I think and look around for the right B record. Then steps 6 - 13

Alnoor. I have found this record: [PR.EMPL B047PAY_RATE1 SNN001092 PAY\RATE 1 01: B ] What should I change here?

Repeat Steps 6 - 13 from above.

Alnoor, Step 6 / 7 said to change a 3 to a 4, but in this record the character was a 2. However, I changed this to a 4 and it now works! Thanks for your help on this. Big thumbs up from me.

The 2 meant Pay Rate 1 in PR.EMPL only had 2 digits right of the decimal place in the dictionary whereas the Rate in PR.DATAENT had 3. Who knew? Glad all is well now.