Skip to main content
Solved

Customer Activities Import Scenario

  • Jan 23, 2024 7:07 PM UTC
  • 6 replies
  • 573 views
  • Translate All

jhouser
Captain II
Forum|alt.badge.img+7

A large number of activities were imported to Customers in Open status. They want all of them completed. I’m trying to craft an import for this action, but getting an error on Summary field. 

I thought all I would need is the ID (noteID field) since that’s the primary key in CRActivity. 

Tried adding summary field though, and still getting the error. These are existing activities, so ID and Summary are from a file I exported out of Acumatica. 

Thoughts anyone?

 

 

 

Best answer by jhouser

I opened a case with Acumatica for assistance with Delete Activities. Their adjustments worked so I applied similar changes to Complete Activities, which also worked. My original response to error was to add Summary field, but turns out some other tweaks are what was needed. Kudos to the support rep who helped. 

 

 

 

View original

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Jan 24, 2024 12:28 AM UTC

@jhouser  Can you please share your import scenario here?

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • Jan 24, 2024 12:53 PM UTC

@Naveen Boga Certainly, it’s attached. Thanks!

Translate

bryanb39
Pro II
Forum|alt.badge.img+6
  • Pro II
  • Jan 24, 2024 3:05 PM UTC

I would think you need a key for the document it's referencing as well. Even if it's not showing as a key on the import scenario. I just dealt with a similar issue for contacts last night. 

It didn't work with just contact, I needed Contact and Customer to update the existing record.   

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • Jan 26, 2024 7:38 PM UTC

@bryanb39 I tried adding baccountID as the related entity, but that didn’t solve the issue. I then tried starting with Customer screen in Import Scenario, but in the Activities object there is no noteID field (the primary key). 

I then tried creating an import to just delete these activities, but get the same error shown above. That import scenario is also attached. 

 

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • Answer
  • Jan 31, 2024 9:26 PM UTC

I opened a case with Acumatica for assistance with Delete Activities. Their adjustments worked so I applied similar changes to Complete Activities, which also worked. My original response to error was to add Summary field, but turns out some other tweaks are what was needed. Kudos to the support rep who helped. 

 

 

 

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Jan 31, 2024 11:24 PM UTC

Thank you for sharing your solution with the community @jhouser!

Translate