On the Sync History screen, I’ve noticed I can search for an individual order or group of orders if I know the External ID or External Description and it loads very fast with no issues. I’m trying to search for a group of transactions from our Shopify store, but group them by their ERP ID.
If I search for something by ERP ID, it times out every single time with the error “Request Entity is too large”. I try filtering by Last Attempt date down to just one day, only the Sales Order Entity, only Processed or Ready to Process Status, and still times out.
Is there any other way to search for a sync history transaction if I only know the ERP ID and not the external?
Thanks in advance!
Page 1 / 1
Unfortunately no. We’re experiencing the same issue.
@bclark , we see the same issue. The only ‘workaround’ is to export Sync History to Excel and use that for research.
Yes, we have this issue to. Having to export to excel is the only way, but not ideal. Would love to see this fixed within the sync history screen in future versions
Agree it is a real pain when you dont have the External ID
My biggest issue is that I need to try and manually resync a group of orders where the ERP ID’s are all similar. If I could search the ERP ID with a Starts with or Contains with Filter, I would be able to manually sync them all at one time.
Their external ID’s are not similar, so that doesn’t help me.
Exporting to Excel is useful for making sure they are all there, but not for resyncing.
@bclark Let me clarify why the system takes so long/times out when you search for orders in the “ERP ID” field when compared to the other fields. The “ERP ID” field is a dynamically populated field where it concatenates the order type and order number and displays it. When you search for something on this field, it takes a long time.
What are the other options we have in hand?
Option 1: In the exported sync history file, you will find a field call “Sync Record ID”, use that field and search, you can locate your records quickly.
Option 2: Use the “Add New” button
Click on the “Add New” button.
On the popup, select the Store, Entity (Sales Order).
In the ERP ID, select the Acumatica Sales Order you want to sync.
You will get an error with the Sync Record id.
Copy the Sync Record id
Use that value and search in the “Sync Record ID” column, you can locate your records quickly and sync them.
Happy to assist for any further questions.
Best Regards,
Sathish S
@bclark Let me clarify why the system takes so long/times out when you search for orders in the “ERP ID” field when compared to the other fields. The “ERP ID” field is a dynamically populated field where it concatenates the order type and order number and displays it. When you search for something on this field, it takes a long time.
What are the other options we have in hand?
Option 1: In the exported sync history file, you will find a field call “Sync Record ID”, use that field and search, you can locate your records quickly.
Option 2: Use the “Add New” button
Click on the “Add New” button.
On the popup, select the Store, Entity (Sales Order).
In the ERP ID, select the Acumatica Sales Order you want to sync.
You will get an error with the Sync Record id.
Copy the Sync Record id
Use that value and search in the “Sync Record ID” column, you can locate your records quickly and sync them.
Happy to assist for any further questions.
Best Regards,
Sathish S
I’m currently using these methods, but it’s a pain. I don’t understand why this can’t be changed.
