To check whether the stock is correct in Uniconta, this Dashboard can be used (the Dashboard has long been available from the Dashboard overview). As this is a standard Dashboard, it can be customized for each company and still be called from the menu.
Please note that the stock accounts in the chart of accounts being reconciled against must have the type stock.
Only records approx. 2 years back in time are retrieved.
NOTE: Benefits must be removed from the comparison. If you want to reconcile production parts lists or if services are included in a production parts list, you must check the "tick" box in ServiceProdStykliste in the inventory.
On the Comparison tab between Lager and Finance, the two lower boxes Lager per Movement type and Finance per type can be used to compare figures by year, month and day.
If inventory matches finance, there will be no differences between the two boxes.
If there are differences, it will appear in the totals.
If production BOMs are used, the sum of the Movement types Included in BOM and Completed must be equal to 0.
On the tab Comparison between Lager and Finance on bookkeeping number, the Difference per bookkeeping number box shows which bookkeeping numbers have differences. This bottom box with the same name shows which lines are not correct.
NOTE: If there are number series without text, cost prices have typically been recalculated via the Finance tab and not as recommended via invoice.
NOTE: If the full vendor amount is entered on an account in Finance, an account is probably set as an expense account for the vendor. This must not be done if inventory management is used.
Here are two error examples.
Marked in red. Here the posting number is 0, but there is an amount. This means that only the inventory has been booked here. This means that the posting in the warehouse - typically the product groups - has been incorrect.
Marked in green. Here it is a posting number and an amount. This means that there is a difference, as the amount on the posting number is the same as in the Finance per Type box, so the entry has only been made in Finance.
On the tab Comparison between Lager and Finance on bookkeeping number, the Difference per bookkeeping number box shows which bookkeeping numbers have differences. This bottom box with the same name shows which lines are not correct.
NOTE: If there are number series without text, cost prices have typically been recalculated via the Finance tab and not as recommended via invoice.
NOTE: If the full vendor amount is entered on an account in Finance, an account is probably set as an expense account for the vendor. This must not be done if inventory management is used.
Here are two error examples.
Marked in red. Here the posting number is 0, but there is an amount. This means that only the inventory has been booked here. This means that the posting in the warehouse - typically the product groups - has been incorrect.
Marked in green. Here it is a posting number and an amount. This means that there is a difference, as the amount on the posting number is the same as in the Finance per Type box, so the entry has only been made in Finance.