Seeking assistance with this 2 issues am facing in a process am designing.
I have 2 grids in my dynaform, grid 1 is named as debitData and Grid 2 is named creditData, these are for submitting debit and credit entries to a team for processing. In the grids I have amount fields separately for debits and credits, the sum is currently being compared with a code which advises the user with a pop up whether the entry is balanced or unequal when 'Submit' button is clicked, but the case does route to the next step even if the entry is not balanced.
I want to restrict submission to the next step if sum of debit amount does NOT equal sum of credit amount. Is this possible, any ideas please?
Related to the same above issue, I need to allow submission to the next step if sum of debit amount does NOT equal sum of credit amount for only certain GL numbers. Both grids have a GL number text field so for example if a user selects GL number 111 on either grid, on click of submit the case should route to next step even if it is not balanced, but if GL number 222 is selected on either grid, the case should not be able to go to the next step if entry is not balanced.
Any ideas to make this possible please.