tag:blogger.com,1999:blog-77002518068388196922024-02-08T06:16:57.513-08:00Sage 100 blog by MnMSolutionsInc.comProviding tips, news, and help for Sage 100 users (formerly MAS 90 and MAS 200)
If you need any help, give us a call at (707) 425-9923.
MnMSolutionsInc.comhttp://www.blogger.com/profile/01507874827357643289noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7700251806838819692.post-27338826053573551102013-07-11T11:54:00.002-07:002013-07-11T11:54:41.264-07:00Sage 100 Scripting Capabilities<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><br />
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
</style>
<![endif]-->
<br />
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style="font-size: 20.0pt; line-height: 115%;">Sage 100 Scripting Capabilities</span></i></b></div>
<div class="MsoNormal">
<span style="font-size: small;"><span style="line-height: 115%;">Below are just some of the examples of what scripting can do in Sage 100 (formerly MAS 90 and 200)</span></span><span style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-style: normal;"><span style="font-size: 20.0pt; line-height: 115%;"><span style="font-size: small;">. If I can be of any assistance with your scripting need, contact me (707) 425-9923.</span></span></span></span><b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style="font-size: 20.0pt; line-height: 115%;"> </span></i></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; mso-highlight: yellow;">Open Related Documents</span></b></div>
<div class="MsoNormal">
A button can be placed on a screen (Item Maintenance,
Customer Master, Vendor Master, etc) to recall a related document stored on the
server.<span style="mso-spacerun: yes;"> </span>There are two options with
naming and storing the related documents.<span style="mso-spacerun: yes;">
</span>The first is that the documents can be stored with their names matching
the file (Item Number = ABC, Document Name: ABC.pdf).<span style="mso-spacerun: yes;"> </span>The second is that an additional text field
can be added next to the button that can store a file name.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; mso-highlight: yellow;">Delete Pricing (Customer or Item
Pricing Records)</span></b></div>
<div class="MsoNormal">
This script was designed to make changing pricing quicker.</div>
<div class="MsoNormal">
For example you have a customer that has special pricing on
1000 items and you want it to stop.<span style="mso-spacerun: yes;"> </span>The
script can run through and delete all pricing records associated with that
customer at once.</div>
<div class="MsoNormal">
The script can be used in combination with visual integrator
to make quick modifications to inventory pricing.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; mso-highlight: yellow;">Calculate Qty Ordered (Sales
Order and Invoice Detail)</span></b></div>
<div class="MsoNormal">
This script is designed to calculate the Sales Order Detail
field “Quantity Ordered" from a combination of stored user defined fields.
"PERBOX", and "BOXES"<span style="mso-spacerun: yes;">
</span>The Quantity Per box is stored at the item level, but can also be
changed at the line level.<span style="mso-spacerun: yes;"> </span>A box
quantity is entered into the BOXES field, the field is then multiplied by the quantity
per box stored.<span style="mso-spacerun: yes;"> </span>The value is then pushed
into the Quantity Ordered field. (the one that is actually used in Sage.</div>
<div class="MsoNormal">
This similar process can be used to calculate unit price and
many other scenarios depending upon the clients needs in data entry.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; mso-highlight: yellow;">Calculate Discount to display on
Line entry and Form Printing</span></b></div>
<div class="MsoNormal">
This script designed to calculate the discount based off of
the difference between the line Unit Price and the items Standard Price or
Retail Price.<span style="mso-spacerun: yes;"> </span>This value is then stored
in a discount field.<span style="mso-spacerun: yes;"> </span>This discount filed
can also be updated to in turn change the Unit Price field.</div>
<div class="MsoNormal">
Ex. Unit Price = 80, Retail Price = 100, Discount = 20%</div>
<div class="MsoNormal">
The Retail Price can’t be changed but the other two can and
will consequentially update the other.</div>
<div class="MsoNormal">
This information can then be used on the Sales Order or
Invoice forms is desired.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; mso-highlight: yellow;">Change Standard Cost Value in
Item Maintenance.</span></b></div>
<div class="MsoNormal">
This script uses a user defined field to populate a NEW
Standard Cost record in Standard Cost Adjustment Entry utility in Inventory. <span style="mso-spacerun: yes;"> </span>A blank field is put on the screen with a
button that when pressed grabs the value in the field and creates a new entry
in Adjustment Entry.<span style="mso-spacerun: yes;"> </span>This is nice
because typically entries can’t be entered unless all entries are updated.<span style="mso-spacerun: yes;"> </span>This script allows for entries to be made
that will be sitting out there ready to be updated when possible.</div>
<div class="MsoNormal">
Note: The Adjustment Entry will have to be updated for cost
changes to take place.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; mso-highlight: yellow;">Coupon Codes in Order Entry</span></b></div>
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">This script
looks at a user defined field "Coupon Code" on the Sales Order Totals
tab and when the coupon is applied to the order, it pulls coupon information
stored in the maintained user defined table “Coupon_Codes” and calculates the
coupon amounts per line.</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">It can work
for all different types of coupons;</span><br />
<div style="margin-left: .5in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 11.0pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">All Customers, All items</span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 11.0pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">Specific customers, All items</span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 11.0pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">Specific customers, Specific items</span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 11.0pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">All customers, Specific items</span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 11.0pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">Percentage based or Amount based</span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 11.0pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;"> </span></div>
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin; mso-highlight: yellow;">Track Rental Contracts in Sales Order</span></b><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">Repeating orders
are set up as contracts in the sales order module.</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">User defined
fields on the lines of the contract reference the serial number of the item
being rented. Rented Serial items are automatically transferred from the stock
warehouse to the rental warehouse by creating Inventory Transfers (though
another script)<span style="mso-spacerun: yes;"> </span>Once the contract has
expired, the item can then be returned to the stock warehouse, or even to a
holding warehouse for repairs and processing. This is done again with an
automatic inventory transfer.</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">Reports can
be ran for rental profits by item and by serial number.</span><br />
<br />
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin; mso-highlight: yellow;">Don’t let Price Go Below</span></b><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;"></span></b><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;">This script
was set up so that certain users could not change the items unit price on an
order or an invoice below either a defined amount per item, or a certain
percentage of the retail price. (these fields can be changed to meet the
clients request)<span style="mso-spacerun: yes;"> </span>If a price was entered
that did not meet the criteria, the price would automatically change back to
the previous price, or to the system price.</span><br />
<br />
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin; mso-highlight: yellow;">Open Google Maps from a specified address in the System</span></b><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-size: 12.0pt; mso-hansi-theme-font: minor-latin;"></span></b><br />
<div class="MsoNormal">
<span style="font-size: 10.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">This script simply is a button that launches Google Maps from
a given address so directions can be printed.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="background: yellow; font-size: 10.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt; mso-highlight: yellow;">Create Production Entry in Bill of Material from
Receipt of Goods</span></b><b style="mso-bidi-font-weight: normal;"><span style="font-size: 10.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"></span></b></div>
<div class="MsoNormal">
<span style="font-size: 10.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Although this could be done from other modules as well, this
script would automatically create a production entry for a specified bill when
a certain item was received.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
MnMSolutionsInc.comhttp://www.blogger.com/profile/01507874827357643289noreply@blogger.com0tag:blogger.com,1999:blog-7700251806838819692.post-56543120890381623752012-11-20T10:37:00.004-08:002012-11-20T10:41:34.511-08:00<div class="MsoNormal">
<h2>
<span style="font-family: Arial,Helvetica,sans-serif;">Are you spending a lot of time running reports?</span></h2>
</div>
<div class="MsoNormal">
<h2>
<span style="font-family: Arial,Helvetica,sans-serif;">Save yourself time, automate your Crystal Reports?</span></h2>
<br /></div>
<div class="MsoNormal">
<span style="font-family: Arial,Helvetica,sans-serif;">Many people have reports that they run monthly, weekly, even
daily.<span style="mso-spacerun: yes;"> </span>Wouldn’t it be nice to just come
into the office and have that report that you run daily just sitting in your
inbox, or sitting in a designated directory on your server for all users to
access.<span style="mso-spacerun: yes;"> </span>Maybe it is a report that you
run once a month, by setting that report to run on the same day and time every
month, you will not have to remember to do so.<span style="mso-spacerun: yes;">
</span>If it is a report that takes several minutes to run, having the report
run and send to you will free up some of you very valuable time.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial,Helvetica,sans-serif;">Crystal Reports automation allows you to run required reports
at defined intervals and export them in a number of formats.<span style="mso-spacerun: yes;"> </span>You can have the reports pushed out to a
directory of your choice in either excel, PDF, or another format, or you can
have the exported report emailed to any number of email addresses.<span style="mso-spacerun: yes;"> </span>You can even encrypt the files for an added
layer of security.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial,Helvetica,sans-serif;">If you want more information with Crystal Reports writing
and/or automation or reporting, give Mike at M&M Solutions a call today.</span></div>
<div class="MsoNormal">
<br /></div>
MnMSolutionsInc.comhttp://www.blogger.com/profile/01507874827357643289noreply@blogger.com0tag:blogger.com,1999:blog-7700251806838819692.post-43587036816892450982012-10-04T10:23:00.001-07:002012-10-04T10:43:49.800-07:00<h2>
<b>Are you maintaining data outside of your system for reporting? Stop wasting your time!</b></h2>
<br />
I come across a lot of people whom for some reason or another are taking information out of Sage 100 (formerly MAS 90 and MAS 200) and manipulating it, either in excel or access, to come up with reports or tables that they need to do their job. Sometimes these processes can take hours to complete.<br />
<br />
How much time are you spending outside of Sage 100 to get information that you need?<br />
<br />
One thing I tell all my clients is,<br />
“If the data is in the system, I can write a report to get the data out in a format you need to see it in. If the data is not in the system, let’s work on getting it in there in a way that will work for you.”<br />
<br />
What this means is that a report that takes you, lets use a small number, ½ an hour a day to maintain and run outside of the system, can be set up to run at the press of a button. You might be thinking that ½ hour a day is not worth the money to set up a report or add fields, but your time is valuable. That short ½ hour a day is equal to 2.5 hours a week, 10 hours a month, 130 hours a year. That ½ hour spent to maintain that report outside of the system is taking up over 16 full work days a year of your time!<br />
<br />
How much is your time worth?<br />
<br />
Sage 100 has built in, often underutilized tools, that help the user get data into their system for reporting. Custom Office allows users to tailor their systems to meet their specific needs.<br />
<br />
<ul>
<li> Add user defined fields to desired tables</li>
<li>Add created fields to various data entry screens </li>
<li>Create User Defined Tables to store data for lookup and reporting purposes </li>
<li>Create scripts to further customize how the data interacts with your system</li>
</ul>
A typical example is a client that wants to track a certain piece of information for a customer or an item. A user defined field can be added to the respective maintenance screen (Customer or Inventory). Lets use inventory in this example; a client wants to track a non-standard item type and have a lookup table that contains all selectable types. This can be done with user defined fields and tables. Custom office then allows for the flow of the custom data to be determined. What this means is that you can create additional user defined fields that allow the data entered to flow through the system all the way through to history. The “Type” user defined field that you entered at the item level can then be used at the data entry level (sales order, invoice, purchase order, receipt, etc.) and then on to history. This gives the user complete control over reporting data at all point in their process. Now with the data in history, a user can add the created field to a report and utilize it just as if it was a standard field in the system.<br />
<br />
Give M&M Solutions, Inc a call today so that we can help free up some of your valuable time.
707.425.9923MnMSolutionsInc.comhttp://www.blogger.com/profile/01507874827357643289noreply@blogger.com0tag:blogger.com,1999:blog-7700251806838819692.post-25700793746373437442012-09-14T09:37:00.001-07:002012-09-14T09:37:14.698-07:00Hi,
<br>
<p>My name is Mike and I am one of the partners here at M&M Solutions, Inc.</p>
We specialize in Implementation, Training and Support of Sage 100 ERP<br>
      (Formerly Sage MAS 90, Sage MAS 200 and Sage MAS 200 SQL).</p>
We also work with;
<ul>
<li>  Crystal Report Writing and Automation</li>
<li>  Custom Scripting</li>
<li>  Sage CRM</li>
<li>  Qqest TimeForce Time Clocks</li>
<li>  Various Accounting Services</li>
</ul>
<p>For more than 10 years, M&M Solutions, Inc. has worked to provide
our clients with top tier personal support. We have both the accounting
and technical background to get you the help that you need. We work hard
to get our clients as streamlined as possible, while at the same time
strive to build relationships with them so that they are clients for life.</p>
<p>Please check back weekly for different write ups and comments. My goal with this Blog is to share information with you while at the same time use this blog as a historical database of tips, help, questions, answers, and documentation that can be referred to at any time.<br>
<p>I will post your questions to me and their answers directly to this blog so that everyone can share in the learning process. So please, send my your questions or comment on my post, and I will do my best to address them.</p>
-Mike McNelisMnMSolutionsInc.comhttp://www.blogger.com/profile/01507874827357643289noreply@blogger.com0