Skip to main content

Notifications

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

Line Item for detail for Sales Tax and VAT Tax

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    nunomaia Profile Picture
    nunomaia 11 Super User 2024 Season 1 on at
    RE: Line Item for detail for Sales Tax and VAT Tax

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

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

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on at
    RE: Line Item for detail for Sales Tax and VAT Tax

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

  • nunomaia Profile Picture
    nunomaia 11 Super User 2024 Season 1 on at
    RE: Line Item for detail for Sales Tax and VAT Tax

    I don't think there is

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on at
    RE: Line Item for detail for Sales Tax and VAT Tax

    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 11 Super User 2024 Season 1 on at
    RE: Line Item for detail for Sales Tax and VAT Tax

    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
    RE: Line Item for detail for Sales Tax and VAT Tax

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

  • Suggested answer
    nunomaia Profile Picture
    nunomaia 11 Super User 2024 Season 1 on at
    RE: Line Item for detail for Sales Tax and VAT Tax

    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.  

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…

Vahid Ghafarpour – Community Spotlight

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

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans