Rapports à partir des factures
Proposer des rapports basés sur les factures.
À partir de cette requête:
select llx_facture.ref as FactureRef, datef as DateFacture, llx_facture.fk_statut as StatutFacture, llx_societe.nom as Tiers, llx_facture.total_ttc as TotalFactureTTC, llx_product.ref as ProductRef, llx_product_extrafields.pickup_pbrand as Marque, llx_product.weight as Poids, llx_product.weight_units as UniteProids, llx_facturedet.qty as Quantite, llx_facture_extrafields.rental_doc as FactureLocation, llx_product_extrafields.pickup_deee as DEEE, llx_product_extrafields.pickup_deee_type as TypeDEEE from llx_facture left outer join llx_societe on llx_facture.fk_soc = llx_societe.rowid left outer join llx_facturedet on fk_facture = llx_facture.rowid left outer join llx_facture_extrafields on llx_facture.rowid = llx_facture_extrafields.fk_object left outer join llx_product on llx_product.rowid = llx_facturedet.fk_product left outer join llx_product_extrafields on llx_product.rowid = llx_product_extrafields.fk_object where datef >= '2022-01-01' order by FactureRef;
Note: ajouter un filtre pour séparer location/vente, si on détecte l'usage de Dolirent.