Tag: SQL

A New Ship-to Report, Now for the Download Version

Previously, I walked through the full treatment of developing new reports from the ground up, starting in SQL Server Management Studio, then adding the View version to the new reports screen we added. Today, we’ll finish that off, by adding the Download version.

Continue reading

A New Ship-to Report, Adding it to the Reports Screen

In my previous post, A New Ship-To Report, From a Development View, I walked through my method of developing queries in SQL Server Management Studio. Today, we’ll take that as a starting point to add it to our reports screen.

Continue reading

A New Ship-To Report, From a Development View

Early in the days of bendustries.co, one of my first posts was an introduction to SQL Server Studio Manager and the basics of SQL queries, using a basic ship-to report as an example. Since then, I’ve expanded a bit on what I run as a ‘typical’ ship-to report. Aside from that, I think the time …

Continue reading

Vendor Contract Report

For many dealers, once you reach a certain size, it makes sense to stock product. In a lot of cases, paper is a natural fit, as the wholesalers’ prices are out of line if you’re trying to compete with the big boxes or Costco. Beyond that, though, you may find it makes sense to bring …

Continue reading

A Status 1 Report

This past Monday, I got a call from a customer, who thought she was losing her mind. She swore she ordered staplers, but could find no evidence of it – not on her order that showed up, not an any confirmations from ECInteractive, nowhere to be found. I pulled up her account in OE History, …

Continue reading

A Replacement Put-Away Report, PO Bin

If you stock product, you’re likely familiar with the Release to On-Hand report. Used to put product away, it’s got a couple flaws for me. First, for my company at least, the report’s almost too small to read. While I could have a look at reformatting the report so it’s readable, it’s got another problem …

Continue reading

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 bendustries.co/files/contracts/warehousereports_inc_cbc-dl.zip. Or the report by itself is 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

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

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