Lexware Office
Connect NetLock RMM to Lexware Office: device counts become one invoice draft per tenant and month, which a person checks and finishes in Lexware Office.
Lexware Office
NetLock counts the devices of a tenant and creates one invoice draft per tenant and month in Lexware Office. A person checks the draft and finishes it there. NetLock never finishes an invoice and never sends one.
Tax: NetLock does not decide tax questions or calculate tax. This page is not tax advice. Have the tax cases you choose checked by your tax adviser, and check every draft.
Requirements
- A Lexware Office tariff with API access, for example the tariff XL.
- An API key, created at
https://app.lexware.de/addons/public-api. NetLock reads the id of your organization with it; documents belong to that organization and not to a connection. The key cannot be restricted; it has access to the whole account. Lexware may limit how long a key is valid; an expired key appears as rejected credentials. - Your company data in the general settings of Lexware Office. Lexware checks it at the latest when a document is finished.
- A public API token with the scope
usage:read, which the connection creates for you.
Setup
- In
Settings → Integrations, open the Lexware Office tile and chooseConnect. - Enter the
API key. The address of Lexware is fixed and cannot be changed. - Under options, enter a
Closing textif you want one, see Reference. - Map each tenant to a customer contact. Tenants without a mapping are not included. There is no import: an accounting product also holds customers that are not tenants.
- Activate the connection.
- In the
Billingtab, add a position for each thing you bill, see A.14.11.
What goes to the vendor
Per draft: the contact of the tenant, the article and the quantity of each position, its price and tax rate, the service period, and the reference. No device names and no alert data go to Lexware.
How a draft is made
- A line refers to an article of Lexware Office. Name, unit, price and tax rate are read from the article when the draft is created. A price set on the position takes precedence over the price of the article; the tax rate stays that of the article.
- If Lexware refuses the reference to the article, NetLock sends the same document once more with manual lines.
- The invoice date is the day the draft is created, the service period is the counted month.
- A draft has the status
draft. The status cannot be changed through the API. - The texts of a document are German. According to the invoice guide of Lexware, the API creates German documents only.
A draft cannot be taken back
The API of Lexware Office has no way to change or delete an invoice, and according to the guide of Lexware every invoice created through the API uses a number from the number range, even as a draft. A draft you delete in Lexware Office leaves a gap in the numbers.
NetLock therefore handles drafts as follows:
- The plan is off by default. Without it, drafts are created only through
Create draftsafter a preview. - One document per tenant and period, all or nothing. A position that fails stops the whole document, because a partial invoice could not be completed later.
- A call that ends without an answer is never repeated blindly. If Lexware does not show the document, the run shows
Check at the vendorand waits for you, see A.14.11. - NetLock stays within the API limit of 2 requests per second, so a large preview can take a while.
Reference
Lexware has no internal field on an invoice. NetLock writes Referenz: NL-<tenant>-<yyyy-MM> as the last line of the closing text (Nachbemerkung). Your customer can read this line. NetLock uses it to find a document again after a failure, so it cannot be switched off.
A closing text sent through the API replaces the default of your account. If you want to keep yours, enter it under Closing text; it is placed before the reference.
If somebody removes the line from a draft, NetLock still knows the document. If creation failed at that moment, the run asks you to check.
Tax cases
The tax case is set per tenant in the Billing tab. For a contact in Germany, no choice is needed. For a contact in another country or without a billing address, you have to choose: without a chosen case no document is created, even on a small-business account.
| Tax case | Tax type at Lexware | Tax rate of the lines |
|---|---|---|
| Domestic | net or gross, as in your account | From the article |
| Small business (from your account, no choice) | vatfree | 0 |
| EU, reverse charge | externalService13b | 0 |
| Third country | thirdPartyCountryService | 0 |
The table follows the names Lexware gives its tax types.
vatfreeonly works for an account that is set up as tax free or as a small business, so the caseTax freeis not available for Lexware. On such an account, no choice is needed for a contact in Germany; for a contact abroad a case still has to be chosen, and the document then staysvatfree.externalService13bneeds a contact of type company with a valid VAT id.thirdPartyCountryServiceneeds a contact withAllow tax free invoices. If Lexware refuses it, no document is created and the history says so.
A refused tax ends the job with The tax of this document is unclear, and nothing is created.
E-invoices
NetLock sets nothing for XRechnung. Lexware takes it from the contact and checks the data when a document is finished.
Known limits
- Lexware bills in euro only.
- The article has to exist in Lexware. An archived article counts as missing, and the job ends with a note in the history.
- A draft you correct in Lexware is not read back. NetLock keeps what it sent.
Related
ServiceNow
Connect NetLock RMM to ServiceNow: alerts become incidents of the mapped company, the all-clear adds work notes and resolves the incident, companies can be imported as tenants. Incidents only, no CMDB.
sevdesk
Connect NetLock RMM to sevdesk: device counts become one invoice draft per tenant and month, which a person checks and finishes in sevdesk.