Vendor report including GL cost code

I am not sure how to send it to you removing sensitive data.  Basically I am pulling through into Power BI the General Ledger Entries Table and the VendorLedgerEntries table.  I have also tried the Vendor_Ledger_Entries table.  

The VendorLedgerEntries table do not include the cost posting lines from the invoice by the looks of it just the accounts payable line.  I have compared the entries with the General Ledger Entries table whch has both.  The tables are linked by enry number so as the entry no line with the cost code is not in the VendorLedgerEntries table it does not show the vendor name.  If I try and llnk by say document number this works but it is a many to many link and then values get lumped together so I do not see the correct value.

I think my problem is undestanding how to link the correct tables together to show the vendor name.  I don't undesrtand why I cannot pull through a table with the purchase invoice lines showing the vendor.