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

Reply
  • 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.

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