• 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…
  • Custom Financial Reporting report linkage problem

    I am using MAS 90 under Windows 7. I have made copies of several custom reports using the Custom Report Maintenance screen, typing in a new report number, and then using the Copy From button to copy the old report number to the new report number. The…
  • Profit & Loss Multiple Year Trend Report

    I am trying to create a profit & loss trend report that compares three or more years. I am using the "Custom Report Maintenance" option in MAS90. Is this possible? Any solutions would be appreciated. Thank you.
  • 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…