Skip to main content
Solved

Cannot Update Customer Price class with import scenarios


frankneo
Freshman II

There seems to be something wrong with import scenarios to update existing customers.  The customer exist in the system and I only had two columns in the excel file, Customer ID and Price Class ID.  When importing, the error is “Legal Name cannot be empty”.  When I add the Account name into the excel spreadsheet, I get “Email address must be specified if “Send statements by Email” option is activated.  The account already has an email address.

I do not want to introduce more fields into the excel spreadsheet as I am just updating the Customer Price Class but it just seems impossible.

Why can’t I just update one field?

Best answer by Laura02

Thank you. When you manually type in the customer id, do you type the Dash, or does Acumatica Add the Dash?

I am wondering whether your Customer ID;’s are segmented.  When ID’s are segmented, we do not type the dash and we do not include the Dash when importing the price class update.

If the Dash is removed from Customer ID in the spreadsheet records, does the import work?

Laura

View original
Did this topic help you find an answer to your question?

8 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @frankneo 

Please find the Import scenario for the customer class

 


frankneo
Freshman II
  • Author
  • Freshman II
  • 9 replies
  • April 1, 2024

I do not have Execute action in my version which is Build 2022.205.  These are all the fields I have.

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @frankneo 

Please find the screenshot of the actions.

It should be common for every build.

Please untick the below one and process 

 


frankneo
Freshman II
  • Author
  • Freshman II
  • 9 replies
  • April 1, 2024

I tried unticking commit for Customer name, Price Class ID or both, I get issues with email address as shown below.  Emails exist in these existing account.
 

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • April 1, 2024

Hello @frankneo ,

Please show the customer ID’s that are in your Excel sheet and show the same Customer ID’s that are in the Customer screen?

Are you able to manually update the same Price Class field on the customers manually, without seeing any messages, and save without error manually in the Customers profile screen?

Thank you.

Laura


frankneo
Freshman II
  • Author
  • Freshman II
  • 9 replies
  • April 1, 2024

Here is the customer screen.  The price class was changed and saved with no messages popping up.

No errors.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • April 1, 2024

Thank you. When you manually type in the customer id, do you type the Dash, or does Acumatica Add the Dash?

I am wondering whether your Customer ID;’s are segmented.  When ID’s are segmented, we do not type the dash and we do not include the Dash when importing the price class update.

If the Dash is removed from Customer ID in the spreadsheet records, does the import work?

Laura


frankneo
Freshman II
  • Author
  • Freshman II
  • 9 replies
  • April 1, 2024

Thank you so much Laura.  Mystery solved.  There were 2 segments and after deleting the dash, it uploaded with no problems.  


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings