Explanation of internal invoice format

Internal invoices are weekly reports of which tools have been out of stock (at a person's or deployed). The rental value is automatically calculated and rounded up to the nearest appropriate unit. This is not an invoice that you have to pay anywhere. The purpose is to help you invoice further costs with tools, for example when renting. It can also serve as a reminder if expensive tools are left unused on a facility somewhere. Perhaps they can be put to better use elsewhere.

You will receive 1 internal invoice per order number/order mark, with all the tools that have been rented out in one or more periods with that order mark last week. «Rented out» here means periods where the tool was not registered in a warehouse.

In each email you will receive the internal invoice in 3 formats: Directly as message text in the email, as a PDF attachment and as a spreadsheet. Some companies send these emails to a common distribution address that goes to all case managers, and from there it is easy for each individual to pick out the cost of «their» orders.

Turn on the Report module, and enter the email(s) in field 2 «Email to receive internal invoice». You can enter multiple emails separated by commas if you want.

See more details at the version links below:

How to import reports into spreadsheets

If you use Libreoffice, Openoffice, Google Sheets or Numbers, you can simply open the CSV file and select UTF-8, comma separated.

Excel is a little different, because it doesn't ask for filter settings when you open CSV, for some reason.
So to open the CSV file in Excel you need to:

1. Open a new spreadsheet
2. Go to Data → Get External Data → From Text

1. Select the CSV file
2. Select encoding UTF8
3. Select separated with characters (not fixed length)

1. Select Comma as the only field separator (and '' for text; it is usually set there by default)

1. Press Next / Done a couple of times

Now you can do regular spreadsheet things with the information