Postive and Negative amounts in GL Transctions
Chris asked 6 years ago
Patrick Roth Staff answered 6 years ago
Yes it handles it fine.
Patrick
eOne
Vernon replied 3 years ago Could you show how it is done?
Chris Hanson Staff answered 6 years ago
One is called fn.POSITIVESOURCE() and the other fn.NEGATIVESOURCE().
Then you can use the positive source function and pass it your source field for the debit, and use the negative source function for the credit in another calculated field. That removes the need for extra lines of code if you had written it all out.
H
Carolyn replied 3 years ago Hi Where can I find a sample or video showing how to use this function?
Vernon replied 3 years ago Can you provide an example — so it can be created?
Russell Delamater replied 3 years ago fn.POSITIVESOURCE() and the other fn.NEGATIVESOURCE(). I assumed this would produce a return value but even after adding a value in the () it is still asking for a return value. What else is it needing?
Patrick Roth Staff replied 3 years ago Russell,
I can take a good guess at what you are trying to say but it helps to give the exact error message and steps to give this error.
All calculations need to return something whether you use a built in function or not.
So most likely you aren’t doing that.
Since these functions do the hard work for you, the calculation is pretty simple.
return fn.PositiveSource(_MYAMOUNT)
replacing my field data with your field data name.
Lorren Zemke Staff answered 3 years ago
How to separate Debits and Credit when the source file has only 1 column