An error Occurred executing an SQL Statement

(0) Share

Report

Posted on by Community Member

Hello Everyone

Well I was in sales transaction entry window, by Mistake I click something in Addittional Tab button at the top of sales transaction entry window and now that message is appearing, I click OK then some other window appears and then some other and this again and the loop continues, I am also not able to go out of it. So please help me how to get rid of it. Thanks in advance. anciously waiting for a possible solution.

*This post is locked for comments

I have the same question (0)

All responses (22)

Answers (2)

Suggested answer

soma 24,410 on at

Like (0)

Report

This is modified window. Change this to standard and try again. For changing to standard window, Open Alternate/Modified Forms and Report window (Tools-->Setup-->System-->Alternate/Modified Forms and Report). In that window choose desired id for the user, product all and type as window. Then expand the sales module and choose sales transaction window as standard Microsoft Dynamics GP then click save. Now open sales transaction window to check the issue occurs or not.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank You Soma,

actually because of that error I was not able to open any tab, three of such messages were opening in a loop, so I just asked asked the key user to kick my user out of server for a while, and my GP comes back. Thank any ways,

I hope you can help me with a similar issue, I have no access limitation on my user like for deleting the Invoice, Sales order, but the problem is New FC dont know the password set by Ex FC for the same purpose. So please suggest is there any possible way to see the passwords?

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

What you mean by FC?

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Go to task manager and End process your Dynamics GP app.

and re-login to GP.

Why waiting for others to kick you. :-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Financial Controller, any solution on how to locate a password?

Was this reply helpful? Yes No
Verified answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Ask your FC to login to GP Navigate to Microsoft Dynamics GP>Tools>Setup>System>Sales and open Sales Order Processing, Click on on Invoice ID and open it, check scrolling window for passwords.

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

Login GP as sa User. Open Sales Order Processing Setup window(Tools-->Setup-->Sales-->Sales Order Processing) and click the Sales Document Setup button to choose the Invoice. In Sales Invoice Setup window, you can see the password for delete documents as below.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you guys, it worked. Can I ask one more ease question.

How to apply Payables Invoice in US Dollars with Payment booked in Euro.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Functional currency is SAR.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

You can't apply one originating currency to another originating currency.

GP allows 3 way of apply process in payables.

1. Functional to Functional

2. Functional to Originating

3. Origination to Functional

For option 1, you can apply from both manual payment apply button and separately from apply payables documents window.

For option 2 & 3, you need to post the functional/originating payment separately and apply it from Apply Payables Documents window with following below steps.

1. Open Apply Payables Document window (Transactions-->Purchasing-->Apply Payables Docuements).

2. Enter vendor ID and choose your appropriate payment booked in Euro.

3. After selected payment numbers, the available documents for the entered vendor will be displaying in scrolling window.

4. Now apply the payable invoice and click OK.

Note: If you apply originating payment to originating invoice, it will through the error message. You can't apply.

Hope this helps!!!

Was this reply helpful? Yes No