This question has been flagged
1 Reply
2068 Views

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

 

Avatar
Discard
Best Answer

Hello,


This report will help you to print valuation on particular date with stock IN/OUT/ADJUSTMENT Quantities.


Navigate To : https://apps.odoo.com/apps/modules/11.0/stock_valuation_on_date/


For more information contact : tidyway.in@gmail.com


Thank you, Rohan

Avatar
Discard