Hi Abdullah, Right click on Journal line and see which is the table associated with this journal line form. You can ask your techi guy to let you know the table name Most Probably it is InventJournalTrans.
Export this table in Excel Template with all fields. All special value fields will also come up. I think all inventory journal (lines) use this same table. There is a field in this table which keeps information whether it is "movement journal", or "Profit & Loss", or "Transfer" etc. In exported excel template this filed will have drop down. In you case you need to select "Movement" for all your records. There is no need to import in any other table. Hope this helps you. If you need more help on this topic please add me in yahoo messenger and I will let you help you out online on this topic. Regards Anil Sinha --- In Axapta-Knowledge-Village@yahoogroups.com, "Abdullah Al-Nunu" <aaln...@...> wrote: > > 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...@... > > 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" > <mgsrush@> 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/> > > > > > >