Hi Abd Allah, First it depends on what AX version you use, because AX version differences will have only impacts on inventory dimensions, because AX 4.0 has only 8 Dim, and AX 2009 has 9 (site: is new dimension). Tables are involved in this operations are: InventJournalName,InventJournalTable,InventJournalTrans,InventDim. You will also deal with some classes are existed to help you in your importing operations from Excel file. such as: sysExcelApplication, sysExcelWorkbooks, sysExcelWorkbook, SysExcelWorksheets, sysExcelWorksheet, sysExcelCells, COMVariant.
ofcourse you will as the tech guy to do this whole importing operation in x++. Mahmoud Anass Senior AX Developer Caliber Plus 3 Sun Rise Tower , Elsefarate dist. Nasr city Nasr city, Cairo, Egypt Mobile: +20109967890 Blog: http://www.ax4all.blogspot.com ________________________________ From: Anil Kumar Sinha <anilsinha1...@yahoo.com> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, February 12, 2009 7:40:31 AM Subject: [Axapta-Knowledge-Village] Re: Inventory opening balances 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- vill...@yahoogro ups.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- vill...@yahoogro ups.com > [mailto:Axapta-Knowledge- vill...@yahoogro ups.com] On Behalf Of Anil > Kumar Sinha > Sent: Tuesday, February 10, 2009 7:51 AM > To: Axapta-Knowledge- vill...@yahoogro ups.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- vill...@yahoogro ups.com > <mailto:Axapta- Knowledge- Village%40yahoog roups.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- vill...@yahoogro ups.com > <mailto:Axapta- Knowledge- Village%40yahoog roups.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/> > > > > > >