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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Posting Invoices. Plea...
Microsoft Dynamics GP (Archived)

Posting Invoices. Please Help!!!!!!!!!!

(0) ShareShare
ReportReport
Posted on by Niju David 880

Dear All,

As I am trying to post the invoices made through the "Sales Transaction Entry" window, the invoices are not getting posted and is showing an error - "Unable to obtain receivables document number".

Kindly advise what the error means and how can I rectify the same.

Thanking in advance

Regards

Niju David

*This post is locked for comments

I have the same question (0)
  • Sagi88 Profile Picture
    Sagi88 2,250 on at

    Hi Niju.

    Here is the resolution per Dynamics GP site:

    RESOLUTION

    To resolve this problem, follow these steps:
    1. Have all users exit Microsoft Dynamics GP.
    2. Use one of the following steps:
    • If you are using Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
    • If you are using Microsoft SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    • If you are using SQL Server Desktop Engine (also known as MSDE 2000), start Support Administrator Console. To do this, click Start, point to Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.
    3. To verify that there are no records in the RM Key File table for the document that you are trying to post, run the following statement against the company database. 
    SELECT * from RM00401 where DOCNUMBR = 'INVxxxx'
    Note Replace the INVxxxx placeholder with the document number that you are trying to post.
    4. Use one of the following steps:
    • If no results are returned, run the following statement to verify the posting status of the documents.
    SELECT PSTGSTUS,* from SOP10100 where PSTGSTUS <> 0
    • If results are returned, run the following statement to update the posting status of the document in the Sales Order Processing table.
    UPDATE SOP10100 SET PSTGSTUS = 0 where SOPNUMBE = 'INVxxxx'
    5. Post the sales batch.
  • Niju David Profile Picture
    Niju David 880 on at

     Dear Sagi,

    Thanks a lot. Lemme try this out.

    Regards

    Niju

  • Community Member Profile Picture
    Community Member on at

    I followed the information as written and was able to post the sales batch, however, now I have 2 transactions in the customer open transactions list and in the RM00401 table one has a docnumbr of INV0196045 and one has a docnumbr of INV0196045001, both for the same amount and with the same batch ID. Now what?

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    Was the batch marked as a recurring batch? Have you run reconcile and Check Links on the receivables transactions?

    Kind regards,

    Lesslie

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans