Accounting settings
Basic Data
Accounting Accounting settings
Attributes
No. |
Field Name |
Type |
Mandatory / default value |
Description |
---|---|---|---|---|
1 |
Default session |
Text |
No / |
|
2 |
Date format |
Text |
No / |
|
3 |
Auto. - Booking session |
Text |
No / |
|
4 |
Auto. booking - Booking text |
Text |
No / |
For example "%V/%v/%K" |
5 |
Auto. booking - Document number |
Text |
No / |
|
6 |
DaVinci Bookkeeping |
Checkbox |
/Not Checked |
Enables the bookkeeping functionality in DaVinci |
7 |
Invoice incl. calculated purchase prices |
Checkbox |
/Not Checked |
|
8 |
Sales journal number (AR) |
Text |
No /"1-VK" |
|
9 |
Purchase journal number (ER) |
Text |
No /"2-EK" |
|
10 |
Value outgoing invoices (Purchase) |
Dropdown |
Yes / 'Actual date' |
Select from 'Actual date', 'Departure date' (=Vorgangskopf.DATUM_VON) and '(maximum of) Departure-/ Actual date' CHANGED Text see Processing |
11 |
Value outgoing invoices (Sale) |
Dropdown |
Yes / 'Actual date' |
Select from 'Actual date', 'Departure date' and '(max. of) Departure/Actual date' |
12 |
Set cancellation "Document date" (Sales) |
Dropdown |
/"Actual date" |
Select from "Actual date" , "Date of document", "(maximum of) Document-/ Actual date" |
13 |
Set cancellation "Document date" (Purchase) |
Dropdown |
/"Actual date" |
Select from "Actual date" , "Date of document", "(max. of) Document-/ Actual date" |
14 |
Cancellation Set 'Booking date' with actual date |
Checkbox |
/Not Checked |
Use the system date when making the bookings for the cancellation, not the date from previous booking, when checked. See Processing / Example |
15 |
Check validity of VAT for SP against: |
Dropdown |
Y/Departure date |
Select from "Departure date", "Date of arrival ", "Actual date" . Important if the VAT tax rate changes |
16 |
Check validity of VAT for PP against: |
Dropdown |
Y/Departure date |
Select from "Departure date", "Date of arrival " , "Actual date" |
17 |
Combined invoice |
Checkbox |
/Not Checked |
Only when this flag is checked, combined invoice (credit note together with new invoice) will be printed. |
18 |
Print invoice with zero price (SP) |
Checkbox |
/Checked |
Only when this flag is checked, Invoices with a sales price of no value will be printed. |
19 |
Print commission credit note with zero value |
Checkbox |
/Not checked |
Only when this flag is checked, a zero commission credit note will be printed. |
20 |
Print invoice for options |
Checkbox |
/Checked |
Only when this flag is checked, |
21 |
Print invoices if request |
Checkbox |
/Checked |
Only when this flag is checked, |
22 |
Sales price-foreign curr.display |
Checkbox |
/Not Checked |
Only when this flag is checked, |
23 |
No confirmation after first print of invoice |
Checkbox |
/Not Checked |
When this flag is checked, no confirmation after the first print of invoice will be generated. |
24 |
No invoice print if no invoice relevant changes. |
Checkbox |
/Checked |
When this flag is checked, only an invoice for invoice relevant changes will be printed |
25 |
New calculation of foreign currency with the daily rate of exchange during invoicing. |
Checkbox |
/not checked |
When checked use the exchange rate when invoice is printed, else use the rate from Day of booking. |
26 |
Activate function for guaranted prices |
Checkbox |
/not checked |
Not supported yet - will work probably in version 1035 |
27 |
Posting of invoice without account group allowed |
Checkbox |
/not checked |
|
Processing / Example
Value outgoing invoices (sales) default: set to "actual date" (revenues)
Value outgoing invoices (purchase) default: set to "departure date" (costs)
When configuring the new version for a client, the new setting "Value outgoing invoices (sales)" and "Value outgoing invoices (purchase)"should both be set to the same setting as the old flag "Value outgoing invoices". Then the system will work like before.
Example:
Step 1: Booking and invoice print on 10.7.05
Step 2: Booking change on 15.8.05
Day of departure 1.10.05
Booking date for cancellations:
- Current behaviour: DaVinci only negates the booking completely, taking also the same date for the cancellation.
Sales
Step |
Debtor Acc. |
Creditor Acc. |
Amount |
Book date |
Doc. date |
Description |
---|---|---|---|---|---|---|
1 |
Debtor |
Revenues |
100 |
10.7. |
10.7 |
|
2 |
Revenues |
Debtor |
100 |
10.7. |
10.7 |
negation of step 1 |
2 |
Debtor |
Revenues |
120 |
15.8. |
15.8. |
|
Purchase
Step |
Debtor Acc. |
Creditor Acc. |
Amount |
Book date |
Doc. date |
Description |
---|---|---|---|---|---|---|
1 |
Costs |
Creditor |
90 |
10.7. |
1.10. |
|
2 |
Creditor |
Costs |
90 |
10.7. |
1.10. |
negation of step 1 |
2 |
Costs |
Creditor |
100 |
15.8. |
1.10. |
|
- NEW behavior: For the second step (second booking lines) use always the current date for the booking date and not the booking date of the original booking:
Sales
Step |
Debtor Acc. |
Creditor Acc. |
Amount |
Book date |
Doc. date |
Description |
---|---|---|---|---|---|---|
1 |
Debtor |
Revenues |
100 |
10.7. |
10.7 |
|
2 |
Revenues |
Debtor |
100 |
15.8. |
10.7 |
new book date |
2 |
Debtor |
Revenues |
120 |
15.8. |
15.8. |
|
Purchase
Step |
Debtor Acc. |
Creditor Acc. |
Amount |
Book date |
Doc. date |
Description |
---|---|---|---|---|---|---|
1 |
Costs |
Creditor |
90 |
10.7. |
1.10. |
|
2 |
Creditor |
Costs |
90 |
15.8. |
1.10. |
new book date |
2 |
Costs |
Creditor |
100 |
15.8. |
1.10. |
|
NEW Flag: "Book cancellation with current date" ("Storno mit aktuellem Datum buchen") in _Accounting basic data{_}. When this flag is enabled, then the previous booking will be executed this way:
Sales
Step |
Debtor Acc. |
Creditor Acc. |
Amount |
Book date |
Doc. date |
Description |
---|---|---|---|---|---|---|
1 |
Debtor |
Revenues |
100 |
10.7. |
10.7 |
|
2 |
Revenues |
Debtor |
100 |
15.8. |
15.8. |
Doc. date = curr. date |
2 |
Debtor |
Revenues |
120 |
15.8. |
15.8. |
|
Purchase
Step |
Debtor Acc. |
Creditor Acc. |
Amount |
Book date |
Doc. date |
Description |
---|---|---|---|---|---|---|
1 |
Costs |
Creditor |
90 |
10.7. |
1.10. |
|
2 |
Creditor |
Costs |
90 |
15.8. |
1.10. |
|
2 |
Costs |
Creditor |
100 |
15.8. |
1.10. |
|
If a cancellation is after departure date and the new flag is enabled, then it has to override the flags: Value outgoing invoices (sales) and Value outgoing invoices (purchase) - if they are set to departure date - and take for both the current date instead (Departure date: 01.10. Cancelled: 05.10.).
Sales
Step |
Debtor Acc. |
Creditor Acc. |
Amount |
Book date |
Doc. date |
Description |
---|---|---|---|---|---|---|
1 |
Debtor |
Revenues |
100 |
10.7. |
10.7 |
|
2 |
Revenues |
Debtor |
100 |
5.10 |
5.10. |
|
2 |
Debtor |
Revenues |
120 |
5.10. |
5.10. |
|
Purchase
Step |
Debtor Acc. |
Creditor Acc. |
Amount |
Book date |
Doc. date |
Description |
---|---|---|---|---|---|---|
1 |
Costs |
Creditor |
90 |
10.7. |
1.10. |
|
2 |
Creditor |
Costs |
90 |
5.10. |
5.10. |
|
2 |
Costs |
Creditor |
100 |
5.10. |
5.10. |
|
Booking step tables
Accounting Accounting settings
Attributes
No. |
Field Name |
Type |
Mandatory / default value |
Description |
---|---|---|---|---|
1 |
Table No. Supplier Invoice |
Number |
No /0 |
|
Departure date relations
Accounting Accounting settings Booking step tables
Attributes
No. |
Field Name |
Type |
Mandatory / default value |
Description |
---|---|---|---|---|
1 |
Table 1 - Jack |
Date |
No /empty |
|
2 |
Table 1 - DaVinci Non-Dir-debit invoice |
Date |
No /empty |
|
3 |
Table 1 - DaVinci - dir debit invoice |
Date |
No /empty |
|
4 |
Table 2 - Jack |
Date |
No /empty |
|
5 |
Table 2 - DaVinci Non-Dir-debit invoice |
Date |
No /empty |
|
6 |
Table 2 DaVinci - dir debit invoice |
Date |
No /empty |
|
7 |
Table 3 - Jack |
Date |
No /empty |
|
8 |
Table 3 - DaVinci Non-Dir-debit invoice |
Date |
No /empty |
|
9 |
Table 3 DaVinci - dir debit invoice |
Date |
No /empty |
|
Currency settings
Accounting Accounting settings
Attributes
No. |
Field Name |
Type |
Mandatory / default value |
Description |
---|---|---|---|---|
1 |
Default currency 1 |
Dropdown |
/EUR |
Select the first default currency |
2 |
Default currency 2 |
Dropdown |
No /Empty |
Select the second best default currency |
3 |
Default currency 3 |
Dropdown |
No /Empty |
Select the third best default curency |
4 |
Local currency |
Dropdown |
/EUR |
Select your local currency |
5 |
Rounding: |
Number |
Y/0 |
Empty = 0 (default) shows in Dropdown "No rounding/ 1000/ 100/ 10/ 1"1 = shows additionaly to above ("0,1")2 = shows additionaly to above ("0,01")3 = shows additionaly to above ("0,001")Defines the entries in Accounting settings Currency chart (6.14)dropdown "Rounding". The Number should NOT be larger than "Decimal digits" otherwise you would see only "0,00000" in dropdown. Also numbers larger than 9 are not recommended. |
6 |
Decimal Digits |
Number |
/2 |
Number of decimal digits |
7 |
Unit |
Number |
/0 |
Unit of currency |
Open Items
Accounting Accounting settings
Attributes
No. |
Field Name |
Type |
Mandatory / default value |
Description |
---|---|---|---|---|
1 |
Debtors as OI accounts |
Checkbox |
/not checked |
|
2 |
Creditors as OI accounts |
Checkbox |
/not checked |
|
Supplier Invoice settlement
Accounting Accounting settings
Attributes
No. |
Field Name |
Type |
Mandatory / default value |
Description |
---|---|---|---|---|
1 |
Evaluation supplier invoice |
Dropdown |
/empty |
Select from: "Invoice date", "Actual date", "Departure date" |
2 |
Evaluation payment |
Dropdown |
/empty |
Select from: "Invoice date", "Actual date", "Departure date" |
3 |
Auto.-Booking Booking text |
Text |
/empty |
|
4 |
Auto.-Booking document no. |
Text |
/empty |
|
5 |
Journal number |
Dropdown |
/empty |
|
6 |
Posting with button "Fully matched" |
Checkbox |
/not checked |
You can only post if supplier invoice is fully matched |
7 |
"Add PP to marked services" as button |
Checkbox |
/not checked |
For the marked price lines the system will generate PP price lines and match them accordingly. |
8 |
Difference between invoice date and date of payment (Days) |
Number |
No/empty |
You can define the days between invoice date and due date of payment here |
9 |
Standard for product type |
Dropdown |
/empty |
Select a standard product type here |
10 |
Standard for cost type |
Dropdown |
/empty |
Select a standard costtype here |
Accounting (Invoice printing)
Accounting Accounting settings
Attributes
No. |
Field Name |
Type |
Mandatory / default value |
Description |
---|---|---|---|---|
1 |
Display invoice date only, not editable in invoice print |
Dropdown |
/empty |
Relevant for single print of invoices. Check this flag to make invoice date read only. |