[webERP-users] Error in Customer Transaction inquiries

[Brian M. <br...@do...>]

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, 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