My Favorite Assistance Story

 

An old man lived alone in Ireland.   He wanted to dig his potato garden, but it was very hard work.  His only son, who would have helped him was in prison for bank robbery.   The old man wrote a letter to his son and mentioned his predicament.    Shortly, he received this reply,

" FOR HEAVEN'S SAKE, Dad, don't dig up the entire garden, that's where I buried the money".

At 4 a.m. the next morning, a dozen policemen showed up and dug up the entire garden without finding any money. Confused, the old man wrote another note to his son telling him what happened, and asking him what to do next.

His son's reply was " Now plant your potatoes, Dad, it's the best I could do from here".
 

Help is not on the way, but help is also not in the way! We've learned that it is often counter-productive to arrive on site, install a system, and then disappear. The user doesn't gain "pride of ownership" nor the hands-on knowledge necessary for long-term maintenance of the system. Instead of flooding you with training we believe in the go slow approach where you can learn at your own speed and not make a purchase commitment until you actually see benefits from our software

 
The first step is to know where to start digging - and the remote assistance (using Citrix server or GoToMyPc to share your actual screen over the web)  we can give  for startup is really of value. In fifteen minutes over web and by phone we can walk you through entering a quotation, making it into a customer order and follow it through manufacturing - scheduling, shop floor control and inventory/purchasing. Our system will then ship it and invoice it.
 
BASICS and WINCAMS are the Windows versions of  SIM*plicity software. The SIM*plicity concept (which has been proven  over 25 years) is to help control your business from quotation to cash. It is not just a tool for order entry or manufacturing but a complete system that helps you maximize profit.

 

 

 

 

 

FAQ's - SIM*plicity  SUPPORT

Support is the key to a successful system. For more than 25 years we have successfully supported our software clients. Our goal is to resolve any critical system problem overnight and the best way to contact us with a problem is to send an email to support@feldmanengineering.com. But first, help yourself by looking for an answer in this listing of frequently asked questions.

 
SIM*plicity

New Features - Please call for details and  installation assistance

