Mahmoud AlSaadi has a SQL Script with General Ledger Journals with Analytical Accounting Details
Mahmoud AlSaadi provides a SQL Script for Reconciling Quantity on Hand
Rose Business explains how to Rollback your SQL script w/o restoring the database.
Samuel Matthew has a SQL Script to List Actual vs Budget for GL Accounts by Period
In his first article as a Microsoft employee, Sivakumar shows off a SQL Script for Account Level Security
Sivakumar has updated his SQL Script for AP-GL Reconciliation
Sivakumar provides a SQL Script for AP-GL Reconciliation
Real Life Dynamics User is back with a SQL Script looking at Vendor Invoice Pricing Discrepancy
“…all Payables invoices that have been entered into your system where the price your vendor is charging does not match the price of your purchase order. “
Ron at Real Life Dynamics User is back with SQL code for SOP to POP Freight Analysis.
“…analyze the freight you charged to a customer versus the freight you were billed from you vendor provided there is a SOP to POP link between the sales order and purchase order.”
Ron at Real Life Dynamics User deliver a SQL Script to show Invoices Coming Due Next Week.
They use it to notify customers that their invoices are coming due, much like the Library reminds me that I’m going to owe them a boat load of money if I don’t return my books on time. Sort a pre-Dunning notification. I like it.