i read through the update.html in detail a couple of times. It seems to me that it does not include the update on database. In 2.1.4 db, there are 70 tables while there are 75 table in 2.2.6 tables.
Baffin
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by btsui
i read through the update.html in detail a couple of times. It seems to me that it does not include the update on database. In 2.1.4 db, there are 70 tables while there are 75 table in 2.2.6 tables.
Baffin
I have been using the FA 2.1.4 and like it very much.
I am trying to upgrade the 2.1.4 to 2.2.6 but have found that the 2.2.6 database struction is different from 2.1.4.
Please advise the procedures to update 2.1.4 db to 2.2.6
Thanks in advance for your help!
The company/X/js_cache directory is double checked writable for www server. Moreover, the the search box in item works on po entry and item maintenance.
Unfortunately, the issue still persists after updated to the new version from CVS!
Yes, the search item list box is checked. After checking in details, I have found that the FA2.1RC works fine with the sample database but not the database upgraded from FA2.0. It seems something wrong with the db. I ran the alter2.1.sql and then forced upgrade on FA2.1RC to upgrade the db. Have I missed anything?
Yes! I followed all the instructions in update.html carefully. Indeed, I had read it many times and ensure every steps are correct. I also run the db upgrade process.
What I mean is:- on the sales order entry page, there is an item code box. Usually, after we enter item code on the box, the system will respond immediatley with the selection/entries updated on the item description, price boxes. This function does not work on my installation whilst it works on FA demo site.
Don't know why, the check item code function does not return any item information after we upgraded to 2.1RC. The demo 2.1 beta on FA website works beautifully but it is not the case at our installation. Does anyone has idea what might be missing?
The item check function on po entry works beautifully however.
Hi Joe,
Thank you so much for your support on my idea and the prompt response on it. As we smooth out all these little wrinkles, FA will be even more user friendly.
Cheers,
baffin
The new version looks beautifully. Nice work!
My fault, I used a wrong terms to explain the issue which caused misunderstanding. Let me explain the issue all over again:-
When we try to create a credit note, we click on the "Supplier Credit Notes" button. The FA will go to a page where list out all delivery items under "Delivery Item Selected For Adding To A Supplier Credit Note". It is where the issue arise. At year end, we have 400+ delivery items which takes more than 3 minutes to list out for selection.
Suggest the FA not to list out all delivery items by default and let the user to specify the period of delivery items to be listed.
Baffin
Thanks! Will give you feedback after testing the demo.
Baffin
Insteading of having FA to list all invoices, I would suggest to let the user to specify the invoice no/date for credit note entry. This should be the simpliest way to resolve this issue.
I think you guys misunderstood the issue. It is not the issue of adding all items. When we try to input a creidt note, the FA will list out all invoices for selection. Imagine when it comes to the fiscal year end, the FA will have to list out the all invoices in this year. This is where the problem arise. In our case, we have about 400 invoices in Year 2008, FA takes about 3 minutes to list all invoices before we can enter a credit note. Hope I explained the issue clearly.
We are trying to create a credit note for a supplier. The FA will list out all invoiced entries of the supplier from the beginning of the current fiscal year. The accumulated entries increases as time evolves.
As it is coming to the end of the fiscal year, we have more than 400 entries for a supplier. It takes almost 3 minutes for FA to respond after we press the Add button. Please help.
Baffin
If one or more items are already received in full (i.e. no outstanding) in one delivery, the "Process Receive Items" is not functional anymore. We are not able to receive other items in next delivery.
I understand your concern. However, this issue can be solved easily if the user is allowed to specify the maximium items to display by themselves. I believe users will love this feature as it will speed up FA a lot. As more more items are invoiced, the number of outstanding received items will be reduced too.
Baffin
Hi Joe, yeah! the 'Add All Items' button is cool. It saves lots of clicks.
The issue we are facing is a little bit complicated. Because we have so many low value items from one single vendors. As the system calls out all items received yet to be invoiced, it slows down the system significantly. One quick solution might be to limit the number of items to be displayed every time (say, 50 or add a box to allow the user decide by himself). Or. add two date boxes to allow the client specify the range of time the items received.
Baffin
I set $go_debug=1 but there is no error reported.
By the way, it also takes about 3 mins to load all these 280+ entries onto the screen when we first select the corresponding vendor.
Baffin
Thanks for your suggestion! Sorry! I don't know how to turn off the Javascript in browser. I am using IE. Please advise.
You are correct! Thanks for your advise on the memory constraint, the reporting function works beautifully after changing the line 61 in class.pdf.inc to:
if ($uni) ini_set("memory_limit", "48M");
Baffin
With go_debug=1, I got the following error message:-
Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /public_html/frontacc/reporting/includes/tcpdf.php on line 4663
However, the error persists even thought I changed to memory_limit = 128M in php.ini
Baffin
Appreciate a lot for your quick actions. I see a great improvement on the UI and new approach in entering Invoice.
However, we still face one critical issue. We are indeed using FA in production. Currently, we have about 280 entries (received items) to be invoiced. It takes about 80 sec for the system to respond everytime we press the Add to Invoice button.
Yeah! Good idea!
One small concern:- The respond of the 'Add Item' button must be fast and instant.
If the 'Add item' button calls the server for repsonse every time, it might rely too much on the internet speed. Or, if a complicated JS is called every time the 'Add Item' button is hit, the response time might be slowed down when there are lots of received items.
Considering somewhere in the world may still using slow speed internet or slow computer, it might be more convenient for having a check box next to each entry and add an 'Add all selected items' button somewhere to allow user to add a bunch of received items into the Invoice in a single time.
As the FA is getting mature, I foresee more more incorporations will use FA for their operations. The design of FA should cater for handling large amount of items/orders with least dependant on internet or computer speed.
The way the system handles sales order and Purchase order is very convenient and speedy. i.e. each item is listed in one row with an edit button that allow us to edit the quantity or price is necessary. When there are several tens of delivered items, it is very annoying by jumping back and forth several tens time especially both price and quantity are correct most of the time.
The supplier invoice process would be much faster if we can select multiple items each time especially when there are lots of received items to be invoiced.
Is there any solution for it?
I have udpated to 2.0.3 recently but the problem still persist. I've found this issue is caused by the encoding setting under the language set up. It works if the encoding is ISO, but turns to blank page it is set to UTF-8. But, I can still print out sales order whether the encoding is set to UTF-8 or ISO.
FrontAccounting forum → Posts by btsui
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.