Creating Amount Spelling variable expression in Report Designer
Hello Community,
I have been trying out either to modify the $TotalAmountSpelling variable expression in the report designer tool or just create a similar one. But I am unable to get a clear view of what logic shall I apply so that the system generates spellings for amounts.
Hello @Laura02 , Thank you for your prompt response, i am kind of looking if there’s a possibility that we can strike out the “Only” term from the words. How would that be possible. Also, is it possible in the report designer to view/modify the already created variables?
Hello,
You may view and modify previously created variables. Look for Variables Collection by clicking on the Headers, then clicking ...] on Variables (Collection) where it shows in Bold Type:
Editor appears, and you can select to edit, and remove/add new variables:
It sounds like you might be working on the Amount in Words in the AP Check. Here is an example of where to remove “Only”.
Hello,
You may view and modify previously created variables. Look for Variables Collection by clicking on the Headers, then clicking ...] on Variables (Collection) where it shows in Bold Type:
Editor appears, and you can select to edit, and remove/add new variables:
It sounds like you might be working on the Amount in Words in the AP Check. Here is an example of where to remove “Only”.
This is what i found for the Subcontracts (SF) report & have been trying to remove the “only” term. Seems have to develop a new expression but still figuring out the expression.
hello,
If the word “Only” is embedded in a stored field “OrderTotalInWords,” I think you will need to be a developer or know one, in order to remove “Only” from the report in this specific case.
Hello @Laura02 , Thank you for your prompt response, i am kind of looking if there’s a possibility that we can strike out the “Only” term from the words. How would that be possible. Also, is it possible in the report designer to view/modify the already created variables?
Hello @Laura02 ,
i tried with this workaround but I dont know why it only displays for amounts in thousands. It doesn’t display for the amounts which are less than thousands.
Previously it was able to display for thousands but now not able to display for any of those.
Previously it was able to display for thousands but now not able to display for any of those.
Hello @Laura02 , I got it achieved. This is what I tried now (used “Replace” expression): = Format('{0} {1},', Replace( $TotalAmountSpelling, 'Only', '' ),$CurrencyName) +'{br}' + Format ('({0} {1}),', $CurrencySymbol, $TotalAmount)