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'
NEW. It is possible to select a different date for sales and purchase invoices now. The dates defined in field 10 and 11 will be used to fill the field BELEGDATUM in the table FIBU_JOURNAL_KOPF, when an invoice is printed (single / batch print) or mailed. This date will later be used in the accounting.  see processing

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.