web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

SLOW PERFORMANCE RELEASING SCREEN AR 08.050.00 PAYMENT REGISTER

(0) ShareShare
ReportReport
Posted on by

Hola, estoy experimentando lentitud en el sistema al momento de liberar lotes en la pantalla 08.050.00 registro de pagos.

Versión 7FP1  con SQL2008 R2

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    This screen, and others, can be slower if the SQL transaction log is very large.  Routine maintenance of the transaction log needs to be done to shrink that log file down in order to keep performance up.

  • Community Member Profile Picture
    on at

    Hola, me gustaría ver a una fecha futura en Artran y \ o Catran. Fijar que a continuación, elimine los registros futuros de CashAvgD y CashSumD.

    No Garantia expresa o implícita.

    thx, google traductor

    Ayrin

  • Community Member Profile Picture
    on at

    Hi, I would look for a future date in ARtran and\or CAtran.  Fix that then delete the future records from CashAvgD and CashSumD.

    No warrenty expressed or implied.

    thx, google translater

    Ayrin

  • Community Member Profile Picture
    on at

    Can you explain why this would affect performance?  I'm so confused about that.

  • Community Member Profile Picture
    on at

    08 screens are AR.  The tables I mentioned have records for each period.  So if someone, as was the case for us, entered a payment received date of 03/03/3015 SL creates the 12000 future periods.  Then when you post another batch to the current period it updates the closebal in CashAvgD for the period of the transaction, then it has to updated the future periods (12,000) of them.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans