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