Cannot Exit Additional Columns window
Brad asked 8 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?
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 answered 8 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.
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 8 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