Map Ship Date and Receipt date in Transfer Order Form

(0) Share

Report

Posted on by AhsanZia

Hi all

I've a scenario where I want to show same ship date and receive date on Transfer Order Form as it is on the Transfer Order History form.

I've written a class to do this, but the values are not changing

Here is my code:

 [FormEventHandler(formStr(InventTransferOrders), FormEventType::Activated)]
    public static void InventTransferOrders_OnActivated(xFormRun sender, FormEventArgs e)
    {
        FormDataSource      InventTransferTable_ds = sender.dataSource(formDataSourceStr(InventTransferOrders, InventTransferTable));
        InventTransferTable inventTransferTable = InventTransferTable_ds.cursor();
        
        
        InventTransferJour  inventTransferJour;
        FormRun             forme;
        FormDateControl     ShipDate, receiptdate, transferId;
       
        

        ShipDate    = sender.form().design().control("LineViewHeader_ShipDate")    as FormDateControl;
        receiptdate = sender.form().design().control("LineViewHeader_ReceiveDate") as FormDateControl;
        
        select inventTransferTable
           join inventTransferJour
            where inventTransferJour.TransferId ==  inventTransferTable.TransferId;
        {

            if(inventTransferJour.UpdateType == InventTransferUpdateType::Shipment)
            {

                inventTransferTable.ShipDate     = inventTransferJour.TransDate;
                
            }
            
            if(inventTransferJour.UpdateType == InventTransferUpdateType::Receive)
            {

                inventTransferTable.ReceiveDate  = inventTransferJour.TransDate;
           
            }

            inventTransferTable.update();
          

        }
    }

Can someone please help me

Kind regards.

I have the same question (0)

All responses (10)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

Have you tried writing display methods for these values?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,904 Super User 2025 Season 2 on at

Like (0)

Report

Moved to the Dynamics 365 Supply Chain Management forum.

Was this reply helpful? Yes No
AhsanZia 30 on at

Like (0)

Report

No Gunjan

Guide me please

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

You can follow this link for an example. You can use the existing query to display the dates in new controls as per your requirement

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

Were you able to get this working?

Was this reply helpful? Yes No
AhsanZia 30 on at

Like (0)

Report

No

I'm trying finding the correct event handler to use in my current code

I want the shipment and receive dates to come from Transfer Order History form, which are obviously the actual shipment and receive dates

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Ahsan,

You are looking to just display these values in the transfer order history form. Correct? Or are you looking to create new fields and insert these values there?

Was this reply helpful? Yes No
AhsanZia 30 on at

Like (0)

Report

I'm looking to get the Ship Date and Receive Date values from Transfer Order History form and show these value in the Transfer Order Header's Ship date and Receive date.

Which means I want the Transfer Orders to always get the Ship date and Receive date from the Transfer Order History's Ship date and Receive date

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Ahsan,

Since you the history table is created on posting the transfer order, you should write an extension of the InventTransferJour\insert method using CoC. This will update the dates when posting the order.

[ExtensionOf(tableStr(InventTransferJour))] final public class InventTransferJour_Extension { public void insert() { InventTransferTable inventTransferTable; next insert(); ttsbegin; select forupdate inventTransferTable where inventTransferTable.TransferId == this.TransferId; if(this.UpdateType == InventTransferUpdateType::Shipment) { inventTransferTable.ShipDate = this.TransDate; } else if (this.UpdateType == InventTransferUpdateType::Receive) { inventTransferTable.ReceiveDate = this.TransDate; } inventTransferTable.update(); ttscommit; } }

You can write a simple job to update the existing orders.

It is not recommended that you update the table every time you open a form. Hence you must take care of this using table methods only.

Was this reply helpful? Yes No
AhsanZia 30 on at

Like (0)

Report

Thank u so much Gunjan

This is the right answer and did the job!!

Kind Regards,

Ahsan Zia

Was this reply helpful? Yes No

Join the conversation

Community site session details

Map Ship Date and Receipt date in Transfer Order Form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

Map Ship Date and Receipt date in Transfer Order Form

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 > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates