Thanks, Ragu. That was a very good suggestion. I made quite some good progress, and even added PR14 in the flow for good measure! Apparently the State of Arizona uses percentages (of gross taxable wages) for Tax withholding and not absolute figures. So their changes are handled by PR14.
Now, I have some issue with Additional Tax Code/Additional Amount on PR13. One record I am processing fails with the error "Must enter Additional Amount', but there is no Additional Amount in the record. Somehow, there is "EDM_ADDL_TAX_CODEr0 = 2" that appears in the log and I have no clue how it is getting there. My javascript if-else construct results in a space for the Tax_Code:
Evaluating JavaScript expression taxCode = '';
if (formType === 'FEDERAL'
{
if (ForEach_StandardTaxForm_FED_ADDTL_AMT) {
if (ForEach_StandardTaxForm_FED_ADDTL_AMT > '0.00'
{
taxCode = '02';
}
}
} else {
if (ForEach_StandardTaxForm_ST_ADDTL_AMT) {
if (ForEach_StandardTaxForm_ST_ADDTL_AMT > '0.00'
{
taxCode = '02';
}
}
}; to value
Here is the AGS call to PR13:
_PDL=TEST&_TKN=PR13.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&EDM-COMPANY=1&
EDM-EMPLOYEE=147151&LINE-FCr0=C&EDM-DED-CODEr0&EDM-RES-CODEr0=Y&EDM-MARITAL-STATUSr0=01&EDM-EXEMPTIONSr0=1
&EDM-EXEMPT-AMOUNTr0=0&EDM-TAX-EXEMPT-FLGr0&EDM-CERT-CODEr0=%20&EDM-ADDL-TAX-CODEr0&EDM-ADDL-RATEr0=0
&EDM-ADDL-AMOUNTr0=0&_DELIM=%09&_OUT=XML&_EOT=TRUE
Here is a snippet of the log:
LwsnTxn9670_TAX_LOCATIONS = Tax Locations
LwsnTxn9670_EDM_EMPLOYEE = 147151
LwsnTxn9670_EMP_FULL_NAME = Xyz, Abc
LwsnTxn9670_STATE_BUTTON = State Rpt
LwsnTxn9670_STATE_BTN_INDICATOR =
LwsnTxn9670_EMP_TAX_STATE = AR
LwsnTxn9670_PSA_DESCRIPTION = Arkansas
LwsnTxn9670_EMP_WORK_STATE = AR
LwsnTxn9670_PSA1_DESCRIPTION = Arkansas
LwsnTxn9670_EMP_TAX_COUNTY =
LwsnTxn9670_PRX_DESCRIPTION =
LwsnTxn9670_EMP_WORK_COUNTY =
LwsnTxn9670_PRX_DESCRIPTION_1 =
LwsnTxn9670_EMP_TAX_CITY =
LwsnTxn9670_PRX1_DESCRIPTION =
LwsnTxn9670_EMP_WORK_CITY =
LwsnTxn9670_PRX_WC_DESCRIPTION =
LwsnTxn9670_EMP_TAX_SCHOOL =
LwsnTxn9670_PRX_TS_DESCRIPTION =
LwsnTxn9670_EMP_WORK_SCHOOL =
LwsnTxn9670_PRX_WS_DESCRIPTION =
LwsnTxn9670_EMP_WC_STATE = AR
LwsnTxn9670_PSA2_DESCRIPTION = Arkansas
LwsnTxn9670_EMP_EIC_STATUS =
LwsnTxn9670_EMP_EIC_STATUS_XLT =
LwsnTxn9670_GROUP_TYPE = BSI
LwsnTxn9670_EMP_BSI_GROUP =
LwsnTxn9670_TAX_FREQUENCY =
LwsnTxn9670_PT_FROM_PR134 =
LwsnTxn9670_EFFECT_DATE =
LwsnTxn9670_END_DATE =
LwsnTxn9670_EDM_USER_ID =
LwsnTxn9670_DETAIL_SIZE = 4
LwsnTxn9670_LINE_FCr0 = C
LwsnTxn9670_EDM_DED_CODEr0 = 001
LwsnTxn9670_EDM_DED_CODE_SVr0 = 001
LwsnTxn9670_DDC_DESCRIPTIONr0 = FEDERAL WITHHOLDING
LwsnTxn9670_EDM_RES_CODEr0 = Y
LwsnTxn9670_EDM_MARITAL_STATUSr0 = 1
LwsnTxn9670_EDM_EXEMPTIONSr0 = 1
LwsnTxn9670_EDM_EXEMPT_AMOUNTr0 =
LwsnTxn9670_EDM_TAX_EXEMPT_FLGr0 =
LwsnTxn9670_EDM_CERT_CODEr0 =
LwsnTxn9670_EDM_DED_PRIr0 = 1
LwsnTxn9670_EDM_SUB_PRIr0 = 0
LwsnTxn9670_ADDL_EXEMPTIONS_TABr0 = Addl Exemptions2
LwsnTxn9670_EDM_PERS_EXEMPTSr0 =
LwsnTxn9670_EDM_DEPEND_EXEMPTSr0 =
LwsnTxn9670_EDM_ADDL_EXEMPTSr0 =
LwsnTxn9670_EDM_ADDL_EXEMP_AMTr0 =
LwsnTxn9670_ADDL_TAX_INFO_TABr0 = Tax Info 10
LwsnTxn9670_EDM_ADDL_TAX_CODEr0 = 2
LwsnTxn9670_EDM_ADDL_TAX_CODEr0_XLT = Addtl Amt; Tax not > txbl wage
LwsnTxn9670_EDM_ADDL_RATEr0 =
LwsnTxn9670_EDM_ADDL_AMOUNTr0 =
LwsnTxn9670_EDM_FORMULA_NUMBERr0 =