Tag: SQL Server 2008

By April 9, 2013 Read More →

SQL Script to List Actual vs Budget for GL Accounts by Period

Few months back one of my customer asked me to create a script that shows net actual amount and total budget amount for a particular account and for a specific year. After working on the script, I thought about expanding the script and create a view to list all General Ledger accounts  with actual amount, […]

By May 8, 2012 Read More →

SQL view for unpaid SOP Transaction with No. of overdue days

Recently one of my customer asked me to create a script to shows all open (unpaid) sales transaction with the total number of days overdue based on the current system date and customer’s payment terms. Customer also wanted to see a column that shows the estimated payment date based on the actual payment terms and the […]

By March 29, 2012 Read More →

Dynamics GP 2010 R2 Database SDK

Sivakumar, MVP at Interesting Findings & knowledge Sharing launched Dynamics GP 2010 R2 database SDK. This is an awesome tool and definitely a good item for consultants tool kit. This database SDK provides information about Microsoft Dynamics GP 2010 R2 database objects such as Tables, Views, Stored procedures etc. Currently he only published Dynamics System database SDK and […]

Posted in: General