wintergreenPrivatePrivate (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 SpurrPrivatePrivate (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.
|
|
|
|
wintergreenPrivatePrivate (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 SpurrPrivatePrivate (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.
|
|
|
|
wintergreenPrivatePrivate (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!
|
|
|
|
wintergreenPrivatePrivate (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 SpurrPrivatePrivate (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 HollandPrivatePrivate (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
|
|
|
|
wintergreenPrivatePrivate (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.
|
|
|
|
wintergreenPrivatePrivate (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)..
|
|
|
|
JonAPrivatePrivate (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 collinsweb 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 VSr Supply Chain System Analyst South Broward Hospital District  (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.
|
|
|
|