even though only SalesTable and SalesLine are required its important to get the correct InventDimId in the salesLine table. As everyone knows that the inventDimId is created depending upon the dimension combination i dont use the standard axapta template import. I would write a function and use it to import the sales orders. if we do want to use standard axapta template then we should use all the 3 tables, SalesTable, SalesLine and InventDim.
--- Hemant Kumthekar <[EMAIL PROTECTED]> wrote: > I will try uploading using your template and let you > know the outcome. > > Hemant > > Priyank Krishna <[EMAIL PROTECTED]> wrote: > I tried as per u said but no luck...help > > lukas nugroho <[EMAIL PROTECTED]> wrote: > Dear preety, > > to create sales order form excel, you need to use > SalesTable and SalesLines only. You ought to fill > the > requirement field (yellow field). do not change or > delete some field on excel regenerated from axapta. > hope it helps > > --- Priyank Krishna <[EMAIL PROTECTED]> > wrote: > > > Thanks for reponse ! > > > > I have used existing Excel template Import > > functionality for creating sales orders but could > > not succeed. > > > > you please tell me correct format.I used > > SalesTable,SalesLine,InventDim what else is > > remaining into it. > > > > Your response is waited > > > > Hemant Kumthekar <[EMAIL PROTECTED]> wrote: > > Hi, > > > > You may like to create the Excel spreadsheet from > > Axapta Administration>>Periodic>>Data > export/Import > > >> Excel Spreadsheet. I have upload sales orders > & > > Lines using the same technique, quite simple. If > you > > need the format let me know. > > > > Hemant > > > > Priyank Krishna <[EMAIL PROTECTED]> wrote: > > Can anyone please tell me the way to upload data > in > > SalesTable & SalesLine with the purpose of > creating > > Sales orders. > > > > Any responses are welcome. > > > > Cheers, > > Preety > > > > > > --------------------------------- > > Yahoo! India Matrimony: Find your partner now. > > > > --------------------------------- > > Yahoo! Music Unlimited - Access over 1 million > > songs. Try it free. > > > > Sharing the knowledge on Axapta. > > > > > > > > --------------------------------- > > YAHOO! GROUPS LINKS > > > > > > Visit your group "Axapta-Knowledge-Village" on > > the web. > > > > To unsubscribe from this group, send an email > > to: > > > > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the > > Yahoo! Terms of Service. > > > > > > --------------------------------- > > > > > > > > > > --------------------------------- > > Yahoo! India Matrimony: Find your partner now. > > > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > > > Sharing the knowledge on Axapta. > > > > > --------------------------------- > Yahoo! India Matrimony: Find your partner now. > > Sharing the knowledge on Axapta. > > > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "Axapta-Knowledge-Village" on > the web. > > To unsubscribe from this group, send an email > to: > > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > --------------------------------- > > > > > --------------------------------- > Yahoo! FareChase - Search multiple travel sites in > one click. ___________________________________________________________ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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/
