search

ledger123 / runmyaccounts

SQL-Ledger Customizations by Run My Accounts
GNU General Public License v2.0
16 stars 9 forks source link

AP-/AR-Invoices don't support linetax #483

Closed raphaelroos closed 7 months ago

raphaelroos commented 7 months ago

Currently, linetax is not supported for AP-/AR-Invoices in SQL-Ledger. Tax rate can be selected for each line... image

...but sum of each tax rate will be booked in a separate transaction and the fields "taxamount" and "tax_chart_id" are not filled image

Is it possible to change this so that taxes will be booked with linetax also for invoices if linetax is enabled?

raphaelroos commented 7 months ago

I also checked the linetax report of sql ledger for the example above. It seems that tax numbers are wrong here, no? image

ledger123 commented 7 months ago

Currently, linetax is not supported for AP-/AR-Invoices in SQL-Ledger. Is it possible to change this so that taxes will be booked with linetax also for invoices if linetax is enabled?

Hi @raphaelroos,

Line tax cannot be supported for invoice line items because each line item (part, service) can have multiple taxes configured for it. And each tax is also dependent on the selection of tax for that customer or vendor.

Further we can discuss on meeting if needed.

Regards

ledger123 commented 7 months ago

I also checked the linetax report of sql ledger for the example above. It seems that tax numbers are wrong here, no?

Linetax report is quite thoroughly tested so probably it should be ok. But we can do to troubleshoot the reported issue:

Check and confirm if the figures are different in the 'Tax Collected' report than this report? The different between line tax and tax collected report is that linetax report shows all taxes.

Regards

raphaelroos commented 7 months ago

Hi @ledger123,

thanks for your answers. I found a way to handle those non-linetax transactions in our VAT settlement. About the "wrong" numbers in the linetax report, there was a misunderstanding from my side. So, no further actions are needed. I will close this issue.

Regards, Raphael