Hi Nitesh, Import function like the one you are doing should be done when we need to import data in the tables which usually dont need any other functions to run (Like BOM tables). When you want to create the Sales order from the excel data then it is better if you just import some of the standard data Like Customer Id, Currency, ItemId, Qty , price etc (may be from .csv file) and then you should write the functions, as the data is imported, to create the Sales order (table and lines). you should write a class and in this 1. import the data 2. check if the data is correct or not. If the data is correct then 3. write the function to create the sales order 4. write the function to create the sales line (check on the salesTable form /datasource:salesLine ,how the salesline is created).
i had emailed this solution at the other yahoo group , development-axapta but dont know why it hasn't been sent yet. cheers, Girish --- Krishnendu Roy <[EMAIL PROTECTED]> wrote: > Hi Nitesh > Easy way to do it. > 1. Convert it to csv file. > 2. Open Administrator>Periodic>Data > Export/Import>Definition Group > 3. Create a new custom type Defn. Group > 4. Select Table name, specify Path name > 5. Select Field Setup, specify the field no > 6. Run import > Hope it will help you. > Rgds > Krishnendu > > Nitesh <[EMAIL PROTECTED]> wrote: > Hi all, > How can i import data from excel for > transaction of sales order form.i e want to enter > the data through excel and want to put it in sales > order form for invoicing.Is it possible??? :-( > Regards > Nitesh > > > Sharing the knowledge on Axapta. > > > Yahoo! Groups SponsorADVERTISEMENT > > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/Axapta-Knowledge-Village/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > > --------------------------------- > Do you Yahoo!? > Read only the mail you want - Yahoo! Mail SpamGuard. ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
