Hi Anil,
Thanks for your answer. I am using Ax 2009. I tried to make the std import from excel sheet to the movement journal, but I believe that there are more than one table to import to (e.g. InventJournalTrans & InventTrans) Actually, I don't know the exact tables to import to and if there is a special values for some fields in those tables. So, if you have succeeded in this before, I will appreciate your help. Regards Abdullah Al Nunu ERP Consultant <http://www.netways.com/> ______________________________ Jeddah - Saudi Arabia Mobile:00966-50-7402504 Email: aaln...@netways.com.sa Website: www.netways.com.sa <http://www.netways.com.sa/> From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anil Kumar Sinha Sent: Tuesday, February 10, 2009 7:51 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Inventory opening balances Hi Abdullah, Use std Axapta excel import functionality. First export the excel template for movement journal table. Fill it up and then import it to AX. BTW which version of AX you are using? Regards Anil Sinha --- In Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> , "mgsrush" <mgsr...@...> wrote: > > Abdullah: > > I would suggest doing this with X++ into a movement journal. I find > it easier to do the data cleansing in SQL Server with SSIS, and then > end up with one line per item for import. > > --- In Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> , "Abdullah Al-Nunu" > <aalnunu@> wrote: > > > > Dear all, > > > > > > > > In Ax 2009, I have more than 5000 items. I have created the items > in the > > system but the problem is how to make the opening balance for each > item. > > > > I was trying to import all these data to a movement journal or > counting > > journal but the import was too hard and I couldn't do it. > > > > So, if you have a best practice or any experience in this area, > please > > enlighten me ASAP. > > > > > > > > Regards > > > > > > > > Abdullah Al Nunu > > > > ERP Consultant > > > > <http://www.netways.com/> > > > > ______________________________ > > > > Jeddah - Saudi Arabia > > > > Mobile:00966-50-7402504 > > > > Email: aalnunu@ > > > > Website: www.netways.com.sa <http://www.netways.com.sa/> > > >
<<image001.gif>>
