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:

Raporttien tuonti laskentataulukoihin

Jos käytät LibreOfficea, OpenOfficea, Google Sheetsiä tai Numbersia, voit yksinkertaisesti avata CSV-tiedoston ja valita UTF-8, pilkulla erotettu.

Excel on hieman erilainen, koska se ei jostain syystä kysy suodatinasetuksia CSV:tä avatessasi.
Avataksesi CSV-tiedoston Excelissä sinun täytyy:

1. Avaa uusi laskentataulukko
2. Mene kohtaan Tiedot → Nouda ulkoisia tietoja → Tekstistä

1. Valitse CSV-tiedosto
2. Valitse merkistöksi UTF8
3. Valitse erotettu merkeillä (ei kiinteä pituus)

1. Valitse pilkku ainoaksi kenttäerottimeksi (ja '' tekstille; se on yleensä oletuksena)

1. Paina Seuraava / Valmis muutaman kerran

Nyt voit tehdä tavallisia laskentataulukkotoimintoja tiedoilla