Grid
Fields
Make the following menu selections to display this grid:
eSite—Inquiry—GL Transfer Inquiry by Batch
GL Transfer Inquiry by Batch assists with reconciliations between eSite and eFinancials by allowing a review of batches and their transfer status. This utility generally is used with the assistance of an AMSI Support representative to help interpret the results.
The initial grid shows a list of batches that have been approved on or after the filter date and that contain transactions for the selected property. The Approved After filter defaults to thirty days prior to the login date and the Property filter defaults to the current property. The batches shown in the grid are not restricted based on user access; however, only properties the user has permission to can be selected.
BB ID
The bank book identification for the batch the transfer is in.
Type
The type of batch. A = Adjustment; C = Cash.
Batch
The batch number.
Approved By
The user who approved the batch.
Approved
The date the batch was approved.
Transfer
The Transfer ID. Each transaction in a batch has its own Transfer ID. While often a batch appears in a single transfer, this is not always the case; therefore, a batch may show in multiple lines in the grid. This ID is the ID currently assigned to the transaction, so if a batch has been transferred, then untransferred, then transferred again, only the most recent ID is reported here. If the Transfer ID is blank then the transactions are not currently marked as being in a transfer. This may be due to the use of the utility to untransfer records.
Count
The number of transactions in this batch/transfer.
Message
The first 100 characters of the message associated with this transfer. If there is no transfer this appears as "NOT TRANSFERRED."
Transfer Info (links)
For users with permissions granted in the System module, this column shows links used to drill down to Batch, Detail, Account, and/or Policy information. These are the same drill downs as GL Transfer Inquiry. Refer to field lists, below, for specific information on these drill-downs.
NOTE
Information in the drill downs is for the whole transfer, not just this specific batch, so users can potentially see data for other properties.
Batch Info (links)
For users with permissions granted in the System module, this column shows links used to drill down to Batch Detail and/or Transfer information. Refer to field lists, below, for specific information on these drill-downs.
Link Fields
Transfer Info
This grid provides batch information for the specific Transfer ID that you selected from the GL Transfer Inquiry grid.
Batch Type
The type of batch.
Bank Book ID
The bank book ID for the batch.
Batch No
The batch number for the batch.
Date Created
The date the batch was created.
Created By
The user that created the batch.
Date Approved
The date the batch was approved.
Approved By
The name of the user that approved the batch.
Approval Code
The approval code for the batch.
Max Entries
The maximum number of entries allowed in the batch.
No Entries
The number of entries in the batch.
Total Rent
The total amount of the rent in the batch.
Total Sec
A total of the security deposits included in the batch.
Total Other
A total of Other amounts in the batch.
Total Misc Income
A total of the Miscellaneous Income in the batch.
Total Non Cash
A total of the Non-cash amounts in the batch.
Batch Stamp
The batch stamp date.
Batch User Stamp
The name of the user who processed the batch.
Batch Trn Type
Batch Created Src
The source of the batch: Internal or External.
Entry Created Time
The time that the batch was created. This is the server time, which may be in a different time zone than the user's browser.
Ext Jnl No
The External batch (journal) number as assigned by a third-party product, if any.
Ext Deposit Total
The deposit total for an External batch, if any.
Ext Settlement Date
The settlement date for an External batch, if any.
Restrict to Property
Is the global policy set for this batch to restrict it to a particular property: Yes or No.
Batch Rent Dep Flag
Is the flag for the default Bank Book associated with this batch set to allow Rent Deposits: Yes or No.
Batch Sec Dep Flag
Is the flag for the default Bank Book associated with this batch set to allow Security Deposits: Yes or No.
Batch Oth Dep Flag
Is the flag for the default Bank Book associated with this batch set to allow Other Deposits: Yes or No.
Batch Misc Income Flag
Is the flag for the default Bank Book associated with this batch set to allow Miscellaneous Deposits: Yes or No.
Batch Wait List Flag
Is the flag for this batch set to place all transactions relating to a waiting list transfer in a special Wait List Batch: Yes or No.
This grid provides Detail information for the specific Transfer ID that you selected from the GL Transfer Inquiry grid.
Seq No
The line number for a detail line.
Property
The property identification code that appears on reports and lists.
Building
The building ID that appears on reports and lists.
Unit
The Unit Short name from Global Policies—Names.
Res/Tenant
The Resident/Tenant Short name from Global Policies—Names.
Bank Book ID
The bank book ID.
Batch No
The batch number.
Batch Type
The batch type.
Inc Code
The income code, for example NSF.
Trans Type
The transaction type.
GL Period
The general ledger period in the format YYYYMM.
Suspense Acct
The Suspense Account number.
Credit Entity
The Entity ID for the credit account.
Credit Acct
The Credit Account number associated with the income code.
Debit Entity
The Entity ID for the debit account.
Debit Acct
The debit account number associated with the Income Code.
DOR
The Date of Record for the transfer.
Trans Amt
The amount of the transaction.
Posted Amt
The amount posted for the transaction
Applied to Prepay
The amount that was applied to Prepaids.
Prepaid Trans
Indicates if an amount was applied to Prepaids: Yes or No.
This grid provides Account information for the specific Transfer ID that you selected from the GL Transfer Inquiry grid.
Property
The property identification code that appears on reports and lists.
Code
The Income Code for the transfer.
Class
The class for the account: Credit, Debit, Refund, Write-off
Entity
The Entity associated with the account.
Acct Method
The Accounting Method used for the account.
GL Acct No
The General Ledger account number for the account.
Profit Center Flag
Indicates the if a Profit Center was used for the selected income code: Yes or No.
Profit Center
The Profit Center that is affected for the account.
Transfer to GL
Indicates the transfer method: Summary or Detail.
This grid provides Property Policy setting information for the specific Transfer ID that you selected from the GL Transfer Inquiry grid.
Property
The property identification code that appears on reports and lists.
Code
The code that identifies the property policy.
Category
The category that the property policy belongs to.
Description
The description of the property policy.
Value
The setting for the policy.
Note
Refer to the Property Policy Groups - Settings page for more information on Category, Description and Value. For example:
Property: 01104
Code: P13.5
Category: Calculations
Description: Method to calculate Loss To Lease
Value: Gross Potential
Batch Info
Property
The property identification code that appears on reports and lists and that is associated with the resident that the transaction is for.
Building
The building identification code that appears on reports and lists, and that is associated with the resident that the transaction is for.
Unit
The unit identification code that appears on reports and lists, and that is associated with the resident that the transaction is for.
Res
The resident identification code that appears on reports and lists, and that is associated with the resident that the transaction is for.
Name
The name of the resident that the transaction is for.
Inc Code
The Income Code that the transaction is for.
Trans Type
The transaction type.
Trans Amt
The amount of the transaction.
Prepaid
Indicates if an amount was applied to Prepaids: Yes or No.
Applied PrePay
The amount that was applied to Prepaids, if any.
Credit Entity
The Entity ID for the credit account. This is based on the current income code/bank book setup.
Credit Acct
The Credit Account number associated with the income code. This is based on the current income code/bank book setup.
Credit PC
The Profit Center number associated with the credit account. This is based on the current income code/bank book setup.
Debit Entity
The Entity ID for the debit account. This is based on the current income code/bank book setup.
Debit Acct
The debit account number associated with the Income Code. This is based on the current income code/bank book setup.
Debit PC
The Profit Center number associated with the debit account. This is based on the current income code/bank book setup.
Ppd Acct
The Prepaid Account number. This is based on the current income code/bank book setup.
Ppd PC
The Profit Center number for the prepaid account. This is based on the current income code/bank book setup.
Used Suspense Acct
The Suspense Account number, if the payment was applied to a suspense account.
Transfer ID
The transfer ID that the batch was included in, or that any transactions in the batch were included in.
Message
The message from that transfer.
Note
A batch can be transferred, untransferred, transferred again, etc., and this list will include all of those transfers. This feature is designed to show this history of transfers. When looking for what is included in the transfers, record the Transfer ID numbers and then use the Transfer Info links for Batch, Detail, Account and/or Policy.
Access to the GL Transfer Inquiry menu item and the ability to drill-down is controlled by permissions set up in the System module (Security—Users—eSite—Inquiry—GL Transfer Inquiry by Batch).
The top level permission provides access to the menu item and to view the grid but not to view the transfer information drill-down links. The ability to view and access the drill down links is provided by separate permissions for Transfer Batches, Transfer Detail, Transfer Policies, Batch Detail and Batch Transfers.
See Also
Copyright © 2018 Infor. All rights reserved. www.infor.com.