CAN I EXTRACT A REPORT FOR CHARGES IN LMS?

Messages

Jul 02, 2021 04:31 PM
Sergi. This is the query for the report.
select c.id, c.[name] courier, v.vibno, v.company,

vs.invoiceno, vs.[date],

count(vs.sundryno) Carges_Count, sum(vs.amount) Total_Amount_Charged, STRING_AGG(vs.comment, ',') comments,

po.id Pack_Order, concat(a.apartment, a.address1, a.address2) full_address, a.postcode, a.suburb

from vibsundries vs

inner join couriers c on c.scode = vs.scode

inner join vib v on v.vibno = vs.vibno

left join Packing_OrdersInvoice poi on poi.invoiceno = vs.invoiceno

left join Packing_Orders po on po.id = poi.OrderId

left join Addresses a on a.id = po.idaddresses

where c.id in (333,334)

group by c.id, c.[name], v.vibno, v.company, vs.invoiceno, vs.[date],

a.apartment, a.address1, a.address2, a.postcode, a.suburb, po.id



Feb 24, 2021 10:59 AM
Sergi: Yes sure we will do. this is the main on the request section. All you need to avoid need open a ticket for a simple report. Thanks for this reminder ticker we will do soon as possible.
Feb 24, 2021 10:52 AM
Moving forward, can LMS users extract a report like the one we had for no charges? I was tasked and ordered by Boss Leanne to raise this concern, so moving forward we could have the report on hand right away, and do the checking and charging within the 24 hour period, (timeframe for money issues) without bugging Dev. :)
Please advise. Many thanks!