About Lawrence Lim

This author has not yet filled in any details.
So far Lawrence Lim has created 12 blog entries.

QAD2SAP Data Migration Toolkits


Business Requirements To comply with your corporate global ERP standardization strategy, it is sometimes inevitable to migrate from your beloved ERP system to another ERP system. For examples: QAD to SAP QAD to Oracle QAD to Fourth Shift Excel to QAD Fourth Shift to QAD SAP to QAD Oracle to QAD Unfortunately, over the last 20 years, there is no simple "plug in" data conversion tools for any ERP system I have heard so far. Therefore, data migration is always considered the last priority in any system implementation, assuming the IT technical team can take care of it easily. [...]

QAD2SAP Data Migration Toolkits2020-03-26T00:10:41+08:00

Create Item Master, BOM & Route From Excel


Current Limitation Sometimes there is a need to perform BULK Item Master creation, either from the engineering PDM, inter-company product transfer or simply a new product launches. If you are in a manufacturing company where item master creation is a burden because of the number of items to be created in (1.4.1) or (1.4.3) + (1.4.5) + (1.4.7) + (1.4.9) is too time-consuming and tedious and error prone, you need alternative solutions to entering the data one by one. Once you have setup the Item Master, next you must create the Product Structure and Routing. These 2 screens are [...]

Create Item Master, BOM & Route From Excel2020-03-26T00:06:54+08:00

MRP2PO-Auto MRP Plan to Purchase Order Creation


Current QAD Limitation There are many companies that require to use discrete Purchase Order rather than EDI or using the QAD Supplier Schedule Order modules. Typically they want to control PO by price due to contract and supplier delivery performance using the Promise Date of the discrete Purchase Order. QAD MRP will calculate the correct requirements for components to be purchased. It has the function to approve planned Purchase Order to become Purchase Requisitions. Unfortunately the approval control for Purchase Requisition is part by part and not consolidated by supplier Purchase Order. Once Purchase Requisition is approved, end user [...]

MRP2PO-Auto MRP Plan to Purchase Order Creation2020-03-26T00:08:26+08:00

Work Instructions Templates


Protection for your Training Asset You have invested heavily in the QAD software and the training for your people. In most cases, you will expect your own staff to document down some kind of work procedures and instructions during or after the training. Guess what, you will get all sorts of reasons for things not being done, like "No time", already busy with work and implementation, cannot do more Don't know how to use Powerpoint or Word properly Don't know how to get started I started, but don't know what to write After implementing more than 100 sites over [...]

Work Instructions Templates2020-03-26T00:21:08+08:00

Customized MFG/PRO Training Template


Training Offering by QAD In the past a typical QAD training is going through the "trio" training of Product Training 1 (PT1) - Mostly Distribution Modules (SO/PO/IC) Product Training 2 (PT2) - Manufacturing Modules (MPS/MRP/BOM/Route/WO) Financial Management (FM) - AP/AR/GL Each of the training modules above takes about 5 days each, continuous. For most people, the first class in the first 3 hours, they have the most energy. They are all charged up and ready to learn the new system their company have purchased and assigned them to sit in through "prestige" training class conducted by someone who supposes [...]

Customized MFG/PRO Training Template2020-03-26T00:18:48+08:00

QAD System Rollout Templates


Repeatable & Consistent QAD system Rollout to multi sites Your CEO has requested you to rollout 8 Manufacturing sites across 4 countries in 12 months, each taking 2-3 months long. You are already having problem with the pilot site with the current consultants and users. Your job is on the line as you don't know which Project Manager is able to handle such a mammoth task. Who do you call? [Clue: Not Ghostbusters] The Solution ERP Consulting LLP has managed 4 large MNC clients who has the same request in the last 18 years. We can tell you it [...]

QAD System Rollout Templates2020-03-26T00:15:25+08:00

Project Management Template For your Organization


Get the facts right The failure rate of IT Projects can be alarming; per Gartner, approximately 74% of IT projects fail, are late, or go over budget. META GROUP REPORTS that a staggering 55 percent to 75 percent of all CRM projects fail to meet their objectives. On average, about 70 percent of all IT-related projects fail to meet their objectives, so CRM's failure rate -- along with the appalling 70-percent failure rate for ERP implementation projects and the shockingly high 70-percent failure rate experienced by those implementing SCM (supply-chain management) -- is about as distressing as a 70-percent [...]

Project Management Template For your Organization2020-03-26T00:12:45+08:00

Business Process Transformation


  Business Solutioning is a process where we define an real and existing business issues or problems, map and analyze them and provide workable solutions within QAD. Typically the big word "Business Process Re-engineering" comes into play here. But in many instances, we do not need to change so radically for a problem that can be easily fixed.     There are many instances in an ERP where it provide the basic functionality but did not concentrate on the productivity cycle.     For example: How do I speed up the Physical Counting process with the "Tag Count" data [...]

Business Process Transformation2020-03-19T12:57:53+08:00

Implementation Services


  Congratulation, you have just purchased the whole QAD suite. What is next? Do not under-estimate the task of implementation. It is your next highest cost related item in an ERP implementation other than the software. Success or failure in an implementation will determine if your crucial investment in an ERP solution will enhance or ruin your business. Any implementation that is not successful will cost you more than triple of your investment. You customer will scream at you for late shipment, your supplier was not paid on time and refuse to send you fresh materials resulting in production [...]

Implementation Services2020-03-19T12:57:53+08:00

Training Services


Optimize your QAD Investment by attending professional training conducted by a qualified trainer who is experience in the industry and QAD software. ERP Consulting LLP has developed modular based training materials and the focus is by business process and key users. Before we undertake any training, we would normally spend 3 days on understanding the company's entire business processes first. We will map out the training modules the company really need and discard those which are redundant. We will build the training materials with your company logo and recommended business processes. The training materials can later serve as the future [...]

Training Services2020-03-19T13:05:45+08:00
Go to Top