Error Creating New Customer Invoice...

[David R. <dr...@su...>]

Hello all,

V1.8 so far has lived up to all the expectations and more! Many thanks to 
Dieter and all who labor in the testing process.

I have an error that comes up when I try to enter a customer invoice (listed 
in full below). It happens only when billing a PART or ASSEMBLY, *NOT* when 
billing a SERVICE.

I corrected the problem with the following change to IS.pm
LINE 500: AND i.qty < 0			(change to specify 'i.')
LINE 501: AND (i.qty + i.allocated) < 0	(change to specify 'i.')



========================================================
Error!

SELECT i.id, i.qty, i.allocated, i.sellprice,
(SELECT c.accno FROM chart c
WHERE p.inventory_accno_id = c.id)
AS inventory_accno,
(SELECT c.accno FROM chart c
WHERE p.income_accno_id = c.id)
AS income_accno,
(SELECT c.accno FROM chart c
WHERE p.expense_accno_id = c.id)
AS expense_accno
FROM invoice i, parts p
WHERE i.parts_id = p.id
AND i.parts_id = 12356
AND qty < 0
AND (qty + allocated) < 0
ORDER BY id
ERROR: Column 'allocated' is ambiguous 
=============================================
-Dave Ratte
Superior Circuit Technologies, Inc.
321-254-4201 x 204
dr...@su...