(4 replies, posted in Banking and General Ledger)

Well I did it in Mysql on a trial verison, and it seems that everything is OK and I can close the year afterwards.  So I will now do it on the real version - of course after making a backup first.

I have what I guess is a once in a lifetime problem with the general ledger.  The government here in Nicaragua decided in December 2012 to change the fiscal year as part of a delayed tax reform.  It was originally from July to June, so I have the ongoing fiscal year defined as 1/7/2012-30/6/2013, and I have already entered transactions in 2013. Now the fiscal year 2012-2 was reduced to 6 months (July to December) and the new fiscal year is from January 1st 2013 to Decmber 31 2013.

As far as I cen see it, there is no way to change the ongoing fiscal year so I can reduce it to 6 months.  And if I go in and code it manually, probably all the posts for 2013 will get lost.

Seems the only solution is to close the fiscal period 2012-2 manually outside the programme and then close again in end June 2013 and open a new fiscal year of only 6 months for July to December 2013.  Not an ideal solution.  Would anyone have a better suggestion?


(17 replies, posted in Reporting)

I have decided to make all the essential management in FA and then use Hoteldruid only for reservations.  It is beyond my capacity, at least for the moment, to try and integrate the two.  What would be needed is essentially an export of the client data from Hoteldruid to FA, so it wouldn't necessary to enter the data twice, and as both are using MySQL I guess it should not be too complicated. So if anybody can do that in an automated way, it would be very nice.

Hi Paul - now in English as asked by the moderator.

I tried to include es_EC.ISO-8859-1 in my "supported.d-local" file and after that the "reconfigure" gave no error.

¿Perhaps you have not installed the locale es_EC?

Try "locale -a" to give you the list of installed languages.  If es_EC does not appear, write :

sudo locale-gen es_EC

to generate the Ecuatorian locale and repeat the "reconfigure".

Hola Paul

Yo traté ahora en mi sistema de incluir es_EC.ISO-8859-1 a mi fichero "supported.d-local" y el "reconfigure" salió sin error.

¿Será que no tienes instalado el locale es_EC?

Intente la orden "locale -a" que te dará la lista de idiomas instalados.  Si no aparece el es_EC, escriba:

sudo locale-gen es_EC

para generar el locale Ecuatoriano y repita el "reconfigure".

Hola Paul

Yo traté ahora en mi sistema de incluir es_EC.ISO-8859-1 a mi fichero

I have FA installed on Linux Mint, and have had a lot of troubles getting FA to display anything but English.  The solution is relatively simple, so I will share it here.

Description of the problem:  In FA, if you go to settings and language, only Chinese locale is shown as "supported".  If you tick the "show unsupported locales" and install the language pack you need (in my case Spanish), nothing changes - the text is still in English only.  After much search and dabbling with the different locale files, I stumbled over the solution.  What happens is that Ubuntu based systems (including Mint) default to Unicode UTF8, and the FA language packages are ISO-8859-1. So this need to be added to the supported locales in Ubuntu/Mint:

Open a terminal and write

sudo gedit /var/lib/locales/supported.d/local

The file should look something like this:

en_US.UTF-8 UTF-8
xx_XX.UTF-8 UTF-8

where xx_XX is your local language (in my case es_Ni i.e. Spanish Nicaragua).

Add the ISO.8859-1 so it looks like this

en_US.UTF-8 UTF-8
xx_XX.UTF-8 UTF-8

Save the file, reconfigure locales with:

sudo dpkg-reconfigure locales

Restart MySQL:

sudo service mysql restart

Open FA and it should now be in your selected language (supposing you have already installed the language and chosen it under "preferences").

smile and smile


