I have a retail business and I am having great difficulty finding how to access my total sales billed per month, (including tax). The only report/reference to monthly sales invoiced is expressed in net amounts (with all taxes taken off) but I need the total amount billed.
I also would like to check some product sales per month and also cannot find.
In the accounting section, it says it generate sales reports per month, product, etc. However it is in fact the payments received, not the invoices billed (sales). So it is misleading and no use to me.
I thought that should be a basic function for a sales program. If there is an add-on that allows me to get these solutions, I would be glad to know.
thanks Ariffidaali - this is the information I am wanting but I don’t have any special tech knowledge. I have found a way to get the information for Total sales exc. VAT and VAT amounts paid - I just have to then add them. It is my go-around solution whilst I’m waiting for my more talented online Dolibarr friends to generate a report button I can click on:)
I had the same challenge, after looking and trying on diferent tools i landed on one tool called PHPReport maker, its a very good tool to explore and you can use it with basic skills.
SELECT DISTINCT
f.datef AS Date,
s.nom AS Customer_Name,
f.ref_client as Cust_Ref,
p.ref as Item_Code,
p.label as Item_Description,
fd.qty as Qty,
fd.total_ht as Amount,
fd.total_ttc as Amount_VAT,
uc.login as Salesperson,
uc.address as Warehouse
FROM
llx_societe as s
LEFT JOIN llx_categorie_societe as cs ON s.rowid = cs.fk_soc
LEFT JOIN llx_c_country as c on s.fk_pays = c.rowid,
llx_facture as f LEFT JOIN llx_projet as pj ON f.fk_projet = pj.rowid
LEFT JOIN llx_user as uc ON f.fk_user_author = uc.rowid
LEFT JOIN llx_user as uv ON f.fk_user_valid = uv.rowid
LEFT JOIN llx_facture_extrafields as extra ON f.rowid = extra.fk_object , llx_facturedet as fd
LEFT JOIN llx_facturedet_extrafields as extra2 on fd.rowid = extra2.fk_object
LEFT JOIN llx_product as p on (fd.fk_product = p.rowid)
LEFT JOIN llx_product_extrafields as extra3 ON p.rowid = extra3.fk_object
WHERE
f.fk_soc = s.rowid AND f.rowid = fd.fk_facture AND f.entity IN (1) AND f.facnumber not like ‘%PROV%’
ORDER BY f.rowid DESC
I made this module named llstats - Simplified Statistics for a retail company
With on click, you can view sales or purchase orders with month values, and select thirdparties or products, and have full information of your database
Have a try, with this link and use “demo” for login and “demo” for password
