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 …
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?
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.
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.
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.
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.
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.
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.
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.
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 …
Recent Comments