Business News
Syndicate
Home arrow Sun Documentation arrow General Ledger arrow Importing Ledger Entries
Importing Ledger Entries PDF Print E-mail
User Rating: / 1
PoorBest 
Sun Documentation - General Ledger
Article Index
Importing Ledger Entries
Page 2
Page 3
Page 4
Overview
Ledger Import allows you to validate and post journals that have been created by another function rather than entered manually using Ledger Entry (LE). These journals are held as import files and stored in the Ledger Import tables. You can use Ledger Import to post actual and budget transactions.
Note: If you are using budget checking, you should note that although the ledger is updated, the transactions are not held for the budgets.
The journals to be imported can be generated a number of different sources including:
  • SunSystems Financials Corporate Allocations.
  • SunSystems Order Fulfilment.
  • Other software packages. 
The transactions must be created as balanced journals, in the required journal transaction format. See Loading Transactions into the Import Tables.
One or more journals can be combined into a single import file, or batch, for processing. However, all of the journals in a file must use the same journal type.
Ledger Import uses a control desk to allow you to select the journals you want to import.
Ledger Import Processing Modes
Ledger Import can be run in two different processing modes: real-time or manual.
When Ledger Import is used to import and post journals in real-time, the journals are passed to Ledger Import automatically as they are generated by the source system. Ledger Import then validates the journals and, providing they are correct, posts them.
When Ledger Import is used to manually import and post journals, the journals are held on the Ledger Import SQL tables within Financials until you choose to import them. You then manually select the journals you want to import, and these are passed to Ledger Import for validation and posting.
Tip: The journals generated by SunSystems Order Fulfilment and Financials Corporate Allocations can be posted either in real-time or posted manually.
All of the journals imported using Ledger Import remain on the import tables after they have been posted, regardless of the Ledger Import processing mode used to post them.
Ledger Import Validation and Posting
Ledger Import applies the same validation and balancing rules as Ledger Entry to each journal it processes to ensure that only valid journals are posted.
You can choose to only validate the journals, or to validate and post the journals. When you are posting the journals, if an error is found in a journal you can choose to either reject the journal or post the error to a suspense account.
Imported journals can be posted to the actual ledger or to a budget ledger. To post to a budget ledger, you must use Change Budget (CB) to switch into the budget ledger before you import the file.
Viewing and Selecting Journals for Import
You use a control desk to initiate, control and monitor the Ledger Import processing. The control desk displays all of the journals on the ledger import tables.
This means that you can use the Ledger Import Control Desk to view journals in any of the following states:
  • those awaiting ledger import processing
  • those rejected by ledger import with validation errors
  • those posted successfully by ledger import. 
You must periodically remove the posted journals from the ledger import tables.
Note: When posting transactions as provisional in Ledger Import, a new journal is generated for each journal type on the import file.
Reversing Journals
If the transaction being imported refers to a journal type which has the Next Period Reversal field set to Yes, and the complete journal is valid, a reversal for the amount of the transaction is posted to the relevant account in the next period.
Importing Journals with Unique References
If the transactions being imported are for a journal type whose definition has the Unique References field set to Yes, and the account to which the transaction is imported is a debtor, creditor, or client type account, the reference number entered is validated against both the ledger and the other transactions being imported. An error is reported if the reference is not unique for that account.
Note: This validation process considerably increases the time taken to import a journal.


New Forum Topics
Latest Articles
 
 
Popular Articles
Poll
Apart from Sun do you use other Infor products?
Yes, we use these Infor products:
Place your ads here: