Hi, @Doug Johnson ,I setup the new integration in 2021 R1 but am still running into issues. Here’s a summary of what I can and cannot accomplish:Download from GitHub, publish ZIP, connect token are successful and same as before For ‘Project Sheet’ mapping, I connected ‘Task Name’, ‘Start’, ‘Duration’, ‘Complete’, and ‘Comments’. If I have ‘Start’, ‘End’, and ‘Duration’, I received an error. If I mapped Approver to ‘Assigned to’, I received an error. I tried mapping different fields to ‘Predescessors’ but received error for all of them. I mapped ‘Status’. Since the default options in Smartsheet do not match the status in Acumatica, subsequent sync did not change task status. I updated % Complete, Start Date, End Date, and Duration in Smartsheet but subsequent sync did not update project tasks. The only field I was able to sync back is ‘Comments’ that I mapped to Task Description.If you’re able to sync your project, can you help me figure out what I’m doing wrong?
@Naveen B. Dumbing down the fields to map is a way to generate the Smartsheet project. But that brings little satisfaction when you cannot synchronize updates back to Acumatica.We have many sales prospects inquiring about project tracking, resource planning, and project management capabilities with Acumatica. We feel that this integration is a good start and has great potential but not ready. In our demos, we focus on Project Accounting but do not elaborate on this aspect and do not market Smartsheet Integration.I wonder if anyone using the Construction Edition has positive result with Smartsheet integration or other ISV tools.
Another reason why I believe field mapping is a little funky is I tried ‘Task Sheet’ in Projects Preferences. I started with all 6 fields. With each error, I tried a different Acumatica field. When nothing works, I left the field blank. I was down to 3 fields (Task Name, Due Date, Comments) when integration went through without errors.
Hi @Naveen B, @Doug Johnson ,I’m experiencing the same errors and found that field mapping in Projects Preferences plays a role. For your first error message, I replicated your setup and found that leaving the PREDECESSORS field blank stopped it from happening. For your second error message that I also cannot get past, I’ve tried mapping to different fields and none of them work.I tested with 2020 R2 (20.211.0037) and I downloaded the ZIP file using the same link that you used.@Doug Johnson you mentioned using customization SmartSheetIntegrationV23. I cannot find that version and wonder if you can share the link to download it. I’d like to use the identical setup as you and see if I can get your results. Eric
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.