RE: [Axapta-Knowledge-Village] Inventory Upload

[Nihar Saraiya]

Hi Jl Markusse, Priyank and Alessandro   Thanks all for the reply. Do this tables have to be uploaded at one go or is it right thing to upload them one after another. I was trying the later part. Please do clarify.   Hi Jl Markusse I uploaded InventTable and then InventTableModule  as 2 different uploads. Since i could not view the data, i did not try to upload InventItemLocation table. Will try out ur advice and update u.   Regards Nihar From: JI Markusse [mailto:[EMAIL PROTECTED] Sent: Thursday, November 10, 2005 6:39 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Inventory Upload Hi Nihar,   Something that will prevent the items from being shown is the InventDimID field in the InventItemLocation table.  If you are not setting up items with warehouses and locations etc. at this point then this field must contain the word "Axapta" and it must be left-padded to the full length of the field with spaces.  E.g. if the field length is 40 then you must have 34 spaces to the left of "Axapta".  Even one space too few here will prevent the item from being shown in the Item Master.   Hope this helps!   Hannes   JI Markusse Pr. Sci. Nat.   Mobile: + 27 (0) 82 442 1074 E-mail: [EMAIL PROTECTED]   "If you're not living on the edge, you're taking up too much space..." - Anonymous From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Priyank Krishna Sent: Thursday, November 10, 2005 3:53 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Inventory Upload   Hi Nihar,   To create an Item master you must import data into   1) InventTable. 2) InventTableModule (3 records per item, one for each module      type Invent, Purch and Sales).  3) InventItemLocation.   I successfully uploaded 5000 items like this without any problem.   Regards,   Priyank Krishna   Nihar Saraiya <[EMAIL PROTECTED]> wrote: Hi All   I am trying to upload Inventory thru Axapta Excel Template. The table i am uploading is Invent Table. The loading was successful and without any errors.   The issue i am facing is that the data is uploaded in the Table, but not appearing on the Item form. For testing purpose we tried to upload the  InvenTableModule as well as InventItemLocation. Still the data is not seen on the Item form.   One more thing was tried, we created a dummy item manually on the Item form and modified the Item description from backend, the updation was seen on the Item form. The uploaded data is still missing on the Item form.   Can some one please help on this, since there are 1000 items to be loaded.   Regards Nihar Saraiya, Confidentiality Notice This email is confidential and may also be privileged. If you are not the intended recipient please notify the sender immediately. You must not copy or use it for any purpose or disclose its contents to any other person. The sender accepts no responsibility for viruses received with or changes made to this email after it was sent. Any opinion expressed in this email may be personal to the sender.   Enjoy this Diwali with Y! India Click here Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS  Visit your group "Axapta-Knowledge-Village" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.