Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 751 views

    Configuring Your RedPrairie WMS System - A Time Saver Trick

    Uploaded by

    Christian RN
    The document discusses using Excel to efficiently configure replenishment release rules in a RedPrairie warehouse management system (WMS). It describes a process of: 1) Creating a sample release rule configuration in RedPrairie to generate a script. 2) Importing the script into Excel and setting up dynamic columns to reference source and destination areas. 3) Having operations staff fill out the spreadsheet, which generates scripts to load all configurations in one operation into RedPrairie. This significantly reduces setup time compared to configuring each rule individually.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Configuring Your RedPrairie WMS System - A Time Saver Trick

    Uploaded by

    Christian RN
    751 views9 pages
    The document discusses using Excel to efficiently configure replenishment release rules in a RedPrairie warehouse management system (WMS). It describes a process of: 1) Creating a sample release rule configuration in RedPrairie to generate a script. 2) Importing the script into Excel and setting up dynamic columns to reference source and destination areas. 3) Having operations staff fill out the spreadsheet, which generates scripts to load all configurations in one operation into RedPrairie. This significantly reduces setup time compared to configuring each rule individually.

    Original Description:

    Configuring Your RedPrairie WMS System_ A Time Saver Trick

    Original Title

    Configuring Your RedPrairie WMS System_ A Time Saver Trick

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses using Excel to efficiently configure replenishment release rules in a RedPrairie warehouse management system (WMS). It describes a process of: 1) Creating a sample release rule configuration in RedPrairie to generate a script. 2) Importing the script into Excel and setting up dynamic columns to reference source and destination areas. 3) Having operations staff fill out the spreadsheet, which generates scripts to load all configurations in one operation into RedPrairie. This significantly reduces setup time compared to configuring each rule individually.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    751 views9 pages

    Configuring Your RedPrairie WMS System - A Time Saver Trick

    Uploaded by

    Christian RN
    The document discusses using Excel to efficiently configure replenishment release rules in a RedPrairie warehouse management system (WMS). It describes a process of: 1) Creating a sample release rule configuration in RedPrairie to generate a script. 2) Importing the script into Excel and setting up dynamic columns to reference source and destination areas. 3) Having operations staff fill out the spreadsheet, which generates scripts to load all configurations in one operation into RedPrairie. This significantly reduces setup time compared to configuring each rule individually.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 9

    HOME READ OUR BLOG NEWSROOM FRANÇAIS

    Warehouse Management Insiders

    Con guring Your RedPrairie WMS System: A Time Saver Trick


    Posted by Abdullah Alkeilani on Mon, August 12, 2013 @ 01:44 PM

    Tweet Share 129 Like 4 Share 4

    I’m sure this scenario will sound familiar. I have seen many delighted customer faces as our professional trainer
    walks their IT and Super Users through con guration screens in a setup workshop training. They are happy because
    for the rst time outside of the sales pitches, they actually have hands-on demo in setting up samples of areas,
    locations, footprints, etc. They suddenly realize how robust and easy to con gure RedPrairie’s WMS solutions are.
    That happiness, however, is short lived for many of them. As soon as they transition into the construction phase of
    the project, their faces become pale and severely long.  They soon realize they have to deal with hundreds of
    con gurations. The exercise of setting up areas policies for replenishment, which they well recall took ten minutes
    in the workshop, is now taking days to complete due to the scale of the entries.
    This is where experienced consultants with tens of implementations under their belts come into play. They bring in
    tools, processes and tips that can signi cantly increase customers’ setup productivity and reduce their costs. I'll just
    share with you one simple method that we have seen work time and again.
    Suppose you’re working on the task of con guring the Replenishments “Release Rules” of your areas, which
    basically involves going through the Area Maintenance, clicking on Modify Policies and going through the wizard.
    For customers with a large facility, this can be a cumbersome task as there can be hundreds of combinations
    involving Source Area, Destination Area, Work Type and picking the unit of measure.  I’ll demonstrate how Excel
    can help you here. At a high level we’ll be entering the data in a spreadsheet which will automatically provide us
    with commands we can later copy, paste and execute in one shot inside RedPrairie, and that will complete our task.

    1. In RedPrairie DLlx client, enable tracing and follow the standard procedure of setting Release Rule for a
    single area. Limit this to one entry. For example, de ne a directed work for Emergency Replenishment going
    from a Source Area called BULK to a destination pickface area called SCPM to move Pallets.
    2. Disable and view the trace le.
    3. Look for the high level command. If you’re not a trace reader, don’t sweat it. Look for “[0] Server got” and keep
    going through the matches until you nd your command (it will be obvious). In our case, it is “create area
    release rule policy ….”
    4. You’ll need to copy the entire command with its arguments. 
    Congratulations! You just completed the hardest part. The rest will be in Excel.
    (Download the excel template here)
    5. Fire up Excel and create columns for your dynamic data that will change from one entry to another. You can
    cheat by looking at the command you just got from the trace. In our scenario, this will be Source Area,
    Destination Area, and Load Level. The rest of arguments such action, priority code, offset, etc. are the same
    from one area to another in our facility.
    6. Add another column for your script. This will hold the command in which its dynamic parameters will be fed
    from the other columns. This is an example of what you type in:
      ="create area release rule policy where wh_id = 'WMD1' and wrktyp = 'E' and srcare = '"&A66&"' and dstare =
    '"&B66&"' and lodlvl = '"&C66&"'and action = 'CREATE WORK' and arguments = 'dstloc_wrkzon,srcloc_stoloc' and
    oprcod = 'EMRPL' and baspri = '10' and offset = '10';"
    7. Notice the ampersand referencing the excel cell position that holds the data (ex., srcare = '"&A66&"'). This
    essentially means the srcare will be whatever is stored in column A, row 66. Also notice the semicolon at the
    end (I’ll explain it later).
    8. You may copy the Excel formula above to all subsequent rows by dragging the selection.
    9. Work with your Operations team to ll in the spreadsheet.
    10. That's it! When it’s done, you basically have all the commands you need generated dynamically based on
    lling in the source, destination and load level. You’ll select ALL the rows under the Script column, copy it,
    paste it into Server Command Operations in Dlx (or use LextEdit or winmsql) and execute it. The semicolon
    between each row enables executing all these commands in one shot.  

    The screenshots below illustrate what my spreadsheet looked like at the end and how I loaded it in the system.
     
     
    In conclusion, the cost of initial setup time, which involves tracing and setting up the Excel sheet, is independent of
    the data scale. It enables your operation teams to ll in the spreadsheet without any technical assistance in a very
    fast and ef cient manner. Your technical resource can then load it into the system in a single shot, also independent
    of the data scale. This method can be used in any application where mass data needs to be loaded into the system.
    For those familiar with Mload utility, this is based on the same principle.  It provides an alternative quick and dirty
    method and an extra level of exibility, such as having full control of selection of which data (rows) are to be loaded
    or loaded rst.
    Download the RedPrairie WMS Replenishments Excel template here

    Tags: RedPrairie System Con guration, RedPrairie Tricks, RedPrairie WMS, JDA WMS, RedPrairie WMS
    Replenishments

    jake
    1/23/2014, 1:06:52 AM
    Red Prairie Online Training 
    Call Us +919000444287 
    Introduction to Red Prairie 
     
    Functional 
    Technical 
     
    Functional: 
     
    Inbound Cycle 
    Outbound Cycle 
    Work Orders and Packing Process 
     
    Inbound Cycle: 
     
    Con guring receiving policies from RP user friendly maintenance screens 
    Con guring receiving data from screens 
    Performing receiving operations from screens 
     
    Con guring receiving policies from RP user friendly maintenance screens
    Reply to jake
    Harsh
    2/11/2014, 5:58:26 PM
    I would like to get training on Redprarie WMS. Please let me know if there is any online
    training available.
    Reply to Harsh

    Rufutech Systems Pvt. Ltd


    2/25/2014, 11:59:43 PM
    Our expertise is in developing RFID and NFC applications for global customers.  
     
    About Us 
     
    We are a pure play RFID and NFC Company organized under Indian laws (Pvt. Ltd
    Company equivalent to C Corporation) headquartered in Coimbatore, India.,a leading
    software solutions provider with strong capabilities in data capture technologies including
    RFID, NFC, Barcode and expertise in developing software applications for asset tracking,
    inventory control, supply chain, warehouse management system, access control, loyalty
    cards among others. 
     
    Our core competences being in the RFID/NFC domain, RufuTech offers end-to-end project
    lifecycle management services [Device Integration-> Data Integration-> Work ow
    Integration-> Presentation and Management and Backend Integration] 
     
    Our engagement models are very exible to suit unique project requirements of the client,
    right from hiring offshore talent pool on T&M; basis (onsite/offsite/offshore) or opt for a
    dedicated team to work on turnkey project as an extended arm, ofcourse realizing off-
    shored cost-bene ts. 
     
     
    Over the past few years we have worked with RFID, NFC and barcode solution providers
    for their middleware , device control and application development and have successfully
    created meaningful decision support systems that RFID/NFC technology promises to
    deliver in a cost-effective manner. 
     
    Our team has a rich experience in developing NFC applications including mobile marketing
    applications like loyalty, couponing and social media or business productivity & security
    applications including asset control, authentication, POS, brand protection, ticketing, data
    exchange etc. Our lab is fully equipped with NFC powered phones, tablets as well as
    standalone NFC devices. We closely follow industry trends and support your NFC
    initiative at very competitive rates 
     
    Please get in touch with us with your requirements or queries if any, we would be more
    than glad to explore a working relationship. 
     
    Note : We also offer NFC training course in india. NFC skillcamp
    (http://rufutech.com/academy/nfc-skill-camp/)  
     
     
     
    Best Regards, 
     
    Raj 
    Sr. Business Development Manager 
    Global RFID & NFC Software Outsourcing Services 
     
    RufuTech Systems Pvt. Ltd 
    Tel : (INDIA) 91-9891404464 
    US + 1 (408) 689 2470 
    Email : raj@rufutech.com 
    Website : www.rufutech.com 
    Skype : rufutech-raj 
    Reply to Rufutech Systems Pvt. Ltd

    Sangita
    11/11/2014, 1:38:21 AM
    MaxMunus Provides RedPrairie Functional/ Technical online Training.If anyone interested
    contact- +91 9738075708 or mail at- sangita@maxmunus.com.
    Reply to Sangita
    golfspecalor1978
    8/26/2015, 6:53:09 AM
    About the amazing easier. A digital textbook series, built from scratch for today's learners
    and current standards, engages students with dynamic, multimodal nice post, we're
    sharing voices from our schools and the agency. What if you could work hard, get paid, and
    love every minute of it amazing competing effectively for admission to business, law, or
    graduate school. Thank you for subscribing to the we newsletter! Englishessaywriter &
    advanced search for nearly 1,800 schools, and search for your perfect t. Essay schools
    received gold, silver or bronze medals. 
    Lnk
    Reply to golfspecalor1978

    First Name*

    Last Name

    Email*

    Website

    Comment*

    Subscribe to follow­up comments for this post

    Type the text
    Privacy & Terms
    Submit Comment

    Subscribe via E-mail


    Your email:

    Subscribe

    Follow Me

    Blogroll
    Supply Chain Nation

    Supply Chain Shaman

    Supply Chain Matters

    Supply Chain Digital

    Supply Chain Network

    Logistics Viewpoint

    Think Tank

    About Longbow

    Home
    About Longbow

    You might also like