90 Minds Community

 View Only

  • 1.  Can you add AR Repetitive Invoice Detail fields to the Repetitive Invoice Listing Report?

    Posted 11-21-2019 15:29
    The client would like to see the Item Description, Quantity and Unit Price fields.  Can't do it by simply adding the Repetitive Invoice Detail file, because line information is replicated.  The Line Key is part of the primary key in the detail file, but there is no corresponding field in the Listing work file.​​  I'm trying a subreport, but not getting any data.  Linking AR Division, Customer No, Reference #, Item Code and Line Sequence No. between main report and subreport.

    Am I on the right track, or is there a better approach?

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: Can you add AR Repetitive Invoice Detail fields to the Repetitive Invoice Listing Report?

    Posted 11-21-2019 16:22
    Add the columns to  AR_RepetitiveInvoiceListingWrk .

    The detail is available as a data source. 




    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------



  • 3.  RE: Can you add AR Repetitive Invoice Detail fields to the Repetitive Invoice Listing Report?

    Posted 11-21-2019 20:21
    Thanks Eric, that did it.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


Related Content