Delete

When a Deposit is deleted, all tagged Receipts are untagged (released) so they can be used on a different deposit.

Grid Layout

Help

Journal Details

 This icon is only visible for 'Posted' Deposits that resulted in a currency gain/loss journal entry.

New

Notes

Print

Save

Amount

A non-editable text box to show the total amount of the deposit, in the checkbook's currency, displayed in the Checkbook's currency format. If the Checkbook is in a foreign currency, then the Currency ID will also be displayed. This defaults to 0.00 but updates on Save to show the amounts for the Payment Receipts that are "Included". The Deposit Amount must be > 0.00 to Approve or Post. If not, the message "The Deposit Amount must be > 0.00." will appear on Save.  

In multi-currency transactions, the 'Deposit Amount' is calculated by converting the 'Receipt Amount' from the 'Receipt Currency' to the currency of the deposit Checkbook. 

This is a calculated field that is not stored in the database. 

Checkbook

A single-select combo box to select the Checkbook the deposit is being made to. Once a value has been selected, the contents of the grid will be populated with all the un-deposited 'Payment Receipts' for the selected Checkbook. This field is editable when the Status is "New". However, if the Checkbook is changed, all tagged Payment Receipts will be un-selected and the contents of the grid will be refreshed to show un-deposited 'Payment Receipts' for the newly selected Checkbook. This defaults to blank but is required to Approve or Post. If missing, the message "Checkbook is required." will be displayed on Save.

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 Deposit. This field is is always editable (even after the transaction is posted) and is not required. If a Comment is entered, it must be <= 60 characters. 

Database Field: ERPx_MFCheckbookTransaction.Comment

Reference

A text box to enter a 3rd party reference number for the Deposit. This field is is always editable (even after the transaction is posted) and is not required. If a Reference is entered, it 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 Deposit posted to, or should post to, the bank account. This defaults to the current date and is required to Approve and/or Post. If not, the message "Deposit Date is required." will be displayed. 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 (where applicable).  The date is formatted based on the User Preference for 'Date Format'.

 If a Deposit has a Payment Receipt included with a Receipt Date greater than the Deposit Trans. Date the message “The deposit has a Payment Receipt, [Transaction ID], with a Receipt Date later than the deposit's Transaction date.“ will be displayed when the record is saved as Approved/Ready To Post.

Database Field: ERPx_MFCheckbookTransaction.TransactionDate

Checkbook Currency

A non-editable text box that displays the Currency ID of the Checkbook.

Database Field: ERPx_MFCheckbook.CurrencySK

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

TransactionSK

A non-editable text box that displays the SK value of the Transaction ID.

Database Field: ERPx_MFCheckbookTransaction.CheckbookTransactionSK

Transaction ID

A non-editable text box that displays the Transaction ID.

Database Field: ERPx_MFCheckbookTransaction.TransactionID

MC: Currency Conversion

This field is used to convert the transaction total 'Deposit Amount' to the 'Home Currency' amount.

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

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Exchange Date

This field is used to convert the transaction total 'Deposit Amount' to the 'Home Currency' amount.

This is a non-editable text box to show the date range of the 'Rate' (Exchange Rate) on the 'Exchange Table' being used to convert the 'Deposit Amount' to the 'Home Currency' amount. This is only displayed and required when the Deposit Checkbook's currency is not in the 'Home Currency'.

This is looked-up using the 'Deposit Date', not the 'GL Date'. This is displayed as: From [Rate From] to [Rate to]. For example, "From 10/01/19 to 10/07/19". The date values are formatted based on the User Preference for 'Date Format'.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Exchange Rate

This field is used to convert the transaction total 'Deposit Amount' to the 'Home Currency' amount.

This is a non-editable text box to show the 'Calculation Method' and 'Rate' being used to convert the 'Deposit Amount' to the 'Home Currency' amount. This is only displayed and required when the Deposit Checkbook's currency is not in the 'Home Currency'. It is set as follows:

• If the 'From Currency' on the Exchange Table matches the Deposit Checkbook 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".

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Exchange Table

This field is used to convert the transaction total 'Deposit Amount' to the 'Home Currency' amount.

This is a non-editable text box that displays the 'Exchange Table ID' used to convert the 'Deposit Amount' to the 'Home Currency' amount. This is only displayed and required when the Deposit Checkbook's currency is not in the 'Home Currency'.

This is assigned as the first Exchange Table containing both the 'Home Currency' and the foreign currency assigned to the deposit checkbook, with a valid 'Rate' (exchange rate) for the 'Deposit Date'. If there are no Rates that cover the 'Deposit 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 [DepositCheckbookCurrencyID] and [HomeCurrencyID]." will be displayed on Save after the Status is changed to Approve and/or Ready to Post.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.

MC: Home Currency Amount

This field is used to convert the transaction total 'Deposit Amount' to the 'Home Currency' amount.

This is a non-editable text box that displays the Deposit Amount converted to the Home Currency. This is only displayed and required when the Deposit Checkbook's currency is not in the 'Home Currency'.

This value is a looked up from the 'Exchange Table' and not stored in the database while the transaction is in a Status of "New". When the Status is changed to either "Approved" or "Ready to Post" the value is updated and written to the database. For posted transactions, this is the value that existed when the transaction posted.