Sage 100

 View Only
Back to discussions
Expand all | Collapse all

How to print Start Bill Date on AR Invoices created from Repetitives when there are multiple invoices for a single customer without duplicating lines on the invoices

  • 1.  How to print Start Bill Date on AR Invoices created from Repetitives when there are multiple invoices for a single customer without duplicating lines on the invoices

    Posted 04-02-2020 17:54
    I have customized an AR Invoice form to pull in the Start Bill Date field from the Repetitive Invoice Header.  The problem I'm having is that when there are multiple invoices in the batch for the same customer, the invoice lines are duplicated.  I have tried linking the two tables with both LOJ and Equal joins and neither works.  If I remove the Repetitive Invoice Header table, no line duplication.  I thought to create a UDF in AR Invoice Header to pull the Start Bill Date and flow it into the Invoice Work file, but the Repetitive Invoice Header is not among the data sources.  Any ideas about how to solve this problem?


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


  • 2.  RE: How to print Start Bill Date on AR Invoices created from Repetitives when there are multiple invoices for a single customer without duplicating lines on the invoices

    Posted 04-02-2020 17:59
    How about a sub-report?

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------



  • 3.  RE: How to print Start Bill Date on AR Invoices created from Repetitives when there are multiple invoices for a single customer without duplicating lines on the invoices

    Posted 04-02-2020 18:24
    Thanks for the idea Therese.  Learned a lesson from @Jim Woodhead today- I needed a UDF in the workfile from AR Invoice Header.  I didn't realize the reference number field was in the Invoice Header table.​​  Problem solved.

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

    Original Message


Related Content