Skip to Content
Menu
This question has been flagged
12 Replies
12485 Views

In Reporting --> Accounting --> Invoice Analysis menu, what is "Total Without Tax" column represent ?

Avatar
Discard
Best Answer

Hai Adrie Taniwidjaja, It was the currency rate shown

Avatar
Discard

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

Best Answer

Hi,

Anyone knows why the total amount in Invoices analysis is different from Total Operating Income (Profit and Loss report)?

Avatar
Discard
Best Answer

The label (Total Without Tax) represent its meaning. It's the sum of the "Subtotal Tax Excluded" on all invoices. (deduced from refund invoices)

Avatar
Discard
Author

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

Author

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.

Author

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.

Best Answer

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?

Avatar
Discard
Related Posts Replies Views Activity
1
Jun 25
97
0
Jun 25
82
1
Jun 25
191
1
Jun 25
161
1
Jun 25
134