RE: [development-axapta] Importing General Ledger / General Journal

[James Flavell]

There is a 'load lines' (or load something but cant remember off hand and no Ax with me right now) in the functions button in general ledger right?

Not sure the format it uses or how it addresses voucher number etc...

 

-----Original Message-----
From: Steve Wright [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 1:53 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [development-axapta] Importing General Ledger / General Journal

You would have to develop a import periodic routine (maybe run in batch job) to pick up the spreadsheet.

 

A couple of harder questions...How would the spreadsheet deal with number sequences like Journal and Voucher Numbers, and deal with any validation issues before you import the spreadsheet?

 

A solution already exists that integrates Excel and Axapta, www.atlasxl.com.au can validate and post General Ledger journals from Excel through the Axapta COM Client.   The Accountants use Atlas to prepare the spreadsheet, get the results into Axapta fully validated and then finally post.

 

Steve Wright

 

---

From: pbercher [mailto:[EMAIL PROTECTED]
Sent: Monday, 19 April 2004 10:27 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Importing General Ledger / General Journal

Hello,

i need to import once a month an excel file into general ledger /
general journal.

Is there any easy way to do?

Thx

Pirmin

---

Yahoo! Groups Links

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
   
• To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.