RE: [Axapta-Knowledge-Village] Inventory Upload

Sat, 12 Nov 2005 21:24:18 -0800

Hi Nihar,
 
Ya all the three tables data must be uploaded in one go in different worksheets.
Pls try it out like this and let us know.
 
Regards,
Priyank Krishna

Nihar Saraiya <[EMAIL PROTECTED]> wrote:
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

Enjoy this Diwali with Y! India Click here

Sharing the knowledge on Axapta.



SPONSORED LINKS
Business finance course Business to business finance Small business finance
Business finance consultant Business finance magazine Business finance schools

YAHOO! GROUPS LINKS



Reply via email to