web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Line Item for detail f...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Line Item for detail for Sales Tax and VAT Tax

(0) ShareShare
ReportReport
Posted on by Trevor Cohen 131

Hi,

I had a few custom data entities created to help export the details of "Open Vendor Invoices" and "Vendor Payment Journals".  The tables that are in the data entities are:

VendInvoiceTrans,  VendInvoiceJour, AccountingDistribution.     I am noticing that these tables only show the amounts allocated to Sales Tax or Vat Tax at the header level, not the line item level.

Do you know which table would have the line item details for Sales Tax and VAT Tax for items in the "Open Vendor Invoices"?

Also is that a data entity already available in D365?

Thanks,

Trevor

I have the same question (0)
  • Suggested answer
    nunomaia Profile Picture
    nunomaia 25 Moderator on at

    Tax information is stored in table TaxTrans. There is no 1-1 relationship between TaxTrans and VendInvoiceTrans.

    You can filter information by Date and Voucher.  

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on at

    thanks - is there a middle table that links them together?

  • nunomaia Profile Picture
    nunomaia 25 Moderator on at

    Like I have mentioned, this is not a 1-1 link, but the relationship is direct using 2 fields. You can have a lookup on screenshot. 

    But the correct link is between VendInvoiceJour and TaxTrans  

    pastedimage1677275130917v1.png

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on at

    thank you very much - do you know if TaxTrans is a data entity already available in D365.   I am looking under the data entities screen in data management and not seeing it, unless I am missing it?.  Thanks

  • nunomaia Profile Picture
    nunomaia 25 Moderator on at

    I don't think there is

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on at

    Hi - do you know what the link would be between VendInvoiceJour and TaxTrans  

  • Suggested answer
    nunomaia Profile Picture
    nunomaia 25 Moderator on at

    It's same of the screenshot ( voucher and date ).

    The link is between VendInvoiceJour  and TaxTans and not really between VendInvoiceTrans and TaxTans

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 555 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 364

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans