Author's details

Date registered: 2013/04/14

Latest posts

  1. Mass-changing Item Records — 2015/10/13
  2. Mass-changing customer records — 2015/10/04
  3. Editing DDMS .dbf files — 2015/01/03
  4. On prefix changes and favorites lists — 2014/10/20
  5. A New Ship-to Report, Now for the Download Version — 2013/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

Mass-changing Item Records

In my previous post, I gave a quick run-down of using the N-CUS1 selector in +W to change customer records. 98% of the time, that’s what I’m doing when I’m in +W. Occasionally, though, I need to mass-change item records. Here’s how we use R-CAT1 to do just that.

Continue reading »

Mass-changing customer records

Mass changing customer records is one of the most powerful, and dangerous, functions in DDMS. Here’s an example of a simple mass-change.

Continue reading »

Editing DDMS .dbf files

As I’m in the midst of the Q1 2015 OPUS load, it occurred to me that other DDMS dealers might not know how they can manually edit DDMS’ .dbf files. After the jump is how it’s done.

Continue reading »

On prefix changes and favorites lists

For Q4 of 2014, United made the decision to align their prefixes with Lagasse’s, as United feels “Lagasse is the standard in jan-san.” Wisdom of that decision aside (hint: I didn’t find it particularly wise), it left a whole lot of dealers with some work to do.

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 »

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 »

Older posts «