Dolibarr ERP & CRM » Bugs » bug #821
'f.facnumber' in accountancyDernières modifications
Répondre
État Détails |
Last Modified On: | 14/04/2013 12:20 | | Submitted by: | David A. G. (braito) |
Submitted on: | 14/04/2013 12:20 | | Dolibarr version: | develop |
PHP version: | | | Database type and version: | |
OS Type/Version: | | | Category: | Other |
Severity: | 3 | |
Summary: | 'f.facnumber' in accountancy |
Description: | SELECT f.rowid, f.facnumber, f.type, f.datef, f.libelle, fd.total_ttc, fd.tva_tx, fd.total_ht, fd.tva as total_tva, fd.product_type, fd.localtax1_tx, fd.localtax2_tx, fd.total_localtax1, fd.total_localtax2, s.rowid as socid, s.nom as name, s.code_compta_fournisseur, p.rowid as pid, p.ref as ref, p.accountancy_code_buy, ct.accountancy_code_buy as account_tva, ct.recuperableonly, ctl1.accountancy_code_buy as account_localtax1, ctl2.accountancy_code_buy as account_localtax2 FROM llx_facture_fourn_det fd LEFT JOIN llx_c_tva ct ON fd.tva_tx = ct.taux AND fd.info_bits = ct.recuperableonly AND ct.fk_pays = '4' LEFT JOIN llx_c_tva ctl1 ON fd.localtax1_tx = ctl1.localtax1 AND ctl1.fk_pays = '4' LEFT JOIN llx_c_tva ctl2 ON fd.localtax2_tx = ctl2.localtax2 AND ctl2.fk_pays = '4' LEFT JOIN llx_product p ON p.rowid = fd.fk_product JOIN llx_facture_fourn f ON f.rowid = fd.fk_facture_fourn JOIN llx_societe s ON s.rowid = f.fk_soc WHERE f.fk_statut > 0 AND f.entity = 1 AND f.type IN (0,1,2,3) AND f.datef >= '20130301000000' AND f.datef <= '20130331235959'
Código devuelto último acceso a la base de datos erróneo: DB_ERROR_NOSUCHFIELD
Información sobre el último acceso a la base de datos erróneo: Unknown column 'f.facnumber' in 'field list'
|
Step to reproduce bug: | |
Etat |
Resolution: | Aucun | | Assigned to: | Aucun |
Status: | Open | |
Commentaires- HENRY Florian 15/04/2013 14:29
- Wich pages ?
Could you give us more dtails ?
|
|
Could you give us more dtails ?