Hello,
I'm looking some existing reports in SAGE 100 and some has User Define Function (UDF) so how do I look at the detail definition of those UDF?
Thank you.
UDF = user defined field (not function).
Always appreciate you quick help. Thanks for correcting me "Function to Field", So it seems 1st I have to create UDT and then UDF right? Can you point me to the document that talks about the UDT and UDF and when to create those?
Thanks again..
UDF's can be in any table listed when you open that screen. Check the help files (? button at bottom right of panel).
Hello,
How can I find which job is tie with the work order? What is the tie point between job table and workorder table?
Thank you.
Hi, it looks like you are working with the Work Order Module. If so, those legacy modules UDF's are not added into their respective tables, rather, there are several UDF Tables depending on which file has the UDF defined for it. For work order, the UDF tables range from WO_95xxx to WO_99xxx. The work order header table UDF field is WO_95xxx.
If this is a custom report, I would suggest you open up the report you are looking at in Crystal and click on the field in question, it will tell you where it comes from and you can back trace it there. Legacy UDF's are usually linked into a report, as opposed to a Framework UDF that is brought in via mapping of the work tables.
Thanks for your reply. But in general if I want to develop a new report and wanted find out all jobs tied with the work orders, how do I tie those tables? Is it a one-to-one relationship (one WO Per Job)?
Thanks again.
*Community Hub is the new name for Sage City