Dolibarr ERP & CRM » Bugs » bug #792
f.facnumber and Error_INVOICE_SUPPLIER_ADDON_NUMBER_NotDefined Latest modifications
Answer now
Snapshot| Details |
| Last Modified On: | 2013-04-04 11:09 | | Submitted by: | David A. G. (braito) |
| Submitted on: | 2013-04-04 11:09 | | Dolibarr version: | develop |
| PHP version: | | | Database type and version: | |
| OS Type/Version: | | | Category: | Module Invoice supplier |
| Severity: | 5 - Major | |
| Summary: | f.facnumber and Error_INVOICE_SUPPLIER_ADDON_NUMBER_NotDefined |
| Description: | f.facnumber is missing when dolibarr try to get the unpaid supplier's invoices.
Error_INVOICE_SUPPLIER_ADDON_NUMBER_NotDefined , I think it's the same error |
| Step to reproduce bug: | f.facnumber appears in the dolibarr's home page.
and Error_INVOICE_SUPPLIER_ADDON_NUMBER_NotDefined appears when i try to paid a invoice supplier. |
| Status |
| Resolution: | None | | Assigned to: | None |
| Status: | Open | |
Comments- David A. G. 2013-04-08 15:21
- Well
I fixed Error_INVOICE_SUPPLIER_ADDON_NUMBER_NotDefine. But, I don't understand why unset the default choice.
f.facnumber is fixed. but, You should check the accountancy module to fix this:
Petición último acceso a la base de datos erróneo: 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, 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 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_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'
|
|
I fixed Error_INVOICE_SUPPLIER_ADDON_NUMBER_NotDefine. But, I don't understand why unset the default choice.
f.facnumber is fixed. but, You should check the accountancy module to fix this:
Petición último acceso a la base de datos erróneo: 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, 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 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_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'