Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Sales Transaction posting too slow

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Sales Transaction posting too slow

    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,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Sales Transaction posting too slow

     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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales Transaction posting too slow

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans