Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

To update the customer on new sales order , when importing the sales order from entity .

(0) ShareShare
ReportReport
Posted on by 1,479
hi,
Everyone ,
I need to update the customer account and all the customer details from the default customer which i have added to cust parameter table  to the new sales order when i am trying to import the sales order through entity , can anyone guide me on this , 
 
 
 
 
thanks 
Regards,
Dinesh
  • Dineshkarlekar Profile Picture
    1,479 on at
    To update the customer on new sales order , when importing the sales order from entity .
    hi , 
    Martin ,
    Thanks for Reply ,
    You were right ,there will be issue if new sales id will be inserted , number sequence is the issue and if i tried to follow the no seq then it search for the recid in salestable if not found it will through validation error "Results  Validations failed while writing entity record". 
     
     
    thanks,
    Regards,
    Dinesh
  • Martin Dráb Profile Picture
    231,931 Most Valuable Professional on at
    To update the customer on new sales order , when importing the sales order from entity .
    You seem to be saying that data was inserted, but you have a problem with some unknown query.
     
    Because it's a different problem than how "to update the customer", it doesn't belong to this thread. Please create a new one, give it a descriptive title (I can't give you a suggestion, because the topic isn't clear to me) and explain your problem in detail there.
     
    Because you seem to have a problem with a query, make sure you explain what the query does and when you run it. Also, explain what you found when you debugged it. If a query doesn't fetch expected data, the problem may be either in query or in the data. Therefore check if the expected records exist and if so, identify the condition that filters them out.
  • Dineshkarlekar Profile Picture
    1,479 on at
    To update the customer on new sales order , when importing the sales order from entity .
    Hi , 
    Martin , 

     In my excel i have followed the number sequence , data is getting uploaded in staging , with no errors , but staging status is not started , and in here new record is getting inserted into salestable but , my salestable query is selecting first record . so i am not able to insert new record in salestable . 

  • Martin Dráb Profile Picture
    231,931 Most Valuable Professional on at
    To update the customer on new sales order , when importing the sales order from entity .
    I already responded in your original thread.
  • Dineshkarlekar Profile Picture
    1,479 on at
    To update the customer on new sales order , when importing the sales order from entity .
    hi ,
    Martin ,
    Thanks for reply ,
     
    as you say existing sales order cannot be modified but when i am importing the new sales order through excel then , is that possible to change .
     
     
    thanks,
    Regards,
    Dinesh
  • Martin Dráb Profile Picture
    231,931 Most Valuable Professional on at
    To update the customer on new sales order , when importing the sales order from entity .

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,272 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,931 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans