Re: [Axapta-Knowledge-Village] importing for invoice through Excel
Yeah. I agree with Girish. We also developed seperate classes/ validations for importing data espcially for invoices / Banking. Girish B <[EMAIL PROTECTED]> wrote: Hi Raj, the trainings are conducted by Microsoft itself orit might be outsourced to some other organisation. youcould find the training scedule from the partner site.good luck.cheers,Girish--- veeraraj govindasamy <[EMAIL PROTECTED]> wrote: -Hi GirishCan u let me know about the Training coursesconducted for the Axapta or where i can theinformation.ThanksRAJ--- Girish B <[EMAIL PROTECTED]> wrote:> 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> __Do you Yahoo!?Take Yahoo! Mail with you! Get it on your mobilephone.http://mobile.yahoo.com/maildemo Sharing the knowledge on Axapta.Yahoo! Groups Sponsor ADVERTISEMENT-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. ___ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.comSharing the knowledge on Axapta. Do you Yahoo!?vote.yahoo.com - Register online to vote today! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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.
Re: [Axapta-Knowledge-Village] importing for invoice through Excel
Hi Raj, the trainings are conducted by Microsoft itself or it might be outsourced to some other organisation. you could find the training scedule from the partner site. good luck. cheers, Girish --- veeraraj govindasamy <[EMAIL PROTECTED]> wrote: - Hi Girish Can u let me know about the Training courses conducted for the Axapta or where i can the information. Thanks RAJ --- Girish B <[EMAIL PROTECTED]> wrote: > 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 > __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT - 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. ___ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
Re: [Axapta-Knowledge-Village] importing for invoice through Excel
Hi Girish Can u let me know about the Training courses conducted for the Axapta or where i can the information. Thanks RAJ --- Girish B <[EMAIL PROTECTED]> wrote: > 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 > __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo 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/
Re: [Axapta-Knowledge-Village] importing for invoice through Excel
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/
Re: [Axapta-Knowledge-Village] importing for invoice through Excel
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 KrishnenduNitesh <[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 NiteshSharing the knowledge on Axapta. Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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.
[Axapta-Knowledge-Village] importing for invoice through Excel
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 Sponsor ADVERTISEMENT 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.
