Search code examples
axaptamicrosoft-dynamicsdynamics-ax-2012dynamics-ax-2012-r3

Join Datasources on Form

From Accounts payable > Periodic > Maintain vendor invoices > Vendor invoice > From product receipt, I can open PurchJournalSelect_PackingSlip form.

I need to add a column with the vendor name.

As far as I see, we are using the table VendPackingSlipJour and a relation with the VendTable is there by default:

enter image description here

Going to VendTable, we can find the relation with DirPartyTable:

enter image description here

Now comes the part that doesn't work.

I have tried to add both VendTable and DirPartyTable to the DataSource list in PurchJournalSelect_PackingSlip form.

  1. VendTable with: - JoinSource: VendPackingSlipJour and Link Type: InnerJoin.
  2. DirPartyTable with: - JoinSource: VendTable and Link Type: InnerJoin.

And the last thing was to drag the Name field from DirPartyTable to the grid. Seems nice but I get an empty column. What am I doing wrong ? I know I could add a display method but that not allow the user to filter on this column..

Solution

  • Please note that the Overview grid in form PurchJournalSelect_PackingSlip uses the VendPackingSlipJour datasource while the All grid uses the VendPackingSlipJourAll datasource. You should change the join source of the VendTable datasource to VendPackingSlipJourAll.