Your QAD Doctor Specialist.

  • Increase font size
  • Default font size
  • Decrease font size
Home Products Copy & Paste Create Item Master, BOM & Route From Excel

Create Item Master, BOM & Route From Excel

E-mail Print PDF

Item Master, BOM & Route Toolkit

 

Current QAD 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 not that "friendly" to non-daily QAD users like the engineer, entering incorrect information.
  • Everyone know the limitation of QAD whereby the ABC Class setup by site, Wrong Taxable flag, Purchase/Manufacturing flag will create problems in your daily operations.
  • How about BULK update to a certain group of supplier Purchasing Lead Time, Buyer/Planner code and MRP Order Policy? How do you do all these without typing one by one?
  • Audit Trial for Item Master, Product Structure and Routing has always been a problem for MFG/PRO eB2 and below. Someone has change the Purchase Flag without informing finance and production creating bad planning and wrong costs!!

The Solution

  • Add-on (non-invasive) customization to employing the propriety ERP Consulting LLP concept of "Copy & Paste" from the Excel right into QAD!!!
  • The following steps are how it is done
    • Step 1-You enter the necessary detail in a predefined Excel format. You can use any common Excel formula as usual, no restrictions
    • Step 2-You simply "Copy" from the Excel column
    • Step 3-You go to a QAD screen and paste the values into the screen directly!!!
  • The program in QAD will perform the necessary CIM loading (to ensure QAD logic is utilized) after a very extensive checking and validation.
  • We can configure according to your company rules on how the program can do the validations. For example,
    • item master coding rules
    • Purchasing LT from overseas is at least 3 weeks
    • MRP Order Policy for FG items is always LFL
  • This package can do the following "Copy & Paste"
    • New Item Master using (1.4.1) + (1.4.5) + (1.4.7) or (1.4.17) + (1.4.9)
    • New Product Structure using (13.5)
    • New Routing using (14.13.1)
  • Data Accuracy will be enhanced because strict validations will be in place before data can be loaded.
  • THIS PROGRAM is not a typical CIM loading via file transfer like FTP. It interface directly from your Excel "Copy" into QAD directly! We are using a special propriety concept.
  • Estimated saving by Return-of-investment (ROI) will be less than 2-3 months after implementations.

Screen Example

Item Master Loading Screen

Actual Screen Interface

 

Newsflash

 

TailorPro Leads the Way in Providing Non-Invasive Customizations!

We are very pleased to announce further industry validation of the Non-Invasive Customization paradigm that ProStar first introduced to the QAD and Progress market. ProStar is now in our tenth year providing TailorPro and our other tools. The fact that others are following our lead confirms the power of our approach.

Well, that shouldn’t be a surprise, given that we introduced TailorPro in 1999 and that our development paradigm and tools have been used worldwide with resounding success adapting QAD and other Progress applications to meet customers’ unique business needs.