FrontAccounting forum — Amount in words in Invoice

Re: Amount in words in Invoice

null@example.com (popsicles12) — Mon, 06 Jun 2022 10:51:56 +0000

Hello @Apmuthu,

Thanks for your prompt response always.

I need you to attend to this please. It is possible to have the amount in words like this Two hundred and fifty thousand naira and eighty five Kobo other than the usual NGN: Two hundred and fifty thousand and "85/100".

thanks for always prompt response

Popsicles12

Re: Amount in words in Invoice

null@example.com (popsicles12) — Wed, 04 May 2022 11:35:33 +0000

Hello All,

Thanks for the beautiful feature. I have the Amount in Words working in my invoice print-out. Can any one assist in the changing the fraction side to proper wording.
For example if my currency is Dollar then the fraction is cents. can it be done in such a way that the cents will be in words and not 00/100. NGN: One Hundred and Eighty-Nine Thousand and "00/100".

Thanks.

Popsicles12

Re: Amount in words in Invoice

null@example.com (rafat) — Wed, 20 Dec 2017 08:33:56 +0000

Thanks Stefan.. Commenting the above lines shows the amount in words also in Sales Invoice.

Regards..

Re: Amount in words in Invoice

null@example.com (stefan) — Tue, 19 Dec 2017 19:56:32 +0000

// if (!($document == ST_SUPPAYMENT || $document == ST_CUSTPAYMENT || $document == ST_CHEQUE ))
// return "";

Re: Amount in words in Invoice

null@example.com (rafat) — Tue, 19 Dec 2017 16:51:55 +0000

Stefan,

Which line to comment you are referencing to? Amount in words is important for me because one of my biggest customers insists that I do. BTW I am new to FA and accounting in general. I am running a small business and FA is perfect for me.

Thanks

Re: Amount in words in Invoice

null@example.com (stefan) — Tue, 19 Dec 2017 08:59:48 +0000

@rafat if I remember well there was some session or cache issue with this filtering - delayed change.
If it's still not working and for you amount in words is important, you can simply comment the line and it will be active for all documents.

Re: Amount in words in Invoice

null@example.com (joe) — Mon, 18 Dec 2017 18:25:34 +0000

During the past 10 years this is the first time I hear that this info is needed on an Invoice.

I know that this info on Receipts and Remittances are needed.

Joe

Re: Amount in words in Invoice

null@example.com (apmuthu) — Mon, 18 Dec 2017 18:18:25 +0000

What is the standard procedure to include it in the invoice? Must we edit it like here or in the repXXX file in any different way? Should it be some choice in the company setup as candidates for the sys_prefs table?

Re: Amount in words in Invoice

null@example.com (joe) — Mon, 18 Dec 2017 18:12:32 +0000

Yes, the reason for not including this info on Sales Invoices is that normally you don't like or need this info on Invoices.

Joe

Re: Amount in words in Invoice

null@example.com (apmuthu) — Mon, 18 Dec 2017 15:57:04 +0000

@rafat: FA now uses Sourceforge's Git and is mirrored on GitHub.

If the price hook exists for your locale, then it would automatically come. Only otherwise will the rest of the function price_in_words be executed when the default for the Invoices is needed to be overridden by my mod.

A more elegant mod version for Line 865 would be:

if (!in_array($document, array(ST_SUPPAYMENT, ST_CUSTPAYMENT, ST_CHEQUE, ST_SALESINVOICE))

The function price_in_words() that finally gets invoked if present is available as a skeleton in lang/new_language_template/locale.inc.

@joe: any reason why the Invoice did not default to the words like the others?

Re: Amount in words in Invoice

null@example.com (rafat) — Mon, 18 Dec 2017 13:49:10 +0000

I actually edited the file includes/ui/ui_view.inc and this is a copy of the line at position 865 of the file:

    // Only usefor Remittance and Receipts as default
    if (!($document == ST_SUPPAYMENT || $document == ST_CUSTPAYMENT || $document == ST_CHEQUE || $document == ST_SALESINVOICE))
        return "";
    if ($amount < 0 || $amount > 999999999999)
        return "";
    $dec = user_price_dec();

Re: Amount in words in Invoice

null@example.com (stefan) — Mon, 18 Dec 2017 11:12:00 +0000

You quoted a reply...
What did you do? You tried with the mentioned file from the repo or you changed the code in the file of your system?

If you tried with the mentioned file, it's still not changed to add words to invoices.
You have to find it and change the mentioned code. When reply was made apmuthu mentioned line 793 but it obviously was quoted before some other changes which increased the lines.
As of today it is at line 829.

Re: Amount in words in Invoice

null@example.com (rafat) — Mon, 18 Dec 2017 10:16:09 +0000

Thanks Stefan,

My language is English C both for the user and system and its also the default language. I am just wondering why its only Sales Invoice that does not show.. ? It shows for Remittance, Receipts and checks.

Re: Amount in words in Invoice

null@example.com (stefan) — Sun, 17 Dec 2017 13:26:17 +0000

I don't know about 2.4.3 but first of all check whether it shows when you set user languge and system default language to English 'C' .
If it works - something is wrong with your locale amount in words.

Re: Amount in words in Invoice

null@example.com (rafat) — Sun, 17 Dec 2017 08:24:11 +0000

apmuthu wrote:

Any reason why this has not made it to the HG repo?
The file is:
includes/ui/ui_view.inc and the line to be changed is line no. 793:
     if (!($document == ST_SUPPAYMENT || $document == ST_CUSTPAYMENT || $document == ST_CHEQUE))
to
     if (!($document == ST_SUPPAYMENT || $document == ST_CUSTPAYMENT || $document == ST_CHEQUE || $document == ST_SALESINVOICE))

amount in words does not show in the Sales Invoice, although it shows on the others. Do I need to change something else? I am running FA 2.4.3.

Thanks