Add vendor name field to PurchLineDocument Query

(3) Share

Report

Posted on by D365FO Junior-Dev

532

Hi Everyone,

I want to add the vendor name to the PurchLineDocument query so that it can be displayed in the workflow editor placeholder for the purchase order lines.

I tried the following approach but it didn’t work for me.

[ExtensionOf(classStr(PurchLineDocument))]
 final class Test_PurchLineDocument_Extension
{

    

    public str parmVendorName(CompanyId _companyId, tableId _tableId, recId _recId)
    {
        PurchLine purchLine;
        VendTable vendTable;
        str vendorName;
        purchLine = PurchLine::findRecId(_recId);

        if (purchLine)

        {
            vendTable = VendTable::find(purchLine.VendAccount);

            if (vendTable)
            {
                vendorName = DirPartyTable::getName(VendTable.Party);
            }

        }

      return vendorName;
         


        

    }

}

However I added the VendTable and DirPartyTable as DataSouce to the query to get the vendor name but I have no idea how to correctly create the relationships between PurchLine, VendTable, and DirPartyTable.

Thanks

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Suggested answer

Waed Ayyad 9,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @D365FO Junior-Dev

Adding vendor name as parm should work. Did you build and sync your project after you created Test_PurchLineDocument_Extension class? if yes, try to sync build the model and Sync the Database.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
D365FO Junior-Dev 532 on at

Like (1)

Report
Copy link

Link copied!

Yes I did both of them, I think my approche is not correct I am looking for a better solution.

Was this reply helpful? Yes No
Verified answer

Waed Ayyad 9,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Change the return type of parmVendorName to Name instead of str, build and sync the project then try again.

Or If you want to add fields to Query, the relation is start between PurchLine and VendTable on PurchLine.VendAccount == VendTable.AccountNum

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 305,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi D365 Junior Dev.

Can you please be more specific on the current behavior? What exactly do you mean by "didn't work for me"? Can you see a new field in the workflow editor or not? If yes, is the outcome wrong or do you get a runtime error?

Using the return type as mentioned by Waed, you will have a field label in the query. So this is recommended to change in your coding. The suggested data type mentioned by Waed will give a label Name. In case you want to have a field available for selection called Vendor name, you can search for an existing other extended data type or create a new one with that label. At least the VendName data type is also only showing Name.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,634 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
By the way, you could simplify your code to this:

[ExtensionOf(classStr(PurchLineDocument))] final class Test_PurchLineDocument_Extension { public str parmVendorName(CompanyId _companyId, TableId _tableId, RecId _recId) { PurchLine purchLine = PurchLine::findRecId(_recId); return VendTable::find(purchLine.VendAccount).name(); } }

Was this reply helpful? Yes No
D365FO Junior-Dev 532 on at

Like (1)

Report
Copy link

Link copied!

Hi everyone @Martin Dráb @André Arnaud de Calavon @Waed Ayyad thank you for your answers at my first step I wasn't able to find the name of the vendor in the workflow placeholders after creating a custom EDT and setting the label text to Vendor Name I was able to locate the label.

Was this reply helpful? Yes No