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)

GirishS 27,825 Moderator on at

Like (0)

Report

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

Hi,

Have you debugged the code?

After creating each line and click on new button does your event handler get called?

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,

I don't know which button you talking about in purchase order form?

Simply I told that in Purch line -- Addlines button is there

and for creating a new line , everytime we clicked on addlines and simply put item id etc..

like this way we created 4 lines. it successfully created on purclines but won't inserted on my custom table.

I hope you understood now

pls give me reply on this.

thanks!

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, I Understood your issue - After creating new line and clicking on AddLine button - Does your onInserting event handler getting called?

You are clicking on save button after creating 5 lines only - In between that you are clicking AddLine button - So I am asking does the debugger hit after entering the new record and click on Add Line button.

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

Let me check and will update you.

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
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,

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

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

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

Yes it will be in PurchLine table.

Thanks,

Girish S.

Was this reply helpful? Yes No