copying a data from purchase requisition to purchase order

(1) Share

Report

Posted on by Danzel Zuo

121

Hi All,

I added a new field “TestFields” to the PurchReqTable (PurchReqTable.TestFields), and added the same field to the PurchTable (PurchTable.TestFields), I want to copy the data from the new field to the PurchTable.TestFields when I approve and complete the workflow on the purchase requisition.

I found the PurchAutoCreate_PurchReq class and in the setPurchTable method, I added purchTable.TestFields = purchReqTable.TestFields; But it didn't work.

When I changed to purchTable.TestFields = 'TEST';, purchTable successfully received the data.

I know that PurchReqTable and PurchTable are not 1 to 1 relationships, but I want to ignore them.

Where should I add the insertion code?

Regards

All responses (4)

Answers (0)

Raj Borad 979 on at

Like (0)

Report

copying a data from purchase requisition to purchase order

Hi Danzel,

You can use the insert method of PurchTable Table and add your logic there.
André Arnaud de Cal... 294,459 Super User 2025 Season 1 on at

Like (0)

Report

copying a data from purchase requisition to purchase order

Hi Danzel,

This should be straightforward. The variable purchReqTable should be set in this class, but probably without all fields. I suggest using the debugger to check the value in your custom field the moment you try to copy the value.
Danzel Zuo 121 on at

Like (0)

Report

copying a data from purchase requisition to purchase order

@André Thank you for your reply.

In fact, I only added this one line of code, I didn't purposely fetch the data from the purchReqTable, and I'm not quite sure how to go about it.
André Arnaud de Cal... 294,459 Super User 2025 Season 1 on at

Like (0)

Report

copying a data from purchase requisition to purchase order

Hi Danzel,

Can you share the full coding you added? Then we can have a look together with you. When your will start debugging you might find out that the variable purchReqTable might not have a record selected or your extension field was not selected in a database call.