Like to insert line in custom table while creating new line in purchase order

(0) Share

Report

Posted on by @rp@n

Hi All,

As per my requirement, When we create a lines on Purchase Order, at the same time I like to insert the same line on my Custom table.

Say for example - I have Purchase Order - P001 and I have created 5 lines

So, i like to insert those 5 lines in my custom table. but for me it is inserted only the last line when I finally click CTRL S once.

I wrote below code, Can anyone pls verify where is wrong? why it is NOT inserted all he lines in my custom table ?

class PurchLineOnInsertingEventHandler
{
    
    /// 
    ///
    /// 
    /// 
    /// 
    [DataEventHandler(tableStr(PurchLine), DataEventType::Inserting)]
    public static void PurchLine_onInserting(Common sender, DataEventArgs e)
    {
        PurchLine purchLine = sender as PurchLine;

        PurchQtyTracking      purchQtyTracking;
        PurchParameters       purchParameters;

        purchParameters = PurchParameters::find();

        
        if (purchParameters.QtyZeroPOLines == NoYes::Yes)
        {

            // to insert the current record only
            ttsbegin;
            purchQtyTracking.PurchId    = purchLine.PurchId;
            purchQtyTracking.ItemId     = purchLine.ItemId;
            purchQtyTracking.RefRecId   = purchLine.RecId;
            
            purchQtyTracking.doInsert();
            ttscommit;
        }
    }

}

Pls give me more shed on this.

thanks!

I have the same question (0)

All responses (13)

Answers (1)

@rp@n 28 on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

thanks Mohit & Girish

done, through PurchLine - insert method

Was this reply helpful? Yes No
Verified answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

Hi, Please debug doApply method in PurchQuickQuote form. It calls insert method of PurchLine table one by one for all selected records. Also add breakpoint on insert method of PurchLine.

Was this reply helpful? Yes No
@rp@n 28 on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

Let me check, will update you

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

Yes it will be in PurchLine table.

Thanks,

Girish S.

Was this reply helpful? Yes No
@rp@n 28 on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

thanks Girish,

is it Purchline table - Validatewrite method ?

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report
RE: Like to insert line in custom table while creating new line in purchase order

First check whether the validateWrite method at table level is calling without clicking save button.

Refer to the below code - You need to validate the records before inserting into custom table.

PurchLine purchLine = sender as PurchLine; PurchQtyTracking purchQtyTracking,purchQtyTrrackingValidate; PurchParameters purchParameters; purchParameters = PurchParameters::find(); if (purchParameters.QtyZeroPOLines == NoYes::Yes) { //add select statement to validate the record in custom table select firstonly * from purchQtyTrackingValidate where purchQtyTrackingValidate.RefRecId == purchLine.RecId; if(!purchQtyTrackingValidate) { // to insert the current record only ttsbegin; purchQtyTracking.PurchId = purchLine.PurchId; purchQtyTracking.ItemId = purchLine.ItemId; purchQtyTracking.RefRecId = purchLine.RecId; purchQtyTracking.doInsert(); ttscommit; } }

Thanks,

Girish S.

Was this reply helpful? Yes No
@rp@n 28 on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

Hi Girish,

Sorry I not understood.

ValidateWrite method --

"In that case you need to validate the custom table to check whether the current record is there or not - If there do not insert - If not there do a insert operation."

kindly elaborate pls

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

Try adding your code in the validateWrite event handler of the table. In that case you need to validate the custom table to check whether the current record is there or not - If there do not insert - If not there do a insert operation.

Refer to the below blog. Follow the table level validate Write event handler.

https://d365solution.blogspot.com/2019/11/validatedwrite-eventhandler-d365-at.html

Thanks,

Girish S.

Was this reply helpful? Yes No
@rp@n 28 on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

Hi Girish,

When I clicked on Addlines, my eventhandler is NOT getting called.

when I completed the line and press CTRL+S then only called the event handler code

But I am looking for each line to insert in my custom table without press CTRL +S.

Where to write the code? In which method

Please guide me

Was this reply helpful? Yes No
@rp@n 28 on at

Like (0)

Report

RE: Like to insert line in custom table while creating new line in purchase order

Let me check and will update you.

Was this reply helpful? Yes No