Sage 100

 View Only
  • 1.  Customer posted duplicate invoice numbers - best way to renumber ?

    Posted 09-10-2020 10:41
    A customer somehow posted duplicate invoices from the Sales Order Invoice entry. 

    Is there a safe way to DFDM ( or otherwise ) renumber these invoices? I'm sure DFDM would work but am concerned about hitting all the data files.

    Thoughts? Have you ever had to do this and how?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Customer posted duplicate invoice numbers - best way to renumber ?

    Posted 09-10-2020 10:45
    I wouldn't even try.  Invoice history is designed to handle it (HeaderSeqNo)... if they don't want the duplicate, credit one, and re-issue with a new number.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Customer posted duplicate invoice numbers - best way to renumber ?

    Posted 09-10-2020 12:28
    I agree with Kevin.  I have done it before with a few invoices, however, it is very time consuming and it is easy to  mess up the records in AR_InvoiceHistoryHeader.  Obviously, make a backup first.

    ------------------------------
    Lila Korb
    ------------------------------