RE: [development-axapta] Importing General Ledger / General Journ al

[Steve Wright]

 
"Load Ledger Transactions" or "Load lines" is used to 
create a new journal based upon an already posted one.   All journal 
lines have to be "Ledger", ie no Customers, Vendors, Assets, Projects etc in 
order for this to work.
 
You are given options about how to generate new voucher 
numbers, such as a new voucher for each 
 
This is no good if the amounts in each journal line can be 
different or if the number of lines in the journal can be different each 
month.
 
Regards,
Steve
 
 


From: James Flavell 
[mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 April 2004 11:54 
AMTo: [EMAIL PROTECTED]Subject: RE: 
[development-axapta] Importing General Ledger / General 
Journal

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 PMTo: '[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 PMTo: [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?ThxPirmin







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.