(29 replies, posted in Modules Add-on's)

It is probably my lack of experience with MySQL.  My System Administrator in FA is the default 'admin'. I can make the grant all statement on the database in MySQL to this user, but I don't know how the FA-name 'admin' translates into mysql.  I have tried to grant the rights to 'admin'@'localhost', but that did not work.  I also tried to create myself as System Administrator in FA, but to no avail.  Any suggestions regarding who I should grant the rights to in MySQL to make the asset module to install correctly?


(29 replies, posted in Modules Add-on's)

OK.  I shall try to create the trigger and report back.


(29 replies, posted in Modules Add-on's)

Well, I had already set the access.  But I still get the error message: DATABASE ERROR :
At file /var/www/frontaccounting/modules/asset_register/includes/db/assets_db.inc:30:
could not get all assets
error code : 1146
error message : Table 'WyM.0_asset_types' doesn't exist
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE !a.inactive
To manually create the asset table in MySQL I would need to know the structure.


(2 replies, posted in Wish List)

I would agree with Erwin that a preview invoice would be nice.  For use in a hotel application, most hotels let the client see a draft of the invoice first (and sometimes ask him to sign it) before creating the invoice.  If the client does not agree, then it will be necessary to create a Credit Note for the same amount, and then create a new invoice. The only way around it in the present setup is to first create an order, and print this out as the draft invoice for the client to see, and possibly modify this if errors have been made. When he agrees, the next step is to deliver the order, and finally make the invoice.  Then comes the actual payment (normally cash or credit card), which will be one more operation.  All-in-all 4 operations. The whole procedure is, however, a bit too heavy.  So the draft invoice would be nice in the "direct invoice" option.


(17 replies, posted in Reporting)

A solution to this retention question, even if a bit awkward, is to create an extra credit account defined as credit from the tax office, and from which the 1% is paid. This credit is set to zero each time the 1% is paid to the tax office. Only drawback is that the payment format under "purchase" only permits one source of payment, so it has to be done as two operations, first with the payment of the 99% with e.g. a check or bank transfer, and then a new payment operation for the outstanding 1% with a tax credit. A lot of paperwork, but at least it works. However, it might be easier to make a manual ledger entry.


(29 replies, posted in Modules Add-on's)

I have tried the asset module also.  It installs OK and reportedly it is installed and active.  But when I try to register an asset type, I get the following error:
DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'WyM.0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive
Looks as if I should create a new table manually in Mysql.  Would that solve it?


(17 replies, posted in Reporting)

Well I am doing that already in another programme.  I simply post the 1% as part of the payment but as a debt to the tax office and pay the rest by cash or cheque.
Thanks anyway - I shall figure something out.


(17 replies, posted in Reporting)

Thanks for the explanation.  Now it works with automatic crediting to the VAT account.
Works fine also for acquisitions.  Sorry for being a bit slow.
Now, we have a very peculiar system here, where we have to retain 1% on all payments for goods and services and pay them monthly to the tax office as an advance tax payment on behalf of the providers.  Is there any smart way we could implement that so it is done automatically when we pay an invoice, we have put into the system?


(17 replies, posted in Reporting)

Thanks for a quick response.
(i) Where in the set-up do I tell the system to post the VAT on the VAT account number?  I have been trying different options.  In the configuration-tax I have told the system, which accounts are used for invoicing and purchases and the VAT % (15 in Nicaragua), but I can see nowhere where the VAT account can be defined.  "Tax groups"? Or "Tax types"?
(ii) If sales are automatically defined as credits, I will obviously have to make another entry with the payment.
(iii) I shall see if I can find somebody who can give me hand with the php file for the invoice setup.  If I find a solution, I shall send it to you.


(17 replies, posted in Reporting)

Thanks for the answer, which I had overseen. I have contributed to completing the translation of FA into Spanish (Nicaragua), and will now ask the tax services to give me a permission to use the programme for GL. It is working nicely so I don't expect problems there.
I have given the "direct invoice" a try, and despite the oddities with "branches" it works.  Some problems, however:
(i)  Is there a way I can get FA to post the VAT directly to the VAT account, so I don't have to do that manually?
(ii)  Despite having defined the invoice as "cash", FA registers it as a credit.  As most of the sales will be cash or credit card, is there a way to make FA register the sale as going to the cash or bank account?
(iii) As the tax office wants me to use preprinted and prenumbered invoices, I would have to change the layout of the invoice, eliminating the header and invoice number.  I guess there is no other way to do that than to edit the php-files under reporting.


(17 replies, posted in Reporting)

I can see this is an old posting, but my question is a bit similar.  I am looking at the possibility for using FA for back-office operations for a small hotel (17 rooms), we are constructing in Nicaragua.  For the frontdesk, I am looking at php-residence/Hoteldruid (also a LAMP based package).  I am doubting whether to invoice in php-residence (as clients are entered there anyway, when they make a reservation) and then enter these invoices manually in FA (as e.g. weekly sales), or to invoice directly in FA.  However, trying out the direct invoicing under sales in FA, I can see the whole thing is set up for a manufacturing or retail company.  And there are a lot of requirements for setting up branches and accounts for direct costs, that are simply not relevant, but without which you can't make an invoice.  So the conclusion is to invoice outside FA, or is there a short-cut?

I have sent you the updated translation files to contributions@frontaccounting.com.  They are in principle 100% translated and updated to FA version 2.3.10, but they are still defined as es_AR-2.3.0-1, as I am not smart enough to find out how to save them as es_NI-2.3.10 - but it would be nice if you can do that and post them on your site so other Latin Americans can use them and adapt them locally.

Thanks for the tip. I have done the merge and now it looks better.  I shall send you the corrected / updated Argentinean .po file, when I have finished.  If you could then convert it to a Spanish (Nicaragua) one and put it on your site, it would be nice, as there are some idiomatic differences, so the Argentineans may not be completely happy with the update.  As I mentioned, I have not been able to create a functional es_NI .po file, so I am just working on the Argentinean one.

I shall of course send you the files, if I succeed.  I have done as you suggested, added the language (.po and .mo files) manually in FA, however FA continues to mark the language as not installed. Just in case, I tried to open your "empty.po" and save it as es_NI and then install it, but that does not work either. I must obviously be missing something. So I guess I will have to revert to the Argentinean one and edit on that one.

Another thing is that there is quite a lot of text in English that can't be edited in  POedit.  I guess it is because I am working in FA 2.3.10 and the translations are from 2.3.0-1.

That link works, but it does not explain how to create a new language from an existing one.  The link that is broken is this one (On the fawiki page:https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages) :

"If the language file you require doesn't exist on the Sourceforge server you can create your own .po and .mo files using Poedit as indicated here: https://frontaccounting.com/wbt/pages/download/download-languages.php Simply use Poedit to alter an existing .po language file where you wish to change it and save to your new language folder. Then update the language as above. "

What I have done, but I am not sure it is the right way, is simply to open the es_AR .po file in POedit and save it as es_NI.  Then install the es_NI locale and make it default.  FA seems now to use the es_NI file, even if it says that it is not installed (it is actually there in var/www/frontaccounting/lang and seems to be updated when I add new translation with POedit).

I have been trying out FA for a small hotel in Nicaragua (in Ubuntu 11.10).  As it is a requirement here that the accounts be in Spanish, I tried first the Mexican version, but as the translation was quite bad, I changed to the Argentinian one, which turns out to be much better.  I have worked with that one and made changes and additions to the translation with POedit.  I had a lot of difficulties getting the language to actually change, so I had to make Argentinian Spanish the default locale to make it work, but that creates a series of problems for my other programmes (plus that there are idiomatic differences too).  I would therefore like to contribute with a Nicaraguan version of the translation (es_NI), but I am not sure how I can do that based on the Argentinian version (es_AR). I found out, I can't simply change the name of the .po file, but the link on the FA website explaining how to proceed seems to be broken.  Could you give me a link to an explanation on how to contribute with a new translation based on a similar one?