Delete

Grid Layout

Help

Journal Details

 This icon is only visible after the transaction is 'Posted'.

New

Notes

Print

Save

Amount

An editable text box to enter the amount of the adjustment, in the checkbook's currency. Once the 'Checkbook' has been selected and the transaction has been saved, this will display in the format of the checkbook's currency. This defaults to 0.00 but must be a non zero value to Approve or Post. If not, the message "Amount cannot be 0.00." will appear on Save.

• A positive 'Amount' increases the checkbook's balance by debiting the Checkbook's GL Account. 

• A negative 'Amount' decreases the checkbook's balance by crediting the Checkbook's GL Account.

This 'Amount' will be value that is auto-assigned to the first line of the Adjustment Lines Grid as either a Debit or Credit.   

Database Field: ERPx_MFCheckbookTransaction.Amount

Checkbook

A single-select combo box to select the Checkbook the adjustment is being made for. This field is editable when the Status is "New". If the Checkbook is changed, the GL Account on the auto-assigned row (first row in the grid) will be updated to be the new Checkbook's GL Account. The data for manually entered lines will remain unchanged but the currency format of the Debit and Credit columns will be updated to match the currency format of the checkbook.

This defaults to blank but is required to add detail rows to the grid and to Approve or Post. If missing, the message "Checkbook is required." will be displayed when the 'New' icon in the Adjustment Lines Grid is clicked.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Checkbooks, sorted by Checkbook, displayed as:

• If the Checkbook's Currency is the 'Home Currency' then [Checkbook]

• If the Checkbook's Currency is NOT the 'Home Currency' then [Checkbook] +([Checkbook Currency])

Database Field: ERPx_MFCheckbookTransaction.CheckbookSK

Comment

A text box to enter a short comment pertaining to the adjustment. This field is always editable (even after the transaction is posted) and is not required. If a Comment is entered, it will become the Comment on the Journal Entry. However, if this is changed for a "Posted" Adjustment, the new 'Comment' will only be visible in the record view and on inquiries, it will not be updated in the posted journal entry. The 'Comment' must be <= 60 characters.  

Database Field: ERPx_MFCheckbookTransaction.Comment

Reference

A text box to enter a 3rd party reference number for the adjustment. This field is always editable (even after the transaction is posted) and is not required. If a Reference is entered, it will become the Reference on the Journal Entry. However, if this is changed for a "Posted" Adjustment, the new 'Reference' will only be visible in the record view and on inquiries, it will not be updated in the posted journal entry.  The 'Reference' must be <= 60 characters.  

Database Field: ERPx_MFCheckbookTransaction.Reference

Status

A single-select standard lookup to assign the Transaction Status. This defaults to "New" but can be changed to "Approved" or "Ready to Post".  Updating the Status does the following:

• New: This is the default value. While in the Status of New all editable fields are open for edit, no posting/approval validations are performed, GL Dates are not assigned, and journal entries are not created. If the transaction was moved back from Approved to New, the GL Date will remain as previously assigned.  

• Approved: Performs all the data validations required to post the transaction. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled except for the Status lookup (and any fields that are always editable), and blank 'GL Dates' are assigned.   

• Ready to Post: Runs the Approval validations. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled with the exception any fields that are always editable and updates the Transaction Status to "Posted".

Database Field: ERPx_MFCheckbookTransaction.TransactionStatusSK

Trans. Date

A date field to enter the date the adjustment posted to, or should post to, the bank account. This defaults to the current date and is required to add detail rows to the grid and to Approve or Post. If missing, the message "Trans. Date is required." will be displayed on Save. This field is only editable while the transaction Status is "New". When the transaction status is changed to Approve and/or Ready to Post, this date will set the GL Date in the database and will always be the date used on the journal. 

Database Field: ERPx_MFCheckbookTransaction.TransactionDate

CheckbookSK

A non-editable text box that displays the SK value of the Checkbook that is assigned to the Transaction.

Database Field: ERPx_MFCheckbookTransaction.CheckbookSK

Created

Database Field: ERPx_MFCheckbookTransaction.CreatedDate

Created By

Database Field: ERPx_MFCheckbookTransaction.CreatedBy

Last Updated

Database Field: ERPx_MFCheckbookTransaction.LastUpdated

Last Updated By

Database Field: ERPx_MFCheckbookTransaction.LastUser

Transaction ID

Database Field: ERPx_MFCheckbookTransaction.TransactionID

TransactionSK

Database Field: ERPx_MFCheckbookTransaction.CheckbookTransactionSK

MC: Currency Conversion

A non-editable text box that displays the currencies on the 'Exchange Table' being used to convert the 'Adjustment Amount' to the 'Home Currency' amount. This is formatted as: "From [Checkbook Currency] to [Home Currency]". This is required when the Deposit Checkbook's currency is not in the 'Home Currency'.

MC: Exchange Rate

A non-editable text box to show the 'Calculation Method' and 'Rate' being used to convert the Adjustment to the 'Home Currency'. This conversion is required to create the Journal Entry and to populate the 'Home Amount' column for this transaction, on the Checkbook Transaction Inquiry. It is set as follows:

• If the Adjustment Checkbook is in the 'Home Currency' this will the set to "Multiply by 1.0000".

• If the 'From Currency' on the Exchange Table matches the Adjustment currency, then the 'Calculation Method' will default from the 'Calculation Method' on the Exchange Table.

• If the 'From Currency' on the Exchange Table matches the 'Home Currency', the 'Calculation Method' will be the opposite as it is on the Exchange Table.

This is formatted as: [Calculation Method] by [Rate]. For Example, "Multiply by 1.0250" or "Divide by 1.0250".

MC: Exchange Date

A non-editable text box to show the date range of the 'Rate' (Exchange Rate) on the 'Exchange Table' assigned to this transaction. This is required to identify which exchange 'Rate', on the exchange table, is used to create the Journal Entry and to populate the 'Home Amount' column for this transaction, on the Checkbook Transaction Inquiry.

The 'Rate' is looked-up using the 'Trans. Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the Checkbook's currency is NOT in the 'Home Currency'. This is displayed as: From [Rate From] to [Rate to]. For example, "From 10/01/19 to 10/07/19".

MC: Exchange Table

A non-editable text box that displays the 'Exchange Table ID' used to convert the Adjustment amount from the Checkbook's Currency to the Home Currency for the Journal Entry and to populate the 'Home Amount' column for this transaction, on the Checkbook Transaction Inquiry.

This will be blank for all Adjustments where the Checkbook's currency is in the 'Home Currency'. This is required for all Adjustments where the Checkbook's currency is in a foreign currency.

This is assigned as the first Exchange Table containing both the 'Home Currency' and the foreign currency on the adjustment, with a valid 'Rate' (exchange rate) for the 'Trans. Date'. If there are no Rates that cover the 'Trans. Date' then the last Rate will be used. If there are no Exchange Tables containing both the 'Home Currency' and the foreign currency then this will be blank and the message "A valid exchange does not exist between [TransactionCurrencyID] and [HomeCurrencyID]." will be displayed on Save after the Status is changed to Approve and/or Ready to Post.

MC: Home Currency Amount

A non-editable text box that displays the calculated amount of the Adjustment in the 'Home Currency' amount.