Price Types in Commercial Records
Price Types in Commercial Records
Price Types in Commercial Records |
 |
 |
The easiest way to demonstrate how different price types affect commercial
records reports is with examples.
Information from the Costing/Pricing
panel of the Items register
Costing: In March, you purchase 1 unit of the item SKUNK PELT at the
purchase price in the Costing/Pricing panel of the Items register: 200 EUR, with
a 10% discount. The purchase price therefore comes to 180 EUR. The sale value
calculated with the sale price from the first price class is 195.83 EUR
excluding VAT or 235 EUR with VAT. The price from the second price class (Wholesale
Price 1) is 190 EUR.
Sale: You sell 1 piece of the item SKUNK PELT at the sale price from
the calculation plus a discount of 10%. The retail price in the pricing for this
item is 235 EUR with tax, and 195.83 EUR without tax. The actual value of the
sale including the discount is 176.25 EUR without tax and 211.50 including tax.
Here it is does not matter whether you entered the discount directly in the
document line or indirectly, through the Contract Prices panel of the Subjects
or Items register.
Balance: Regardless of the pricing options you select in the
Commercial Records window, the balance of these two transactions must be 0. This
is why the purchase and sales must be listed symetrically.
 |
Formally, the most correct report type is the one
described below in point 3: Retail Price,
Document Line. The other reports
are intended for internal overviews and reports. |
If this option is selected, the Read Sale Price From box will not appear! The
valuation price and the value according to this price do not change if the
customer receives a discount. In this case, the values from the warehouse cards
are shown.
Če za kriterij izpisa izberemo maloprodajne cene iz prvega cenovnega razreda
z vključenim DDV in za iskanje prodajne cene izberemo cene iz cenika, se zaloga
obremeni po tej ceni, po isti ceni pa se zaloga razbremeni tudi ob izdaji. Pri
tem se za razliko od izpisa iz točke 3. ne izpisujejo morebitni rabati ali znižanja
cene, priznana v fakturi kupcu. Izpis torej ne upošteva dejanske kupcu
fakturirane vrednosti.
If the retail price (first price class plus VAT) is selected together with
the Prices option in the Read Price From box, stock will be burdened by this
price, and it will also be used when stock is unburdened through an issue of the
goods. The difference between this method and the method shown below (method 3)
is that with this option, any discounts or price reductions listed in the actual
issue invoice will not appear here. In other words, commercial records reports
with these options do not take the actual values which appear in the invoice
issued to the customer.
If you select Retail Price in the Price Types box and Document Line in the
Read Price From box, stock will be burdened by this price, and it will also be
used when stock is unburdened throught the issue of goods. Unlike the report in
described above (method 2), the actual values, including any differences between
the actual invoice issued to the customer and the prices in the Pricing in the
Items register, will be shown in the report. They will appear separately as
reversals in the Receiving section of the report.
|
|
The Use Actual Sale Price option is only suitable for accounting firms
that do not have access to their customers' complete records! The
balance from these movements could differ from the actual value of stock by
retail price! |
In this case the discount that the customer received on the retail price will
not appear anywhere, because this information cannot be discerned from the daily
proceeds. The actual value of the stock (by retail prices) and the value of
the of the stock according to the commercial records report will therefore
differ by the difference between the retail price in the Pricing and the retail
price given to the customer (that is, the price minus the 10% discount). For an
example of this type of commercial report, see Record
on Retail Purchases and Sales by Daily Proceeds.
If the sale price from the first price class excluding VAT (that is, the Sale
Price (excl. VAT) option) is selected in the Price Types box and the Prices
option is selected in the Read Sale Price From box, the stock will be unburdened
by this price, and it will also be used when stock is unburdened through an
issue of goods. However, any discounts or price reductions that appear in the
invoice issued to the customer will not appear in the report. In other words,
the actual values from the invoice will not be used.
If the sale price from the first price class excluding VAT (that is, the Sale
Price (excl. VAT) option) is selected in the Price Types box and the Prices
option is selected in the Read Sale Price From box, the stock will be burdened
by this price, and it will also be used to unburden stock. The value of the sale
will be the actual sale price from the selected price class (excluding VAT), and
the difference betwween the sale price from the receiving document (discount,
for example) will be shown as a reversal of the purchase.
|
|
The Use Actual Sale Price option is only suitable for
accounting firms that do not have access to complete records! The balance
from transactions displayed this way may differ from the actual value of
stock by retail prices! |
In this case, the discount that you have given the customer on the retail
price will not appear because it only appears as part of the daily proceeds.
The actual value of stock (by retail prices) and the value of stock in a retail
commercial records report can therefore differ by the difference between the
retail price in the Costing/Pricing and the retail price that you charged the
customer. For an example see Records on Retail
Purchases and Sales by Daily Proceeds.
If you select the sale price from a different price class (excluding VAT) in
the Price Type box and the Prices option in the Read Price From box, stock will
be burdened by this price, and will be unburdened at the same price when the
goods are issued. However, any discounts or price reductions that appear in the
invoice issued to the customer will not appear in the commercial records report.
The report will therefore not use the values that appear in the actual invoice.
If you select the sale price from a different price class (excluding VAT) in
the Price Type box and the Document Line option in the Read Price From box,
stock will be burdened by this price, and it will also be used to unburden stock
when goods are issued. The value of the sale will appear as the actual sale
price from the selected price class (in this case, Wholesale Price 1, excluding
VAT), with the difference between the actual price and the price from the
receiving document (discoutn, for example) shown as a reversal of the purchase.
|
|
The Use Actual Sale Price option is only suitable for
accounting firms that do not have access to complete records! The balance
from transactions displayed this way may differ from the actual value of
stock by retail prices! |
In this case, the discount that you have given the customer on the retail
price will not appear because it only appears as part of the daily proceeds.
The actual value of stock (by retail prices) and the value of stock in a retail
commercial records report can therefore differ by the difference between the
retail price in the Costing/Pricing and the retail price that you charged the
customer. For an example see Records on Retail
Purchases and Sales by Daily Proceeds.
If you select the sale price from the third price class (Wholesale price 2,
excluding VAT) in the Price Type box and the Prices option in the Read Price
From box, stock will be burdened by this price, and will be unburdened at the
same price when the goods are issued. However, any discounts or price reductions
that appear in the invoice issued to the customer will not appear in the
commercial records report. The report will therefore not use the values that
appear in the actual invoice.
If you select the sale price from a different price class (excluding VAT) in
the Price Type box and the Document Line option in the Read Price From box,
stock will be burdened by this price, and it will also be used to unburden stock
when goods are issued. The value of the sale will appear as the actual sale
price from the selected price class (in this case, Wholesale Price 2, excluding
VAT), with the difference between the actual price and the price from the
receiving document (discoutn, for example) shown as a reversal of the purchase.
|
|
The Use Actual Sale Price option is only suitable for
accounting firms that do not have access to complete records! The balance
from transactions displayed this way may differ from the actual value of
stock by retail prices! |
In this case, the discount that you have given the customer on the retail
price will not appear because it only appears as part of the daily proceeds.
The actual value of stock (by retail prices) and the value of stock in a retail
commercial records report can therefore differ by the difference between the
retail price in the Costing/Pricing and the retail price that you charged the
customer. For an example see Records on Retail
Purchases and Sales by Daily Proceeds.