Tax Report

I have tried that. It works as you are basically assigning a tax code to GL account. So it is not adviceable to use "Supplier Invoice" for non-VATable expenses as your tax report will be wrong. The problem is when I have issued a purchase order to a supplier and then you find on the actual invoice a shipping charge. At this point on "Supplier Invoice" you add all order lines and the only options are quick entry or choose shipping from GL Account. I have tired both and none of them works if the expense is not VATable. All you have to do is cancel the whole purchase order, create new PO with shipping charge on and then post the invoice. If you were to go for creating service items then you have create one for each expense account.

I would suggest to bring tax code assignment to each GL account in next upgrade. In the meantime, easier way out is to make slight change in the "posting" code on supplier invoice which should insert all the data from the form and not do any other background calculations. I tested one supplier invoice by entering expense for £1000 and then manually entered 20% VAT line as amount £190 (instead of £200). What system posted in table "trans_tax_details" was tax of £190, which is correct but the invoice value was £950 (instead of £1000). What system should post in database is what is inserted on the form. By doing background calculate without user knowing is very misleading.

Deven

My advise from former topic still is adequate, however, you should enter the correct shipping value from the beginning.

Remember this is only needed if the Tax Type rate is 0-%. Otherwise you can use the normal GL Items entry.

Try to enter these lines:

XXX Stock item                           1                             1000               1000
YYY Shipping                             1                              10                  10
Total                                                                                     1010

If you look at the tax report you will see the correct statistics.

/Joe

The default FA install will have Price After Tax - hence add whatever tax you want in each line item of a Direct Sales Invoice Entry Form. The tax reporting is based on tax per item. That is why we have item tax. The default Sales Invoice PDF does not have the individual taxes but the total tax included as a summary line.