<@ULEFXLCRH> I do not know if there's a better sol...
# suitescriptc
Craig
02/08/2021, 5:40 AM@blue I do not know if there's a better solution but I'd just use a small JS library to create the text and save it in a custom field. Assuming you can find a reliable library / function - this can be done in SuiteScript on whichever record provides fields to your PDF - pretty quick job.
b
blue
02/08/2021, 5:45 AMHi Craig thanks for the input. I was thinking more of a solution using SQL expressions so we don't have to script. There is a sample CASE formula in some SA articles but the output is incorrect so I'm thinking a tweak in the formula is all that's needed.
c
Craig
02/08/2021, 5:46 AMYeah that could work too but for me I wouldn't do it like that because it's not a solution I'm comfortable with
b
blue
02/08/2021, 5:46 AMThis is the formula I got from the SA article btw and just pasted:
CASE WHEN {total}=0 THEN 'ZERO' ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC({total}, 0)),'J'),'JSP') || ' ' || ' ' || {currency} || (CASE WHEN LENGTH(TO_CHAR(REGEXP_REPLACE({total}, '^[0-9]+\.', ''))) = 1 THEN TO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, '^[0-9]+\.', ''), 0)*10),'J'),'JSP') || 'cents' ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, '^[0-9]+\.', ''), 0)),'J'),'JSP') || '(s) Only' END) END
c
Craig
02/08/2021, 5:46 AMIf you ask for a solution in a SuiteScript channel the answer will usually be script
Craig
02/08/2021, 5:46 AMAny reason you're against scripting?
b
blue
02/08/2021, 5:47 AMYes you're correct my bad for posting here...actually I'm not a technical person and our technical resource is still a beginner. We have an external resource but we'd want to avoid external fees so I'm looking at standard solutions for now.
c
Craig
02/08/2021, 5:48 AMYeah I see what you're saying - I do think the statement you posted will be a massive pain to debug - it's cramming a lot of logic into one line.
b
blue
02/08/2021, 5:52 AMI'll keep that in mind. Thanks!
c
Craig
02/08/2021, 5:52 AM@blue if you're happu with the way I'd do it, get your technical guy on here and I'll walk him through it - I'm happy to set 30 mins aside to get on a call with him if you want,.
Craig
02/08/2021, 5:53 AMI don't think it's difficult thing to script as long as you're happy with it being a script.
Craig
02/08/2021, 5:53 AMUp to you.
b
blue
02/08/2021, 5:54 AMThanks for the offer Craig. For now though I don't think she can she's loaded with projects. But I'll DM you if ever thanks!
c
Craig
02/08/2021, 5:54 AMNo worries - in the meantime, you can expect to see a blog post from me walking through a potential solution. I'll ping you a link when it's done in the next week or so 🙂
👀 1
Craig
02/08/2021, 5:55 AMIt's a good topic - never seen this requirement before but I can see why it would be useful.
b
blue
02/08/2021, 5:55 AMWow nice. Thanks so much I'll definitely read it 😄
blue
02/08/2021, 5:55 AMLink to your blog?
b
battk
02/08/2021, 7:10 AMid imagine that this would be something simple for something like https://github.com/yamadapc/js-written-number
s
Selcuk Dogru
02/08/2021, 8:54 AMwhat about using N/format/i18n module? there is format.spellOut method which would work
c
Craig
02/08/2021, 12:58 PM@Selcuk Dogru I didn't know about that function - I'll take a look at it.
Craig
02/08/2021, 1:01 PMIf it does what it says - that removes the requirement for a custom module to convert the number to text - everything stays the same - good find!
s
Selcuk Dogru
02/08/2021, 1:03 PMfor integers it works fine. for decimals, you may need to divide and apply both parts
b
blue
02/20/2021, 9:24 AMHi @Craig just wondering if you wrote that article? Would be interested to read it