Syndicate
Home arrow Sun Documentation arrow Accounts Receivable arrow Transaction Matching (TM)
Transaction Matching (TM) PDF Print E-mail
User Rating: / 0
PoorBest 
Sun Documentation - Accounts Receivable
Article Index
Transaction Matching (TM)
Page 2
Page 3
Page 4
Page 5
Page 6

Using Transaction Matching
Click here to see the screenshot
Currency Identifier
The currency value type to be matched. You can match transactions by base currency, transaction currency, or fourth currency.
If you match by transaction currency, the corresponding base currency amounts must also be equal before an allocation is made. If the difference is caused by an exchange gain or loss, a journal is generated automatically to post this difference to the realized gain or loss account.
Account Type
The type of accounts for which transactions will be selected for matching.
From/To
The account, or range of accounts, to be selected within the account type chosen. Transactions for these accounts, matching the selection criteria, are considered for matching and allocation. Leave these fields blank to include all accounts of the chosen type.
Tip: Closed and suspended account codes are excluded from Transaction Matching.
Selection 1-3
This option allows you to identify up to three selection criteria which transactions must meet before they are picked for matching. If you leave all three selection criteria blank, you will select all of the unmatched transactions for the selected accounts, for periods up to the selected Cutoff Period.
From/To 1-3
A code, or range of codes, within the chosen selection criteria. Transactions are only selected if they include this range of codes. For example, you may wish to restrict the transactions to those for a range of analysis codes.
Match Criteria 1-3
You can select up to three different match criteria. The criteria selected will determine the basis for matching transactions to each other. If you choose to match on the transaction currency, one of the Match Criteria must be Currency Code.
Cutoff Period
A cutoff period can be identified beyond which, transactions are not considered for matching. The default is to select the current period as the cutoff period.
Report Unmatched
This option enables you to determine the reporting detail you require for transactions that have been selected, but remain unmatched, after a transaction matching run. You can choose not to report the unmatched transactions at all, to report unmatched debit and credit transactions, only unmatched debits, or only unmatched credits.
Report Matched
This determines whether or not the transaction matching report identifies the matched transactions.
Post Transactions
This determines whether or not the allocations and any resulting discount and gain/loss transactions are posted to the ledger. If provisional postings are optional, you can choose to post the transactions as provisional or permanent.
Input Discount Account
This is the account to which settlement discount generated on debtor/receivables accounts, or sales transactions on a client account, will be posted.
Output Discount Account
This is the account to which settlement discount generated on creditor/payables accounts, or generated on purchase transactions on a client account, will be posted.
Discount Tolerance
The discount tolerance identifies the acceptable difference between the amount of discount allowed, as identified by the settlement terms, and the actual discount amount taken. The tolerance is entered either in the form 9999.99 to specify a fixed amount tolerance, or in the form 999.99% to specify a percentage tolerance from the calculated discount. Leave the field blank if no tolerance is required.
Note: Discount only applies if you are matching transactions on debtor, creditor or client accounts.
Realized Difference Account (Gains or Net)
This field is only required if you have selected Transaction Currency matching in the Currency Identifier field and you are posting rather than reporting transactions. When transactions are matched based on transaction currency, the system will ensure that the base currency values balance. Consequently, gains/losses may be generated.
The Revaluation Posting Method setting in Ledger Setup (LS) determines the use of this account. If the Revaluation Method is set to Gains only, Losses only, or Net Gains and Losses, you are prompted to enter the realized gain, realized loss or net realized difference account.
Realized Losses Account
This field is only required if you have selected to match in the transaction currency and the Revaluation Posting Method is set to Gains and Losses Seperately in Ledger Setup. Any realized exchange losses are posted to this account.
Posting Period
The period to which transactions generated during Transaction Matching are to be posted. Leave this blank to post to the current period. This is only required, if you selected Yes in the Post Transactions field.

Comments

Only registered users can write comments.
Please login or register.



Latest News
Forum Topics
Latest Articles
 
 
Popular Articles