1 Reply by SDC

(7 replies, posted in Installation)

Hi Janusz,

This now works perfectly except for the following couple of field issues.

SQL script execution failed in line 225: Field 'name' doesn't have a default value
--------------------------------------------------------------------------------
SQL script execution failed in line 230: Field 'notes' doesn't have a default value
--------------------------------------------------------------------------------

In alter2.3.sql I added the name and notes fields on lines 225, 230, and 235.

All worked after that.

Many thanks for your help.
Cheers, Steve

Go to forum: Installation

2 Reply by SDC

(7 replies, posted in Installation)

Many thanks Janusz, I'm not setup for CVS and as I use windows, looks a bit of a pain to configure.... Is there any way of getting the code I need or do you know when the next stable release will be put out?

Thanks in advance
Cheers, Steve

Go to forum: Installation

3 Reply by SDC

(6 replies, posted in Accounts Payable)

Hi Joe, I'm struggling to install 2.3 RC2 at the moment (discussed in a seperate thread) however to get FA running quickly can I use these two files with 2.2.11 ?

Thanks in advance..
Cheers, Steve

Go to forum: Accounts Payable

4 Reply by SDC

(7 replies, posted in Installation)

Thanks Janusz, this worked ok but now it has tripped up on a couple more issues.

The first is the update_totals section of the alter2.3.php. This section fails with....

FATAL : sales order return nothing - etc etc.

...when trying to update the second company database I think due to this sql....

SELECT sorder.*, cust.name, cust.curr_code, loc.location_name, cust.discount, stype.sales_type, stype.id AS sales_type_id, stype.tax_included, ship.shipper_name, tax_group.name AS tax_group_name , tax_group.id AS tax_group_id FROM 0_sales_orders sorder, 0_debtors_master cust,0_sales_types stype, 0_tax_groups tax_group, 0_cust_branch branch,0_locations loc, 0_shippers ship WHERE sorder.order_type=stype.id AND branch.branch_code = sorder.branch_code AND branch.tax_group_id = tax_group.id AND sorder.debtor_no = cust.debtor_no AND loc.loc_code = sorder.from_stk_loc AND ship.shipper_id = sorder.ship_via AND sorder.trans_type = '30' AND sorder.order_no = '1'

It looks like there is a table prefix issue here because even for the second company the sql it trying to select from company 0_

The var TB_PREF seems to come from the logged in user (which when upgrading is 0_) and there seems to be other references to it which generates these errors in the error.log....

[12-Oct-2010 07:28:36] 0:admin:cart_class.inc:403:[before upgrade] Invalid argument supplied for foreach()
[12-Oct-2010 07:28:36] 0:admin:cart_class.inc:463:[before upgrade] Invalid argument supplied for foreach()

Also another issue seems to be with the trans_link column as below.

DATABASE ERROR : Parent document numbers cannot be retrieved
error code : 1054
error message : Unknown column 'trans_link' in 'field list'
sql that failed was : SELECT trans_link FROM 0_debtor_trans WHERE trans_no='5' AND type='10' AND trans_link!=0

...this I got round by deleting the call to drop the trans_link column in the alter2.3php and assume I can drop the column after the upgrade.

Welcome your thoughts.
Cheers, Steve

Go to forum: Installation

5 Reply by SDC

(7 replies, posted in Installation)

Just seen RC2 is release... tried to upgrade but the same issue is present...

Go to forum: Installation

6 Topic by SDC

(7 replies, posted in Installation)

Hi, trying to upgrade FA from 2.2.11 -> 2.3 RC1.

Getting stuck at the database upgrade section.

When installing I get the error....

SQL script execution failed in line 86: Incorrect integer value: '' for column 'length' at row 1

Looking at the alter2.3.sql file at line 59...

INSERT INTO `0_sys_prefs` SELECT 'postal_address','setup.company', 'tinytext','', c.postal_address FROM `0_company` c;

The issue would seem to be that the tinytext length is set to a '' string and not an integer. If I set this to NULL it moves past this error and gets stuck again at another tinytext further down the file.

Is it OK to set these to NULL or should they have a value.... ?

Any other solutions gratefully received smile

Thanks in advance.....
Cheers, Steve

Go to forum: Installation

7 Reply by SDC

(6 replies, posted in Accounts Payable)

Many thanks for the quick response Joe.

I am running Release 2.2.11 and not 2.3 RC1.

Can I stil patch 2.2 with these files or should I go up to 2.3 first ?

I understand that 2.3 fixes the Tax issue on the supplier invoice anyway so probably should move up to that release anyway ? Welcome your thoughts....

Cheers, Steve

Go to forum: Accounts Payable

8 Topic by SDC

(6 replies, posted in Accounts Payable)

Hi, thanks for a great product ... !

When entering the supplier payments we decided to skip the purchase order and go direct for Supplier Invoice, then lodge the payment through "Payments to suppliers"

I understand from other posts that the Tax is not automatically calculated and that I should enter the tax as a seperate line of the supplier invoice. All this seemed fine as we processed the first month.

The issue came when we did a Tax enquiry shown below....

IVA 18% Charged on sales (Output Tax):  3,104.39   17,246.59
IVA 18% Paid on purchases (Input Tax):   644.09      3,578.28
IVA 18% Net payable or collectible:          3,748.48    
    Total payable or refund:                  3,748.48

Although the numbers look fine, it seems to be adding the input and output tax together.

Not sure this is right. I'm posting to the same GL account for both customer and supplier invoices.

Is this the correct method or should I be doing something different?

Thanks in advance
Cheers, Steve

Go to forum: Accounts Payable