Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 577 Super User 2026 Season 1
Giorgio Bonacorsi 309
Diego Mancassola 259