Payroll Deduction "Flat Amount" and deduction frequency

Hi all you out there in Sage 300 CRE Land!  Hope you are having a great day.

Regarding Payroll Deduction setup.  Is there a way to have a "flat amount" deduction come out of each and every CHECK vs each WEEK automatically?

Asking for a friend ;)

  • 0

    Morning,

    You only need to go the employee setup for which you need to set up the deduction for.  Click on Deductions - Choose the Deduction ID you want to set up. On calculating method choose flat amount.  On amount enter the amount to be deducted. Click on Auto so the program knows it will have to do this automatically every pay period. If you have Calculating Frequency set up to Week change it to Check. Then put a Limit if there needs to be one.  Then change the Limit Period to Check.  Click Accept Table and you are done Slight smile

  • 0 in reply to JanellRosa

    This will only work if there is only one check sequence for that employee that week because flat amounts will only come out of the first check.  If there are more than one check for that employee that week, it won't come out of the other two.

  • 0

    Tell your friend to use a formula to "Lookup" the flat amount.

  • 0

    Start with setting up a Deduct ID, if you don't already have one.  The calc method on that deduct will need to be formula.  Then create a new formula.  It will read LOOKUP(Amount, Employee, and the name of your deduct ID in quotes).  Amount will be from the Employee Deduct record, Employee from the check record, and then the name of you deduct ID.

    Example: LOOKUP(Amount, Employee, "TEST")

    Make sure to go back to your deduct setup and add the formula you just created in the field for the formula.

    Then add that deduct ID to the employee master file.  The calc method can be default since the deduct is set up as formula, add the amount of the deduct, check the auto box and the calc frequency will be check. 

    That way no matter how many different check sequences the employee has in any given week, the deduct will occur for each one.  Let me know if you need any further assistance with this.  [email protected]