how to get invoice amount from vend invoice journal form and display it on Purchase Table form grid?

(0) Share

Report

Posted on by JJDunaid

226

i am working on form customization and wanted to add invoice amount from vend invoice jour form to Purch Table form. I have used COC to add up the field .

but its not showing any data on purchase order form.

any guidence?

[Extensionof (formStr(PurchTable))]
final class PurchTableForm_Extension
{

    
    
    public void  getInvoiceAmount()
    {
        VendInvoiceJour  vendinvoicejour;
        PurchTable purchTable;
        AmountCur invoiceAmount;

        select * from  vendinvoicejour 
            where purchTable.PurchId == vendinvoicejour.PurchId;

        purchTable.InvoiceAmount = VendInvoiceJour::findFromPurchId(purchTable.PurchId).InvoiceAmount;

        
    }

}

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

GirishS 27,827 Moderator on at

Like (0)

Report

RE: how to get invoice amount from vend invoice journal form and display it on Purchase Table form grid?

Hi Junaid,

If you have created new field in the PurchTable then you need to write a script to update the value to the new field for old records. For new records you need to decide when to populate this field.

If it's simple field to display the invoice amount in PurchTable you can go with adding display method instead.

Refer to the below blog for adding display method.

https://community.dynamics.com/365/financeandoperations/b/howtodynamics365/posts/how-to-create-display-method-for-table-extension-in-dynamics-365

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
RE: how to get invoice amount from vend invoice journal form and display it on Purchase Table form grid?

Hi, you don't need select statement. You can refer below code. Have you mapped this method to field in PurchTable form? You can add display method (If you don't want to export data or filter it in form).

public void getInvoiceAmount() { VendInvoiceJour vendinvoicejour; PurchTable purchTable = this.dataSource(IdentifierStr(PurchTable)).cursor(); AmountCur invoiceAmount; purchTable.InvoiceAmount = VendInvoiceJour::findFromPurchId(purchTable.PurchId).InvoiceAmount; }

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report

RE: how to get invoice amount from vend invoice journal form and display it on Purchase Table form grid?

Girish ,

this blog helped me , its now working. My issue is solved by display method.

Thanks,

Was this reply helpful? Yes No

Join the conversation

Community site session details

how to get invoice amount from vend invoice journal form and display it on Purchase Table form grid?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

how to get invoice amount from vend invoice journal form and display it on Purchase Table form grid?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates