I tried to create 'Blanket Sales order' using one dataport from csv file. In csv file suppose: have 8 mandatory column in one row, 3 from sales header and remaining 5 from sales line.
How will i linked each other so that data will import from single row that is from two different table? or, can be exported the all 8 column in single row?
I created sales line as dataitem and created global variable for 'document type', 'No.' and 'Sell to customer No.' of sales header field and assign it in sales Line onBeforeExport trigger. after that thinking to add the SH variable in Sales line dataport fields manually including Sales line field. then try to export.
Still not getting as expect. Working on that.
Please advice/guide, whether i am on correct path or should be some different.
Any specific reason for CSV, Why not excel?
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
Thanks for your valuable response.
First, if i am trying with single dataport with field validation importation, then also its not good to import directly in base table SH,SL?
If not then ,suppose i imported the csv file in any staging/intermediate table. so what will be the 3 steps to proceed?
Second, If i am importing from excel then what will the short procedure?
Thanks alot for your guide..
I am stucking still on above. please guide me.