Skip to main content
Solved

Import Scenario to update existing time activities “Employee Time Activities” screen??


sean21
Varsity I
Forum|alt.badge.img+1

Does anybody know how to update an existing time activity using business event/import scenario? I am trying to update time activities with the correct project task and cost code combination when techs enter time incorrectly. It’s like an “auto-correct” feature…. The GI I have brings in the incorrect time entries, the business event triggers on record insertion, and the import scenario is supposed to replace the project task and cost code with the correct coding. 

The two challenges I see are:

  1. Perhaps I need to place the activity on “hold” first so the project task and cost code are editable fields. You can see in the import scenario that I tried placing on hold, saving, then editing the fields and saving again.
  2. How do I link the records in the GI with the proper time activity? I’m trying to do this using the RefNoteID. It seems as if that’s the only way to link them so the correct entry is updated through the import scenario.  

 

The XML of the GI and import scenario are both attached. I also read the topic below as reference, but that’s for importing new records. 

https://community.acumatica.com/import-and-export-scenarios-117/import-scenario-to-employee-time-activities-screen-7548

 

 

Best answer by cshaheen26

@sean21 @kellymorin16 I managed to get the import to work using the below settings in the import scenario. I am using a GI that pulls current Time Activities and using the RefNoteID as the key.

 

 

View original

Forum|alt.badge.img
  • Jr Varsity II
  • October 6, 2022

@sean21 did you receive an answer to your question? I am running into the issue where my import is just importing another line instead of updating the one already there.


sean21
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • October 6, 2022

@cshaheen26 unfortunately not. I ended up scrapping this and going in a different direction entirely. 


I’m trying to do the same thing. Any ideas out there? I’m trying to update using the RefNoteID but am not able to pull a specific line. @sean21 what direction did you head in?


sean21
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • February 26, 2024

@kellymorin16 in our use case, we were exporting time activities to Workforce Go. I ended up creating a separate GI for the Workforce Go export/integration and used iif statements to ensure that the proper project task/cost code combination was used. Fortunately we had only a few combinations that were possible so it was easy to address with formulas. 


Forum|alt.badge.img
  • Jr Varsity II
  • February 27, 2024

@sean21 @kellymorin16 I managed to get the import to work using the below settings in the import scenario. I am using a GI that pulls current Time Activities and using the RefNoteID as the key.

 

 


@cshaheen26 You are THE BEST! I was missing the Hold lines. Thank you tons!


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