• Adding field to SO_InvoiceWrk Crystal Report

    We have a number of customers who require their item# to print on the invoice and packing slip and I'm running into performance issues when trying to get a customized SO Invoice Print form to work. I've added those customer specific item #s to the IM_AliasItem…
  • Questions about work tables

    I know how to view contents of a work (wrk) file and I know how to view what tables are used to make a work file, but: 1) how do i know how the tables are linked (joined on what field(s)?) to produce the work table? where can I see this? 2) how do…
  • How to write User Defined Script to calculate Discount?

    I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total. The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount. I don…
  • RE: How to Add UDF to PO Detail Table from PO Header Table

    Thank you very much. It works. However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table. Also, what are all abbreviation of different type of tables, such as header table, wrk…
  • How to Add UDF to PO Detail Table from PO Header Table

    I created a UDF, Estimated Delivery Date, in PO Header. Now I have trouble to add this UDF to PO Detail table. Anyone can help me? User-Defined Field and Table Maintenance-->PO Purchase Order Detail-->Right click-->Edit Fields-->Green '+' on the right…