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) / Missing Apply PM30300 ...
Microsoft Dynamics GP (Archived)

Missing Apply PM30300 on AP Invoice

(0) ShareShare
ReportReport
Posted on by Community Member

I have an PM invoice in the PM30200 table with a curtrxam of zero.  This particular voucher number is not in any of the open PM tables.  When I run a HATB the invoice appears as if unpaid, yet the invoice is not available to apply a payment.  Coincidentally, for that particular month in question the GL vs the sub-ledger is off by this exact dollar amount.  I cannot void the invoice as it is in history and I cannot apply a payment because the invoice is showing paid.

It is almost like the PM30300 payment apply is missing.  I do see a voided payment related to this voucher number, but the invoice itself is not voided.  Perhaps the void was interrupted and disrupted the invoice?

Any suggestions here?  I have read some people doing an insert on the PM30300 to remove it from the HATB, but I would not know where to get all of the relevant information for the insert.  I have run checklinks and purchasing reconcile and did not come up with anything.

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Missing Apply PM30300 on AP Invoice

    Hello Babu

    Unfortunately, it won't :)

    Those table has to do with releasing a batch or transaction, but deleting the corrupted sessions from them won't restart the processes in such case.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: Missing Apply PM30300 on AP Invoice

    Hi Mahmoud,

    I thought if the void or payment has interrupted and stuck in between the script might help.  Thanks for very detailed answer.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Missing Apply PM30300 on AP Invoice

    Hello There

    Babu, I don't believe this has got to do with anything related to the case above.

    J.R

    Apparently, what you are describing is a database corruption case in which the invoice record is not updated after voiding the payment, therefore, you will have to manually migrate the invoice details back to the open tables, while updating the current transaction amount field to have the same amount of the original invoice amount.

    Moreover, you will have to update the RM key master table (document status)

    In summary, this does requires Dynamics GP and DB knowledge. Therefore, I would recommend consulting your partner accordingly, in order to avoid any DML mistakes while working on the db level.

    Please never hesitate to share any further details,

    Your feedback is highly appreciated,

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: Missing Apply PM30300 on AP Invoice

    Hi,

    have you tried the following, take a backup before  doing this.

    View the contents of the following tables to verify that all users are logged off: DYNAMICS..ACTIVITY, DYNAMICS..SY00800, DYNAMICS..SY00801, TEMPDB..DEX_LOCK, and TEMPDB..DEX_SESSION. To do this, run the following script.

    SELECT * FROM DYNAMICS..ACTIVITY

    SELECT * FROM DYNAMICS..SY00800

    SELECT * FROM DYNAMICS..SY00801

    SELECT * FROM TEMPDB..DEX_LOCK

    SELECT * FROM TEMPDB..DEX_SESSION

    Note When all users are logged off from Microsoft Dynamics GP, these tables will not have any records in them.

    clear the stuck records by using any of the following appropriate scripts.

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    after doing this run checklink again

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans