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

  • +1
    verified answer

    Do you have multi-bin?  I think that changes the table where tier data is entered.

  • 0

    This error means the UDF column you added (for one of your entities) got updated in the dictionary but not in the physical table. This tends to happen more on the Premium version when there are many company codes.

    Regardless, change into the company you were trying to enter data for. Then go back to User Defined Field and Table Maintenance, then one at a time, double-click each entity that you touched (IM Item Cost, PO Receipt Tier Distribution, IM Transaction Tier Distribution, and anything else) and for each one, click Update button. Everyone should be out of Sage when you do it.

    Then back on the screen where you added the UDF with Customizer, now using Customizer again, remove the field from the panel, then add it right back. Save the panel, exit Customizer, then trying entering data into the field again.

  • 0 in reply to Kevin M

    I do have Multi-Bin.  Any chance you know what the different table names are?  Nothing else seems that obvious

  • 0 in reply to Alnoor

    Followed those steps, but same result.  Any chance it has to do with multi-bin?  

    I updated the Multi-bin Tier distribution panel in customizer and it allows me to pick from the UDFs I created, so i would think i got the right tables... Is there some sort of WRK table or anything else that needs to be updated in the background to allow the data to be entered?

  • +1 in reply to Ryan OHara
    verified answer

    Found the IM Multi-Bin Transaction Entry Tier Distribution in the list... dont know how many times i scrolled past it... Let's see if this works

  • 0 in reply to Ryan OHara

    I was able to get the get this to work.  Tested with an Inventory adjustment and i can see my fields on the cost detail tab of item maintenance!  

    Last issue that i have is i can not seem to find a way to customize the distribution screen in Purchase Order Receipt of Goods Entry.  Any idea where to find that screen in customizer Selection?

  • +1 in reply to Ryan OHara
    verified answer

    With the panel open for data entry try Ctrl + F9.

  • 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?

  • 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?