1,551

(4 replies, posted in Items and Inventory)

3 Months requirement.

1,552

(3 replies, posted in Reporting)

Report engine module is unsecure, so guess it is a reason why it is available only in first company.

Janusz

E.g. for apache 2.0/php5 add to /etc/php5/apache2/php.ini:

extension=mysql.so

Janusz

1,554

(16 replies, posted in Report Bugs here)

I don't see the problem here.  If I need to store all sell prices in base currency, in order to make the system work right.  What is the problem with the system doing it for me?

I'm stuck. From your first post I understood the problem is that system does not calculate price automatically 'when you try make a sale...'. I explained why it doesn't and what are rationale behind this.

Now you are talking about storing prices in base currency/pricelist automatically. Ok, this is another preposition. So, when and how it should be calculated to satisfy you?

Janusz

1,555

(9 replies, posted in Accounts Payable)

Yes, this the only way for now, I thnik. It would be good to extend idea of allocation by enabling payment entry against purchase order/GRN as prepayment. So process would look like this:
. After PO/GRN entry we have link to payment against this PO/GRN
. Entered payment is preallocated against this PO/GRN
. When GRN/Invoice is entered the allocation is moved from PO/GRN to GRN/Invoice.
This way we could avoid additional allocation step in mos cases, i.e. when payment is done against some single PO.
Janusz

1,556

(9 replies, posted in Accounts Payable)

I don't know.  If those are really payments you probably should have some related invoices, so you can allocate them together.
Janusz

Maybe mysql interface is switched off in php setup? I see no other reason why php standard l  mysql_connect() function is not visible on your system.
Janusz

1,558

(9 replies, posted in Accounts Payable)

Supplier payments entered via general bank interface are not allocated to transactions, just because you have no way to select transaction for allocation here. If you want allocate payment to transaction in one step use Purchases/Payments to Suppliers instead.
Janusz

1,559

(16 replies, posted in Report Bugs here)

alvin wrote:

If you were to automate this price problem [....]

This is what we want to avoid by clear defaults: automatization of problems wink.

Also what is the Base for auto price calculations: used for in Company Setup?

This is price list selected as base for price calculations, when there is no explicit price set for some items. If you have 'No base price list' here you have all automatic calculations for prices off. Maybe this is your problem? Set it to most complete/often used pricelist.

If you have some base price list set the price selection order described in my previous post is used.

Janusz

Seems you haven't mysql installed?

Janusz

Well, timeout was enlarged to 6s in  2.2.5 and this should be enough in any circumstances, or anyway user interface became unusable. If this still genearte trouble I will think about finding some cure, although it can be difficult.

Janusz

1,562

(4 replies, posted in Installation)

I have enabled uploading images for logged in users, so you should be able to upload the screenshot now.
Janusz

1,563

(16 replies, posted in Report Bugs here)

No, Alvin. I have just explained why it cannot be done automatically: To ensure that  no random price is selected we have to base on clear defaults.  So only three prices are considered as apprioprate:
. Price in customer currency in current pricelist.
. Price in current pricelist in default currency (USD in your case)
. The price in default pricelist and default currency

Such selected price _is_ recalculated to customer currency, so you have not to do it manually.
We cannot use any available price just because we can have 10 different non-default prices for various currencies and there is no way to select the right one as base for final price calculation. We have to avoid any ambiguity here just to avoid mistakes in use.

Janusz

1,564

(9 replies, posted in Wish List)

There is no internal constraints which could make this impossible. The best you can do is download the application, install it and test. For such a big amount of items surely you will want to use 'Search item list' option in company setup (which filter items available in item selectors using pattern entered after space bra  pressed).

Janusz

1,565

(9 replies, posted in Wish List)

Hello Anthony,
thank you for pointing out this outdated information. FrontAccounting has release cycle established a couple of years ago, so point 3. on features page is misleading. I have fixed it. FA is suitable enough for most SME segment companies and non-profit organizations as well. There is lack of some more sophisticated features like batch/serials inventory control needed eg. in food industry, but it has most basic features needed by average business activity.

Janusz

1,566

(6 replies, posted in FA Modifications)

Yes, this have to be timeout. You can fix it about line 39 in utils.js. I will consider changing it in next minor release for all reports.
Janusz

1,567

(6 replies, posted in FA Modifications)

You should set memory_limit to some bigger value in php.ini, or just in config.php, e.g.:

ini_set('memory_limit', '48M');

Janusz

1,568

(16 replies, posted in Report Bugs here)

Maybe I do not understand what is your problem, or you do not understand how the price calculatons work. Let's return to the original report:

I have base currency USD, and currencies HNL, GTQ,  I have a mix of all 3 currencies for sale prices,  When I try to make a sale in GTQ, the items that are priced in HNL, return a 0.00, and when I try to make a sale in HNL, the items priced in GTQ return a price of 0.00

I guess you have only one pricelist and this pricelist is set as default in company settings, right? In this case if you have no price defined in USD (your home currency) there will be no price guessed for GTQ nor HNL. Just because you have no price for this item defined in default currency (USD) , and you have no price defined in your default pricelist (the only you have). If this is the case, this is correct.

Price list do the same thing...print in GTQ, price in HNL show 0.00

When printing in GTQ, you have prices in GTQ, and no price in HNL should be displayed (zero or non zero). In any report all prices should be the same as selected in sales order form.
Janusz

1,569

(16 replies, posted in Report Bugs here)

Just set the price in the target currency for the target price list. Not all can be guessed, nothing can be calculated when there is no data to be calculated from.
Janusz

Most likely it means you have found a bug.
Janusz

1,571

(2 replies, posted in Accounts Receivable)

If you really need this you will have to made some customization in the script.
Janusz

1,572

(6 replies, posted in Setup)

Put it on your server in place of the old one.
Janusz

1,573

(16 replies, posted in Report Bugs here)

Sales price is guessed from base price list as it is set in company setup, and from home currency, so if you have home currency USD in case of lack of price in GTQ it will NOT be guessed from HNL price. The price is guessed only using default currency and/or default price list. This is how the algorithm works - we can guess price only form defaults, not from any random price in database.

Janusz

Well, I can't reproduce the problem. As I said the process works right on demo site - please check there (I have just cleaned up the demo data to make it more usable). You have version 2.2.6 while demo uses 2.2.7, but there was no related changes (I think) in meantime, so this should also not hurt. In fact when you press All control, javascipt fills the input field, so if the value displayed is the same as entered manually, the effect should be the same.

Janusz

1,575

(5 replies, posted in FA Modifications)

Ok, I understand. The implementation need some changes in database, so maybe in next major release.

Janusz