Monthly Archives: May 2015

Error message when you import purchase orders into Microsoft Dynamics GP from Microsoft Retail Management System Headquarters: “7321-Decimal places passed in for UNITCOST does not match setup”

select * from  IV00105 where  itemnmbr=’OFC’  –update IV00105 set DECPLCUR = 5 where  itemnmbr=’OFC’

Posted in Uncategorized | Leave a comment

How to filter Empty or Null Values IN Smart list Report.

Please Look into the Image: Here We have been filtering the two cases,like 1)In Report 1099 Type is not Equal to “Not a 1099 Vendor”. 2)Second filter is for removing Empty or Null values from Report. Select Column name and … Continue reading

Posted in Uncategorized | Leave a comment

“Prevent saving changes that require the table to be re-created” negative effects”

I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2). I got the usual error “The changes you have made require the following tables to be dropped and re-created” from SQL … Continue reading

Posted in Uncategorized | Leave a comment

An incorrect company appears in the Company drop-down list when you try to log on to Microsoft Dynamics GP

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

Posted in Uncategorized | Leave a comment

Modifying /Copying Report Writer Report Packages

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

Posted in Uncategorized | Leave a comment

General Ledger Journals with Analytical Accounting Details –SQL Script

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

Posted in Uncategorized | Leave a comment