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, […]

Share Button
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 […]

Share Button