Friday, June 19, 2009

UPS WorldShip® Shipping Link for MAS90/200

Shipping Link eliminates the cumbersome double data entry between MAS90/200 and UPS WorldShip®. This ‘bolt on’ software interface eliminates the need for duplicate data entry, passes pertinent data seamlessly between the two programs, provides for instant access to tracking data at the click of a button, and allows users to ship multiple Sales Orders in the same package.

The interface is intended to save time, save money, eliminate data entry errors and streamline the shipping process by:

• Cutting data entry time in half
• Cutting customer tracking number time in half
• Automatically calculating pre-determined shipping zone costs based on weight and shipping method
• Automatically capturing and writing UPS tracking numbers back to MAS90/200
• Shipping multiple Sales Orders in the same package or packages (up to 20 per shipment)
• Allowing users with Web access real time tracking from within MAS90/200
• Making data accessible to Crystal Reports for Forms and Reports

All pertinent Sales Order shipping data is automatically imported into UPS WorldShip® when the Sales Order number is entered. After packages are shipped, all shipping information, like weight and freight, is automatically imported back into MAS90/200 for invoicing. Users can display all the UPS package reference numbers associated with any order or invoice.

• Integrates MAS90/200 Sales Order with UPS WorldShip® & shipping software
• Ships multiple Sales Orders in the same package or packages
• Integrates with S/O Entry, S/O Shipping Data Entry and S/O Invoice Data Entry
• Displays tracking information instantly
• Simplifies entry of freight charges during invoicing

All S/O Data Entry information, such as customer number, shipping address, desired shipping method (e.g. Next Day Air), is instantaneously exported for use in UPS WorldShip® when the Accept button is pressed.

All pertinent UPS WorldShip® information, such as actual shipping method, freight charges, miscellaneous charges and package weight, is returned automatically to MAS90/200 and is available in real time with no additional import or other action necessary by the user.

Wednesday, April 29, 2009

Lean Execution for Sage MAS90/200

:: InSync Technologies LLC:: Sage MAS 90/200 Enterprise Software
Lean Execution™ for MAS 90/200

Utilizing core Sage MAS 90/200 Enterprise Software along with Lean Execution™ methodology will empower any enterprise to create a “paperless and information rich environment,” and gain immediate benefits such as:
Reduction of enterprise cycle times
Reduction of order lead time
Reduction of indirect labor costs
Reduction of direct labor costs
Reduction of data entry time
Reduction or elimination of paperwork
Reduction of work in process (WIP) inventory
Increase in equipment utilization
Implementing Lean Execution™ techniques enables critical information to flow throughout the organization—including the often-forgotten areas of distribution and manufacturing. This requires that the information is within the control of those who actually produce your goods or services. “Paperless and information rich environments” have been created for a few forward-thinking enterprises, producing dramatic gains throughout their entire organizations. Now you will learn how the same results are possible for your enterprise.
A Lean Execution™ Implementation may employ some of all of the following techniques:
THEORY OF CONSTRAINTS
LEAN THINKING
JUST IN TIME
FLEXIBLE MANUFACTURING SYSTEM
ADVANCED PLANNING & SCHEDULING
TOTAL QUALITY
SIX SIGMA
DEMAND FLOW TECHNIQUES
Our consultants understand the complexities of Modern Enterprises and will follow each possible method through the Planning, Organizing, Scheduling, Directing and Controlling of each implementation. We will assure the most beneficial outcome is achieved in each and every implementation.

White Paper ABC Analysis and Purchasing Automation

White Paper:
Automated Purchase Order Generation
with use of ABC Category Coding in MAS90/200
By Olias Lynch
InSync Technologies, LLC
January 2009