Panel Optimization. Select most economical panel for a job
Upcharge pricing by product length,  component quantity, area,  volume,
Add vendors and customers "on the fly".
Automatically select freight classes on Bills of Lading
Material type (plaid fabrics, etc.) can select special labor operations
Inventory "Multiple Location " display and transfer
Metric Shop Floor Interface - inches for customers; metric for your team
External Product Sourcing automatic pricing  and processing of buyouts. 
Labor Reporting Integrated with Production Reporting (by ticket #)

 

Frequently Asked Questions by Category:

 

 

Getting Started  <Please Read this first!

 

Costing

Options and Features Tutorial  <<< Read this !

How are Work in Process items valued?

Where are labor and overhead rates set?

 

Database

What are Master Records?

What is the relationship between Labor, Workstations, Workcells, Department and Equipment Records?

How do I run WinSpcl  (the utility that performs special tasks)?

Why can't I read your files with Word or Excel?

How do I read "date-time codes?

Order Processing

Introduction to Order Entry <<< Read this first!

Can we add vendors and customers "on the fly"?

Can we automate the processing of "buyout" products?

Can we get a list of the buy-out items at the time a customer order is approved?

How are upcharges calculated and what features are they dependent on?

  Why doesn't Freight $  show on the Acknowledgment or Invoice?

How do I clear an option (drop-down box) in Order Entry?

How do we handle multiple packs?

How do I format product and component labels?

How do I  format  shipping labels? 

What are the default option  values (Programs.usr files)?

How can we automatically designate the freight classes on Bills of Lading?

How do we create   "Special Pricing Programs"

What is conditional pricing and how do I activate it?

How do we use both metric and inch measurements in our company?

Are there any shortcuts for entering due dates?

Invoice Processing

Invoice Details - Setting Variables

Can we designate a starting number for our invoices?

What is Automated Transfer Output?

Product Engineering

Introduction to Product Engineering <<< read this first

How do I copy (clone) Bills of Material?

Do we need meaningful inventory numbers for panel materials?

What is the logic for Booleans (Yes/No options) in dynamic b/m's?

What is Grain Sensitivity?

How do I specify alternate processes based  on characteristics of raw materials or components?

How does panel optimization work?

What determines the number of decimal places displayed and/or printed?

What math functions can be used to determine quantities?

Production Planning and Scheduling

How do I simultaneously  view items stored at different locations?

How can I determine the most economical panel sizes for an order?

How do I setup a Manufacturing Schedule? 

How do I change the format of schedules?

 

Production Reporting

What are the Labor Reporting Options when using Production Reporting.

 

Philosophy

How do you support SIM*plicity?

What part of free don't you understand?

Why are you giving BASICS software away for free?

 

Purchasing

Introduction to Purchasing   <<< read this first

 

Can we automatically price buyout items?

Can we add vendors and customers "on the fly"?

Are there any shortcuts for entering due dates?

 

Startup 

Getting Started    <<<Read this first!

"Error with Calendar Data" Message

I only see an empty (blank) screen when I start the program. What should I do?

How do I personalize Wincams to include our company information, and to turn on and off features?

Where are the files located (file structure)?

Wincams won't run over our  network! How do I change it?

Can we use older versions of Windows with SIM*plicity ?

Can we use SIM*plicity with Vista?

What data needs to be changed when we decide we are done testing SIM*plicity and are ready to start with actual orders?

How do I reset  a key (make a fresh start on data)?

How do I know if I have the latest version of  SIM*plicity?

Runs very slow - How can I speed it up?

What are the values of the "inventory flags" that are used for data imports?

===================================================================================

 

How do I personalize Wincams to include our company information and to turn on and off features?

Modify CAMS.INI (found in your user directory). Optional values are shown for the lines commonly changed. If a file name is indicated (such as for document footers) either modify that file or point it to another file. Start by modifying the files with  the "fot" suffix. (These are your address files.) Also edit the default  logo.bmp or substitute your logo bitmap for the one in \wincams\winuser\bitmaps. Caution: Bitmap logo size is limited - if you make it too large the page won't print.

Can we add vendors and customers "on the fly"?

Life isn't as formal as in years past!  Early on, our clients were insistent about "accounting" having the final say over who they bought from and sold to. To accommodate them SIM*plicity required pre-approval by having a separate vendor and customer file.

Today, the philosophy is get the order (or at least quote it) and somehow we will work things out with potential customers. This requires a system capability of adding new customers at the time of quote and adding new vendors whenever needed. We made it as easy as possible -  just right click on the vendor or customer # field  and select the the "add new" option ( the bottom entry on the pop-up search list). This will bring up the database screen. Please remember - click on the new box first before entering data and to enter  a zip code tab down form the address line and enter the zip code #. If it exists, it will fill in the city line, if not it will pop-up a new zipcode entry box

Wincams won't run over our  network! How do I change it?

Single user versions will not run over a network. If you have purchased a multi-user version please contact us for the necessary authorization files and/or to resolve your problem.

Where are the files located (file structure)?

There are three groups of files:

- Wincams Folder: Program files (Wincams32.exe + network control files).

- Windata folder: Data files (database and log files). Temporary ( for specific orders)  Bill of Materials, and Schedule files are in subfolders.

- Winuser folder: User files (settings for your company including dynamic bills of material.  Bitmaps subfolder contain product bitmaps.

Single user system folders must follow this naming convention and logic

 

C:\ C:\Wincams C:\Wincams\Windata C:\Wincams\Windata\Billmatl
C:\Wincams\Windata\Schedule
C:\Wincams\Winuser C:\Wincams\Winuser\Bitmaps

 

 

What is the relationship between Labor, Workstations, Workcells, Department and Equipment Records?

Bills of Material specify labor operations (identified by class#11).  These are performed at at specific workstations (class #D2). A given workstation can have a number of similar machines (class #D1) that can perform the same operation (and these are assignable during the scheduling process).  Functionally similar machines are grouped  in workcenters (class #D3) and they in turn are grouped into departments (class #D4)

This is a little complicated so bear with me. What we have is a chain of command that is used for work assignment and cost control.

Departments are the highest level and overhead costs are normally charged by department .

A department is a collection of Workcenters.

Each Workcenter is composed of  one or more Workstations).

 A Workstation  is a generic functional  machine:  it can be an individual piece of equipment , i.e., panelsaw,  or cutting table, a workcell (group of machines  dedicated to a multi-step  process) or a dedicated line (metal painting or hot press panel laminating line).  

Specific machinery ( each panelsaw or router), workcells and lines are  listed in the equipment key. The first parent is the machine or workcell  location,  the second parent is normally the Workstation.   For equipment which is part of a dedicated workcell or a line (the gluespreader on a laminating line), the second parent is the specific workcell or line in the equipment key.

Production schedule data is accumulated by Workstation and then summarized by Workcenter and Department.  Group leaders can use the Workstation Schedule to assign specific machines to jobs, to check whether materials are available or prior operations are completed.  These records point to each other by the use of "parent records" An example:

 

labor

operation

equipment Workstation

(workcell /line)

Workcenter Department
class #11 class #D1 class #D2 class #D3 class #D4
labor op - P1
Glue-up Laminating
equipment -P2
 spreader#1 Pressline A
Press#56 Pressline A
Spreader#21 Pressline B
Press #88 Pressline B
workstation -p1
Pressline A Laminating
    Pressline B Laminating  
        workcenter -P1
      Laminating Panels

 

 

 

I only see an empty (blank) screen when I start the program. What should I do?

 

 

If the screen is truly blank - no text visible on the above accordion bar (left side of screen) go to Control Panel> Display>Windows Setup> Display> select "Classical Windows " theme!  If you can see the Accordion Bars but after clicking on one, can't see subheadings then you must change the colors in your Windows Setup. Select Default (Blue).

Click this link for more details on our opening page!

 

"Error with Calendar Data" Message

Your software needs a more current calendar file (days worked and holidays). Please email us for the version suitable for your version of SIM*plicity.

 

 

 

What math functions can be used to determine quantities?

SIM*plicity's dynamic bill of material files contains a full range of mathematical functions. First here is an example of how to use them:

05    Panel     L1         0.25         W5           72                    ""        I1      Panel     0       0..
06    Panel     L1         0.25         12            72                    ""        I1      Panel     0       (ceil(W/W5))..    $
 
In this example we are determining how many panels are required in a product such as a wall. The first line sets the width of an individual panel to be that which is set up in the I1 key; the second line defines the number of panels as the Width of the product (wall) divided by the width of an individual panel. The ceil function (for ceiling) says that if there is any fraction then go up to the next highest integer; i.e. 4.1 -> 5. The "$" indicates that there is upcharge pricing on quantity determined by the function. Note the parentheses around the overall function, "(ceil(W/W5))". They  are critical -- it won't work properly without them. Here is a list of common functions  (there are a lot more- just ask):

 

FUNCTION DEFINE AS  COMMENTS
integer INT integer part of a real number
ceiling CEIL lowest integer >= to x
floor FLOOR highest integer<= to x
absolute ABS absolute value of number
fraction FRAC fractional part of number

 

 

 

What are the Labor Reporting Options when using Production Reporting.

Labor can be reported within either the Plan and Perform module or by using the Production Reporting option in the Manufacturing Control module.  This discussion pertains only to the Manufacturing Control module where labor is reported by ticket number.   

To initiate labor reporting add (or edit) the following lines in CAMS.INI manufacturing section:
[Manufacturing]
Report Labor=yes           (no is the default)
Report Inventory=no       (yes is the default)

The significance of  the setting "Report  Inventory" depends on how labor is reported in your company. If you report it in real time set this value to yes. If you batch report (i.e., enter  time card date at the end of the day) you may want to avoid the lag in entry time required for the inventory to be updated after each transaction. If "Report Inventory" is set to "no" inventory transactions will only take place when you ship the product . With either option back-flushing of inventory and labor usages will take place unless that specific transaction was reported.

Operators name, and/or ticket numbers can be entered by scanning of  barcodes or directly via the keyboard.  Time can be entered as conventional (1:00 pm) or military time  (1300). Entering "=" enters the current time.

 

How do I copy (clone) Bills of Material?

Dynamic Bills of Material are normally used for a wide range of products while Static Bills are used for specific products. If you have similar products which require Static Bills you can use a similar item as a template --"cloning" its structure to an an empty Bill of Material.  From the Engineering accordion bar select "Create/Edit B/M". Select the bill to copy from and click "Ctl-C" {control plus the c key}. Then select the empty bill and click Ctl-V". The data from the original bill is copied to the new bill which can then be edited.

 

 

 

 

How are upcharges calculated and what features are they dependent on?

Select Order Entry, then Product Definition selection  on the menu accordion. Entering an item allows you to select the Global option that establishes the base price for that product. If you enter "0" in the base price then the unit value prices are the product prices. If you enter a value in the base price the unit values are incremental. To these prices you can add feature specific pricing which can be either Global (Order) or Product Option specific. However these upcharges are the same for all products that have the specific options selected in their bills of material.

Upcharges depend on the unit value of the selected option (if not a yes/no option), and are defined with the following characters (selected from a drop down list). note values can be negative (price reduction)

$    Dollar amount added to product price.

Q    Count function  that multiplies the $ amount selected by the quantity (i.e., number of doors, buttons, etc.). To activate the count function enter  a "$" at the end of  the line in the bill of materials that defines the option.

%    Percentage of product base price.

T   $ amount multiplied by product's thickness

$ amount multiplied by product's width

L    $ amount multiplied by product's length

A    Area: calculated as length multiplied by  width

M     Metric area  Area is calculated as length multiplied by  width and as this could become a very large number  use the "M" option which is area divided by one million - equivalent to converting square millimeters to square meters.

P     Perimeter: 2x width plus 2x length

S    2x(width x length x thickness)

B   Board Feet - thickness ( specific size ranges) x (length x width)/144

    Using Board-feet values requires a special usr file "boardft.usr. Here are some typical values:

1              .83

1.25        1.05

       1.5          1.31

      2               1.81

     2.5             2.31

 For example all products with a final finished thickness greater than 1.05 and less than 1.31 would be considered 6/4 and have their surface area (divided by 144) and multiplied by 1.5.

CAUTION: The following  options may require reformatting of your acknowledgment and invoice layout.

U  A per order charge - regardless of quantity

N  A charge (or reduction) if the quantity is greater than specified default

A charge (or reduction) if the quantity is less than specified default

(When selecting N or X a pop-up box appears to input the minimum or maximum quantity.)

 

How do I run WinSpcl  (the utility that performs special tasks)?

Prior to doing so copy wincams32.ini to winspcl.ini so that at startup it will find your two versions of the database. Your application is on the pull down bar at the top of the screen. Try it on your test database first!!!

 

 

What are Master Records?

Master Records

 

The engine that drive  SIM*plicity is a relational database.  It is transparent to most users but sometimes you need to get “under the hood”  (when setting up your database) or just want to know what’s there.  This overview should help but please contact us for detailed info before you change anything in the “System Maintenance” area.

 

 To isolate problems SIM*plicity’s database is divided into separate files. Most of these share a common format and are designated “Master Records”. The layout of a standard Master Record is divided into fields as per these examples:

 

Standard Record Format

Zipcode Format

Zipcode Record

Record #

Z0-nnnnnnn

Z0-0000704

Class/Key (identifier)

Z0

Z0

Code (must be unique)

Zip Code

11201

Description

City (Only)

Brooklyn

Unit Value

Country

“0”=U.S.A.

First Parent

State

“Z9 –33”  N.Y.

Second Parent

Not used

 

Status

Not Displayed

“A”

 

 

 

All these fields are  indexed (sorted automatically)  giving you immediate access to a single record or groups of records based on any of the above.

 

 RECORD #   Each record in the system has a unique identifier so you know what file it belongs to and what its record # is. An analogy is a car’s VIN#.  Change its license  from state to state or even repaint it and you can still identify it.  This is extremely important within the system because you can  rename products in your catalog without losing the links to related products or to its original  bill of material.  ( W3030 is  kitchen cabinet industry standard nomenclature – you could change  its identification or description for ease of data entry or for private labeling without changing any of its manufacturing information).

 

CLASS/KEY   The record # prefix is two characters designating the file to which it belongs.  These characters are  called “classes” and” keys” Visualize them as a long bank of file cabinets. The individual cabinets are the classes identified “0-9 and A-Z). Each cabinet has ten “key” drawers (0-9). This gives us a total of 360 Master Record files, each dedicated to a specific purpose.   Most users don’t need to deal with  knowing the Class/Key characters as the system automatically ties them to their intended function.

 

The classes are identified with functional names as well as the characters so a “file clerk” doesn’t have to hunt at random. For example; inventory is stored in the “I” class (cabinet) with the main  manufacturing inventory in I1 and satellite warehouses and special inventories in the keys (drawers) 0, 2-9. In the system maintenance section of SIM*plicity the user can designate (initialize) keys for specific functions and access utilities to repair the keys if they get damaged.

 

CODE A unique identifier (within the selected Class/Key) up to 10 characters long.  Zipcodes are the best analogy.

 

DESCRIPTION  Up to 30 characters. This does not need to be unique.  (There are many Brooklyns in the United States but every one has a unique Zipcode).

 

UNIT VALUE   A single character (key specific)  to designate a family grouping.  In the product key it may be used to designate sofas, chairs, etc.  In the inventory key it may be used for pieces. pounds, sets, etc. Next to the Unit Value field in the screen above are up and down arrows called “Spin Buttons”. The user can select or change the unit value for any record by using these arrows. The default number of unit values for any key is 10. If you need more unit values create a file with the key's file name and the suffix  "unt". For example the state file "Z9" uses the unit value field to identify  countries. To add additional countries create a file (in your data folder) with the name "cmkeyz9.unt".

 

PARENT RECORD Every Master Record is tied to two parents so  the user can  find records based on their parents or children.  Parent records are predetermined and selected by the spin buttons when data is entered manually.

 

STATUS Master record designations change in use:

"A"  active. An active record can be located and modified as required.

“I”   inactive record can be located and modified much the same way as an active record, but generally does not appear on reports and other displays.

“D" deleted which means the record is hidden and removed from the sort indexes. Master records are only marked as deleted, they are not removed from the file

"L"   locked. This is temporarily used within a network to prevent other users from modifying a record while it is being processed.

"U”  unused.  

For how- to information on importing your existing data into SIM*plicity please read:Importing Data

 How do I clear an option (drop-down box) in Order Entry?

To clear an option in order entry, select the option and then right click and choose "Clear Option"

Why doesn't Freight $  show on the Acknowledgment or Invoice?

Check the FOB.USR  file in your user directory. If the freight description starts with a "+" sign freight always defaults to zero and can't  be changed in order entry. Select another value in the freight pulldown box or alter the FOB.USR file.

Char  Description

0           +Collect                        (no freight value )

1            PrePay & Add            (freight charged on invoice)

 

 

How do we handle multiple packs?

A classic question. Ordered are 6 arm chairs and 3 swivel rockers. Chairs are 4 to a box and rockers are 2 to a box. How many boxes were used and how much did they weigh? Did they put the two extra chairs in one carton? Did they put a chair in with a swivel rocker? We don't know! Therefore:

Weights are per piece based on your standard pack.

Pieces per box are your standard. We will always divide the total quantity of a "line item" by its standard pack and round up!

Enter pcs per box info in the inventory add/edit section.

 

What are the values in the Programs.usr files?

The PROGRAMS.USR file, residing in the user file directory, specifies  

the various sales programs which are available and the default options for each

program. There is a line in the file for each program.

The first field, terminated by a "\", is the program name. The second

field is the unit value for the item price. The next fields represent

the record number of the global option -- the first of these fields would

represent the option defined by the parent of the first master record of

the global option key. If the value is 0, then no default is defined;

if the option is positive, then it represents the record number of the

option specified by the parent of the global option master record but

the operator can specify a different option, if desired. The last

global option is followed by a "\" if there is additional information

on the line. Following this second "\" is the optional name of the

program which will appear on acknowledgments and invoices. The

acknowledgment name can be followed by a "\" and the number of the

discount file which will apply to this program.

 

Are there any shortcuts for entering due dates?

Default due dates for order entry are defined in "CAMS SETUP".  Default due dates for requisitions (purchasing) are defined in CAMS.INI in your user directory. In the purchasing section of this file is a line "DUE DATE DELTA=0 . The number after the equal sign is the default # of  working days between ordering and due.  You can edit this value directly; click on the calendar icon to select a date; or, use one of the following shortcuts entries:

    EOM    sets date to last working day of month

    Tomorrow  sets date to next working day

    Today sets date to today

    Mon, Tue, Wed, Thu, Fri sets date to next date that corresponds to day of week.

    Final  sets date to last day of month corresponding to today's day of week.

 

Why can't I read your files with Word or Excel?

You can - use the transfer function in the Utilities section of the accordion menu. What you can't do is directly read or write to our file structure from other programs . This is for user security and general safety. (The transfer utility has additional security features including  preventing users whose authorization has expired from accessing the data.)

 

How do I setup a Manufacturing Schedule? 

Manufacturing Schedules Setup

 In the user file directory, there needs to be a file, SORTINFO.USR, which defines the various sort sequences that are needed. The first line of this file is ignored and can be used as comments. (A sample file follows - note that the display format  may make it appear that there are blank lines between the data lines there should not be any blank lines in your file. Please see the actual file in your user directory).

1=NotUsed;2=Part#;3,4,5=T,W,L;6=Due;7=Remarks;8=Order #;9=Cust;10=Labor,11=Ship Date, 12=Global Option,13=Local option,   14= Customer Name, 15=scheduled date 16=Product Name

Labor/Part#/T/W/L/DateDue\ 10 6 3 4 5

Part#/T/W/L/DateDue\   2 3 4 5 6

T/W/L\  3 4 5

Part#/T/W/L\  2 3 4 5

DateDue\ 6

Ship\ 10 6 9 8

Cut Panels\ 6  8

Date due/partnumber\ 6 2

Frame Color/Part#\ 2 G-1 

Up unto the ‘\’ is a description of the sort sequence; following the ‘\’ are  the indices for the various sorts. These are:

   Sort Index:

      1 : Species

      2 : Part Number

      3 : Thickness

      4 : Width

      5 : Length

      6 : Date Due

      7 : Remarks

      8 : Order Number

      9 : Customer Number

     10 : Labor Op (Code)

     11 : Ship Date

     12 : Global Option

     13 : Local Option  

     14:  Customer Name

    15: Pack (schedule) date

    16. Product Name

     Note: a '!' following an option creates a page break. A"*" following an option says not to sub-total on that option.

 

In the example above, the first sort sequence is identified as  “Labor/Part#/T/W/L/DateDue” and the sort order is first by labor operation (10), then by Date Due (10),  then by thickness, then width, and then length (3 4 5).

For Global Options, either a 12 or a ‘G’ will suffice and similarly for Local Options, a 13 or an ‘L’. These parameters, however need to be followed by which option #. For example, G-1 says the global option defined by the M0 key, record number 1. (Local option capability is limited at this time.)

After the SORTINFO table is built, there are two ways to define which sort sequence to be used for a particular machine. In the DOS Add/Edit Machine Info screen there is a field for this. Alternatively, the manufacturing schedules are defined by CMUFACT5.INI and the sort sequence can be specified there.

            140-1 Paint Line\                        D1-26     :  9

Indicates that the ninth sort sequence in SORTINFO.xx0 is to be used for the equipment identified by D1-26. With the file above, this would be “G-1 2”. D1-26 is the parent of the labor operations to which the schedule should apply.

 

 

How do I change the format of schedules?

Edit cmufact5.ini. The default is a multi-line detailed listing. To change, add one of the following characters in front of the workstation #:

                 "%"   Totals only

                        "&"  Summary  (one line per item)

                        "*"  Summary/w totals

[Work Cells] 
140-1 PAINT LINE\          %D1-26    :   9
150-1 ASSEMBLY\           *D1-28     :   9

Note there is no space between the symbol and the workstation #

 

 

IWhat is the logic for Booleans (Yes/No options) in dynamic b/m's?

If the option  is a Boolean , then the number

list it represents is "No" "Yes" (2 numbers, after the exclusion, like 0 1..)

If the option is part of an expression such as !L1 or L1+L2, whether it is a

Boolean option or not, the 1st number in the number list represents "Yes"

 

What is Grain Sensitivity?

How do I specify alternate processes based  on characteristics of raw materials or components?

 

“Grain Sensitivity” in a Bill of Material

 

Grain Sensitivity is a modifier used to designate material with process limitations. Examples are plaid fabrics which can’t be cut on automatic cutters and wood grain laminates where the length and width dimensions  are not interchangeable for optimization in panel saws or in router nesting.

There are two places where grain sensitivity is specified:

-         The first is on the inventory item itself and is set through the Add/Edit Inventory Item screen, Physical tab. This flag being set indicates to the system that this particular item has grain sensitivity. 

-         The second place is in the bill of material designating the operations which are affected by grain sensitivity.For static bills of material, this is set in the Create/Edit Bill of Material Screen. On the Create/Edit screen, the “Grain Sensitive” check box is three-stage. Checked means that the b/m item should be included if a previous item is grain sensitive; Unchecked means that the item should not be included if a previous item is grain sensitive; and Gray means always include the item. For dynamic bills, this is specified on the line after the record numbers and before the Autocad information, if any, as a “G+” or “G-” indicating that the item in the bill of material is grain sensitive and non-grain sensitive. The absence of either a “G+” or a “G-” implies a grayed state.

 

When exploding the bill of material, the system looks at every selected item and if the grain sensitivity flag is set for that item, it sets an internal flag saying that the component, assembly or whatever has grain sensitivity specified. This internal flag only applies to the current level of the bill of material – each higher or lower level has its own flag. Each subsequent item (and the item itself) is now checked against the bill of material grain sensitivity flag.

  1. If the internal flag is set and the b/m item sensitivity is set (Checked), the b/m record is selected.
  2. If the internal flag is set and the b/m item sensitivity is not set (Unchecked), the b/m record is not selected.
  3. If the internal flag is set and the b/m item sensitivity has not been specified (Grayed), then the b/m record is selected.

 

It is anticipated that Checked/Unchecked combinations of labor records  would be used in pairs in a bill of material in order to select one or the other operations based upon whether a previous item was grain sensitive. (If no item in the current level of the bill of material has its grain sensitivity flag set, then the Unchecked and Grayed would produce the same result.)

What is conditional pricing and how do I activate it?

Conditional pricing is when the value selected for one option is combined with the value selected for another to determine price (or upcharge on the  base price). For example if you are making tables with both laminate and veneer tops you could  decide that you wanted a substantial upcharge for combining wood edges (rather than laminate edges) with laminate tops. To activate it you create  a  matrix  of unit values of the two dependent options in the following format :

1 5           0      1      2      3      4      5      6      7      8      9      A
0             0      0      0      0      0      0      0      0      0      0      0
1             0      0      0      0      0      0      0      0      0      0      0
2             0      0      0      0      0      0      0      0      0      0      0
3             0      0      0      0     16     16     16      0      0      0      0
4             0      0      0      0     32      0     32      0      0      0      0
5             0      0      0      0      0      0      0      0      0      0      0
6             0      0      0      0      0      0      0      0      0      0      0
7             0      0      0      0      0      0      0      0      0      0      0
8             0      0      0      0      0      0      0      0      0      0      0
9             0      0      0      0      0      0      0      0      0      0      0
A             0      0      0      0      0      0      0      0      0      0      0
B             0      0      0      0      0      0      0      0      0      0      0

 

"1 5" in the upper left hand corner are the option #'s. Across are the unit values for option #5 and down are the unit values for option #1. Non-zero values in the table are the conditional pricing  values when both of these unit values are selected.

File names are:
GlobalOptionFile: UPCxxyy.USR 
LocalOptionFiles: UPLnxxyy.USR (Ln = L1, L2, etc)
xx = first option record # 
yy= second option record #

In product definition select multiple options are the pricing option and enter the names of the conditional option in the  special box that pops-up when multiple options are selected.

Can we designate a starting number for our invoices?
Edit CAMS.INI in your user directory.
In the [Invoices] section add a line
Number Offset=nnnnn (nnnnn is a number 1  less than your first invoice #)
 

How do we create   "Special Pricing Programs"

1. Edit the DISCNTxx.USR files to set up the various special 
discounts. For instance, DISCNT00.USR, should look like:

Installers Program
H1 H0
9
F 50 (.50)\                            0.50       0.05
E 50-10 (.45)\                      0.45        0.05 
D 50-10-10 (.405)\              0.405      0.05
J  Employee Disc 28%\         0.28        0.00
K 50-10-5\                          0.4275    0.05
A (A) Blue MoonProgram\    0.10        0.04

Note: In Product Definition, the names for the various discounts 
comes from the lowest number DISCNTxx file -- in this case, 
DISCNT00. Therefore, the lowest number DISCNTxx file MUST contain 
the names of all the special discounts.

2. Initialize the H0 key (through the Utilities menu). There need to be only enough records to hold 
the products for which there are special discounts.

3. Enter into the H0 key only the products foer which there are special discounts
t
4. In the Customer Database, set up each eligible customer for 
the particular program and within each program, set them eligible 
for the specific special discount programs.

How do I read "date-time" codes?

The date-time code is used to automatically create master records.  It is a nine digit number followed by an ASCII character. Decode 201240855> as:
Position 1:Year (2002)
Positions 2-5 : Date 0124= January 24th
Positions 6-9: Military time 0855 =8:55 am
Position 10: Sequential ASCII value necessary to avoid duplication as we could be writing more than one record to the same file during a given minute
 

 

 

What data needs to be changed when we decide we are done testing SIM*plicity and are ready to start with actual orders?

To flush out all your trial data  the following keys have to be reset.
 
e9 - Demand key
q1 - Order Key
u1 and/or u2  - Order Audit Key2
t1 -  Invoice key
g7 - Factory Orders
a2 and/or a3 - Order Entry Audit keys
 
 
The following files also have to be deleted:
Ordrinvc.*      (Invoice messages)
Ordrmfg.*     (Manufacturing messsages)
Ordrpack.*   (Packing slip messages)
Dtailq1*.*     (Customer Order Details)
Dtailg7*.*     (Factory Order Details)
Cogsq*.*      (Cost of Goods Sold)
1a00*.*        (Billmatl files)
Relieve.*      (Shipped Order quantities)
 
 
Delete all files in your schedule and billmatl directories (folders)
 

How do I reset  a key (make a fresh start on data)?

Key Maintenance functions are found in System Maintenance>CAMS SETUP>Keys. Select the key by right clicking on it 

To  reset a key

1. Screenprint so you know  headings and unit values.
2. Reset the key.  When you are prompted for # of records enter 500.
3. Rename cmkeyXX* to xmkeyXX.* (Where XX is the key  you are resetting. This is an extra step just to make sure that you've cleared the disk space.) If you are starting afresh just copy the entire data folder  to a new name such as old-data.
4. Reinitialize the key.

Special Cases: M0 and L0 are read into memory as you enter SIM*plicity- always exit and restart after modifying these keys. It may be easier to edit these keys one record at a time!

Order Entry and Factory Order Keys have a number of associated records - see the list of keys to be reset in the startup discussion above.

 

How do I  format  shipping labels? 

 

Please read this page for field definitions:

Product and Component Labels

Shipping Labels Formatting

 

The shipping label format is under control of the “Shipping Label Format” section of the CAMS.INI file.

 

Each entry in the section has the following format:

Key Name=Control String

Where Key Name can be any of the following (case is not important; spacing is}

PRODUCT CODE

PRODUCT DESCRIPTION

CARRIER

PRO NUMBER

PO NUMBER

ORDER NUMBER

ITEM NUMBER

ORDER NUMBER PLUS ITEM

SHIP DATE

QUANTITY

STAGING LOCATION

THICKNESS

WIDTH

LENGTH

NOTES 1

NOTES 2

SHIP TO

ADDRESS 1

ADDRESS 2

CITY

In addition, a Key Name of LABEL puts just text onto the label.

The label is measured in inches, with the upper left corner being 0,0. The control string is made up of a series of parameters separated by semi-colons of form:

Parameter:value

The various parameters are as follows:

Xlabel                          X-coordinate for the label

Ylabel                          Y-coordinate for the label

Xfield                           X-coordinate for the field

Yfield                           Y-coordinate for the field

LabelSize                     Size of the label font in pixels

FieldSize                      Size of the field font in pixels

Font                             Name of the font

Bracket                        Place the value string before and after the field

Label                            The fixed text that is associated with the field

The “ORDER NUMBER PLUS ITEM” has a special parameter string, SEPARATOR, which defines the character string that is between the order number and the item number. Also, the presence of BOLD, ITALICS, or UNDERLINE in the control string sets the appropriate printer characteristic.

 

The items are printed in the order they appear in the section of the INI file. If there are duplicate key names in the section, only the first one is recognized.  The label, if any, is printed before the field.

 

If an X dimension field (Xlabel or Xfield) is omitted, the X position is the end of the last string printed; if the Y dimension field is omitted, the Y position is the next line down. If the FONT parameter is omitted, the previously defined font will be used. If the font is changed during the printing of the label, be sure that the first Key Name entry has the font reset to the default.

 

In the [Shipping Labels] section (separate from the Shipping Label Format section), provision has been made for:

Orientation=landscape

Or

Orientation=portrait

In order to properly set the printer to the right mode.

 

A sample [Shipping Label Format] section is:

 

[Shipping Label Format]

Product Code=XLabel:0.25;YLabel:0.25;Label:"Product # ";YField:0.25;Font:"Times New

Roman";LabelSize:12;FieldSize:16

Product Description=XLabel:0.25;YLabel:0.5;Label:"Product Desc ";YField:0.5;LabelSize:12;FieldSize:16

Carrier=XLabel:0.25;YLabel:1.0;Label:"Carrier ";YField:1.0;LabelSize:12;FieldSize:16

PRO Number=XLabel:0.25;YLabel:1.25;Label:"PRO Number ";YField:1.25;LabelSize:12;FieldSize:16

PO Number=XLabel:0.25;YLabel:1.50;Label:"PO Number ";YField:1.50;LabelSize:12;FieldSize:16

Order Number=XLabel:0.25;YLabel:1.75;Label:"Order Number";XField:0.25;YField:2.10;LabelSize:12;

FieldSize:20

Item Number=YLabel:2.10;Label="_";YField:2.10;LabelSize:16;FieldSize:16

Quantity=XLabel:3.50;YLabel:0.25;Label="Qty Pkd";XField:3.75;LabelSize:12;FieldSize:16

Ship Date=XLabel:3.50; YLabel:1.00;Label="Ship Date";XField:3.50;LabelSize:12;FieldSize:16

Location=XLabel:3.50;YLabel:1.50;Label="Location";XField:3.50;LabelSize:12:FieldSize:20

Notes 1=XField:4.5;YField:0.25;FieldSize:16

Notes 2=XField:4.5;FieldSize:16

Ship To=XField:7.00;YField:0.25;FieldSize=16

Address 1=XField:7.00;

Address 2=XField:7.00;

City=XField:7.00;

Order Number Plus Item=XField:4.5;YField:1.75;Bracket="*";Font:"3 of 9 Barcode";FieldSize:48

 

Note: the lines which are indented need to be included in the line above the indention.

 

How can we automatically designate the freight classes on Bills of Lading?

 

Bill of Lading Freight Class Files

Purpose:

These files contain the text for the” article descriptions” that are printed on the bill of lading. Additional fields have been added to designate which product unit value are associated with each class. SIM*plicity will automatically print the the number of cartons for each on bills of lading.

File Name Designation:

Prefix specified in CAMS.INI

[Bill of Lading]

Class File Name=(defaults to “BillOfLading”).

BillOfLading files:

These are text files located in your user directory.  Extensions  are of the form “.nnn”. One file for every class description that should appear on the bill of lading There are a maximum of 8 files of this type.

Example:  BillOfLading.001

Class=85;0,1,2

BOOTHS,BAR,REST, OR STORE NOI KD

FLAT, IN PACKAGES ITEM #82400

Format:

First Line          CLASS=nn

Where “nn” is the class that appears on the bill of lading. This text can be optionally followed by a “;”, and then a unit value list or the word “Default”, such as:

CLASS=85;0,1,2

CLASS=85;Default

Second and subsequent lines:

Text that is included in the article description. Although there is no limit as to the number of lines to be entered, the box printed on the bill of lading will only contain four lines.

These files define the article descriptions to be placed on the bill of lading.  If the unit value list is not used, all items on the orders are grouped into the first description.

If the unit value list is used, the items on the order(s) are processed, and the appropriate description, based on a match with the product unit value, is tallied for piece count and shipping weight. If a unit value match is not found, the default article description is used. If no “Default” is specified, the first article description that does not contain a unit value list is used.

 Note, if  needed please request the Word document illustrating the CAMS.INI values for Bill of Lading FORMAT fields:

 

Can we automatically price and process (at order entry) buyout items?

Sub-contract and buy-out items are automatically costed in the same manner as product pricing. A base price can be established depending on the unit value (species, fabric grade, etc.) and option and feature upcharges can also be calculated based on their unit value. Option and feature charges can be calculated on area and % as well as $ cost.

In order to use this feature, the following items need to be set:

  1. In the [Accounting] section of CAMS.INI:
              Product Costing=Yes
  2. The H9 key (default) needs to be initialized. When the Product Costing=Yes option is present in CAMS.INI, a key is displayed on the System Maintenance | CAMS Setup screen. Description should be something like “Product Costing”. The key needs to be initialized but not necessarily populated.
  3. Order Entry | Product Definition – for product type, choose Product Costing. Enter a part number. The search is actually done on the normal product key, H1, and an appropriate record is displayed. If a corresponding record does not exist in the H9 key, it is added with the “External Source” flag set.
  4. In the H9 key, enter the appropriate unit value pricing and the appropriate upcharges for both the global and local options.
  5. In the H1 product key, select the attributes ("color" options) that you want printed on the PO. Size of the purchased product and reference to the customer order and line # are also printed.
  6. An external source item can be either directly entered or be included in a top level bill of material. Examples of this would be the purchase of unfinished chairs with the bill of material then having upholstery operations or doors for kitchen cabinets.

When a customer order is approved</