Tag: MSSQL

Item Bin report, and introducing the PSyOPs Framework

A while back, I discovered something of a weakness in DDMS: there’s a bug in the Allowable Functions permissions settings for Item. In short, you can’t give someone read-only access to Item History where bins and inventory are kept. To allow them to view it gives them the ability to change fields on that subscreen. …

Continue reading

Download a pre-configured XAMPP

The past few days I’ve been working with a fresh installation of XAMPP, used for my article Setting up XAMPP to Work With MSSQL. I realized that if you don’t have some experience with web servers, etc., it can be a bit much. What I mean is, I struggled with it a bit, and it’s …

Continue reading

Creating a Ship-to Report in SQL Server Management Studio

The company I work for is approaching its 10th anniversary this year. In that time, we’ve accumulated a variety of ways of getting data out of the system. For a ship-to report, I can run a couple variations from the N screen, or via Access through some of Carol Brown’s near-magic. And I have a …

Continue reading

Your first MSSQL Report, ‘Flushed Today’

A few weeks ago, I had quite a few orders go sideways on me. The orders that were a mix of wholesale product and items we stock were missing our stocking items from the deliveries. With a little investigation, it seemed the culprit was likely that tickets had been prematurely flushed to status B. As …

Continue reading

Setting up XAMPP to Work With MSSQL

In this article, I’ll show you how to set up XAMPP on a Windows 7 machine. The process is largely the same on Windows XP, if you’re repurposing an older machine. One thing to keep in mind, though, is the newest versions of XAMPP use a version of PHP for which there is not an …

Continue reading

A Better Method of Reporting in DDMS

If it wasn’t clear before, I’m a huge evangelist of using the SQL Server for reporting in DDMS. I’ve spent a lot of hours working with DDMS in a lot of ways, and I’ve always seen its reporting capabilities as a huge weak spot. A few years ago, I sat down and got serious about …

Continue reading

An introduction to SQL for DDMS

By day, I work for a fair-sized office products distributor. The company, like a lot of independent OP dealers, is on ECI’s DDMS platform. I’ve got my issues with the software, but it’s what we’ve got, so I do what I can to make it as painless as possible. By coincidence, around the same time …

Continue reading