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.