Software (include version): Ancora, DocStar IDC, Epicor IDC    


Use Case: This is useful for when client would like to extract both account number and invoice date to use for invoice number. This is done mostly for invoice like utility bills or service bills that don't use an invoice number. AP depts. use the combination of account number and invoice date to make the invoice number


Customer: 


Prerequisites: 


Instructions:

  1. Concatenate Account Number + invoice date into invoice number 

    invoice date display mmddyyyy


    ex...  12345678 05112022                                                                                                     STRJOIN(FT_ACCOUNTNUMBER," ",STRRIGHT(FT_ISSUE_DATE,4),STRLEFT(FT_ISSUE_DATE,4))

  2. ex... 12345678-05112022                                                                                                          STRJOIN(FT_ACCOUNT_NO,"-",STRRIGHT(FT_INVOICE_DATE,4),STRLEFT(FT_INVOICE_DATE,4))






Helpful Links:  Document link