FKV (Multi-Key) New Table

Epicor ERP 10
1

I created a BOOL UD Field in VendorPart called Certified_c. I want this is be a view-only reference in PO Entry & Tracker on the Lines/Details as well as in Receipt Entry &Tracker on the Details/Lines. I was trying a low code no code approach but not sure if that’s an option. I was hoping to have a checkbox that the user would see in the mention forms. I tried creating a FKV with multi-keys but i’m not seeing how to connect to the VenderPart table in PO Entry form. I thought would use a BAQDropDown. This seemed to work but the use has to click on it to see the values. Also it caches the value when user moves between PO lines.

I though this would be pretty straight foward…am I missing something easy?

2

I would add Certified_c to PODetail and RcvDtl. Put the field read only on the form and post processing on PO.ChangeDetailPartNum and Receipt.GetDtlPOLineInfo populate the field.

This should all update into the new UX also.

3

I ended up added those fields as suggested. Then I added PostProcess Method on GetByID to populate that field on the PO and Receipt. Seems to work.

Thanks!

1 Like
4

GetByID would be a second opening of the PO or Receipt and if the PO is approved or the receipt completed on the first pass this could be missed.

5

Yeah that right. I was using PO.ChangeDetailPartNum and Receipt.GetDtlPOLineInfo to show a popup message. I just added the widget to populate s field there as well. Then I added the GetByID to populate the field when they go back in as you stated. This seems to do the job. I wish I could have just done it with callcontext but it just seemed way to messy.
Thanks again !

1 Like