» Available only in Dotypos FULL and higher. « |
|---|
Purchase and sales price differential
Inventory overview
You can find all the inventories in the overview on the tab Warehouses » Stock taking. You can complete a work-in-progress inventory here 
or view the details of a completed inventory here 
.
After clicking the DETAIL button for the selected completed stocktake, its report is displayed. You can customize this report as you wish by adding, removing, or moving individual columns under the COLUMNS 
menu. Columns are handled here in the same way as in data reports. The stocktake report can be exported to one of the supported formats using the 
button.
|
The column settings are stored locally in your browser. After deleting the cookies, the settings are reset. Similarly, the column settings will not be accessible from another computer. This allows each user to set the report to their own preferences. |
Purchase and sales price differential
The page with an overview of products for stocktaking displays the purchase price differential (PP differential). This price is calculated by adding the actual quantities in stock for the specific product and its purchase prices. The sale price differential (SP differential) is similarly calculated by adding products in stock and their sale prices.
Example:
1.You buy 100 of a product at a purchase price 10 EUR each.
2.Two days later there are 50 of the product left in the warehouse at purchase price of 10 EUR each.
3.The next day you buy 10 of the same product at 5 EUR per piece.
This means the displayed purchase price differential for this product will be:
(50 x 10) + (10 x 5) = 550: 60 = EUR 9.1
Sales price difference
In the overview of products for stocktaking, depending on the entered warehouse status you can also see the calculated sales price differences (SP financial differential) based on the preceding stocktaking balance, calculated Write-Off and stock in. The sales price difference is calculated using this formula:
(Warehouse status found by the previous stock-taking - Current warehouse status - Write-offs + Stock ins) * Item sales price, VAT exclusive.
