Overview
Currently there is not a system report that lists all skip orders with a rental charge in place.
The Skip orders CSV Export also does no contain this data.
The below steps will walk you through creating a Gen1 report which will provide the required data.
Creating the Report
Hover on Reports and Click on View More Reports
Click on "Generator 1" in the top-right corner
In the "Title" field enter "Skip Rentals Export Report"
In the "Code" area, paste the below "Report Code" text exactly as it appears.
Click on Create
Click on Report to run the report
The resulting report will list every active skip order that has a rental charge in place. it will include the order number, account and address details, the product on the order, the rental price and the date up it which the rental has been charged.
Report Code
select so.OrderNo, ac.AccountNo, ad.Name as 'Address Name', ad.Line1 as 'Address Line1', ad.Line2 as 'Address Line2', ad.Postcode, uos.Code as 'Unit', soc.PPU,
convert (varchar(10),so.LastRentalChargeDate,103) as 'Last Rental Charge Date' from SkipOrder so
inner join SkipOrderCharges soc on soc.OrderId = so.Id
inner join Product pr on pr.id = soc.ProductId
inner join UnitOfSale uos on uos.id = soc.UnitOfSaleId
inner join account ac on ac.id = so.AccountId
inner join Address ad on ad.id = so.AddressId
where so.Deleted = 0
and soc.Deleted = 0
and so.Status = 0
and uos.Code like 'RENT%'
order by so.OrderNo