Joe,
I replied to you privately with my database login details so you can see what I'm doing
Stephen
1 09/17/2008 03:27:57 pm
Re: 2.01 not working propperly for me (4 replies, posted in Report Bugs here)
2 09/17/2008 02:46:12 pm
Re: 2.01 not working propperly for me (4 replies, posted in Report Bugs here)
I tried that but get the following error:
Wrong user name or password - Access denied for user 'swake'@'localhost' (using password: YES)
This is even though I am entering the correct details for the database, ans all the appropriate directories specified are fully writable.
I tried creating a new database user and running the update again with the same login error:
If I make a back up of my company SQL files, and do a completely new install will I be able to restore the 1.16 Company SQL files into 2.01?
3 09/17/2008 12:45:07 pm
Topic: 2.01 not working propperly for me (4 replies, posted in Report Bugs here)
I recently upgraded from 1.16 to 2.01.
I followed the instructions on the website to the letter, and I could log in and get to the new main screen of 2.01 without any problems.
As I started to use it and try out various functions, I am continually getting database errors. Examples include:
New Sales Order Entry:
DATABASE ERROR : Customer Record Retreive
error code : 1054
error message : Unknown column '0_sales_types.tax_included' in 'field list'
sql that failed was : SELECT 0_debtors_master.name, 0_debtors_master.address, 0_credit_status.dissallow_invoices, 0_debtors_master.sales_type AS salestype, 0_sales_types.sales_type, 0_sales_types.tax_included, 0_sales_types.factor, 0_debtors_master.curr_code, 0_debtors_master.discount FROM 0_debtors_master, 0_credit_status, 0_sales_types WHERE 0_debtors_master.sales_type=0_sales_types.id AND 0_debtors_master.credit_status=0_credit_status.id AND 0_debtors_master.debtor_no = '1'
Updating Preferences:
DATABASE ERROR : could not update user display prefs for swake
error code : 1054
error message : Unknown column 'show_hints' in 'field list'
sql that failed was : UPDATE 0_users SET prices_dec='2', qty_dec='0', rates_dec='6', percent_dec='1', show_gl='1', show_codes='1', date_format='1', date_sep='0', tho_sep='0', dec_sep='0', theme='default', page_size='A4', show_hints=0 WHERE user_id = 'swake'
Attempting to view transaction detail:
DATABASE ERROR : Cannot retreive a debtor transaction
error code : 1054
error message : Unknown column 'ov_freight_tax' in 'field list'
sql that failed was : SELECT 0_debtor_trans.*, ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total, 0_debtors_master.name AS DebtorName, 0_debtors_master.address, 0_debtors_master.email AS email2, 0_debtors_master.curr_code, 0_debtors_master.tax_id, 0_debtors_master.payment_terms , 0_bank_accounts.bank_name, 0_bank_accounts.bank_account_name, 0_bank_trans_types.name AS BankTransType FROM 0_debtor_trans, 0_debtors_master , 0_bank_trans, 0_bank_accounts, 0_bank_trans_types WHERE 0_debtor_trans.trans_no=17 AND 0_debtor_trans.type=12 AND 0_debtor_trans.debtor_no=0_debtors_master.debtor_no AND 0_bank_trans.trans_no =17 AND 0_bank_trans.type=12 AND 0_bank_trans_types.id = 0_bank_trans.bank_trans_type_id AND 0_bank_accounts.account_code=0_bank_trans.bank_act
I am getting error reports like this on probably about 40-50% of the functions that I am trying to use.
Can someone please advise me how to rectify this?
Thanks
4 09/16/2008 08:57:15 am
Topic: How do I enter a supplier invoice for items received? (1 replies, posted in Accounts Payable)
I am having trouble with supplier invoices. Here is my scenario/problem:
1) I created a purchase order successfully
2) I received items against the purchase order successfully
3) I open up the "Supplier Invoices" link to enter the bill for items received and do the following:
- Click on the edit button for "Received items charged on this invoice"
- The next screen is titled "Select Received Items to Add" and split in 2 parts the top half is titled "Items Charged on this invoice" which is empty and the bottom half titled
"Items Received Yet to be Invoiced" which contains the details of the items I've ordered and received.
I can't see any way of selecting the received items and adding them to the supplier invoice. Is there supposed to be a check box here or something?
There is a screenshot of what I'm looking at here: www.bigrigrecords.net/temp/fascreenshot.png
Can anyone tell me how to get the items onto the supplier invoice?
Thanks
5 06/15/2008 03:13:42 pm
Topic: Customizing Templates (6 replies, posted in Reporting)
Is there anyway to customize the way various forms appear when printed?
I am an Australian user and there is no such thing as VAT so the reference to VAT numbers on the Invoice are invalid.
We do however have to by law call our Invoices a "Tax Invoice" and include our Australian Business Number (ABN).
Is there anyway that this template could be changed to substitute ABN for VAT and change the Invoice heading to "Tax Invoice" ?
I haven't looked at the purchase order yet, but I assume there may be some tweaking required there also.
Is there a quick and easy way to modify this??
Thanks
Stephen