simple request - Urgent !!!

Hi,

I would create a journal first and then import the journal lines by code. For some guidance, please have a look at some basic codes in my website -

http://www.harishm.com/Navision/Code.html

It is fairly easy to import journal lines by code. If you have any problems/queries please feel free to post here or mail me.

I am not sure whether you would be interested in this or not. But for the sake of information, there is also another option as well. Either you can do this by writing code or you can try using Atlas XL. It is an Excel add-on using which you can import journals into Axapta. This is quite powerful. You can also use this to generate some complex reports across Axapta. For more info, please visit -
http://www.globesoftware.com.au/AtHome.htm

or write to Steve Wright at steve@globesoftware.com.au

Regards,

Harish Mohanbabu

Hi,

Apologies for the delay in my response.

Here is a skeleteon code -

LedgerJournalTrans                ljt;
;

ljt.overwriteSystemfields(true);
ljt.TransDate = str2date(STRLRTRIM(conpeek(line,1)),123); //DATE
ljt.JournalNum = conpeek(line,2); // JOURNAL NUMBER
ljt.AccountType = conpeek(line,3); //ACCOUNT TYPE
ljt.AccountNum = conpeek(line,4); //ACCOUNT
ljt.Txt = conpeek(line,5);//DESCRIPTION
ljt.AmountCurDebit = abs(conpeek(line,6));//DEBIT
ljt.AmountCurCredit = abs(conpeek(line,7)); //CREDIT
ljt.OffsetAccountType = conpeek(line,8); //OFFSET ACCT TYPE
ljt.OffsetAccount = conpeek(line,9);//OFFSET ACCT
ljt.Voucher = conpeek(line,10);//VOUCHER NO (MANUAL)
ljt.CurrencyCode = conpeek(line,11);//CURRENCY
ljt.insert();

Should you wish, you can validate each and every line even while you import. Also in the above code, the voucher number is being imported manually. Alternatively you can get the next number sequence.

If you are not familiar with importing lines from a CSV file, please refer to the sample code in my website -

http://www.harishm.com/Navision/Code.html

Hope this helps ,

Harish Mohanbabu

Hi,

Point 1 - I am not sure what you want to do here. But on click of a button, if you just want to open a form and display, you should write something like this -

FormRun              frm;
;

frm = ClassFactory.formRunClass(new args("SalesTable"));
frm.init();
frm.run();
frm.wait();

The above code example would open SalesTable form.

Point 2 - Yes! Provided the fact that all the things mentioned by you has been correctly set-up/configured, you don't need to do anything.

Regards,

Harish Mohanbabu