Sage 100

Have a UDF that pushes to AR_InvoiceHistory. The field flows fine, data is good. I can create a lookup from Invoice History Inquiry and add the UDF (Project) and it's perfect. DFDM looks great. The issue is when I open up the invoice in Invoice History Inquiry, most of the time the UDF (Project) is wrong. But, the really strange thing is that if we click on the addesses tab and then close the addresses tab, it's like it refreshes and pulls in the correct UDF/Project value. But of course the customer doesn't want to have to do that each time, and they don't want to rely on the custom lookup - they just want to open up the Invoice in Invoice History and see the correct Project #. Has anyway seen anything like this before? Thanks

When you see the wrong Project# on the screen, does that happen to be the correct one for the previous or next invoice? If so, on your lookup do you see a ""blank"" invoice history record - something w/o an Invoice No and HeaderSeqNumber or just plain looks invalid? If so you could make a backup of AR_InvoiceHistoryHeader and DFDM delete that record then see if correct Project# displays.

we actually changed the UDF value in DFDM (AR_InvoiceHistoryHeader) on one of the incorrect values that was pulling up - to see if it was really pulling from that table - just the wrong record - and it's not. Even after changing all of the 123 project values to BOO for instance, some Invoices still pulled up 123 for the project - even though that value no longer existed in AR_InvoiceHistoryHeader. It's not always the same bad value, it seems to move around. I've tried to look at logic (previous, next, customer) and I can't see any logic to the madness.

Have you tried just doing the silly stuff like re-updating the UDF in UDF Maintenance and rebuilding AR_InvoiceHistoryHeader

yeah - tried that, I just tried a new custom panel and moving it down to a different section, but no luck. Looks like maybe Sage has had some issues with UDF's here in past versions, I'm probably going to give them a call - just seems like a bug.

What version? Is the Inquiry panel customization set for All Users / All Companies and then by chance do you have some individual users or company customizations set up also for this panel? A few times we've seen conflicts if there are individual user settings as well as All / All.

Thanks for the feedback Susan and Alnoor - I believe the panel is all users/one company, and then I created a new panel for just my user and it still had the same issue.

Which version and product update?

sorry, meant to answer that - 4.5 PU5 - no custom programming but some scripting - but nothing that should be firing from history/inquiry.