The Algorithm Blog

Rick Debusk

Recent Posts

A Farewell Message from Rick DeBusk

“The moving finger writes, and having writ, moves on…” — The Rubaiyat of Omar Khayyam

Forty-five years have elapsed since I began a career in manufacturing working as an injection molding machine tender on the midnight shift. Events, education, and experiences led into a position as a manufacturing applications consultant some twenty years ago. I will be retiring from full-time consulting at Algorithm effective December 31, 2018. Barb and I plan to devote more time to family, volunteer work, and travel.

Continue Reading →

The Importance of Inventory Accuracy

For manufacturers and distributors, product availability (i.e. inventory) is the driver of almost all revenue-generating activity.  Next to fixed assets (property, equipment), inventory represents the biggest outlay of capital.

Continue Reading →

SSRS Vs. Crystal Reports — Some Key Differences

Posted on July 14, 2017 by Rick Debusk

Many companies are moving towards developing system reports in SQL Server Reporting Services (SSRS) vs. Crystal Reports. Here are some key differences between the two systems and a few compelling reasons for why this shift is happening:

Continue Reading →

Manufacturing Software: Everything You Need to Know

Employing manufacturing software can optimize and empower your employees to efficiently manage your business resources and processes.

In turn, this allows your company to focus on profit-making products and outsmarting the competition by eliminating slow production cycles, inefficient scheduling of resources, inventory excesses and shortages, and redundant data entry.

Continue Reading →

Wisys and Macola - A Materials Management Perspective

Macola and Wisys are two different systems that help business owners focus on what they do best— business.

Continue Reading →

Macola Standard Cost Module Gets Enhanced Features

In past versions of Macola, the Standard Cost module allowed the user the select locations for costing, but all of the selected locations shared the same cost master.

For companies with multiple locations and different cost structures, this meant that either all material costs for the selected locations were averaged together or the user was forced the run the standard cost processes for each unique location. 

Related: Macola 10.4 and Macola ES 9.6.700 Product Update Webinar

Continue Reading →

The Underutilized Notes Function in Macola Progression and ES

The notes function in Macola Progression and Macola ES isn't widely utilized, but it can be a very helpful tool for storing additional data specific to items, customers, and vendors. 

Macola Progression has two types of Notes buttons, the Note button on the toolbar and the Notes button beside fields on Progression screens.

Continue Reading →

Crystal Reports Help: Using Not In Logic in Record Selection

Posted on June 12, 2013 by Rick Debusk

Record selection criteria is set in Crystal Reports in the Select Wizard. Users can build a custom record select statement using multiple criteria. By clicking on the Show Formula button, users can see the Select statement.

If an SQL query already exists, users can paste the SQL select statement into the Select Expert Formula window. Here’s an example of a SQL statement pasted into Crystal and cleaned up to conform to Crystal requirements:

Continue Reading →

How to Build a Master List of Crystal Reports

Posted on July 09, 2012 by Rick Debusk

Are you looking for a list of all currently published reports with descriptions in Crystal Reports? As you may know, hovering over a report name will show you the report descriptions but this could mean potentially hovering over hundreds of reports, which is not a very good use of your time.

The best way to build this master list is right within Crystal Reports. To do this you must have the report files stored in a folder locally.

Continue Reading →

Crystal Reports: IN and NOT IN Record Selection

Posted on June 21, 2012 by Rick Debusk

Many of Algorithm's customers use Crystal Reports as their reporting platform. It is a mature platform with a large user base and is a great tool for report writing. A customer recently ran into a syntax issue while using Crystal Reports so we wanted to share the resolution.

The proper Crystal Reports syntax for searching using the NOT IN operator is different than the IN operator.

Example for IN Syntax: 

RecordSelectionFormula = "{ERPtable.field2}in [ " & xyz & "]".

If a NOT operator is merely added to this formula (e.g. RecordSelectionFormula = "not {ERPtable.field2}  in [ " & xyz & "]" ), it fails with a boolean or string expected error message.

Example for NOT IN Syntax:

not({table.field} in ["A","B","C"]).

Continue Reading →

Subscribe to Our Blog

Recent Posts