Receivables & Collections

Get Involved. Join the Conversation.

Topic

    Surya G
    Error while uploading the customer data via FBDI
    Topic posted May 29, 2019 by Surya GSilver Medal: 2,000+ Points, tagged Financials, Receivables 
    62 Views, 4 Comments
    Title:
    Error while uploading the customer data via FBDI
    Summary:
    Error while uploading the customer data via FBDI
    Content:

    Hi,

    Can someone please help me to sort the below error?

    "The customer profile record designated for update does not exist. Update CUST_ORIG_SYSTEM_REFERENCE and CUST_SITE_ORIG_SYS_REF to match an existing profile"

    I'm trying to update the customer payment terms via FBDI(RA_CUSTOMER_INT_ALL), but when i try to import the file the above error is being faced.

    Can anyone please help on this?

     

    Regards,
    Surya

     

    Comment

     

    • Karthikeyan Sukumar

      Surya- Makesure the Customer Orig System Refernce# & Customer Site Orig System Refernce are same value while updating

       

      Thanks!

      Karthik

    • Suresh Kumarasamy

      HI Suriya,

      Is payment term update at customer account level or site level?

      1. If customer account level mean, you should fill only Party, Account and Profile sheet in fbdi.

      2. If customer site level mean, you need party, party site, account, account site and profile sheet in FBDI.

      You have to ensure the all ORIG_SYSTEM_REFERENCE matching across the sheets. Before prepare the FBDI, you can extract the ORIG_SYSTEM_REFERENCE from database and prepare the upload sheet.

       

      Regards

      Suresh

      • Surya G

        Hi Suresh,

        I have successfully loaded the file. 

        1. If customer account level mean, you should fill only Party, Account and Profile sheet in fbdi.

        Yes, you are correct. I tried with this process only later the file loaded successfully.

         

        Regards,
        Surya