Group Sales and Customer Sales, part one

It came up not long ago that there seemed to be a problem with the Group Sales versus Total Sales numbers in DDMS. In short, Group Sales was showing a total just shy of double what Total Sales was. As I had just added in some new categories, I left it overnight, hoping dayend might …

Continue reading

Who is Behind Bendustries?

Word made it my way that this here blog has been getting some play on DDMSUnderground lately. Somewhat surprisingly, nobody has asked me who I am. So who is behind Bendustries?

Continue reading

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

Planet Press and Python Scripting

Planet Press can be a very powerful tool. Later on, I’ll put up a post that some dealers might find pleasantly surprising in uses for Planet Press you might not have realized. For now, though, a quick note on using Python in Planet Press.

Continue reading

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

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