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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum (Archive) / Inventory Reconcile - ...
Microsoft Dynamics GP forum (Archive)
Suggested answer

Inventory Reconcile - An error occurred executing SQL statements

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

         I tried to run Reconcile for Inventory .But I could not process further ,Getting the Following Error .

An error occurred executing SQL statements.
GPS Error: 0
SQL Error: 0
ODBC Error:

    Can Someone help me to fix this Issue or to Know why does this occurs?

Categories:
Development / Customization / SDK
I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    You will run Check Links before IV Reconcile. Run it on the entire Inventory series. Check Links will confirm links between all tables. It does have the ability to delete records which is why I suggest you perform a backup first.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    Should I have to Run al the Check Links in the Inventory Module or any particular thing ? And will it affect any Record If I run Checklink Before Reconcile ?

    pastedimage1639963365228v1.png

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    GRANT.SQL will not help here. Have you tried running this on the server? How about making a backup and then run check links on the inventory series. See if check links reports any errors.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    I am getting the Same Error even in 'sa' .

    Should I still have to still Run the GRANT.SQL ? And I don't Find any null or blank values in ITEMNMBR.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    First, try running IV reconcile as 'sa'. If you do not get the error it is security. If you still get the error then this is data driven. Try running GRANT.SQL. You will find this in C:\Program Files (x86)\Microsoft Dynamics\GP\SQL\Util. If error persists try

    SELECT * FROM [dbo].[IV00101] ORDER BY ITEMNMBR

    SELECT * FROM [dbo].[IV00102] ORDER BY ITEMNMBR,LOCNCODE

    SELECT * FROM [dbo].[IV10200] ORDER BY ITEMNMBR,DATERECD

    Look for any NULL or blank values.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    Do you have any ideas regarding the permissions ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    No I have not tried in Fabrikam company !! I have just tried in production and Test Server !! Same error in both the server

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,004 Moderator on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    Which account are you using to run this item reconcile process ? have you tried to run this against the TWO / Fabrikam company ?

    This looks like a permission issue possibly, or some other weird SQL settings...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    Do you have any idea regarding why does this happen ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Reconcile - An error occurred executing SQL statements

    Yes. I have tried even with one item . Still the same Error occurs

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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard > 🔒Ι Microsoft Dynamics GP (Archived)

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans