Re: [webERP-users] Error in Customer Transaction inquiries

[Phil D. <ph...@lo...>]

Hi Brian,

I think you may mean CustomerInquiry.php
This bug was squashed a few weeks back see

http://web-erp.svn.sourceforge.net/viewvc/web-erp/trunk/CustomerInquiry.php?r1=4597&r2=4635

SQL should be:

SELECT debtorsmaster.name,
	currencies.currency,
	currencies.decimalplaces,
	paymentterms.terms,
	debtorsmaster.creditlimit,
	holdreasons.dissallowinvoices,
	holdreasons.reasondescription
FROM debtorsmaster INNER JOIN paymentterms
ON debtorsmaster.paymentterms = paymentterms.termsindicator
INNER JOIN holdreasons
ON debtorsmaster.holdreason = holdreasons.reasoncode
INNER JOIN currencies
ON debtorsmaster.currcode = currencies.currabrev
WHERE  debtorsmaster.debtorno = '5004'

I guess you are using an older version? Although I am surprised I 
thought you were using the latest purchase order code.

Phil

On 31/08/11 11:25, Brian May wrote:
> I have a customer that I have never made a invoice for.  When I click on
> customer transaction inquiry from the SelectCustomer.php script and I
> get the following sql error:
>
> For customers that have transactions, things seem to work fine.
>
> *Database Error* : The customer details could not be retrieved by the
> SQL because
> Not unique table/alias: 'debtorsmaster'
>
> *Database SQL Failure* : The SQL that failed was
> SELECT debtorsmaster.name <http://debtorsmaster.name>,
> currencies.currency, currencies.decimalplaces, paymentterms.terms,
> debtorsmaster.creditlimit, holdreasons.dissallowinvoices,
> holdreasons.reasondescription FROM debtorsmaster INNER JOIN paymentterms
> ON debtorsmaster.paymentterms = paymentterms.termsindicator INNER JOIN
> holdreasons ON debtorsmaster.holdreason = holdreasons.reasoncode INNER
> JOIN currencies debtorsmaster.currcode = currencies.currabrev WHERE
> debtorsmaster.debtorno = '5004'
>
> --
> Brian May
>
>
>
>
> ------------------------------------------------------------------------------
> Special Offer -- Download ArcSight Logger for FREE!
> Finally, a world-class log management solution at an even better
> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
> download Logger. Secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsisghtdev2dev
>
>
>
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

-- 
Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz