Dynamics Community Forum Thread Details

How to bring out ledger trans data with customer and vendor fields onto a report, which data entities/Tables are required in D365?

We are trying to create various cost Centre/Bank reports, in AX we pulled through data via custtrans and vendtrans, however in D365 where we can we are using default description to bring in Customer/Vendor account numbers, This is not available for all posting types and we would like to use the Customer and Vendor fields on the Voucher, I understand that these are Dimension Attribute Values and there are a numbert of tables including DimensionAttributeValuescombination however we are struggling to join on GeneralJournalAccountEntry or Ledger Trans.

In the below transaction we have managed to pull a default description however for Bank postings this does not pull through on the description and only visible through the attribute fields.Has anyone managed to join the tables and if so are you able to share the query or advise if there is another method.

I have also looking into financial reports to see if these attributes can be pulled but no luck. so any help will be appreciated