To use Excel to take on stock is a nightmare.
Would suggest that you ask developers to develop an import script for you. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of madhubabu_r Sent: Wednesday, September 26, 2007 7:55 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock 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 <mailto:Axapta-Knowledge-Village%40yahoogroups.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 > > > > > [Non-text portions of this message have been removed]