help needed
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
these will not work i want top fetch indian tax details from vendinvoicejour table
These should work. I did similar thing for Indian localisation for project invoices. Just try to give a query.
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'
as i was saying , vendinvoicetrans only contains invoices of purchase order invoices but i want tax for all vendor transactions
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader