Receivables & Collections

Get Involved. Join the Conversation.

Topic

    Nicole Wilson
    Update AR invoice number in AutoInvoice table from Contracts...
    Topic posted May 22, 2019 by Nicole Wilson, tagged Receivables 
    51 Views, 1 Comment
    Title:
    Update AR invoice number in AutoInvoice table from Contracts source
    Summary:
    Need a method to update the AR invoice number in the AutoInvoice table from Contracts before importing into AR for converted invoices
    Content:

    We working on conversions for AR transactions and Project Contracts.  We would like to use the original transaction number as the converted transaction number from Contracts.  Is there a way to update the AR invoice number in the AutoInvoice table from Contracts before importing into AR for converted invoices?

    Version:
    19B (11.13.19.04.0)

    Comment

     

    • Brian Wolfe

      Nicole,

      You should be populating the row in AutoInvoice table with the converted transaction number at the outset.  Please note the following:

      TRX_NUMBER

      VARCHAR2(20)

      Identifier of the transaction, which is either system generated or provided by the user.

      You should only populate this attribute if you have not enabled the Automatic Transaction Numbering option on the transaction source used for this record.

      Regards,

      Brian