found it. can anybody point me on adjusting the height of the data? i found the column spacing...
2 07/09/2009 10:51:25 am
Topic: Allocation: how to (1 replies, posted in Setup)
what is allocation for? for payment, i have to allocate money for the cheque i issued? the money will be from my bank account?
and why is it that i also need to allocate payments from my customers?
can you suggest on where i can read more info about allocation?
3 07/09/2009 07:15:06 am
Re: Cash Sale Invoice. How to: (27 replies, posted in Accounts Receivable)
i have problems in dealing with cash direct invoice. it says that i have no stocks available, in fact i have available.
i can do direct delivery, but not direct invoice. i have 3 locations, all of the have sufficient stocks.
4 07/09/2009 06:04:35 am
Topic: Check Print Module (6 replies, posted in Modules Add-on's)
I changed the default currency in my bank, but why is it that when printing cheque, it still shows the $ sign?
still trying out this module
5 07/02/2009 12:07:04 am
Re: installation procedure (12 replies, posted in Installation)
FA is for all OS. it's a PHP based. all you need is a webserver with mysql and php. right admins?
6 07/01/2009 07:16:40 am
Re: reinstalling FA (6 replies, posted in Installation)
found another solution:
im using windows with XAMPP.
from the phpmyadmin, i export the data_0 into .sql file and then i empty the new company data and import them from the .sql file, which has all the items, chart of accounts, customers and etc...
i can use this solution with my concern.
the purchasing pricing works well. thanks!
7 07/01/2009 02:37:39 am
Re: reinstalling FA (6 replies, posted in Installation)
what i did, i back up the data_0 sql file, download them and create a new company using these sql file, i got an error:
sql script execution failed in line 1741: you have an error in your sql syntal; check the manual that corresponds to your mysql server version for the right syntax to use near "" at line 7
after comparing with the file, en_US-new.sql, i add some script to my current database and it created the new company smoothly. ( i think i just add: PRIMARY KEY (`issue_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;). after checking, the newly created database has only 66 tables, the default is 70.
is this okay? but i notice the items is not imported with the database. what is included in the importing of database?
thanks! really a great work here.
8 06/30/2009 01:06:01 am
Topic: reinstalling FA (6 replies, posted in Installation)
hi mods,
i have now entries with items, accounts, customers and etc. with version 2.1.2 at 0_, i would like to make a new installation 2.1.3 and import all the items, accounts, customers into the 2.1.3 which will be at Table_1, where table_0 will be the demo account.
what is the process in doing this?
i tried installing the 2.1.3 and import the sql file under the 2.1.2 and it has an error, i don't know the correct way to do it.
thanks
9 06/29/2009 09:11:02 am
Re: error upgrading to 2.1.3 (4 replies, posted in Installation)
Joe,
the version at the lower screen is still
FrontAccounting 2.1.2 - Theme: cool
it won't change to 2.1.3 ?
10 06/29/2009 12:28:16 am
Re: error upgrading to 2.1.3 (4 replies, posted in Installation)
during the force upgrade, i go this error:
Seems that system upgrade to version 2.1 has been performed for this company already.
If something has gone wrong and you want to retry upgrade process you MUST perform database restore from last backup file first.
Database upgrade to version 2.1 failed for company 'Sterling'.
You should restore company database from latest backup file
11 06/29/2009 12:24:54 am
Topic: error upgrading to 2.1.3 (4 replies, posted in Installation)
i got his error during the upgrade. i have no demo account demo.0
when i log in again, the version stays with 2.1.2
DATABASE ERROR : could not get user for admin
error code : 1146
error message : Table 'demo.0_users' doesn't exist
sql that failed was : SELECT * FROM 0_users WHERE user_id = 'admin'
12 06/26/2009 11:31:08 pm
Re: Desperatley trying to get FA to work (11 replies, posted in Installation)
is this problem with the sql database? for me, i just use the default password in the system.
13 06/26/2009 12:26:48 am
Re: UOMs (10 replies, posted in Setup)
hi joe. is this implemented in version 2.1.3? or i should wait for the 2.2?
14 06/12/2009 12:22:18 am
Re: negative inventory adjustment (6 replies, posted in Items and Inventory)
maybe we can have a more easy way to. like it can be made in 1 manufacture only, or maybe something like a repackage type of manufacturing, from a big bulk to smaller sizes... as long as you have the items, it will automatically add to the smaller sizes and deduct from the big bulk
15 06/11/2009 09:57:03 am
Re: UOMs (10 replies, posted in Setup)
cool! hopefully we can have the version 2.2 very soon. more power to you guys!
16 06/11/2009 09:54:39 am
Re: negative inventory adjustment (6 replies, posted in Items and Inventory)
hi joe, this is repacking.
i purchased a 25-kilo item, and i will repack it into 1 and 5 kilos.
17 06/11/2009 06:13:36 am
Re: UOMs (10 replies, posted in Setup)
yup, i tried it and 1/12 will be 0.0833 and the ordering UOM will not be the correct one.
i can wait for the version 2.2, im still exploring the program. Thanks
will be database work if i upgrade to v2.2?
i'll just download the database, install the v2.2 and restore my old database. is this correct?
18 06/11/2009 05:54:04 am
Re: negative inventory adjustment (6 replies, posted in Items and Inventory)
joe, like if i have 5 sacks of the 25-kilo, i'll repack the 25-kilo to few bags of 1-kilo and few of 5-kilo pack.
it won't permit me a negative inventory, or to deduct 1 from the 5 sacks i have.
19 06/10/2009 09:24:19 am
Re: UOMs (10 replies, posted in Setup)
hi joe, i'm confused with the conversion factor.
i am selling at UOM EA at 15
my purchasing price at UOM DOZ, conversion factor 12, cost will be 10 and the price here will be (10x12) 120
is this correct?
20 06/10/2009 06:59:49 am
Topic: negative inventory adjustment (6 replies, posted in Items and Inventory)
in the item adjustment note, what is the positive/negative adjustment for?
my scenario is this:
i need to convert my 25-kilo flour into 1-kilo and 5-kilo packing. In my current system i can adjust the inventory: deduct 1 bag to my 25-kilo and add some 1-kilo and 5-kilo item. in front accouting, i cannot do this, i tried the manufacturing process but this won't work with my system.
Is there a work around for this adjustment?
Thanks,
Zedd
22 06/08/2009 09:35:32 am
Topic: UOMs (10 replies, posted in Setup)
i have items that is by Case, and i can sell it by Piece.
how can i use this item that i buy it from my supplier by Case (12pcs/case), and will sell them either by Piece or Case... and it should reflect in my inventory... maybe per piece.
23 06/01/2009 02:50:18 am
Re: Print out date and time (10 replies, posted in Setup)
hi.
the time is based on mysql or php? i found out that the time front accouting uses is based on GMT+10, and my windows system is GMT+8. i don't know where to change.. either php or mysql ?
24 04/15/2009 01:59:40 am
Re: Print out date and time (10 replies, posted in Setup)
thanks jan, i will try to look for it.
25 04/13/2009 12:37:11 am
Re: Print out date and time (10 replies, posted in Setup)
Jan, why is it that the time is not as server's time?