Hello everybody,
here is my problem, any help will be wellcome.
When exporting supplier invoices to excel, get an error in the backgroud, the excel file is generated but there is no “ref” (Supplier Invoice Number).
Those are the errors, anyone is getting the same or know the solution?, the excel file is unusable without that info.
Message: Bad value for field with code=f.facnumber. Try to redefine export.
Message: Bad value for field with code=s.cp. Try to redefine export.
Thank you
The same result with customer invoices when exporting to a file.
But the errors are:
Bad value for field with code=f.note (Not in the query)
ad value for field with code=s.tel (Not in the query)
Bad value for field with code=s.ville (Not in the query)
Bad value for field with code=s.cp (Not in the query)
SELECT DISTINCT s.rowid as s_rowid, s.nom as s_nom, s.address as s_address, s.zip as s_zip, s.town as s_town, c.code as c_code, s.siren as s_siren, s.tva_intra as s_tva_intra, f.facnumber as f_facnumber, f.datef as f_datef, f.total as f_total, f.total_ttc as f_total_ttc, f.tva as f_tva FROM llx_societe as s LEFT JOIN llx_c_pays as c on s.fk_pays = c.rowid, llx_facture as f LEFT JOIN llx_paiement_facture as pf ON pf.fk_facture = f.rowid LEFT JOIN llx_paiement as p ON pf.fk_paiement = p.rowid WHERE f.fk_soc = s.rowid AND f.entity = 1
planpc wrote:
Hello again,
does anybody know why could this occur?
I´m testing now, and I think that creating a new export task, the problem is solved, no error in backgroud now.
But I think there is a bug, as it is not possible to export the Invoice number called “ref_supplier” in the database(in supplier invoices).
Just invoice ref, wich is the Dolibarr numeration depending on the mask configured, or the Invoice ID, numeric order, but the really important number, the supplier reference or number invoice is not accesible when exporting.
I´m using V 3.4.1.
Any help to solve this?
Note:
Browsing in the MySQL database, I see:
In the llx_facture_fourn table, there is no row called f.facnumber, I supouse the equilavent row is called ref_supplier, in both cases, there is stored the invoice number.
I added the missing field for 3.4.2 and higher version.
Thank you very much for your help Eldy.
By the way, wich is the best way to know future version launch, is there any rss feed or calendar or something like that?, I appreciate this information.
Regards
