Receivables & Collections

Get Involved. Join the Conversation.

Topic

    Veth Aven Espanol
    Autoinvoice Error: Primary Sales rep ID, Ship to ID, Bill to...
    Topic posted October 23, 2019 by Veth Aven EspanolGreen Ribbon: 100+ Points, tagged Financials, Receivables, Revenue Management, Security, Setup / Administration 
    26 Views, 1 Comment
    Title:
    Autoinvoice Error: Primary Sales rep ID, Ship to ID, Bill to ID
    Summary:
    Autoinvoice Error: Primary Sales rep ID, Ship to ID, Bill to ID
    Content:

    Whenever running Autoinvoice for multiple customers the following errors are received:
    The original system bill-to customer ID {ORIG_SYSTEM_BILL_CUSTOMER_ID is invalid. (300000039020473)
    The ship-to customer identifier {SHIP_TO_PARTY_ID is invalid. (300000039020471)
    The original system bill-to customer address ID {ORIG_SYSTEM_BILL_ADDRESS_ID is invalid. (300000039020474)
    The ship-to party site identifier {SHIP_TO_PARTY_SITE_ID is invalid. The party site either does not exist or is not associated to the ship-to party. (300000039020475)
    The primary salesperson ID {PRIMARY_SALESREP_ID is invalid.

    Comment

     

    • Sudhakara Rao Kovuru

      Hi Veth Aven,

      These are the mandatory columns which must be populated in Interface table (RA_INTERFACE_LINES_ALL) from the source so you need to review each transaction and update the corresponding values in the interface error correction form then re-run the AutoInvoice so that they will go through.

      The original system bill-to customer ID {ORIG_SYSTEM_BILL_CUSTOMER_ID is invalid. (300000039020473)

                   --> 300000039020473 Bill to customer might be inactive or end dated or different customer id might be populated 
      The ship-to customer identifier {SHIP_TO_PARTY_ID is invalid. (300000039020471) 

                  --> 300000039020471 ship to customer might be inactive or end dated or different customer id might be populated 
      The original system bill-to customer address ID {ORIG_SYSTEM_BILL_ADDRESS_ID is invalid. (300000039020474)

                  --> 300000039020474 Bill to customer Site might be inactive or end dated or different customer id might be populated 
      The ship-to party site identifier {SHIP_TO_PARTY_SITE_ID is invalid. The party site either does not exist or is not associated to the ship-to party. (300000039020475)

            --> 300000039020475 Ship to customer Site might be inactive or end dated or different customer id might be populated 
      The primary salesperson ID {PRIMARY_SALESREP_ID is invalid.

             --> Salesrep id might not populated or Invalid , you pass default -3 (no salesrep)

      Please check and let me know.

      Thanks,

      -Sudha.