Sage 100

4.4.08 with JobOps R3 Astro - I created a custom office UDF in PO detail, added to the PO entry screen and PO_PurchaseorderWork. I added the UDF to the PO form, details C - where the item description and warehouse are printing but the data in the UDF does not appear on the form. Any suggestions? Thanks, Lisa

Have you checked via DFDM to see if the UDF is populated in the work file?

When I go to DFDM - the work file has 0 records. I just added PO_detail to the form and it prints. Thanks.

The work file always has zero records. In order to view it populated, you have to preview the report. Then DFDM the temporary work file that was created (work file name PLUS some additional code indicating who the user is the created it. See the image. If you are trying to tweak a form and are constantly previewing, delete or rename the orginal work file, then copy/rename this temporary file by deleting the user information (e.g.PO_PurchaseOrderWrkJAS052914694700.M4T to PO_PurchaseOrderWrk.M4T). This will allow you to preview the from from withing Crystal Designer. Hats off to Dan B for this trick from many moons ago.

I've done the same with work files @JeffSchwenk when working on a form/report. Either that, or I export to an rpt format so that I have the data. Of course, that doesn't work if you're adding tables, etc.

Great - thanks for the tip!