Hi Sumit, Finally shud i take the following tables in the excel templates: InventJournalTable InventTrans InventSum???
The tables I have uploaded are InventJournalTransa and InventTrans. I have managed all the number sequences in excel template itself. I could upload the data into the Movement Journal Lines. Movement Journal was also posted. I could see the onhand stock. But when I was trying to create a Sales order/Purchase Order /any inventory journals - just after entering the item and i click save I am getting an error message - "Illegal Reference" and I cannot proceed further. Any answers for this?? Regards, Madhu --- In Axapta-Knowledge-Village@yahoogroups.com, "Sumit Loya" <[EMAIL PROTECTED]> wrote: > > Hi, > > I wudnt say only InventJournalTrans and InventDim.. > > All item transactions are also mirrored in InventTrans table and also > the on-hand (stock detalis) are stored in InventSum table (Onhand > table). > > Regards, > Sumit > > On 9/25/07, madhubabu_r <[EMAIL PROTECTED]> wrote: > > Hi friends, > > > > Manually entering opening stock in Movement Journal must be the most > > laborious job with all those Excise related entries also included. In > > my current project there are about 10000 items as opening stock. I > > would like to know which tables I have to consider for excel upload of > > these opening entries. > > > > Awaiting your valuable responses friends. > > > > Thanks and best regards, > > > > Madhu Babu Rapolu > > > > >