Today I have a report complementary to the previous Item on Contract Report, a report of Contract by Customer. That is, enter a given contract code, and it will return all customers using that contract, along with reporting the full pricing setup for each of those customers. In addition, is shows the sales rep assigned …
Category: MSSQL
Contract by Item report
In my previous post, I showed you how to add a menu to our web interface. If we had a ‘Contract Reports’ page, we could easily navigate to it with two clicks. Today, we’ll add that page and our first report so as to make it a bit useful. Here and there, I have a …
Item Bin Report with Bulk Bins
In my previous post, I showed you an item bin report. This allows you to see what bin an item resides in in your warehouse without having to wade into the Item History screen (or keeping unauthorized employees from needing to ask employees that have access to these screens). What I presented there was actually …
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. …
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 …
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 …
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 …
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 …
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 …
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 …
- 1
- 2
Recent Comments