In Reporting --> Accounting --> Invoice Analysis menu, what is "Total Without Tax" column represent ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
Hai Adrie Taniwidjaja, It was the currency rate shown
yeah, I had a similar problem. somehow in the Settings ->Accounting -> Default Currency if you click to edit it has 1.28xxxx rate by default. Change it to 1 and you will get right nubmers
Hi,
Anyone knows why the total amount in Invoices analysis is different from Total Operating Income (Profit and Loss report)?
The label (Total Without Tax) represent its meaning. It's the sum of the "Subtotal Tax Excluded" on all invoices. (deduced from refund invoices)
Total amount of what ? Have you try before answering the questions ? There is nothing related with the invoice price on those report !
it is based on account_invoice_line report, its the total of invoice line sub total field without include tax
I am still not clear with your answer, if it represent the number of invoice line why can I have a decimal value on those column ? As an example I get this value on the report : All product / Saleable (8), number of line : 8, Qty : 19.00, Total without tax : 19.29 I intrepret those as the total number of invoice line of all saleable product is 8 line, the quantity on those 8 line is 19, but what is 19.29 ? Is it the total number of subtotal field without tax ? What is the meaning of the decimal point ?
Yes it is subtotal of invoice line without tax.
It means (in the example I wrote above) there is 19.29 invoice line (without tax). What is 0.29 invoice line means ? Where is this number came from ?
The numbers it seems to be wrong summarized, if you ask for groupong the data by: product, Customer, type, it gives you wrong data
Ok I checked the code account_invoice_report.py of account module that tries to get the currency of the user with condition rate = 1 that means that you must check that your base currency have the rate = 1 and the value of the report will give to you the right value of Total without tax other way you will receive fake values i think this check it most be changed on code to looking for base currency instead of rate = 1 because it could take fake values.
hI, I also have problem interpereting the invoice analysis report. i changed the default currency exchange rate to 1 as specfied above,it gave a better figure but whats the meaning? when i dug deeper showin journal, product and date in the advance filter parameter, it showed a particular sales and purchase invoice? found out that the total is balance between the sales invoice and the purchased invoice picked. my question is why were they picked?