A Downloadable Version of Contract by Customer

Like we did with the Item by Contract report, today we’ll add the option to download the Customer by Contract report. The refreshed version of completecontracts.php, completecontracts.js, and the customer_by_contract-dl.php file itself, available from http://www.bendustries.co/files/contracts/warehousereports_inc_cbc-dl.zip. Or the report by itself is http://www.bendustries.co/files/contracts/customer_by_contract-dl.zip. As before, contractreports just needs two lines uncommented to show the download button, …

Continue reading »

Putting Your Reports in Excel – introducing PHPExcel

As I mentioned way back, one of the fundamental weaknesses DDMS has is the lack of an easy way to get reports into spreadsheet programs to allow you to work with your data in a coherent way. We currently have two reports, Item by Contract and Customer by Contract where we’ll often want to work …

Continue reading »

Customer by Contract Report

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 …

Continue reading »

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 …

Continue reading »

Adding a Menu to the PSyOPs Interface

In my previous articles, we’ve got a fair start to our reporting interface. We’ll flesh out our Warehouse Reports a bit more later, but today I’m going to cover something a bit different. We’ll start by adding a menu to our interface. After all, not all our reports will pertain to our warehouse functions, and …

Continue reading »

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 …

Continue reading »

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 »

Setting up FileZilla and MySQL

To fully utilize the capabilities of your reporting sandbox, there are a couple tools in XAMPP that you will need to utilize, FileZilla and MySQL.

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 »

Older posts «

» Newer posts