Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Receivable Batches issue

Posted on by

I have an issue with Receivable Batch when click post the batch doesn't post. Below is the screen on the process monitor. This process doesn't complete and it stays forever. I cant end GP normally I am forced to use task manager. 

I have cleared the sessions through

DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

66157.Capture.PNG

I have even cleared SY01300 but still no success. After running the trace it the following stored procedures keep on recurring repeatedly

(1)exec FBI.dbo.zDP_RM00101SS_1 'MAUR00010-GICE'
(2)exec FBI.dbo.zDP_RM10301N_4
  25,'RM_Sales','MM-09-18',7,'CREDT000000001389','RM_Sales','TEST',-32768,'','RM_Sales','TEST',32767,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ'
(3)exec FBI.dbo.zDP_RM10301N_1 25,1,'SALES000000000216',NULL,NULL,NULL,NULL
(4)exec FBI.dbo.zDP_RM00101SS_1 'WILK00014-AHU'

The batch remain unposted, has no errors and surprisingly, no reports on the screen that comes on screen/on file as the batch posts towards completion.

I have already restarted the server but this never ending posting process continues. When I end through the task manager, the batch status changes to interrupted and have to be recovered plus clearing the posting batch from sy00800.

My question is, how can I sought this problem so that the batches post normally. My GP version is GP2010 R2 (Version 11.00.1752)

RomRyan

*This post is locked for comments

  • Romryan Profile Picture
    Romryan on at
    RE: Receivable Batches issue

    Jen,

    Yes. You could say that.

    I will do that when I get back to the office.

    RomRyan

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: Receivable Batches issue

    If the batch isn't large (# of transactions), at this point I would recommend deleting the original and re-keying it. With all of the steps you've undertaken, it just sounds like something could be corrupt somehow and "fixing" might not be an option.

    Jen

  • Romryan Profile Picture
    Romryan on at
    RE: Receivable Batches issue

    Jen,

    I had printed the edit list but the batch had no errors.

    RomRyan

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: Receivable Batches issue

    Hi RomRyan,

    I would start with printing the Edit List to screen first, to view if it has any issues or errors in the transaction. Ideally the edit list might show you what is wrong that needs correcting.

    Jen

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans