Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

X++ code to fetch tax from vendor invoice journal . totally stuck on it

(0) ShareShare
ReportReport
Posted on by

help needed

  • RE: X++ code to fetch tax from vendor invoice journal . totally stuck on it

    as i was saying , vendinvoicetrans only contains invoices of purchase order invoices but i want tax for all vendor transactions

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: X++ code to fetch tax from vendor invoice journal . totally stuck on it

    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'

  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: X++ code to fetch tax from vendor invoice journal . totally stuck on it

    These should work. I did similar thing for Indian localisation for project invoices. Just try to give a query.

  • RE: X++ code to fetch tax from vendor invoice journal . totally stuck on it

    these will not work i want top fetch indian tax details from vendinvoicejour table

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: X++ code to fetch tax from vendor invoice journal . totally stuck on it

    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

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans