Hi Naveen - received your message. I believe you are very close! :)
You are correct that you will need the basic fields like material, qty, UOM , price and acct assignment.
What I noticed in your screen shot is:
- You used X for item number in the ITEMX table, but in fact, you have to pass up the actual line item number in the "X" table. I just mapped them to the same column in Excel.
- Also, you can edit/delete the loops, so that both ITEM and ITEMX are in the same loop. It makes it simpler with one loop.
Here's a screen shot of mine:
Hope this is the last bit and it works for you!
Best Regards,
Sigrid
------------------------------
Sigrid Kok
pse | Winshuttle North America
------------------------------