Introduction
Automated Purchase Order Generation with the use of ABC Category Coding has proven time and time again to save the end user time, mistakes, over ordering, under ordering and the business money. Automation of Purchase Orders will eliminate the headache of the purchaser and correctly replenish Inventory according to the ABC Analysis with a just in time functionality.
Headline
The use of ABC Analysis tied directly to Automated Purchase Order Generation is becoming more and more popular and has become an extremely useful tool for many manufacturing companies worldwide. Recent studies with our clients have proven that time, management, and money have drastically improved with the implementation of this newly recognized and credible procedure.
The companies that have implemented Automation combined with the ABC Category Coding have been positioned to benefit from this and stay ahead of their competition so that Sales that are coming in are Shipping in a timely manner without the depletion of the Supply Chain.
ABC Analysis?
ABC analysis is a basic supply chain technique, often carried out by inventory controllers/materials managers, and is the starting point in inventory control.
A system of categorization, with similarities to Pareto analysis, the method usually categorizes inventory into three bands with each band having a different management control associated. Although different criteria may be applied to each category the typical method of “scoring” an inventory item is that of annual consumption value of said item (qty consumed X cost of item) with the result then ranked and then scored (A, B or C).
Bandings may be specific to the industry but typically follow a 70%, 90%, 100% banding in that A class items represent 70% of the value, B class items fall between 70% and 90% of the annual value with C class the remaining. In practical terms the complex high cost materials typically fall into the A class items, with the consumable, low cost (and typically fast moving) classed as C class.
Not all stock is equally valuable and therefore doesn’t require the same management focus. The results of the ABC analysis provide information that helps evaluate how each inventory part should be monitored and controlled.
These controls are typically:
A class items which are critically important and require close monitoring and tight control – while this may account for large value these will typically comprise a small percentage of the overall inventory count.
B class are of lower criticality requiring standard controls and periodic reviews of usage.
C class require the least controls, are sometimes issues as “free stock” or forward holding.
In summary, ABC Analysis is the basis for material management processes and helps define how stock is managed. It can form the basis of various activity including leading plans on alternative stocking arrangements (consignment stock), reorder calculations and can help determine at what intervals inventory checks are carried out (for example A class items may be required to be checked more frequently than c class stores.

Automation of Purchase Orders?
Automatic Reorder Selection is used to generate purchase orders for items that have an on-hand quantity at or below the reorder point specified in the Inventory master file.
Every time you order goods from your vendors, contracts to buy and contracts to sell are created. The Purchase Order module for Sage MAS 90/200 ERP systems helps you keep accurate records of these very important transactions. With every order, you need to specify (and keep track of) shipping method, date required, and the name of the person with whom the order was placed. In addition, you need to confirm the quantities ordered and price per item. This module streamlines and organizes the entire purchasing process.
When your on-hand quantity falls below a specified minimum level, purchase orders can be automatically generated to ensure that you never run out of key items. You can process partial receipts, update your inventory records when goods are received, and monitor cost variances between goods received and goods invoiced.
When this module is integrated with the ABC Analysis, Accounts Payable, Inventory Management, and Sales Order modules, you will have a comprehensive, fully integrated purchasing system. Receipt of goods will automatically adjust inventory quantities and produce a Back Order Fill Report. Furthermore, invoices received will automatically update Accounts Payable records. With the implementation of the Purchase Order module, you will be able to make more informed purchasing decisions, and all of your purchasing and receiving information will be readily available as needed.



Key Findings

· ABC Analysis has proven to reduce time spent on analyzing what needs to be ordered and in the quantity needed.
· Auto Generated Purchase Orders have proven to drastically eliminate Purchasing errors due to fat fingers, bad eyesight, or not enough of the right information syndrome.
· Combining ABC Analysis with the Auto Generation of Purchase Orders will indefinitely save the Employees mistakes, the Company money, and produce time for Employees to focus their attention in other areas of their job functions that need to be addressed.
· Customers will be extremely satisfied with the new level of service from your Company due to having key Inventory in stock, and Shipping these items to them on time.
· Stock items that are low in demand will not need to be ordered constantly and stock items that are in high demand will be readily available as buying trends change from your customers.



Conslusion
A common thread throughout this white paper is the ease of use and time well saved, while money is definitely well spent on product that is well needed just in time. The headaches and confusion of creating Purchase Orders shall be completely taken out of the equation and Automatically generated through a thoroughly thought out system that integrates the ABC Analysis to the end user. Mistakes and “out of stock” items will wither away while the Sales are Shipping smoothly and making it to your customers on time.

Bio on Olias Lynch

Olias E Lynch is one of the founders and the Vice President of InSync Technologies, LLC. InSync Technologies is focused on ERP integration consulting and has partnered with Oracle, Microsoft, Princeton Softech, iQ4Bis & Sage Software. The team of highly qualified consultants that Olias and his partner’s have assembled currently focus on both the business and the technical infrastructure components of computer systems management.Olias began his career February of 2006 in manufacturing & distribution and has remained dedicated to improving business processes in these two important business sectors. Additionally Olias has managed numerous implementations of Sage MAS ERP software and creation of Networks from the ground up.Sites included Street Furniture, Plastic Forming, Large Scale Printing, Hospitality Design and Development, and Audio Cables. Financial experience with Re-engineering Accounting Systems through Business Process Restructuring resulting in paper-less information flow and retrieval. Manufacturing Cost Accounting expertise in multi facility operations. Sales experience with Collaborative Groups of Sales Managers resulting in highly accurate Sales Projections utilizing state of the art Forecasting and BI tools. Sales and Operations Planning teams consisting of a diverse range of participants including executives, managers, line leads and shop floor planners. Distribution experience with large Multi-National and Multi-Level Supply Chain Distribution, Managing full Supply Chains from Internal Manufacturing, Purchasing, Traffic, Distribution, Re-Distribution and Sales.

Specialties

Specialties Managing Operations consisting of Project Manager on complex ERP Implementations and UpgradesMigration of Business Processes and DataLean Enterprise Implementation TechniquesLead the Industry in Lean Enterprise Intelligence SolutionsMulti-Product / Multi-Discipline manufacturing & Distribution, Lean & Theory Of Constraints Multi-site Relocations, Process Flow Re-engineering, Factory Automation Applications.

Experience

Vice President and Owner
InSync Technologies, LLC
Information Technology and Services industry
February 2006 – Present (3 years 3 months)
Lean Enterprise SolutionsLean Execution™ Implementing Lean Execution™ techniques enables critical information to flow throughout the organization—including the often-forgotten areas of distribution and manufacturing. We specialize in Oracle/JD Edwards and Sage MAS90 Implementations.Lean Enterprise Intelligence System™ Stop the insanity of your job and in the process de-mystify your enterprise system as it relates to the human beings that work for your company. Microsoft Dynamics CRM Microsoft Dynamics CRM is a customer relationship management (CRM) solution that provides the tools and capabilities needed to create and easily maintain a clear picture of customers, from first contact through to purchase and post-sales. Data Reporting and Management Information All of our customers utilize Crystal Reports and Crystal Enterprise from Business Objecst.

ERP Project Consultant
Tolar Manufacturing Company Inc.
Furniture industry
June 2007 – September 2008 (1 year 4 months)
ERP Consultant for Sage MAS90 software.Implementation and full upgrade of MAS system to current level. Customization of reporting tools using Crystal Reports v.10.Customization of for MAS modules to meet requirements for Tolar staff.

IT Manager
Gettys Worldwide
Privately Held; 51-200 employees; Design industry
September 2007 – March 2008 ( 7 months)
Managed all IT applications within the Irvine, CA office. Managed the Network infrastructure within the Irvine, CA office.

ERP Project Manager
Bolero Platics
Plastics industry
December 2006 – December 2007 (1 year 1 month)
Set up network and networking cable throughout the building. Built server room and rack for networking equipment.Implemented and set up network server and server software. Implemented Sage MAS90 ERP software from ground up. Created custom reporting tools with Crystal Reports v.10.

ERP Project Manager
AGE Nameplate
Printing industry
March 2006 – September 2007 (1 year 7 months)
Set up network and networking cable throughout the building.Built server room and rack for networking equipment. Implemented and set up network server and server software. Implemented Sage MAS90 ERP software from ground up. Created custom reporting tools with Crystal Reports v.10.