Sage 100

My day for asking questions. How a UDF flow that appears in the PO_Purchase Order detail record? I want to flow the item eventually to the accounts payable invoice history detail table. I am trying to start with the PO receipt table but the PO detail table does not appear. Looked at the help information for mapping, there is nothing. On v4.5.4.

Under data sources, do your system not have the ""copy from PO"" choices?

Very interesting @PhilMcIntosh So PO does not work like the other modules? I don't think I have ever seen a ""copy from"" on any of the other modules or have I just missed it?

SO uses the same copy from method for Sales Order -> SO Invoice

Thanks @MichaelNottoli good to know. I have always linked it from the UDF first screen - Business object but in PO you could not do it that way.

When you create the UDF in PO_ReceiptOfGoodsDetail you want to pull it from ItemCode or you can do a manual entry and create the correct lenght. On the Data Sources Tab you will select PO_ReceiptOfGoodsDetail_Bus:CopyFromPurchaseOrder. The Data Source will be PO_PurchaseOrderDetail.

So is the concensus that you creat a MANUAL udf in PO receipt, then modify it to copy from the PO detail table?

If the field does not exist in CI_Item then yes.

OMG, what has happened here. A UDF is created in the PO detail table but in PO receipt detail you can't pull it directly from the PO detail. Is there any business reason why one isn't able to link directly?????? Where is the QC department?? Oh wait, they are now in direct sales. Should I post on the idea web site?

It should, the only time I have trouble is if my control type, data type and maximum lenght are not all the same on the new UDF as the one I'm pulling in.

I can take a look at it with you if you'd like.

@JeffSchwenk do it the way @PhilMcIntosh said to do it. Create a udf in PO receipt detail same size and type and then go to business object tab and use the copy from.