Deduction Codes - Need help to get sum of multiple deduction amounts

Noe Ramos

I'm helping create a benefit file and have to pull the data directly from lawson.   For example - we have employee 0001 with deduction code ABC and Check Date 11.1.22.   There are two deductions for that employee with that deduction code on that check date.    Example - Deduction Code ABC for $1.00   and Deduction Code ABC for $2.00.     

i want to be able to query by the employee 0001 and date range and regardless of 1 or 20 deduction amount entries I need the query to give me a sum of all the amounts entered.   For my example i want my Lawson_DED_AMT field to give me a final amount after the loop is completed of $3.00 for my example above.  here is what i'm using - 

PROD=LSAPPS&FILE=PAYDEDUCTN&FIELD=EMPLOYEE;DED-CODE;DED-AMT;CHECK-ID;CHECK-DATE&SELECT=EMPLOYEE=<!vEmployee>%26CHECK-DATE%3E%3D<!UTCDateRange>%26DED-CODE%7EFS&OUT=CSV&DELIM=*

i have also created a variable at start  named    vDeductionTotal

right after my Lawson node i have an Assign Node with a string entry

Variable Name:

vDeductionTotal          

Variable Type:

String

Variable Value:

parseFloat(Lawson_DED_AMT).toFixed(2);

Is there anything else i'm missing to get the sum of my records for that field?  Thank you

richard-lyons

You need to initialize vDeductionTotal = 0.00 before your loop, but then during the loop of records you need to add the new DED_AMT to the total.  So, in the assign node where you are setting vDeductionTotal, have that value be vDeductionTotal + parseFloat(Lawson_DED_AMT).

After you are done with the loop, then you can set vDeductionTotal to vDeductionTotal.toFixed(2).

I do have a question.  You have mentioned one deduction code, what if they have several?  Do you want the total per deduction code?  As in:

ABC = 3.00, DEF = 2.00, etc.

If you want the deduction totals per code, then you will need to work with arrays to keep the totals separate.

0904080939293831.xls