LedgerSMB
The foundation for your business
Fork me on GitHub
Re: [devel] Product traceability
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [devel] Product traceability



On søndag den 16. juli 2017 08.30.48 CEST you wrote:
> Hi
> 
> We need to trace to whom we sell our products but I can't find any product
> sales breakdown
> 
> The closest I can find is in Goods and Services -> Reports -> Inventory
> Activity, where I seemingly can see the number of sold items during a time
> period. But when clicking the number, I just get a full list of all
> invoices, NOT only the ones containing the requested part,

The AR Search includes a Partnumer option. But it doesn't work at all. The 
Partnumber entered is never used in the query.

According to the log, this query is fired

SELECT * FROM "public"."report__aa_transactions"('2', NULL, NULL, NULL, NULL, 
NULL, 
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 
'1', '1')

But looking at the definition you can see there's no partnumber parameter, and 
there's no parts table involved in the search. So it's just a fancy front.

-- 
Med venlig hilsen
Kaare Rasmussen, Jasonic

Jasonic:  Nordre Fasanvej 12, 2000 Frederiksberg

_______________________________________________
devel mailing list
..hidden..
https://lists.ledgersmb.org/mailman/listinfo/devel