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
It's same of the screenshot ( voucher and date ).
The link is between VendInvoiceJour and TaxTans and not really between VendInvoiceTrans and TaxTans
Hi - do you know what the link would be between VendInvoiceJour and TaxTrans
I don't think there is
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
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
thanks - is there a middle table that links them together?
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.
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156