Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Purchase invoice showi...
Microsoft Dynamics GP (Archived)

Purchase invoice showing already been applied

(0) ShareShare
ReportReport
Posted on by zulfi721 6,825

while applying a payment the client computer got restarted due to power failure.

On again login to GP and applying the same payment Gp is indicating  the invoice has already been applied.

although i checked the transaction with the vendor but this voucher has neither been posted nor it is saved.

*This post is locked for comments

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Purchase invoice showing already been applied

    Zulfi,

    I would suggest to consul with a partner to resolve your issues on the stuck batches.

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: Purchase invoice showing already been applied

    babu dont have access to sql server.....

    actually i dont know about sql server........No knowledge about it...

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Purchase invoice showing already been applied

    Zulfi,

    you can install the trial version of GP with sample company but you still require SQL in order to install the same.  You haven't confirmed regarding my question about access to SQL server.

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: Purchase invoice showing already been applied

    Hi babu,

    thanks for the reply.

    No babu i didnt installed the GP.Installation is done by other person.

    well kindly recommend some link for me so that i can install a trial version of GP on my laptop for practice purpose

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Purchase invoice showing already been applied

    Zulfi,

    Have you installed the GP yourself or Partner did it.  Please confirm whether you have SA user ID and password and access to the GP SQL server.  Also please check the following

    under Tools-Routines-Batch Recovery and check any batches stuck there.  If not please check the Financial-Enquiry-Account summary and go to Bank Account and see whether this payment entry can be seen.

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: Purchase invoice showing already been applied

    Also adding to the above,that payment voucher is not available for voiding  in open or historical transaction  under purchasing..........

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: Purchase invoice showing already been applied

    Also aged trial balance shows that those invoices has been applied.

    But the PMT voucher is not appearing in the transaction with the vendor under the inquiry menu.

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: Purchase invoice showing already been applied

    thx babu for the reply but in case of SQL i dont know any thing........

    have to get knowledge of this thing also........

    if you know some learning resources do suggest for me ...thx

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Purchase invoice showing already been applied

    Zulfi,

    You need to run the following query  on SQL, before doing this please logout everyone the first select statement will show you if anyone still logged in.  Please take a backup before running this.

    SELECT * FROM DYNAMICS..ACTIVITY

    SELECT * FROM DYNAMICS..SY00800

    SELECT * FROM DYNAMICS..SY00801

    SELECT * FROM TEMPDB..DEX_LOCK

    SELECT * FROM TEMPDB..DEX_SESSION

    If you get answers / results to any of the above, make sure everyone is in fact logged out of GP and then run the following scripts to clear the tables.

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: Purchase invoice showing already been applied

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 us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans