Skip to content
+1-888-319-3663

COMMUNITY FORUM

Cannot Exit Additional Columns window

Brad asked 6 years ago
If I try to close the Additional Columns Window, I get the message: “Credit: Value of field ‘Debit’ is invalid as it is not set until after this rolling column”.  If i move the Debit Column about the Credit, column, I get the same message but the Debit and Credit labels are reversed.
 
If I validate all of the columns, they all validate successfully.  There is a GP rolling column type in my list and I have tried positioning it at the top, at the bottom and everywhere in-between.
 
Thoughts or suggestions?
Answers
Lorren Zemke Staff answered 6 years ago
Brad,
Are you referencing the GP Rolling Column in one of the calculated columns? If so, this would be your issue. Otherwise it’s a little hard to understand without seeing it. Maybe you can post the debit or credit calculations.
 
Brad replied 6 years ago

I did mention there a GP Rolling Column which is getting the next Voucher number. It does not appear to being referenced by either the Debit or Credit Calculation.

The formula for Debit calculation is :

IF _DEBITCREDIT >= 0 THEN
return _DEBITCREDIT
ELSE
RETURN 0
END IF

and the Credit is:
IF _DEBITCREDIT >= 0 THEN
return 0
ELSE
RETURN fn.abs(_DEBITCREDIT)
END IF


If you would like to submit an answer or comment, please sign in to the eOne portal.