- This topic has 3 replies, 2 voices, and was last updated 2 years, 3 months ago by Travis P..
-
AuthorPosts
-
7 August 2024 at 7:55 am #8506SBSteven B.
Hi all,
not sure of this is a Dynamic Ship issue or simply BC issue but our BC 24.3 Saas has been extremely slow lately when trying to post dynamic ship worksheets. It’s especially true when another colleague is posting a batch of invoices. Looking at the database locks, I can see that Dynamic Ship locks the database at many levels.I understand that both posting at the same time can cause conflicts since it’s doing inventory adjustments but it’s never been a problem until about a month ago. Don’t know if it’s a coincidence but we updated to BC 24 around a month ago.
Is there anything that can be done ?
7 August 2024 at 8:06 am #9967TPTravis P.Insight WorksDynamic Ship does not generate locks on posting, it is just waiting for something else to release locks that were already in place before the shipment was posted.Make sure that users who are posting the Warehouse Shipments have an entry on the IWX User page with the “Manage License Plates” permission enabled so that they have the correct access to license plates and their locks.
It is not just for posting, but Microsoft says that if you enable “Allow Gaps In Nos” option on the License Plate number series it will improve performance and cut down lock time.
Uninstall any Dynamic Ship Update/Hotfix, EasyPost Update and License Plate Posting apps from the Extension Management page as they are no longer applicable.
Make sure that Warehouse Insight handheld devices are each using unique logins. Shared logins are bad for performance.
Many posting locks are caused by Automatic Cost Posting being enabled in Inventory Setup.
You may also want to archive old license plates so that the LP table has less open records:7 August 2024 at 8:49 am #9968SBSteven B.Thank you for the reply Travis.
I will tick “Allow Gaps in Nos” if it doesn’t hurt performance.
As for the uninstall of the application, I have none of the ones you mentioned.
This is what I have. Should some be removed ? Is WHI Sample Factboxes needed ?
Regarding the locks, we managed to optimize this by making some changes to our setup. I will document this here as it might help others.
1) In “Inventory Setup” we unchecked “Automatic Cost Posting”. This will disable all the calculations when posting an invoice or shipment.
2) We still need to update the costs so instead, we run this on a job queue once per day, every night.
3) Open the job queue and run the codeunit 2846.
4) We also created another job queue that runs report 795.By doing this, our shipments and invoice postings has been greatly accelerated.
7 August 2024 at 9:27 am #9969TPTravis P.Insight WorksJust the aps that were listed should be uninstalled because they have been rolled into the current build of the apps on AppSource.
The sample factbox app is for customizations, so that is not something that will get rolled into new builds.
-
AuthorPosts
- Sign in below to reply.