You’re offline. This is a read only version of the page.
2
Has anyone experienced issues where SOP batches take an unusually long time, more than an hour, to post through?
In this instance the batch contained 179 documents and took more than 3 hours.
*This post is locked for comments
I would check out the White Paper on Performance:
It could also be something in the batch, a couple of examples:
- 179 documents with 1 line item on each are not the same as 179 documents with 100 line items on each each.
- If one of those documents is a return for inventory items going back to On Hand that are using average cost and have a negative inventory quantity, it could take a long time to process just that one item because of all the updates needed to the prior documents with this item.
There could be several different causes as to why the batch is posting so slow
- Has the SQL server got sufficient memory / processing power
- Are other non-GP processes running that are consuming memory / processing power
- Is the GP client on the LAN with the SQL server or are you connecting via a WAN.
Regards
Andrew Dean
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (