upload RQ10

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.

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!

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.

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!

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...

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.

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

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.

so, is it the best way to do the upload? I am exploring any possibility, like process flow, or RQ500 (CSV interface)..

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.

For us, we wrote vbscript routines to push the data into RQ10. (header and lines)

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.