Is it safe to run “Validate Inventory” on a weekly basis?
Best answer by Gabriel Michaud
View originalIs it safe to run “Validate Inventory” on a weekly basis?
Best answer by Gabriel Michaud
View originalDoug,
My experience is that it is safe to run the “Validate Inventory” on a weekly basis. I have clients that run it daily as well. What you want to be aware of is that in setting the schedule you want to select “Weekly” and avoid the “Daily” schedule type unless absolutely necessary. The “Daily” type can impact your system’s performance even though the process is not running because the system is constantly checking the schedule. In addition setting the “Validate Inventory” after hours obviously would be a good idea as well.
I hope that helps.
Dan
If the inventory balances become invalid, this is because you have a data integrity issue somewhere that is caused by a bug in Acumatica, and this should be reported to support...
Thank you. We recently changed the inventory that shows on our Big Commerce website from all to one location. After the change we noticed inventory from the a second location is showing up on the website when it should not. We noticed the issue right after we made this change. So we are working on the assumption the issue is related.
And I have reported this issue.
>And I have reported this issue.
If you moved all items from location B to location A, and than re-synchronized Availability in the BigCommerce connector, than Products Quantities should be good. If it is not the case, i would like to review it.
The case I have with Cloud 9 is Case Number 053129. Please note;
I greatly appreciate your looking into this matter. Thank you.
Doug
We have more examples of items being in the Ketchikan warehouse (A location that is set up not to show on our Big Commerce website) showing up on our website. I can provide them if it will help you solve this issue.
Hi Doug,
I have done some investigation locally on this subject but it works fine.
Could you please try one thing for me please?
If I’m right, than you should have correct Qty. I suspect that the problem is that you haven’t re-synchronized items after you changes settings in the store preferences.
We fixed it in 2020r2 version of Acumatica where resync will be happening automatically. In 2020r1 it has to be done manually.
If that is the case you should do Reset Sync in the entities page and sync availability one more time for all the entities.
This fixed the issue of SKU 3005E, which is in Ketchikan, showing up on our Big Commerce website, which is configured to only show items in Anchorage. SKU 3005E is no longer on our website (which is now correct). Thank you.
Here is what I found when i followed your instructions. Please note what I found is slightly different than what you said I would find:
Thank you so much.
PS: Should I run “Re-Sync” for the other tenants?
Doug
Hi Doug,
Thanks for checking and I glad that it helped! If you have the same problem with the other tenants/stores feel free to do it there too. Also you are right that you did Reset Sync only for Availability - it is the right approach.
Please note that you need to do this only once, when you change settings of the warehouses/locations.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.