The Business Date Sales by Location Report answers how much each location sold and for how much on each business day. It sums the quantity, the amount and the VAT of the sales that match the filter, and with the default columns splits them by item, user and customer. Open it from Reports → Business Date → Sales by Locations….
It is the Sales by Locations report counted by business day, with user filters added: a business day starts and ends at Business day start/end: in Tools → Settings… → Special (see The business day). With 04:00, a sale saved at 01:30 belongs to the business day before.
Filter
The Business Date Sales by Location Report window opens first. Fill in only the filters you need: an empty filter does not limit the report. Click OK to run the report. Clear empties the filters and sets the check boxes back to their default. The window keeps the last filter you ran.

The check box in front of a filter puts its column in the result. A cleared check box also adds the rows up over that column: with the item and the partner filters cleared, the sales of a location make one row for each user. A text filter finds the values that contain the text. Press F4 or click … to choose from a list.
| Filter | What it limits | Column by default |
|---|---|---|
| Date: | The period, by business day. Choose a period from the list, where Today is the business day that is running now, or Custom Dates and a start and an end date. Without dates the report covers all sales. | Not shown |
| Item code:, Item name:, Item group: | The items. | Shown |
| Barcode:, Catalogue: | The items by barcode or catalogue number. Each adds three columns. | Shown when the item window shows barcodes and catalogue numbers |
| Location:, Location group: | Where the sale was made. | Shown |
| User:, User group: | The user in the User field of the sale. | User: only |
| Partner name:, Partner group: | The customer. | Shown |
| Quantity: | Rows whose Total Qtty equals, not equals, is more than or less than the number you enter. | Shown |
| Item tag:, Location tag:, User tag:, Partner tag: | Listed when such tags exist. They only filter. | No column |
| Lot:, Serial number:, Production date:, Expiration date:, Lot location: | Listed when you work with lots. A shown lot column splits the rows by lot. | Not shown |
The report has no Sort by:. Click a column header in the result to sort by it.
Results
The result opens in its own tab. The example below has Item code:, Item name:, Barcode:, Catalogue:, Partner name:, Partner group: and Location group: cleared, so each location has one row for each item group and user.

| Column | What it shows |
|---|---|
| Date | The business day of the sales on the row. |
| Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Item Group | The item, as it is now in Items. |
| Location, Location Group | The location, as it is now in Locations. |
| User, User Group | The user in the User field of the sale. |
| Partner Name, Partner Group | The customer. |
| Total Qtty | The quantity sold. With the item columns cleared it adds up different items, whatever their Measure:. |
| Amount | The sum of quantity × price, after the discounts of the rows. |
| VAT Amount Included or VAT Amount | The VAT of these sales: part of Amount when prices include VAT, on top of it when they do not. |
How the numbers are counted
- The report counts saved sales from every sale window, for example Sale and Touch Screen, and Consignment Sale. Drafts and sales still pending in another database are left out. An annulled sale no longer exists, so it is not counted.
- Returns and credit notes are not subtracted. See the Returns report for them.
- A sale counts on the business day of the time its rows were saved, not on its Date. A sale saved today with an earlier Date counts today.
- Amount includes VAT when Use prices with included VAT is selected in Tools → Settings… → Special, and is without VAT when it is cleared. The VAT column is hidden when VAT registered is cleared there or all VAT groups are 0%.
- Amounts are in the main currency of the program. A sale made in another currency is counted at the rate saved with it.
- Location, partner, user and item names, codes and groups come from the lists as they are now, not as they were on the day of the sale.
Work with the results
Document opens the print preview of the result with its filters, and Export saves it to a file. Totals adds a row with the totals of Total Qtty, Amount and the VAT. View shows the result as bars or a pie (see View Report Results). Filter → Report Filter shows the filters next to the result and runs it again as you change them, Report Filter as New… opens the result of another filter in a new tab, and Quick Filter searches the text of the rows. Refresh runs the report again. The report can also be a panel of the Dashboard.
Double-click a row or use Actions → Edit to open its location (see Adding, editing and deleting locations).
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Business Date → Sales by Locations… | The report. | Operators (the whole Reports menu) |
| Manage operators and view their operations | The sales of all users. Without it User: is fixed to your name. | Operators |
A user with a Locked partner: or Locked location: in the user’s settings gets that partner or location fixed in the filter.
FAQ
How do I get one total for each location and business day?
Clear all the check boxes except Date:, Location: and Quantity:. Each location then has one row for each business day.
Why are the numbers different from Sales by Locations?
Sales by Locations counts a sale on its Date. This report counts it on the business day it was saved, so the sales after midnight and before Business day start/end: go to the day before.
Where do I see the profit of each location?
In Profit by locations. This report has no purchase prices.