18 November 2008
Filter Dynamics GP Lookups Using VBA
Guys, A got allot of mails requesting to have Item Security functionality to distribute sites items and show only certain items for the warehouse keeper. For those who are looking for such functionality, you need to follow the steps below: 1. Create a Read More...
0 Comments  
11 November 2008
Filling Missing Transactions Numbers in GP
If the end user created any kind of transactions in GP that holds let’s say the ID 9 and another one that holds 10, then deleted 9; the next number will be 11 and 9 will be ignored. For the clients that do not accept these gaps, and since almost all of Read More...
0 Comments  
11 November 2008
Dynamics GP, AX, SL, NAV and others into one ERP called Project Green?
Project Green is Dead! Project Green started making headlines in late summer 2003, a few months before Microsoft made the formal announcement of what was supposed to become a horizontally integrated ERP suite. Project Green would do for ERP applications Read More...
0 Comments
Filed under:
 
11 November 2008
DEX.INI Commands Explanation
Interested to learn more about DEX.ini file and what does it effect? I found a post under ( http://msdynamicsgp.blogspot.com/2007/09/weekly-dynamic-dexini-settings.html ) and found it interesting, below the parameters definition for DEX.ini File: SuppressChangeDateDialog=TRUE Read More...
0 Comments  
11 November 2008
GL Query For Posted and Unposted GL Transactions
View Trial Balance for Posted and Unposted GL Transactions: SELECT 'HISTORY' POSTINGSTATUS, DBO.GL00100.ACTDESCR, DBO.GL00105.ACTNUMST, DBO.GL30000.JRNENTRY, DBO.GL30000.ACTINDX, DBO.GL30000.REFRENCE, CASE WHEN DBO.DTA10200.CODEAMT>=0 THEN 0 WHEN DBO.DTA10200.CODEAMT<0 Read More...
0 Comments
 
11 November 2008
Vendor Statement For GP
Looking for a complete Vendor Statement that displays Posted and unposted transactions? Check the view below: ----------POP UNPOSTED---------------------------- SELECT 'RECIEVING UNPOSTED' AS TRXSOURCE, DBO.POP10300.RECEIPTDATE AS DOCDATE, DBO.POP10300.VNDDOCNM Read More...
0 Comments  
11 November 2008
Dynamically Get GP database connection information when using VBA
Dynamically Get GP database connection information when using VBA: 'Class Module: GP Dex_VBA_Link 'Author: Matt Connor 'Version: 2.01 'Updated: 06-Apr-2006 'Connection Properties Public PasswordUnencrypted As Boolean Public SQLPassword, SQLPasswordDecoded Read More...
0 Comments  
11 November 2008
Drop and recreate database Logins
Script below loop database users then drop and recreate them one by one: DECLARE @UserName Varchar(500) DECLARE UsersCurr Cursor For Select Name FROM sysusers WHERE (islogin = 1) AND (name <> 'dbo') AND (name <> 'guest') Open UsersCurr Fetch Read More...
0 Comments  
11 November 2008
Item Transactions Analysis
Interested in analyzing your items transaction? Check view below: SELECT dbo.SOP10100.DOCDATE, dbo.SOP10200.LOCNCODE as TRXLOCTN, CASE WHEN dbo.SOP10200.SOPTYPE = 4 THEN 'Return Unposted' When dbo.SOP10200.SOPTYPE = 3 Then 'Sales Unposted' end AS TrxType, Read More...
0 Comments  
11 November 2008
List of inventory items that have not sold between two dates
View below list the inventory items that have not sold between two dates: SELECT IV00101.* FROM dbo.IV00101 INNER JOIN dbo.IV00102 ON dbo.IV00101.ITEMNMBR = dbo.IV00102.ITEMNMBR WHERE (dbo.IV00101.ITEMNMBR NOT IN (SELECT dbo.SOP30300.ITEMNMBR FROM dbo.SOP30300 Read More...
0 Comments  
13 October 2008
Microsoft Dynamics GP (Great Plains) Row Level Filtering (Row Level Security)
Guys, David Musgrave the Microsoft Dynamics GP Specialist proofed that the GP could have Row Level Security customized by developing the tool for the sample company, the tool is great and contains all what we need to filter GP rows. You can find this Read More...
0 Comments
Filed under:
 
12 October 2008
Auto login for Microsoft Dynamics GP!
Auto login for Microsoft Dynamics GP I found the below idea in one of the forums and liked it! 1. Create new text file in “C:\Program Files\Microsoft Dynamics\GP” call it Login.mac 2. Paste the code below inside it and save. 3. Replace “sa” with your Read More...
0 Comments
Filed under:
 
11 October 2008
Fix for Slow Correcting JE Lookups
Fix for Slow Correcting JE Lookups I found the following post @ Mark's [MVP] blog and thought it will be helpful! When you do a correcting Journal Entry in GP, the lookup to find the entry to correct can be brutally slow. it's so slow because it's looking Read More...
0 Comments
Filed under:
 
11 October 2008
Copy Microsoft Dynamics GP Setup
To copy Microsoft Dynamics GP setup from company to another company DTS the following tables via SQL Finance GL00100 Chart of Accounts Note Do not copy the GL00101 GL00102 Account Category Master GL00103 Fixed Allocation Accounts GL00104 Variable Allocation Read More...
0 Comments  
06 October 2008
Why does Microsoft Dynamics GP encrypt passwords?
Why does Microsoft Dynamics GP encrypt passwords? Check post below: http://blogs.msdn.com/developingfordynamicsgp/archive/2008/10/02/why-does-microsoft-dynamics-gp-encrypt-passwords.aspx Read More...
0 Comments  
More Posts Next page »