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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Cash Receipt Batch Wil...
Finance | Project Operations, Human Resources, ...
Suggested answer

Cash Receipt Batch Will Not Post (PSTGSTUS=20)

(0) ShareShare
ReportReport
Posted on by Kristie McNulty 1,008

I have an older cash receipt batch which will not post and the table RM10201 shows a posting status (PSTGSTUS) of 20 for all line items within the batch, not the usual values of 1 through 4

When printing the edit list, the only error message to display is 'Transaction will not post'.  The batch was created using an import process, as 100's of other batches have been created.  The transactions, on the customer's record, show as Work; however, when I attempt to extract the details of the unposted batch using SmartList, there is no data returned.  When I try to run the Receivables Aged Trial Balance for the time frame of when the batch was to be posted, there is no report generated, but I receive a pop-up box which reads 'Message #-1 missing.'.  

Would a reasonable next test step be to change the PSTGSTUS value of 20 to 1 for the batch in question? 

RM10201 PSTGSTUS/Posting Status Values (documented)

1 = Work
2 = Open
3 = History
4 = Originating

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at
    RE: Cash Receipt Batch Will Not Post (PSTGSTUS=20)

    If you check the RM open (RM20101), do you see the same transaction? How about if you check the RM keys (RM00401), does the record exist in this table\ and if so, does it show a 1 (unposted\work) for DCSTATUS?

    It's possible there was an interruption and the records might be stuck between work\open. If it's solidly in work only, might just want to delete the problem transactions and recreate them.

  • Suggested answer
    Kristie McNulty Profile Picture
    Kristie McNulty 1,008 on at
    RE: Cash Receipt Batch Will Not Post (PSTGSTUS=20)

    Hi Josh, thank you for responding to my question.  

    The transactions are not showing in the RM20101 table, and the DCSTATUS in the RM00401 table is set to 1 for the transactions appearing in the RM10201 table.  We would like to preserve the original entry details of the user who created the transaction and prefer not to delete and recreate the batch as the user is no longer with the company.  I did test changing the PSTGSTUS value from 20 to 1 (using SQL), changed the posting date to current period date (using the window/form), and was able to post the batch.  The transactions from the batch now show as OPEN and were automatically applied against their corresponding open documents.

    In case it's also helpful, I tried all of the usual steps: reconciliations, check links, default settings, etc., but nothing would move the status from 20 to 1 in the RM10201 table.  Brute force was necessary.

    Thanks again for taking the time.

    RM00401: DCSTATUS Document Status

    1 = Work

    2 = Open

    3 = History

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 857 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 548 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans