1

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

Brilliant. I'm glad this helped.

2

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

I've pushed my textcart repository on github there

   https://github.com/elax/fa-textcart

The latest version fixes the Purchase order update problemes. However, this version of textcart is meant to work with my fork of FrontAccountting (which includes a few non-compatible features). An up to date version of text compatible with FA 2.3 should be easily doable by uncherry picking what is specific to my FA fork.

The main update from the version you should have is the ability to set cart parameter (like customer, date, reference) etc from the text cart.

I'm happy to answer any question.

3

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

I managed to fix the update (I actually needed it the other day, to amend the quantity of a purchase order without changing anything else).
I'll push my version probably on github if you are intereset.

/Elax

4

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

Textcart author here,

What do you exactly mean by it doesn't work ?
There is no version specific to work with 2.4.x planned, however I don't think there are fundamental changes between 2.3 and 2.4 which will stop it from working.
I don't use FA 2.4.x but a fork of 2.3.x and I have no plan to upgrade at the moment, therefore I am not planning to upgrade textcart to 2.4. However, I'm happy to provide guindance or help to make it work on 2.4.x

/elax

5

(6 replies, posted in Report Bugs here)

Thank you for your quick answer.
You are right, sorry about that. I have an customed version and haven't  been merging indeed for a while

/Elax

6

(6 replies, posted in Report Bugs here)

Is mantis still the way to submit bugs ?
I've submitted to related to customer credit notes vs invoice and submit a patch for one.
Unfortunately, I don't have the time to investigate the other as I found a easy work around.

Looks good indeed. Thanks

I need to interface FA via a REST API ? I think they are a few modules available to do so.
What is their current status, or which one to use ?

Thanks.

/Elax

I create a new report and some permission on it. Everything works fine : the report works well and only people with the correct permission can launch it. However, How can I disable the actual link to the report ? (In the list report list).

10

(12 replies, posted in Announcements)

I think I already made similar comments, but even though Mega menu are the trends, have to click twice to be able to do everything is a deal breaker for me (and my users).

(I use the executive theme with a dashboard and everything related the current APP on the left).

/Elax

Both (as well as just bank payments).

/Elax

I sometimes enter a payment with the wrong bank account. The problem is most of the transaction are not editable, therefore the only way to correct it is to void the transaction and reenter it. Which takes time and it's another source of error (I often forgot to set the date in the past, meaning I have to void it and reenter it again etc ...).

Is changing the bank account in the database safe or is void/reenter the safest way to fix such mistakes ?

/Elax

13

(2 replies, posted in Accounts Receivable)

I'm not a sure about the Bank account types, but don't use dimensions. Dimensions are a pain, because there is nothing to enforce them and it's really easy to forget to set them or have something overriding the dimension without warning.

To reconcilate, just use a different account per terminal. I have one terminal and have a bank account specific to this terminal (as well has a bank account for "cheque") and it works really well.

/Elax

14

(44 replies, posted in Reporting)

Sorry guys, I've been quite busy recently (I'm still) and don't come often on this forum.
Can someone summarize the situation ? I only use 0-VAT for journal entry and payment/deposit
so some bugs in sales or supplier invoices are possible.

/Elax

15

(44 replies, posted in Reporting)

@apmuthu thanks.

@dls: you might try apmuthu zip.

/Elax

16

(44 replies, posted in Reporting)

dls wrote:

Ok I just got the files from

http://devel.frontaccounting.com/git/?p=fa-stable.git;a=commit;h=481038ba4817907d494aa66fb6a888f1493221b2



I'm running 2.3.22 Do I just copy files from the zip file over my current files?  (backing up current prior)

Are you familiar with git ?
If it's to just to have a look checkout this commit as it is (eventually in another directory).
I don't know if the files have been modified by FA team since i modified them, so I don't know if you can just copy them.
The best would be to merge my branch 2.3.33.

/Elax

17

(44 replies, posted in Reporting)

It does save the net amount in the 0_trans_tax_detais but affect all of those files

config.default.php
gl/gl_bank.php
gl/gl_journal.php
gl/includes/db/gl_db_banking.inc
gl/includes/db/gl_db_trans.inc
gl/includes/ui/gl_bank_ui.inc
gl/includes/ui/gl_journal_ui.inc
includes/ui/items_cart.inc
js/inserts.js

18

(44 replies, posted in Reporting)

apmuthu wrote:

Is the FA v2.3.19 patch in the attached file sufficient to now port to FA v2.3.22+?

What do you mean ?

19

(44 replies, posted in Reporting)

What do you mean ? The data (amount + net_amount) are stored in the in the trans_tax_details which are then used for the tax report . Of course, you need to enter the GL line corresponding to the 0-VAT account.

