I have multiple accounting problems occurring. Standard UK chart of accounts in use.
1/ On "Tax statements" (VAT) the box 6 sales & box 7 purchases totals are being misreported (a lot more than actual) .
The taxes are correct.
2/ In chart of accounts (UK chart of accounts) Sales, purchases & stock are all reporting a lot more than actual which in turn is obviously impacting on the balance sheet & profit & loss.
In short, the only part that works correctly is the tax reporting.
I now know that the problem is caused by my real time inventory valuation configuration:
Stock input account 500000 Cost of sales
Stock output account 400000 Sales Category 1
Income account 400000 Sales Category 1
Expense account 500000 Cost of sales
Incidentally, I did have a little help from Odoo at the very beginning. The configuration above came direct from an Odoo advisor.
My question is; Is it possible to re-set all the DATA (not configuration settings) on V8 online ?
So that I could then start from the beginning again. If I cannot find a solution to the real time inventory valuation problem I could revert to manual stock valuation.
If a re-set is not possible I would be very grateful for alternative suggestions to return to 0.
However, it seems that reversing all my entries would probably cause further problems due to an apparent bug that I have read about: https://www.odoo.com/forum/help-1/question/customer-returns-causing-ever-increasing-asset-liability-account-growth-real-time-stock-valuation-54204