Category: PSyOPs

Bulk Bin Updater (or How I Learned to Stop Worrying and Love ODBC Connections)

Quite a while ago, I posted a replacement for DDMS’ Release to On-Hand report, PO Bin. Over the years, I’ve had a variety of ways of keeping the bulk bin table updated. Here is how I’m doing it now, and it’s the most efficient way I’ve ever had.

Continue reading

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

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

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