Hi,
I added a custom filed on Register Purchase Order Arrivals screen, can I know which table will the custom filed be saved to? I checked the debug console but didn’t find any clues, could someone help me on this?
Many thanks.
Hi,
I added a custom filed on Register Purchase Order Arrivals screen, can I know which table will the custom filed be saved to? I checked the debug console but didn’t find any clues, could someone help me on this?
Many thanks.
Hi
Thanks for explaining your issue clearly once again. Just to confirm, In other words, that your requirement is to add a persistent custom field on the PurchaseOrderLine LU and add it to be appeared on the Receive dialog box. And then When you do a receival of an PO arrival, you want to save the entered custom field value, back to the PurchaseOrderLine LU’s custom field value.
If this is what you are expecting, as per my understanding, this seems not technically possible, since the table in the Receive dialog box is not permanently mapped with a particular data source (to be persisted) and which fields should be saved is handled via a separate business logic/function.
But as a workaround, you can enter it separately after the receival or before receival of the order line in Purchase Order Lines window. Or if the custom field is introduced in PurchaseReceipt LU, then you can enter it in the Purchase Receipt window after the PO receipt is created upon registering the arrival. But I don’t think that it is very user friendly and productive.
What I meant earlier was something similar to this.
You can customize the below sample query to retrieve data as per your requirement.
SELECT * FROM
PURCHASE_RECEIPT_NEW pr,
PURCHASE_ORDER_LINE_NEW_cfv pol
WHERE pol.order_no = pr.order_no
AND pol.line_no = pr.line_no
AND pol.release_no = pr.release_no;
Hi
If you want to query the purchase receipt related data, you should join the view PURCHASE_RECEIPT_NEW with the relevant keys in order to get those data as well.
/Ruchintha Samararatne
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.