Author's details

Date registered: 2013-04-14

Latest posts

  1. Group Sales and Customer Sales, part one — 2019-07-13
  2. Who is Behind Bendustries? — 2018-03-25
  3. Bulk Bin Updater (or How I Learned to Stop Worrying and Love ODBC Connections) — 2018-03-25
  4. Planet Press and Python Scripting — 2018-03-20
  5. Mass-changing Item Records — 2015-10-13

Most commented posts

  1. Setting up XAMPP to Work With MSSQL — 2 comments
  2. A New Ship-to Report, Adding it to the Reports Screen — 2 comments

Author's posts listings

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 »

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 »

Older posts «

» Newer posts