In billwerk you can configure additional fields in your financial accounting export to output further useful information. Go to "Settings > Accounting > Export Settings" and first select whether the additional fields in the export of Datev postings, Datev debitors, Lexware postings or Lexware debitors should be output. Then select the output column in the "Outbox" field, a title of your choice in the "Title" field and the desired information in the "Inbox" field. Use the button "Add Field" to add as many custom fields as required and finally click "Save".
Datev and Lexware postings
The following options are available:
| Name | Description |
|---|---|
|
Customer.Id |
ID of the customer |
| Customer.ExternalId |
External ID of the customer |
| Customer.DebitorAccount |
Debitor account of the customer |
| Customer.DestinationCountry |
Destination country of the customer |
| Customer.CustomFields.* |
Content of a custom field of the customer |
| VAT Percentage |
Applied tax rate (VAT / Sales Tax) |
| Tax Country |
Tax country |
| Date DD.MM.YYYY |
Posting date in the format DD.MM.YYYY |
|
Invoicing Reason |
Possible values:
|
| PSP Transaction ID |
ID of the payment transaction with the payment provider |
| LineItem.Description |
Description of the LineItem |
| LineItem.ProductId |
ProductId of the LineItem |
| LineItem.PlanVariantId |
ID of the PlanVariant active in the contract |
| LineItem.PeriodStart |
Start of the delivery period |
| LineItem.PeriodEnd |
End of the delivery period |
| Posting.Id |
billwerk ID of the posting |
| Posting.SequentialId |
Unique numeric ID for the posting group which only exists for final postings |
| IdealPostingDate |
Ideal posting date of a posting (disregarding closed periods) |
| Contract.StartDate |
Start date of the contract |
| Contract.EndDate |
End date of the contract |
| Contract.Contract.* Contract.CustomFields.* |
Content of the custom field of the contract |
| PostingGroup.DocumentNumber |
Document number of the invoice / credit note |
If you want to use the LineItem.* fields, you should active the option "Per line item postings" in the Accounts settings.
Datev and Lexware debitors
The following options are available:
| Name | Description |
|---|---|
|
Customer.Id |
ID of the customer |
|
Customer.ExternalId |
External ID of the customer |
| Customer.DebitorAccount |
Debitor account of the customer |
| Customer.DestinationCountry |
Destination country of the customer |
| Customer.Name |
Name of the customer (Lastname, Firstname or Companyname if available) |
| Customer.Firstname |
First name of the customer |
| Customer.Lastname |
Last name of the customer |
| Customer.CompanyName | Company name of the customer |
| Customer.EmailAddress | Email address of the customer |