Hi,
This issue had started towards the end of last year, around the 22nd December 2009. Whenever a sales transactions (Return) is posted, the system takes between 7-10 minutes to complete the posting!
I have run a SQL trace on the posting and finally figured out that this only occurs when an item is on that transaction. Unfortunately, its one of the compulsory items that we sell and is included in majority of our invoices.
I have tried posting returns without including this item and it goes through fine but when this item is included, its takes a long time.
Looking at the trace file, i've seen that it keeps executing the following procedures:
EXEC RET.dbo.zDP_IV10201N_5 25,'ACCVRTR414 ','2009.12.24',79902,'ACCVRTR414','2009.12.24',-2147483648,'ACCVRTR414','2009.12.24',2147483647
Notice the date that is included in the procedure i.e. 2009.12.24. I posted this yesterday. It continues multiple times for different days until yestaerday. While this happens, many of the users in the system at the time are stuck and are unable to process or continue with work until this process completes.
I have checked links, i have done an inventory reconcile on that item (which took around 15-20 minutes). Still the same issue thereafter.
The dynamics GP version that we have installed is Dynamics GP9.
Could someone kindly assist.
Kind regards.
*This post is locked for comments
Interesting. There are known issues with TS and named printers in terms of performance, and the fact that a different printer is used for returns and invoices is a good lead. I will have to go searching through our support files - I remember a similar issue about 2 years back. I'll update you when I can.
Best regards,
Hi Ian,
Thanks again for the reply.
Initially i had also though of a relaiton between the 2, however, this issue started since the end of last year only, and its only on that particular item. I have recommended changing the item code etc. but trying to avoid doing that.
Another suspected cause, i thought, could be that we have about 90000+ on hand of this item? Could that be a factor?
Although, come to think of it, i can recall seeing other items with much more qty on hand.
Another post on this site refers to average perpetual stock valuations etc. Only, it still brings me back to the point that it is just this particular item thats the cause.
Ian, we have a terminal server environment and we use the named printers function so that invoices print at a certain printer, returns print at another. I have changed the printer as well, thinking that since it hangs on the Report Destination screen after posting, that could have been the cause, but it wasn't. Also changed the report types.
Kind regards.
Hi Ismail, Refer to my reponse to your other post. I think the two are possibly related.
In terms of performance of GP when it comes to posting, the workstation should have a default printer assigned. Try setting this to a local pinter rather than a network printer. (however, in your case, its just SOP Returns, so I don't think the above will help...but maybe worth mentioning all the same).
Best regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156