Hi
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
Thanks
Reshma
Hi Reshma
Have you looked at the ACCOUNTING SOURCE EXPLORER inquiry. This includes Customer/Vendor name and code.
Regards
James
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156