UDFs in Transaction Entries

SOLVED

I'm attempting to make a UDF that will appear on the 8. Cost Detail Tab in Item Maintenance and be available to report on for some government requirements.

I've been able to add the UDF in IM_Transaction Tier Distribution Entry, PO_Receipt Tier Distribution, and link them both to IM_Cost as business objects.

I then made changes to the entry form to add the place to enter my UDF in the customizer and was able to select my field.

When i tired to enter a transaction and put data in the field, i get an error that "The column is not in the IOList"

Can someone explain what that means, and what other table(s) i need to update to get the field to make its way through to IM_Cost?

Thanks,

Ryan

Parents Reply
  • 0 in reply to Kevin M

    Awesome trick!

    So i got it to include my fields and they were included through data entry, when i tried to post i got the following error:

    Error 88 .... Invalid/unknown property name

    O/S Error ... Path not found (err/ret=2/0)

    Program .... SY_MAINT.PVC

    Statement.... 3187

    Class.....PO_PurchaseOrder_Bus

    Method......CallScript

    I assume another table that needs the UDFs added?  Or is this getting more complicated now?

Children
  • 0 in reply to Ryan OHara

    It sounds like you have a P/O Entry script that that needs to get excluded from Updates / Postings. In your script you can avoid it from firing off in the middle of an Update like this:

    If oSession.Updating = 0 Then 
    ' do rest of script .

    Another way: 
    If oSession.Updating Then Exit Sub

  • 0 in reply to Alnoor

    Makes sense, the issue is not with the transactions but something in my test server setup processing the posting...

    So the last issue i now run into is that I need my UDF to cause the Item_Cost Table to keep entries with different values separate.  I see that my first test was unsuccessful where i repeated a lot/serial number and used different UDF values, but I only see one of my UDF entries and the Lot/Serial quantity is inclusive of both entries.

    Anyone know if that is possible?

  • 0 in reply to Ryan OHara

    If you are trying to set up Expiry Dates, v2020 adds that feature.

    The cost tier handling is based on the key values, and UDFs are just extra data (where last write wins).  If you want another row, choose a different lot# / serial#.