Overview
Weighsoft does not currently have an "Export" option on the Outlets screen (although it has been requested to be added in a future version of the software).
In order to get the information you can either speak to support to get an extract of the data, or follow the below steps to create a report which will export the data for you and can be run at any time going forwards,
Create a Custom Report
To get a "Data Dump" such as this it is usually better to use the "Report Generator 1" which essentially passes a query to the background of the system and displays the response.
Hover on Reports and Click on View More Reports
Click on "Generator 1" in the top-right corner
In the "Title" field enter "Outlet 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
Important: Do not edit the report code text at all without first talking to the Support Team.
β
The code is a query designed to get specific data from the databse itself so any changes must be in the correct format or could potentially casue issues accross the entire system
Report Code
select o.Code, o.Name, o.Address1, o.Address2, o.Address3, o.Town, o.Postcode, o.Telephone, o.Internal, o.ExternalOutlet, l.Description as 'Linked Location', a.Description as 'Set Activity', o.WasteCode,
s.Name as 'Linked Supplier', o.InvoiceName, o.IsDefaultActivity, o.IsDefaultSkipOrder, o.IsDefaultWeighbridgeLocation, o.IsDefaultMaterialOrder, o.IsDefaultHazOrder, o.IsDefaultRMCOrder, o.Deleted, o.LastModified, o.LastModifiedUser, * from Outlet o
left join location l on l.id = o.locationid
left join ActivityCode a on a.id = o.ActivityId
left join Supplier s on s.id = o.supplierid
left join account ac on ac.id = o.customeraccountid
