Category Archives: Uncategorized

Symptoms:When you try to log on to Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains 8.0, an incorrect company appears in the Company drop-down list in the Company Login window. The incorrect company is either a duplicate of … Continue reading →

Microsoft Dynamics GP Report Writer allows you to have one modified version of each report per dictionary, allowing you to print the modified version of the report in place of the original report. To access Report Writer, navigate to Microsoft … Continue reading →

In this post, SQL script for the GL Journal entries with Analytical Accounting details is provided along with all the associated details, as shown below; Tables Included: AAG30000 | Analytical Accounting GL Header AAG30001 | Analytical Accounting GL Distribution AAG30002 … Continue reading →

With standard SmartLists in Dynamics GP, you can double-click on a record to access a related window, or you can use the “Go To” button in the upper right-hand corner to access additional related windows for the selected record. However, … Continue reading →

STEP 1  –  create SQL view To start we need a  SQL view.  I have published a number of views for getting GP data, so I will use one of my favorites – Payables Apply Information.  You can see the list … Continue reading →

sandipdjadhav.blogspot.ae/…/types-of-integration-method-with.html

We had problem in scrolling window like its listing only Shipments BOL number  not as Invoices  BOL Number.This issue was resolved through Dexterity. Soluion: l_sResults[1] = “”; sQuery = “SELECT USER_DEFINED_TEXT01 FROM POP10306 WHERE POPRCTNM like ‘%”+ trim(‘POP Receipt Number’ … Continue reading →

I would recommend getting all users out of GP and running the following in SQL Server Management Studio: Delete DYNAMICS..SY00800 Delete DYNAMICS..SY00801 Delete DYNAMICS..ACTIVITY Delete TEMPDB..DEX_LOCK Delete TEMPDB..DEX_SESSION

just we need to reconsile the Account setup format,here is the path just follow. MS Dynamics GP–>Tools–>Utilities–>System–>Reconcile Select “Account Format Setup,” then click “Insert” and “Reconcile.” Check your Account Format to ensure it is correct.

Error message: when you try to grant a user access to a test company in Microsoft Dynamics GP: “The user could not be added to one or more databases” Solution:First check if any unused Companies are in Access Window and … Continue reading →