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, "Abdullah Al-Nunu" <aaln...@...> 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: aaln...@... > > Website: www.netways.com.sa <http://www.netways.com.sa/> >