Skip to main content
Solved

Import Scenario to "Reset Sync" on the Salesforce Sync State screen


gorazem
Varsity I
Forum|alt.badge.img

Hello,

I am trying to create an import scenario that’ll allow me to use the “reset sync” button in mass for many records. (Salesforce Sync State - CST.SF.20.50.40) Currently the “reset sync” button on that screen only allows you to checkbox the ones you want reset, and can’t select them in mass. (that I know of)

I tried to create my own generic inquiry, data provider and Import Scenario to do this, but I seem to be running into issues. 

I’m not sure how I “select the checkboxes” on the import scenario for the action “reset sync” Currently when I run my attached import scenario is says success, but the record is not reset.

I can’t seem to get it to work, this is a little more advanced for me so I’m struggling. Any ideas?

Best answer by gorazem

I was not able to get this to work with an Import scenario. I’m guessing that’s because this screen does not have a Key or anything like we would normally expect with an Import. (could be wrong on that)

So instead I created a simple database script that just removed all records from the ‘SFSyncRecord’ table and when I check the “sync status” tab on the Baccount, it is blank like expected. 

Something like:
 

DELETE FROM SFSyncRecord
WHERE SyncRecordID IS NOT NULL;


 

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

2 replies

gorazem
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 39 replies
  • Answer
  • November 7, 2023

I was not able to get this to work with an Import scenario. I’m guessing that’s because this screen does not have a Key or anything like we would normally expect with an Import. (could be wrong on that)

So instead I created a simple database script that just removed all records from the ‘SFSyncRecord’ table and when I check the “sync status” tab on the Baccount, it is blank like expected. 

Something like:
 

DELETE FROM SFSyncRecord
WHERE SyncRecordID IS NOT NULL;


 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2546 replies
  • November 7, 2023

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


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