For a more detailed information on rounding settings see some
examples.
 |
Predefined rounding settings in some examples are in bold! |
1. Price Calculation Rounding
The price calculation rounding parameter determines, how (if)
the price will be rounded,
when converted according to the price range (i.e.
by formula, in another currency, etc.), or how it should be recorded in the
document line.
Example:
In the customer's price list for the foreign subject Foreign Partner Ltd you
have determined the contract price 1 DEM. You would like to convert the actual
issued invoice into GBP. The exchange rate for converting currencies, valid on the date of the issued
invoice, is 100 SIT for 1 DEM and 300 SIT for 1 GBP.
Price calculation: 1 DEM * 100 SIT / 1 GBP * 300 SIT = 0,33333333...
Price calculation rounding in parameters
|
Price in a document line
|
0,0000
| GBP 0,333333333...
|
| 0,0001
| GBP 0,3333
|
| 0,0100
| GBP 0,33
|
The greater the quantity the more will the rounding method affect the end
result .
2. Line Rounding
The Line Rounding parameter determines, how a singular value of a document
line will be rounded.
The sum up of the line value = (price - discount) * quantity
Example:
Let's see the result, when you have different settings for line rounding. You
have the previously mentioned example with the not rounded price 0,3333333... and
quantity of 10.000 pieces:
Line Rounding in parameters
|
Value Rounding of the document
|
| 0,0100
| GBP 33.333,33 |
| 0,0000
| GBP 33.333,00 (If you do not set the parameter, the program will round
the line to a whole number!!!)
|
| 0,0001
| GBP 33.333,3333
|
3. Rounding Values
Rounding document values affects only issued invoices and received sales orders
if those are issued in the primary currency.
Example:
Let us presume that the sum of the document lines is SIT 10.110,44, the VAT
value is SIT
1.920,98 and the total value is SIT 12.031,42.
|
Value Rounding in parameters |
Document value for the report and posting |
| 0,0100
| SIT 12.031,42
|
| 0,0000
| SIT 12.031,42 (If you do not set the parameter or the parameter is less
than 0,01, the program will always round the value to the second decimal
place!!!)
|
| 0,5000
| SIT 12.031,50
|
| 1,0000
| SIT 12.031,00
|
Report: The difference between the sum of lines and the document value
rounding will on the report of issued invoices and sales orders display
as rounding difference.
Report when rounded to 0,01 (default setting):
Report when rounded to 0,50:
Report when rounded to 1,00:
Or on POS invoice (see Report of
POS invoices):
----------------------------------------
Item 1
1,00 PCS 194.028,47 194.028,47
----------------------------------------
Value: 194.028,47
Offset:
-0,47
To pay: SIT 194.028,00
----------------------------------------
Posting: The difference between the sum of lines and the document value rounding
will when automatically posting of issued invoices be posted as
a positive or negative rounding difference.
Posting when rounded to 0,01 (default setting):
Posting when rounded to 0,50:
Posting when rounded to 1,00:
4.
Basis for Sale Price Calculation
The Basis for Sale Price Calculation determined, how the program will round
the sales price. Let's take an example, where the price of an item is a value
with the recurring decimal. Such values are a result of converting prices by formula or contract price list (for more information see Price ranges).
Example:
Items price is 6,666666666... SIT, 19-peercentage VAT is 1,26666666.. SIT,
total value is 7,93333333... SIT.
Used are predefined settings for rounding prices, lines and documents.
Basis for price calculation in parameters
| Price | VAT
| Price + VAT= Value
|
M - Rounding basis is the retail price, VAT included
| SIT 6,67
| SIT 1,26
| SIT 7,93
|
| P - rounding basis is the sale price,
excluding VAT | SIT 6,67
| SIT 1,27
| SIT 7,94
|