Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UDF on AR history inquiry form; scroll thru invoices behavior? 1

Status
Not open for further replies.

webhoncho

IS-IT--Management
Jul 22, 2006
2
US
Mas90 3.71
I added a 1,000 character text UDF on its own tab to AR Invoice History Inquiry. (UDF is used on AR Invoice Entry and on customized Customer invoice. Works fine.)

A question on using UDFs on their own form Tabs: Normally in Invoice History inquiry, you can scroll through invoice data when you are viewing either Tab, Header or Lines. However, I can't do this on a new Tab (which I created to show my "new" UDF). I can go to a specific Invoice and go to the new tab and the data in the UDF is retrieved, but it doesn't look like a UDF can be pulled dynamically using the "VCR" buttons to scroll through invoices. Nothing appears until I go to one of the original Header or Lines tabs, and then back to the new tab.

Funny that Mas90 knows I clicked the VCR button X times since the invoice number will move up X invoices equal to the times I clicked the VCR buttons, but ONLY after I go to to either one of the original tabs. Looks like the UDF query is done after a specific invoice # is pulled up, so this may be normal behavior. But if anyone knows how to change this behavior (VB scripting?), I'd appreciate help.
Thanks!
 
Can't be done with VB as this is not what the program is written in. UDFs are in separate tables when you scroll through the invoices you have to move to another tab and then come back to the UDF panel so the program can requery the table for the data.
 
A bit more. This is normal behavior. When you scroll through the invoice records you see changing data on the other panels because you are reading the detail of the record. The UDF data does not change because it is in a table of it's own and it is not automatically requeried when the record changes. You have to exit the panel and then come back in. The action of coming back to the custom panel with the UDF requeries the UDF table.
 
BigLouie - Thanks for confirming this is the way it works. I appreciate the details on the UDF panel behavior.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top