It would be great if you could add an optional input for account value functions (e.g., BC.CLOSINGBALANCE) to specify what to return if a value is missing, such as return 0 rather than an error. This would function the same as [if_not_found] in XLOOKUP.
0 Votes
2 Comments
Sorted by
C
Chauncey Beggsposted
2 days ago
I missed that option previously. Thanks for pointing it out! Defaulting to zero should work for my purposes.
0 Votes
It would be great if you could add an optional input for account value functions (e.g., BC.CLOSINGBALANCE) to specify what to return if a value is missing, such as return 0 rather than an error. This would function the same as [if_not_found] in XLOOKUP.
0 Votes
2 Comments
Chauncey Beggs posted 2 days ago
I missed that option previously. Thanks for pointing it out! Defaulting to zero should work for my purposes.
0 Votes
Gabriel Michaud posted 9 days ago
Hi Chauncey,
I missed this post - are you familiar with the "Missing identifier behaviour" in the workbook options? https://help.velixo.com/doc/main/acumatica/options
Do you have a use-case for returning anything other than 0?
Thanks!
1 Votes
Login or Sign up to post a comment