Hi Tushar, This can be done easily , withinn Axapta only. Write a utility ( class ) , that will access the Excel data and will import that to the AxaptaTables ( sales order related) using the correct classes .
Once the Salesorder created its very simple to invoice them . here is the code for invoicing SalesFormLetter_Invoice salesFormLetter = salesFormLetter::construct(DocumentStatus::Invoice); ; salesFormLetter.update(_salesTable,systemDateGet(),SalesUpdate::All,AccountOrder::None,NoYes::No,NoYes::No); Hope this will help you Regards Akash --- tushar_r_panda <[EMAIL PROTECTED]> wrote: --------------------------------- Hi all, I want to post an Sales order and also invoice it. The data required to create a sales order is there in an excel sheet. I want to write a code such that the data is picked from the excel sheet and all the necessary validations present in a Sales order form is done and then invoiced. Can this be done and if so how? Regards, Tushar 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 the Yahoo! Terms of Service. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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/