David Stein

Subscribe

Who Wrote This Crap?

“Did you ever notice that other peoples stuff is crap, but your crap is Stuff?” George Carlin

Last year I came across an article with the same title on Jeff Atwood’s “The Coding Horror.”

Whether I am looking at Made2Manage or another vendor’s code or code created by a [...]

The Shipping Screen Needs Another Status

The correct process of dealing with a bad shipper in M2M is to edit it and zero out all the quantities shipped.

Some of the reasons a shipper may be bad include:

Someone may have run a shipper based on the wrong sales order, shipped the wrong line item, or released from the correct sales [...]

Solution to Encyclopedia Brown and the Case of the Data Corruption

This is a continuation from this previous post.

“It’s simple,” Encyclopedia said. “First I ran the following query against our database.”

SELECT SOM.fshipvia
FROM somast SOM
WHERE SOM.fsono = ’123456’

“The value returned was UGB, which is the actual value for UPS Ground Bill in our database. So, I knew that the Ship Via [...]

Made2Manage Lacks Referential Integrity

I was surprised that some of the software packages I was recently testing for database comparison and writing faster queries failed to work properly with Made2Manage. When I investigated further, I realized why they wouldn’t work. M2M, to the best of my knowledge, completely lacks referential integrity.

What is referential integrity?
Referential integrity is the [...]

Great SQL Server User Group Presentation Last Night

I’ve been attending the North Texas SQL Server User Group meetings for some time and have met a lot of great SQL people in my area. Last night was especially good however, as Brian Knight of Pragmatic Works gave the presentation “Introduction to SQL Server Analysis Services.”

I’ve been studying SSAS, as well [...]

SQL Script – Physical Inventory Count Sheets (RPPHIN)

SELECT INM.Fac,
INM.fpartno,
[...]

SQL Script – Purchase Order Status/History (RPPSTA)

SELECT POM.fcompany AS [Vendor],
POM.fpono AS [PO No],
[...]

Encyclopedia Brown and the Case of the Data Corruption

Encyclopedia Brown is a character in a series of mini-mystery books written by Donald J. Sobol. I read most of these books in my formative years. The main character, Encyclopedia, is a young wiz kid who solves mysteries in his home town of Idaville. The stories typically have a factual [...]

That FastForms Bug? Yeah, It’s a Feature!

In a previous article, I mentioned that FastForms has a bug wherein it modifies all of the Made2Manage SQL databases- not just the one you intended to customize. It does so even if you indicate that you only want to modify a single database. However, while editing a M2M report to pull in [...]

VBA Rants

Can someone please tell me why, after all these years, VBA is still a manually installed application?

To the best of my knowledge, they’ve offered VBA for nearly 10 years. Yet I still have to manually install VBA on every single computer which runs M2M. To make things worse, the instructions for installing it [...]

Page 1 of 212