I remember having to change something to allow 0 amount line to be valild, but I'm pretty sure it's included in the patch.

/Elax

20

(44 replies, posted in Reporting)

I pushed my patch there https://github.com/elax/frontaccounting/tree/gl_tax_support. It's based on FA 2.3.17 so might want to rebase it to the current version, however, to see how it looks and what it does, you can just use as it is.

This patch, as well as allowing 0-VAT transaction, allows to modify net amount if needed, and check that EVERY transaction is properly VATed :ie that the total amount of non-tax account, matches the sum of net amount of tax account.

The way is works, is by adding a new column in payment/deposit/journal entry which correspond to net amount.
For non tax account, nothing change (and the cell in the new column is empty). For tax account, you can specify the amount (as before) AND the net amount (or taxable amount). Both values are automatically prefilled depending on the VAT rate and the total of net amount, already entered in the form.

For example, let's say you buy some stationary for £100 (ex VAT).
the first GL line is

Account          | Amount | Net Amount |
Stationanry     | 100.00  |                   |

When you enter the line corresponding to the VAT account, it will be automatically prefilled to 20 and 100 (this can be modified) so you'll end up with
Account          | Amount | Net Amount |
Stationanry     | 100.00  |                   |
VAT 20%         |  20.00  |         100.00|

If you select a 0 VAT account, it will be prefilled with 0, 100.  etc ...

At the moment, it doesn't work with quick entry but only for normal payment/deposit and journal entry.
Modifying the way quick entry work to have a 'net amount' option shouldn't be a problem.
At the moment, when I use 0-VAT quick entry, I just add manualy the 0-VAT line (because the validation tells me that I forgot
to "balance" the VAT) and everything is fine.

Disclaimer: I just pulled on old branch from by repository, so It might not work. If it doesn't just ask me. I use it on production every day and it works well (but I can't push my production branch, because it contains other patches)


/Elax

21

(17 replies, posted in FA Modifications)

Try replacing `mysql_real_escape_string` by `db_escape` in includes/db_pager.inc.

I think you are trying to solve problems which don't exist. I agree that FA UI could look slightly nicer, but the only feature which is mising is 'responsiveness'. Everything else is a matter of taste.

You are speaking of UI "principles", but the first principle is probably "to make the user happy", the second , minimize the number of clicks. Your solution is adding  1 or 2 clicks to everything, I don't really see how it follows modern UI principles.

Also, the problem of "digging" under 2 or 3 level of submenu, features you don't use often is: you don't remember where they are and struggle to find them each time you need them.

What you proposed already exists, it was called OpenERP, and now Odoo apparently and as you said, you need 4 clicks to create a new customer (or pretty much everything in fact). I chosed FA vs OpenERP for that reason (and also because it was nightmare to find things in OpenERP).

The question is, why would peoble "buy" the new FA over Odoo ?
It's a bit like saying vim modes sucks, let's create a modeless vim to compete with emacs ... There a market for both editors and there is no need for 2 emacs.

In other, Don't fix it, if it ain't broken ...

/Elax

23

(44 replies, posted in Reporting)

At the moment the net amount is attached to every transaction in the database, so there is no problem record it.
However, there is indeed a problem for Quick Entry. The way my patch work at the moment is, you'll have to enter manually the 0 VAT line (with the required amount). You could indeed forget, but my patch ask you confirmation before commiting an "unbalanced" VAT transaction (ie if all the non-VAT items amount, doesn't match the VAT items net amounts).

/ELax

24

(44 replies, posted in Reporting)

It's easier and more complicated than that.
You can't deduce automatically the net amount from a 0 Vatted transaction, so there is no point to try to do something automatic.
However, if you know the net amount, it's super easy.

The solution is therefore to ask the user (somehow) what is the net amount. What can be automatically is prefill the net amount which is what my patch does. I'll send it to you but I'm really busy at the moment.
Alternatively, you can ask itronics or Joe the patch, I sent it to them a while ago.

/Elax

mkozielski wrote:

My experience with customers is that they don't like that many items in menu. More experienced users have no issue with complicated menu.

I'm a user. I've been using FA several hours a day for years: 3 levels of depths in menu is too much.


Speaking of "customers" there is a difference between doing something "shinyY and  easy to "sell" to new customers and something which is easy and fast to use once people learn to use it.

A good example is animation when closing or opening windows (on window managers). It looks great, is super cool but after 30mn you just realize that waiting 2s to open a window just gets on the way.

If you really need flexibility for the menu, maybe it's better to have hooks that storing them in the db.
Anyway, maybe the solution is just mega menu (which is trendy ;-)).

/Elax