• How to get Crystal Reports to Pull Data from 2 Unrelated Tables and Summarize Them

    I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files and I have the exact same report pulling data from our un-posted SO_InvoiceHeader and SO_InvoiceDetail tables. I want to have the two…
  • How to Sort a Crystal Report by Positive or Negative Summary Fields and also by Item Number

    I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files. I want to have it subtotal the quantities of each of the products and then print all items with a negative number on one page and all…
  • 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…