Populate UDFs from BOM to Production Order

[ivarsk2]

Dear experts,

Please advise how to technically implement the following requirement in SAP Business One:

We have an UDF in Production BoM title, and the same UDF in Production Order title. The requirement is that whenever a Production Order is created for the respective product/BoM, the UDF from the BoM must be copied to the Production Order.

I know how to accomplish this with UI API when a user would select the product in a new Production Order. But this is only a partial solution, since a Production Order can be created in other ways without user opening a Production Order form, e.g. by using the MRP run.

I could use the SP_PostTransactionNotice and copy the UDF from there at database level, but since the UDFs are on SAP standard tables, I understand this is a no-go because of support policy.

Another approach would be using SP_PostTransactionNotice that writes the queue of to-be-updated production orders to a specific UDT, and then have an external application to monitor that UDT and update Production Orders using Service Layer. But isn't this a bit of an overkill for such a seemingly simple requirement?