2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 - This is an already logged session. _SESSION['dol_login']=martin.d@gs.com.mk _SESSION['dol_entity']=1 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, fk_user_creat as user_creation_id, fk_user_modif as user_modification_id, u.statut as status, u.lang, u.entity, u.datec as datec, GREATEST(u.tms, uef.tms) as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code_user_general, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, s.label as label_establishment, u.fk_establishment FROM llxv3_user as u LEFT JOIN llxv3_user_extrafields as uef ON uef.fk_object = u.rowid LEFT JOIN llxv3_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxv3_c_departements as d ON u.fk_state = d.rowid LEFT JOIN llxv3_establishment as s ON u.fk_establishment = s.rowid WHERE u.entity IN (0, 1) AND u.login = 'martin.d@gs.com.mk' ORDER BY u.entity ASC 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'user' ORDER BY pos 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT param, value FROM llxv3_user_param WHERE fk_user = 1 AND entity = 1 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 DefaultValues::fetchAll 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT rowid, type, user_id, page, param, value FROM llxv3_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,1)) AND (entity IN (0,1))) 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxv3_user_rights as ur, llxv3_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT DISTINCT r.module, r.perms, r.subperms, r.entity FROM llxv3_usergroup_rights as gr, llxv3_usergroup_user as gu, llxv3_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2026-04-15 07:01:38 NOTICE 92.53.60.252 3476991 1006 --- Access to GET /fourn/facture/card.php - action=calculate, massaction= 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT transkey, transvalue FROM llxv3_overwrite_trans where (lang='mk_MK' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position, m.showtopmenuinframe FROM llxv3_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.type DESC, m.position, m.rowid 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'facture_fourn' ORDER BY pos 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 FactureFournisseur::fetch 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.ref_ext, t.entity, t.type, t.subtype, t.fk_soc, t.datec, t.datef, t.tms as datem, t.libelle as label, t.paye as paid, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut as status, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.vat_reverse_charge, t.fk_fac_rec_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.last_main_doc, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_label, cr.libelle_facture as cond_reglement_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_label, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as label_incoterms, t.fk_transport_mode, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llxv3_facture_fourn as t LEFT JOIN llxv3_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llxv3_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN llxv3_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN llxv3_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid = 2288 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 FactureFournisseur::fetch_lines 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT f.rowid, f.ref as ref_supplier, f.description as line_desc, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn, f.fk_remise_except, f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, f.extraparams, p.rowid as product_id, p.ref as product_ref, p.label as label, p.barcode as product_barcode, p.description as product_desc, f.fk_code_ventilation, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llxv3_facture_fourn_det as f LEFT JOIN llxv3_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=2288 ORDER BY f.rang, f.rowid 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, GREATEST(s.tms, sef.tms) as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.phone_mobile, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.birth, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.accountancy_code_customer_general, s.code_compta, s.accountancy_code_supplier_general, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxv3_societe as s LEFT JOIN llxv3_societe_extrafields as sef ON sef.fk_object=s.rowid LEFT JOIN llxv3_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxv3_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxv3_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxv3_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxv3_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxv3_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxv3_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxv3_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 142 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'societe' ORDER BY pos 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 security.lib.php::checkUserAccessToObject::return True 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 FactureFournisseur::fetch 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.ref_ext, t.entity, t.type, t.subtype, t.fk_soc, t.datec, t.datef, t.tms as datem, t.libelle as label, t.paye as paid, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut as status, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.vat_reverse_charge, t.fk_fac_rec_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.last_main_doc, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_label, cr.libelle_facture as cond_reglement_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_label, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as label_incoterms, t.fk_transport_mode, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llxv3_facture_fourn as t LEFT JOIN llxv3_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llxv3_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN llxv3_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN llxv3_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid = 2288 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 FactureFournisseur::fetch_lines 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT f.rowid, f.ref as ref_supplier, f.description as line_desc, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn, f.fk_remise_except, f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, f.extraparams, p.rowid as product_id, p.ref as product_ref, p.label as label, p.barcode as product_barcode, p.description as product_desc, f.fk_code_ventilation, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llxv3_facture_fourn_det as f LEFT JOIN llxv3_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=2288 ORDER BY f.rang, f.rowid 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, GREATEST(s.tms, sef.tms) as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.phone_mobile, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.birth, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.accountancy_code_customer_general, s.code_compta, s.accountancy_code_supplier_general, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxv3_societe as s LEFT JOIN llxv3_societe_extrafields as sef ON sef.fk_object=s.rowid LEFT JOIN llxv3_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxv3_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxv3_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxv3_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxv3_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxv3_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxv3_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxv3_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 142 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 FactureFournisseur::update_price 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 sql=SELECT rowid, qty, pu_ht as up, remise_percent, total_ht, tva as total_tva, total_ttc, total_localtax1 as total_localtax1, total_localtax2 as total_localtax2, tva_tx as vatrate, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, info_bits, product_type, description, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc FROM llxv3_facture_fourn_det WHERE fk_facture_fourn = 2288 ORDER by rowid 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 BEGIN Transaction 2026-04-15 07:01:38 WARNING 92.53.60.252 3476991 1006 We found a rounding difference after line 6736 between HT*VAT=19.44 and total in database=19 (calculated with UP*qty) but diff=-0.44 is too high (> 0.1) to be corrected. Some data in your lines may be corrupted. Try to edit each line manually to fix this before restarting. 2026-04-15 07:01:38 DEBUG 92.53.60.252 3476991 1006 ROLLBACK Transaction 2026-04-15 07:01:38 ERR 92.53.60.252 3476991 1006 Error url=/fourn/facture/card.php?id=2288&action=calculate&token=9a4f3efea1f189b8987d208aa7db53e4&calculationrule=roundoftotal, query_string=id=2288&action=calculate&token=9a4f3efea1f189b8987d208aa7db53e4&calculationrule=roundoftotal, sql=BEGIN, db_error=, msg=We found a rounding difference after line 6736 between HT*VAT=19.44 and total in database=19 (calculated with UP*qty) but diff=-0.44 is too high (> 0.1) to be corrected. Some data in your lines may be corrupted. Try to edit each line manually to fix this before restarting. 2026-04-15 07:01:38 INFO 92.53.60.252 3476991 1006 --- End access to /fourn/facture/card.php 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 - This is an already logged session. _SESSION['dol_login']=martin.d@gs.com.mk _SESSION['dol_entity']=1 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, fk_user_creat as user_creation_id, fk_user_modif as user_modification_id, u.statut as status, u.lang, u.entity, u.datec as datec, GREATEST(u.tms, uef.tms) as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code_user_general, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, s.label as label_establishment, u.fk_establishment FROM llxv3_user as u LEFT JOIN llxv3_user_extrafields as uef ON uef.fk_object = u.rowid LEFT JOIN llxv3_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxv3_c_departements as d ON u.fk_state = d.rowid LEFT JOIN llxv3_establishment as s ON u.fk_establishment = s.rowid WHERE u.entity IN (0, 1) AND u.login = 'martin.d@gs.com.mk' ORDER BY u.entity ASC 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'user' ORDER BY pos 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 sql=SELECT param, value FROM llxv3_user_param WHERE fk_user = 1 AND entity = 1 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 DefaultValues::fetchAll 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, type, user_id, page, param, value FROM llxv3_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,1)) AND (entity IN (0,1))) 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxv3_user_rights as ur, llxv3_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 sql=SELECT DISTINCT r.module, r.perms, r.subperms, r.entity FROM llxv3_usergroup_rights as gr, llxv3_usergroup_user as gu, llxv3_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2026-04-15 07:01:39 NOTICE 92.53.60.252 3476992 1006 --- Access to GET /fourn/facture/card.php - action=, massaction= 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 sql=SELECT transkey, transvalue FROM llxv3_overwrite_trans where (lang='mk_MK' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2026-04-15 07:01:39 DEBUG 92.53.60.252 3476992 1006 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position, m.showtopmenuinframe FROM llxv3_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.type DESC, m.position, m.rowid 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'facture_fourn' ORDER BY pos 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::fetch 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.ref_ext, t.entity, t.type, t.subtype, t.fk_soc, t.datec, t.datef, t.tms as datem, t.libelle as label, t.paye as paid, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut as status, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.vat_reverse_charge, t.fk_fac_rec_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.last_main_doc, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_label, cr.libelle_facture as cond_reglement_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_label, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as label_incoterms, t.fk_transport_mode, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llxv3_facture_fourn as t LEFT JOIN llxv3_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llxv3_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN llxv3_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN llxv3_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid = 2288 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::fetch_lines 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT f.rowid, f.ref as ref_supplier, f.description as line_desc, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn, f.fk_remise_except, f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, f.extraparams, p.rowid as product_id, p.ref as product_ref, p.label as label, p.barcode as product_barcode, p.description as product_desc, f.fk_code_ventilation, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llxv3_facture_fourn_det as f LEFT JOIN llxv3_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=2288 ORDER BY f.rang, f.rowid 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, GREATEST(s.tms, sef.tms) as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.phone_mobile, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.birth, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.accountancy_code_customer_general, s.code_compta, s.accountancy_code_supplier_general, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxv3_societe as s LEFT JOIN llxv3_societe_extrafields as sef ON sef.fk_object=s.rowid LEFT JOIN llxv3_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxv3_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxv3_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxv3_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxv3_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxv3_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxv3_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxv3_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 142 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'societe' ORDER BY pos 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 security.lib.php::checkUserAccessToObject::return True 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::fetch 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.ref_ext, t.entity, t.type, t.subtype, t.fk_soc, t.datec, t.datef, t.tms as datem, t.libelle as label, t.paye as paid, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut as status, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.vat_reverse_charge, t.fk_fac_rec_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.last_main_doc, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_label, cr.libelle_facture as cond_reglement_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_label, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as label_incoterms, t.fk_transport_mode, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llxv3_facture_fourn as t LEFT JOIN llxv3_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llxv3_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN llxv3_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN llxv3_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid = 2288 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::fetch_lines 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT f.rowid, f.ref as ref_supplier, f.description as line_desc, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn, f.fk_remise_except, f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, f.extraparams, p.rowid as product_id, p.ref as product_ref, p.label as label, p.barcode as product_barcode, p.description as product_desc, f.fk_code_ventilation, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llxv3_facture_fourn_det as f LEFT JOIN llxv3_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=2288 ORDER BY f.rang, f.rowid 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, GREATEST(s.tms, sef.tms) as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.phone_mobile, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.birth, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.accountancy_code_customer_general, s.code_compta, s.accountancy_code_supplier_general, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxv3_societe as s LEFT JOIN llxv3_societe_extrafields as sef ON sef.fk_object=s.rowid LEFT JOIN llxv3_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxv3_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxv3_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxv3_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxv3_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxv3_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxv3_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxv3_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 142 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::getSommePaiement 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llxv3_paiementfourn_facturefourn WHERE fk_facturefourn = 2288 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 DiscountAbsolute::getSumCreditNotesUsed 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxv3_societe_remise_except as rc, llxv3_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 2288 AND f.type IN (0,2) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 DiscountAbsolute::getSumDepositsUsed 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxv3_societe_remise_except as rc, llxv3_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 2288 AND f.type = 3 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 DiscountAbsolute::getAvailableDiscounts discount_type=1 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxv3_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 142 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 DiscountAbsolute::getAvailableDiscounts discount_type=1 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxv3_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 142 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%')) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid FROM llxv3_facture_fourn WHERE fk_facture_source = 2288 AND type < 2 ORDER BY fk_statut DESC 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::liste_contact 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, '-1' as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.fk_country as country_id, t.civility as civility, t.lastname as lastname, t.firstname, t.email, t.address, t.zip, t.town, tc.source, tc.element, tc.code, tc.libelle as type_label, co.label as country FROM llxv3_c_type_contact as tc, llxv3_element_contact as ec LEFT JOIN llxv3_user as t on ec.fk_socpeople = t.rowid LEFT JOIN llxv3_c_country as co ON co.rowid = t.fk_country WHERE ec.element_id = 2288 AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'invoice_supplier' AND tc.source = 'internal' AND tc.active = 1 ORDER BY t.lastname ASC 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::liste_contact 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.fk_pays as country_id, t.civility as civility, t.lastname as lastname, t.firstname, t.email, t.address, t.zip, t.town, tc.source, tc.element, tc.code, tc.libelle as type_label, co.label as country FROM llxv3_c_type_contact as tc, llxv3_element_contact as ec LEFT JOIN llxv3_socpeople as t on ec.fk_socpeople = t.rowid LEFT JOIN llxv3_c_country as co ON co.rowid = t.fk_pays WHERE ec.element_id = 2288 AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'invoice_supplier' AND tc.source = 'external' AND tc.active = 1 ORDER BY t.lastname ASC 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 files.lib.php::dol_dir_list path=/home/groupsol/dolibarrdata/fournisseur/facture/8/8/(PROV2288) types=files recursive=0 filter="" excludefilter="(\\.meta|_preview.*\\.png)$" 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT COUNT(rowid) as nb FROM llxv3_links WHERE objecttype = 'invoice_supplier' AND objectid = 2288 AND entity = 1 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::getSommePaiement 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llxv3_paiementfourn_facturefourn WHERE fk_facturefourn = 2288 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 DiscountAbsolute::getSumCreditNotesUsed 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxv3_societe_remise_except as rc, llxv3_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 2288 AND f.type IN (0,2) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 DiscountAbsolute::getSumDepositsUsed 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxv3_societe_remise_except as rc, llxv3_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 2288 AND f.type = 3 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT MAX(te.ref) FROM llxv3_facture_fourn as te WHERE te.ref < '(PROV2288)' AND te.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT MIN(te.ref) FROM llxv3_facture_fourn as te WHERE te.ref > '(PROV2288)' AND te.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid FROM llxv3_facture_fourn WHERE fk_facture_source = 2288 AND type = 2 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Form::load_cache_conditions_paiements 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, code, libelle as label, deposit_percent, entity FROM llxv3_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Form::load_cache_types_paiements 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT id, code, libelle as label, type, entity, active FROM llxv3_c_paiement WHERE entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Translate::getLabelFromKey 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT libelle as label FROM llxv3_c_paiement WHERE code = 'LCR' AND entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Translate::getLabelFromKey 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT libelle as label FROM llxv3_c_paiement WHERE code = 'KLA' AND entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Translate::getLabelFromKey 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT libelle as label FROM llxv3_c_paiement WHERE code = 'SOF' AND entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Translate::getLabelFromKey 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT libelle as label FROM llxv3_c_paiement WHERE code = 'BANCON' AND entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Translate::getLabelFromKey 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT libelle as label FROM llxv3_c_paiement WHERE code = 'IDE' AND entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Translate::getLabelFromKey 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT libelle as label FROM llxv3_c_paiement WHERE code = 'GIR' AND entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Account::fetch 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT ba.rowid, ba.ref, ba.label, ba.bank, ba.number, ba.courant as type, ba.clos as status, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation as address, ba.pti_in_ctti, ba.proprio as owner_name, ba.owner_address, ba.owner_zip, ba.owner_town, ba.owner_country_id, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.fk_accountancy_journal, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, ba.datec as date_creation, ba.tms as date_modification, ba.ics, ba.ics_transfer, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, aj.code as accountancy_journal FROM llxv3_bank_account as ba LEFT JOIN llxv3_c_country as c ON ba.fk_pays = c.rowid LEFT JOIN llxv3_c_departements as d ON ba.state_id = d.rowid LEFT JOIN llxv3_accounting_journal as aj ON aj.rowid=ba.fk_accountancy_journal WHERE ba.entity IN (1) AND ba.rowid = 5 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'bank_account' ORDER BY pos 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llxv3_categorie_supplier_invoice as ct, llxv3_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_supplier_invoice = 2288 AND c.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Translate::loadCacheCurrencies 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT code_iso, label, unicode FROM llxv3_c_currencies WHERE active = 1 AND code_iso = 'MKD' 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT COUNT(ab.rowid) as nb FROM llxv3_accounting_bookkeeping as ab WHERE ab.doc_type = 'supplier_invoice' AND ab.fk_doc = 2288 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT p.datep as dp, p.ref, p.num_paiement as num_payment, p.rowid, p.fk_bank, c.id as payment_type, c.code as payment_code, pf.amount, ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal FROM llxv3_paiementfourn as p LEFT JOIN llxv3_bank as b ON p.fk_bank = b.rowid LEFT JOIN llxv3_bank_account as ba ON b.fk_account = ba.rowid LEFT JOIN llxv3_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llxv3_paiementfourn_facturefourn as pf ON pf.fk_paiementfourn = p.rowid WHERE pf.fk_facturefourn = 2288 ORDER BY p.datep, p.tms 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_invoice_supplier_source FROM llxv3_societe_remise_except as re WHERE fk_invoice_supplier = 2288 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 Product::fetch id=1711 ref= ref_ext= 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT p.rowid, p.ref, p.ref_ext, p.label, p.description, p.url, p.note_public, p.note as note_private, p.customcode, p.fk_country, p.fk_state, p.lifetime, p.qc_frequency, p.price, p.price_ttc, p.price_min, p.price_min_ttc, p.price_base_type, p.cost_price, p.default_vat_code, p.tva_tx, p.recuperableonly as tva_npr, p.localtax1_tx, p.localtax2_tx, p.localtax1_type, p.localtax2_type, p.tosell, p.tobuy, p.fk_product_type, p.duration, p.fk_default_warehouse, p.fk_default_workstation, p.seuil_stock_alerte, p.canvas, p.net_measure, p.net_measure_units, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.last_main_doc, p.surface, p.surface_units, p.volume, p.volume_units, p.barcode, p.fk_barcode_type, p.finished, p.fk_default_bom, p.mandatory_period, p.packaging, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.pmp, p.datec, GREATEST(p.tms, pef.tms) AS tms, p.import_key, p.entity, p.desiredstock, p.tobatch, p.sell_or_eat_by_mandatory, p.batch_mask, p.fk_unit, p.fk_price_expression, p.price_autogen, p.stockable_product, p.model_pdf, p.price_label, p.stock FROM llxv3_product as p LEFT JOIN llxv3_product_extrafields as pef ON pef.fk_object=p.rowid WHERE p.rowid = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'product' ORDER BY pos 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, det FROM llxv3_product_extrafields WHERE fk_object = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT lang, label, description, note as other FROM llxv3_product_lang WHERE fk_product = 1711 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 Product::fetch id=1711 ref= ref_ext= 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT p.rowid, p.ref, p.ref_ext, p.label, p.description, p.url, p.note_public, p.note as note_private, p.customcode, p.fk_country, p.fk_state, p.lifetime, p.qc_frequency, p.price, p.price_ttc, p.price_min, p.price_min_ttc, p.price_base_type, p.cost_price, p.default_vat_code, p.tva_tx, p.recuperableonly as tva_npr, p.localtax1_tx, p.localtax2_tx, p.localtax1_type, p.localtax2_type, p.tosell, p.tobuy, p.fk_product_type, p.duration, p.fk_default_warehouse, p.fk_default_workstation, p.seuil_stock_alerte, p.canvas, p.net_measure, p.net_measure_units, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.last_main_doc, p.surface, p.surface_units, p.volume, p.volume_units, p.barcode, p.fk_barcode_type, p.finished, p.fk_default_bom, p.mandatory_period, p.packaging, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.pmp, p.datec, GREATEST(p.tms, pef.tms) AS tms, p.import_key, p.entity, p.desiredstock, p.tobatch, p.sell_or_eat_by_mandatory, p.batch_mask, p.fk_unit, p.fk_price_expression, p.price_autogen, p.stockable_product, p.model_pdf, p.price_label, p.stock FROM llxv3_product as p LEFT JOIN llxv3_product_extrafields as pef ON pef.fk_object=p.rowid WHERE p.rowid = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, det FROM llxv3_product_extrafields WHERE fk_object = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT lang, label, description, note as other FROM llxv3_product_lang WHERE fk_product = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT code, label, short_label FROM llxv3_c_units where rowid = 40 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 Product::fetch id=1711 ref= ref_ext= 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT p.rowid, p.ref, p.ref_ext, p.label, p.description, p.url, p.note_public, p.note as note_private, p.customcode, p.fk_country, p.fk_state, p.lifetime, p.qc_frequency, p.price, p.price_ttc, p.price_min, p.price_min_ttc, p.price_base_type, p.cost_price, p.default_vat_code, p.tva_tx, p.recuperableonly as tva_npr, p.localtax1_tx, p.localtax2_tx, p.localtax1_type, p.localtax2_type, p.tosell, p.tobuy, p.fk_product_type, p.duration, p.fk_default_warehouse, p.fk_default_workstation, p.seuil_stock_alerte, p.canvas, p.net_measure, p.net_measure_units, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.last_main_doc, p.surface, p.surface_units, p.volume, p.volume_units, p.barcode, p.fk_barcode_type, p.finished, p.fk_default_bom, p.mandatory_period, p.packaging, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.pmp, p.datec, GREATEST(p.tms, pef.tms) AS tms, p.import_key, p.entity, p.desiredstock, p.tobatch, p.sell_or_eat_by_mandatory, p.batch_mask, p.fk_unit, p.fk_price_expression, p.price_autogen, p.stockable_product, p.model_pdf, p.price_label, p.stock FROM llxv3_product as p LEFT JOIN llxv3_product_extrafields as pef ON pef.fk_object=p.rowid WHERE p.rowid = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, det FROM llxv3_product_extrafields WHERE fk_object = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT lang, label, description, note as other FROM llxv3_product_lang WHERE fk_product = 1711 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 Product::fetch id=1711 ref= ref_ext= 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT p.rowid, p.ref, p.ref_ext, p.label, p.description, p.url, p.note_public, p.note as note_private, p.customcode, p.fk_country, p.fk_state, p.lifetime, p.qc_frequency, p.price, p.price_ttc, p.price_min, p.price_min_ttc, p.price_base_type, p.cost_price, p.default_vat_code, p.tva_tx, p.recuperableonly as tva_npr, p.localtax1_tx, p.localtax2_tx, p.localtax1_type, p.localtax2_type, p.tosell, p.tobuy, p.fk_product_type, p.duration, p.fk_default_warehouse, p.fk_default_workstation, p.seuil_stock_alerte, p.canvas, p.net_measure, p.net_measure_units, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.last_main_doc, p.surface, p.surface_units, p.volume, p.volume_units, p.barcode, p.fk_barcode_type, p.finished, p.fk_default_bom, p.mandatory_period, p.packaging, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.pmp, p.datec, GREATEST(p.tms, pef.tms) AS tms, p.import_key, p.entity, p.desiredstock, p.tobatch, p.sell_or_eat_by_mandatory, p.batch_mask, p.fk_unit, p.fk_price_expression, p.price_autogen, p.stockable_product, p.model_pdf, p.price_label, p.stock FROM llxv3_product as p LEFT JOIN llxv3_product_extrafields as pef ON pef.fk_object=p.rowid WHERE p.rowid = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, det FROM llxv3_product_extrafields WHERE fk_object = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT lang, label, description, note as other FROM llxv3_product_lang WHERE fk_product = 1711 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT code, label, short_label FROM llxv3_c_units where rowid = 40 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, emptyonclone, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxv3_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Form::select_produits_fournisseurs_list 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT p.rowid, p.ref, p.label, p.price, p.duration, p.fk_product_type, p.stock, p.tva_tx as tva_tx_sale, p.default_vat_code as default_vat_code_sale, pfp.ref_fourn, pfp.rowid as idprodfournprice, pfp.price as fprice, pfp.quantity, pfp.remise_percent, pfp.remise, pfp.unitprice, pfp.barcode, pfp.multicurrency_code, pfp.multicurrency_unitprice, pfp.fk_supplier_price_expression, pfp.fk_product, pfp.tva_tx, pfp.default_vat_code, pfp.fk_soc, s.nom as name, pfp.supplier_reputation, p.description, u.label as unit_long, u.short_label as unit_short, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.surface, p.surface_units, p.volume, p.volume_units FROM llxv3_product as p LEFT JOIN llxv3_product_fournisseur_price as pfp ON ( p.rowid = pfp.fk_product AND pfp.entity IN (1) ) AND pfp.fk_soc = 142 LEFT JOIN llxv3_societe as s ON pfp.fk_soc = s.rowid LEFT JOIN llxv3_c_units u ON u.rowid = p.fk_unit WHERE p.entity IN (1) AND p.tobuy = 1 ORDER BY pfp.ref_fourn DESC, pfp.quantity ASC 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 CUnits::fetchAll 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT t.rowid, t.code, t.sortorder, t.label, t.short_label, t.unit_type, t.scale, t.active FROM llxv3_c_units as t WHERE 1 = 1 AND (t.scale = 1 AND t.unit_type = 'surface' AND t.active = 1) 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 DolEditor::DolEditor htmlname=dp_desc width= height=100 toolbarname=dolibarr_details uselocalbrowser=1 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 Form::load_cache_vatrates 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT t.rowid, t.type_vat, t.code, t.taux, t.localtax1, t.localtax1_type, t.localtax2, t.localtax2_type, t.recuperableonly FROM llxv3_c_tva as t, llxv3_c_country as c WHERE t.fk_pays = c.rowid AND t.active > 0 AND t.entity IN (1) AND c.code IN ('MK') ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT cc.code FROM llxv3_c_country as cc WHERE cc.eec = 1 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 get_default_tva: seller use vat=1, seller country=MK, seller in cee=0, buyer vat number=MK4032018540057 buyer country=MK, buyer state=0 buyer in cee=0, idprod=0, idprodfournprice=0, SERVICE_ARE_ECOMMERCE_200238EC= 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT t.taux as vat_rate, t.code as default_vat_code FROM llxv3_c_tva as t, llxv3_c_country as c WHERE t.active = 1 AND t.fk_pays = c.rowid AND c.code = 'MK' AND t.entity IN (1) ORDER BY t.use_default DESC, t.taux DESC, t.code ASC, t.recuperableonly ASC LIMIT 1 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 get_product_vat_for_country: ret=18 (DDV) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, label, code FROM llxv3_c_units WHERE active > 0 ORDER BY sortorder 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 DiscountAbsolute::fetch 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT sr.rowid, sr.fk_soc, sr.discount_type, sr.fk_user, sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx, sr.vat_src_code, sr.multicurrency_amount_ht, sr.multicurrency_amount_tva, sr.multicurrency_amount_ttc, sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source, sr.fk_invoice_supplier_line, sr.fk_invoice_supplier, sr.fk_invoice_supplier_source, sr.description, sr.datec, f.ref as ref_facture_source, f.type as type_facture_source, fsup.ref as ref_invoice_supplier_source, fsup.type as type_invoice_supplier_source FROM llxv3_societe_remise_except as sr LEFT JOIN llxv3_facture as f ON sr.fk_facture_source = f.rowid LEFT JOIN llxv3_facture_fourn as fsup ON sr.fk_invoice_supplier_source = fsup.rowid WHERE sr.entity IN (1) AND sr.fk_invoice_supplier_source = 2288 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 files.lib.php::dol_dir_list path=/home/groupsol/dolibarrdata/fournisseur/facture/8/8/(PROV2288) types=files recursive=0 filter="" excludefilter="(\\.meta|_preview.*.*\\.png)$" 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 /core/lib/function2.lib.php::getListOfModels 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llxv3_document_model WHERE type = 'invoice_supplier' AND entity IN (0,1) ORDER BY description DESC 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, tms as date_m, fk_user_c, fk_user_m, acl, position, share FROM llxv3_ecm_files WHERE entity = 1 AND filepath = 'fournisseur/facture/8/8/(PROV2288)' 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 FactureFournisseur::fetchObjectLink 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llxv3_element_element WHERE (fk_source = 2288 AND sourcetype = 'invoice_supplier') OR (fk_target = 2288 AND targettype = 'invoice_supplier') ORDER BY sourcetype 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llxv3_societe as s, llxv3_propal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (142) AND t.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref FROM llxv3_societe as s, llxv3_expedition as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (142) AND t.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llxv3_societe as s, llxv3_commande as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (142) AND t.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llxv3_societe as s, llxv3_facture as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (142) AND t.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total_ht FROM llxv3_societe as s, llxv3_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (142) AND t.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, t.total_ht FROM llxv3_societe as s, llxv3_commande_fournisseur as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (142) AND t.entity IN (1) 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 ActionComm::getActions 2026-04-15 07:01:40 DEBUG 92.53.60.252 3476992 1006 sql=SELECT a.id FROM llxv3_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 2288 AND a.elementtype = 'invoice_supplier' ORDER BY a.datep DESC, a.id DESC 2026-04-15 07:01:40 INFO 92.53.60.252 3476992 1006 --- End access to /fourn/facture/card.php