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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December 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... 605 Super User 2025 Season 2

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 437 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 348 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans