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

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) / PSTL Tools IV Reconciler
Microsoft Dynamics GP (Archived)

PSTL Tools IV Reconciler

(0) ShareShare
ReportReport
Posted on by Community Member

Hi There,

When I try to run the PSTL Tools IVReconciler it gives me an error saying [Microsoft][SQL Server]could not find the stored procedure ivReconcileSearch. after this I tried creating the stored procedure for this through the SQL maintenance but it did not create this particular stored procedure, any suggestions are welcome.

Thanks, 

 

 

*This post is locked for comments

I have the same question (0)
  • Saif Esmail Mohammed Profile Picture
    Saif Esmail Mohammed 215 on at

    Hi, i"m also having the same issue. any clue?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    This is normally encountered due to one of the following;

    1. When the PSTL was first configured, installation was not successfully completed, when you first open Dynamics GP after deploying the .cnk file and open PSTL for the first time, stored procedures and other database objects are created.
       
    2. The other reason is having the following options checked on the ODBC; (Use ANSI quoted identifiers and Use ANSI nulls) and (padding and warnings should both be unchecked) Refer to support article for further details; Article ID: 907675

    Hope this helps, 

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    So, how to fix it.  

    You need to remove PSTL and then run a sql script to remove the triggers.  Then reinstall PSTL.

    You can get this script from MS.  Open a case with support

  • Suggested answer
    Saif Esmail Mohammed Profile Picture
    Saif Esmail Mohammed 215 on at

    The second solution did the trick for me.

    "he other reason is having the following options checked on the ODBC; (Use ANSI quoted identifiers and Use ANSI nulls) and (padding and warnings should both be unchecked) Refer to support article for further details; Article ID: 907675"

    you need to remove the checks then open the PSTL and click on "Register" and it will create all the procedures and tables again.

    Thanks.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans