help needed
as i was saying , vendinvoicetrans only contains invoices of purchase order invoices but i want tax for all vendor transactions
Use the below query and pick all the tax details you need from TAXDOCUMENTROWTRANSACTION table
.
select tt.* from VENDINVOICEJOUR v join VENDINVOICETRANS vt on vt.PURCHID = v.PURCHID and vt.INVOICEID = v.INVOICEID and vt.INVOICEDATE = v.INVOICEDATE and vt.NUMBERSEQUENCEGROUP = v.NUMBERSEQUENCEGROUP and vt.INTERNALINVOICEID = v.INTERNALINVOICEID join TAXDOCUMENTROWTRANSACTION tt on tt.INVOICEID = vt.INVOICEID join TaxDocumentComponentTransaction T on T.TAXDOCUMENTROWTRANSACTIONRECID = tt.RECID where v.INVOICEID = 'Invoice Id'
These should work. I did similar thing for Indian localisation for project invoices. Just try to give a query.
these will not work i want top fetch indian tax details from vendinvoicejour table
I don't know exactly which tables these Vendor invoice journals will be present as I did not work on it earlier and not aware the navigation in UI. For tax purposes you can give some relation with these below mentioned 2 tables and can get the tax.
TAXDOCUMENTROWTRANSACTION and TaxDocumentComponentTransaction
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156