Hi,
At first you should have created the new journal then you can import the lines
from excel by the import tool of Axapta. You should first export the excel
sheet from management->periodic-> import/export->excel->excel wizard by
selecting ledgerjournaltrans table. When you export this excel it gives you
which places you must and should fill in. If they are yellow this column must
be filled in. Don't forget to fill the journalnum. Then from SysImpGroup you
can import your excel. SysImpGroup is crested automaticly when excel export is
done. If you can't import from this way you should import it by creating your
excel in csv format.
Good luck.
-----Özgün İleti-----
Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine
p.saravanakumar
Gönderilmiş: Per 30/11/2006 09:18
Kime: Axapta-Knowledge-Village@yahoogroups.com
Bilgi:
Konu: RE: [Axapta-Knowledge-Village] Import to General Jouranl?
Dear Kareem
You may use ledgerjournaltrans table for importing the journal lines.
Regards
P Saravanakumar
09894999281
-----Original Message-----
From: Kareem [mailto:[EMAIL PROTECTED]
<mailto:behind_memories%40yahoo.com> ]
Sent: Thursday, November 30, 2006 11:21 AM
To: Axapta-Knowledge-Village@yahoogroups.com
<mailto:Axapta-Knowledge-Village%40yahoogroups.com>
Subject: [Axapta-Knowledge-Village] Import to General Jouranl?
Hey
How can I import data from excel sheets to GL journal head and General
journal lines?I already have journals created in Axapta, but i want to
add new ones? what fields needed to be in excel? what are the tables
needed? and how to do the import procedure?
thanks
[Non-text portions of this message have been removed]
____________________________________________________________________________________________________________________________
Bu e-mail'in tüm icerigi gönderenin kisisel tasarrufu ile olusturulmus ve
gönderilmistir. Oyak Teknoloji Bilisim ve Kart Hizmetleri A.S. bu e-mail
icerigi hakkinda sorumluluk kabul etmez.
This e-mail has been sent by the sender under his/her own individual
discreation. Oyak Teknoloji Bilisim ve Kart Hizmetleri A.S. accepts no
responsibility.
[Non-text portions of this message have been removed]
