PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 9/9/2014 7:19 PM by  Kat V
upload RQ10
 12 Replies
 0 Subscribed to this topic
 77 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Author Messages
wintergreen
Private
Private
Veteran Member
(237 points)
Veteran Member
Posts:93


Send Message:

--
12/12/2011 7:04 PM
    Anyway knows how to upload the RQ10?  I have 2 excel files, one is the header for the RQ, another file is the lines' detail for each RQ.  How to do the upload if the lines have more than 5 items,  in fact,  we have 10 -50 lines for each RQ. Thank you for your help.
    Robert Spurr
    Private
    Private
    Veteran Member
    (344 points)
    Veteran Member
    Posts:130


    Send Message:

    --
    12/12/2011 9:27 PM
    You focus on the first line on the requisition and map line detail to that (Every line is mapped to the first line). Make sure to pass blanks for fields that would/could default. By default Lawson inquires first on the form, which populates all the fields, if you don't blank out or overwrite the value Lawson assume it should be included in the upload and this will cause all kinds of problems. Use a Line FC of A and a form action of Change. Lawson will added the line and assign the next available line number and when you inquire you will see your lines in the order they were loaded.
    wintergreen
    Private
    Private
    Veteran Member
    (237 points)
    Veteran Member
    Posts:93


    Send Message:

    --
    12/13/2011 1:47 PM
    Robert, thanks for your reply. But I don't understand what you said, could you give me an example?
    Did you mean I only map the first line for each RQ, how about the 2nd line to 50th line? How does it look like in the excel file?
    I really appreciate your help. Thank you!
    Robert Spurr
    Private
    Private
    Veteran Member
    (344 points)
    Veteran Member
    Posts:130


    Send Message:

    --
    12/13/2011 2:17 PM
    You map ever line to the first line. Think of this way. You go to RQ10 and begin adding lines manually. You add the first line and perform the form action and now the line exist. You go to the FC of the first line and clear the data (Crtl-Shift-K) and enter data for the second line and perform the form update and when you inquire both lines know exist. In the upload wizard you should see something like LINE-FC1 through LINE-FC5. Always map to the field ending in 1 which is the first line. This is how you add multiple lines to a document.
    wintergreen
    Private
    Private
    Veteran Member
    (237 points)
    Veteran Member
    Posts:93


    Send Message:

    --
    12/13/2011 2:46 PM
    Robert, if I map to the first line, then what the 2nd line in the excel looks like? Do I just skip those fileds that are RQ header information? The RQ header has been added in the first line... thanks!
    wintergreen
    Private
    Private
    Veteran Member
    (237 points)
    Veteran Member
    Posts:93


    Send Message:

    --
    12/13/2011 2:55 PM
    Robert, the RQ number is system automatically assigned, when I upload the RQ10, can I upload the RQ header and lines at the same time? or I need to upload RQ header first, then lines? If I upload at the same time, my question is in the above statement. If I upload separately, then how do I know the RQ number for lines? There must a key to link the RQ header and lines...
    Robert Spurr
    Private
    Private
    Veteran Member
    (344 points)
    Veteran Member
    Posts:130


    Send Message:

    --
    12/13/2011 3:09 PM
    If you are using addins to upload you need to create/upload the headers first and you will need to populate the requisition number into the lines spreadsheet to upload. There is no way I know of to do headers and lines on the same load.
    Rick Holland
    Private
    Private
    Basic Member
    (44 points)
    Basic Member
    Posts:16


    Send Message:

    --
    12/13/2011 3:10 PM

    I attached my excel sheet for RQ10 line upload and a screen print of the mappings for Lawson Upload in addins. The is the first time I have posted with attachments let me know if it does not work. 

    Thanks,

    Rick

    Attachments
    wintergreen
    Private
    Private
    Veteran Member
    (237 points)
    Veteran Member
    Posts:93


    Send Message:

    --
    12/13/2011 3:47 PM
    Thank you both of you. I just wondering if we can upload header and lines at the same time. If I upload separately, it is half manually - populate the RQ number and manually map the RQ number to the lines in the excel.
    wintergreen
    Private
    Private
    Veteran Member
    (237 points)
    Veteran Member
    Posts:93


    Send Message:

    --
    12/13/2011 3:49 PM
    so, is it the best way to do the upload? I am exploring any possibility, like process flow, or RQ500 (CSV interface)..
    JonA
    Private
    Private
    Veteran Member
    (3473 points)
    Veteran Member
    Posts:1155


    Send Message:

    --
    1/6/2012 7:53 PM
    It would depend on how many requisitions you need to add to Lawson with this process and how often it needs to be done. What is the upload for? On the Addins upload if you don't upload the req header info first and reference the req number in the req line upload you will end up with one single line req for each line you upload. If you have 50 lines, you will get 50 reqs.
    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MidMichigan Health
    darwin collins
    web manager
    dallas area rapid transit
    (49 points)
    Posts:19


    Send Message:

    --
    9/9/2014 6:46 PM
    For us, we wrote vbscript routines to push the data into RQ10. (header and lines)

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2972 points)
    Veteran Member
    Posts:1016


    Send Message:

    --
    9/9/2014 7:19 PM
    We upload Hurricane orders to RQ10. I use RQ140 to find the req headers then use a vlookup to put them on the line upload. Still manual, but only copy/past from the RQ140 report once.
    You are not authorized to post a reply.