Sky evolution 6.1: total amount in words
vdv123456
Posted messages
1
Status
Member
-
Mokhtar -
Mokhtar -
ciel commercial management evolution 6.1
I need help to display the amount in words on my invoices
Thank you
I need help to display the amount in words on my invoices
Thank you
Configuration: Windows XP Firefox 2.0
2 answers
-
In the parameterizable states options folder
YOU select your document
you insert a field by clicking on the ab button
it opens the script editor
in the bottom left, uncheck simple script and type:
Letter([Total Gross Amount TTC],[Currency.KeSys])
you can change Total Gross Amount TTC to the field you want to display in full letters.-
-
-
-
-
A way to bypass the issue
The Letter function uses currency, but we don't have a way to define cents, millimes, cents, or others
the trick is to break the amount into two parts (decimal part + whole part) and concatenate the two parts using the same function and there you go:
it was tested with version 16 and it's OK
"This invoice is set at the sum of: "Letter(Ent([Amount Due\Piece]),"dinars ")" and "Letter((([Amount Due\Piece]*1000)-(Ent([Amount Due\Piece])*1000)),"millimes")"."
-
-