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