Deletes the transaction or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. 

_{WARNING: Records cannot be recovered once they are deleted!}

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

 The bolded view is the default view, which will determine the view will automatically display in when opened. 

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. 

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

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

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

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 push to the 'GL Date' property if the 'GL Date' is blank. 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

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

Database Field: ERPx_MFCheckbook.CurrencySK

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

Database Field: ERPx_MFCheckbookTransaction.CheckbookSK

A non-editable text box to identify the Created Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user.

Database Field: ERPx_MFCheckbookTransaction.CreatedDate

The date the transaction posted (or will post) to the general ledger. If unassigned when the transactions Status is changed to "Approve" or "Ready to Post", it will default from the Transaction Date. To Approve or Post, the GL Date must be in a valid period that is open for posting. If not the message, "The Fiscal Period is not open." will be displayed on Save. 

Database Field: ERPx_MFCheckbookTransaction.GLDate

A non-editable text box to identify the Last Updated Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user.

Database Field: ERPx_MFCheckbookTransaction.LastUpdated

A non-editable text box to identify the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user.

Database Field: ERPx_MFCheckbookTransaction.LastUser

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

Database Field: ERPx_MFCheckbookTransaction.CheckbookTransactionSK

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

Database Field: ERPx_MFCheckbookTransaction.TransactionID

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.

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.

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.

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.

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.

Allows users to select which records they want removed from the transaction. The list contains:

• Remove Filtered: When selected, all the records in the current grid will be un-selected.
• Remove Selected: When selected, only the records that have been manually tagged in the current grid will be un-selected.

This action is only applicable while the transaction is in a Status of "New".

Removing (un-selecting) a receipt removes it from the deposit, clears it from the 'Deposit Amount' column in the grid, and removes it from the 'Deposit Amount' in the header.

Displays the amount that the Payment Receipt will add to the deposit, in the checkbook's currency, displayed in the checkbook currency format. The 'Deposit Amount' defaults to 0.00 and is updated for each selected record. This column has a total at the bottom.

If the 'Receipt Currency' matches the Checkbook's Currency, the 'Deposit Amount' will be the 'Receipt Amount'. If the 'Receipt Currency' does not match the Checkbook's Currency, the 'Deposit Amount' will be the 'Receipt Amount' converted to the Checkbook's Currency. The deposit Amount is calculated as either:

• [Receipt Amount] * [Deposit Exchange Rate] - If the 'Exchange Rate Calculation Method' = "Multiply"
• [Receipt Amount] / [Deposit Exchange Rate] - If the 'Exchange Rate Calculation Method' = "Divide" 

Database Field: ERPx_MFCheckbookDetail.DebitAmount

Displays the 'Payment #' from the 'Payment Receipt' (e.g. for Receipt Types of "Check", this represents the Check #). This field is not editable from the grid but is editable from the record view of the Payment Receipt transaction by clicking on the Trans. # hyperlink, even after the transaction is posted.

Database Field for A/P Payment Receipts:: ERPx_APTransactionHeader.DocNumber

Database Field for A/R Payment Receipts: ERPx_ARTransactionHeader.DocNumber

Displays the amount of the 'Payment Receipt' in the 'Currency' and currency format it was received in. This column has a total at the bottom.

Database Field for A/P Payment Receipts: ERPx_APTransactionHeader.ExtendedAmount  

Database Field for A/R Payment Receipts: ERPx_ARTransactionHeader.ExtendedAmount

Displays the Currency ID of the 'Payment Receipt'.

Database Field for A/P Payment Receipts: ERPx_APTransactionHeader.CurrencySK  

Database Field for A/R Payment Receipts: ERPx_ARTransactionHeader.CurrencySK

Displays the 'Receipt Date' from the Payment Receipt. The date is formatted based on the User Preference for 'Date Format'.

Database Field for A/P Payment Receipts: ERPx_APTransactionHeader.TransactionDate  

Database Field for A/R Payment Receipts: ERPx_ARTransactionHeader.TransactionDate

Database Field for A/P Payment Receipts: ERPx_APTransactionHeader.CashReceiptType  

Database Field for A/R Payment Receipts: ERPx_ARTransactionHeader.CashReceiptTypeEN

Displays the name of the account that the Payment Receipt was received from. Most Payment Receipts are from customers, but they can also be from Fishermen and Loan Accounts.

Database Field for A/P Payment Receipts: ERPx_APTransactionHeader.VendorSK

Database Field for A/R Payment Receipts: ERPx_ARTransactionHeader.CustomerSK

This is used to convert the 'Receipt Amount' to the 'Deposit Amount' for each Receipt that is "Included" on the Deposit.

This is a non-editable text box that displays the currencies on the 'Deposit Amt: Exchange Table' being used for the conversion. This is formatted as: "From [Receipt Currency] to [Deposit Checkbook's Currency]". This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is different from the Deposit Checkbook's Currency.

This value is a looked up from the 'Deposit Amt: 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.

This is used to convert the 'Receipt Amount' to the 'Deposit Amount' for each Receipt that is "Included" on the Deposit.

This is a non-editable text box to show the date range of the 'Rate' (Exchange Rate) on the 'Deposit Amt: Exchange Table' being used for the conversion. This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is different from the Deposit Checkbook's 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 is formatted based on the User Preference for 'Date Format'.

This value is a looked up from the 'Deposit Amt: 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.

This is used to convert the 'Receipt Amount' to the 'Deposit Amount' for each Receipt that is "Included" on the Deposit.

This is a non-editable text box to show the 'Calculation Method' and 'Rate' being used for the conversion. This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is different from the Deposit Checkbook's Currency. It is set as follows:

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

This is used to convert the 'Receipt Amount' to the 'Deposit Amount' for each Receipt that is "Included" on the Deposit. 

This is a non-editable text box that displays the Exchange Table used for the conversion. This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is different from the Deposit Checkbook's Currency.

This is assigned as the first Exchange Table containing both the 'Receipt Currency' and the 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 'Receipt Currency' and the currency assigned to the Deposit Checkbook then this will be blank and the message "A valid exchange does not exist between [DepositCheckbookCurrencyID] and [ReceiptCurrencyID]." will be displayed on Save after the Status is changed to Approve and/or Ready to Post.

This value is a looked up 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non-editable text box that displays the two currencies involved in the Exchange. This is formatted as: "From [Receipt Currency] to [Home Currency]". This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is not in the 'Home Currency'.

This value is a looked up 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non editable field that displays the 'Receipt Amount' converted to the 'Home Currency' based on the exchange rate for the Deposit Date on the 'Gain/Loss: Deposit Exchange Table'. This is formatted in the Home Currency format. This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is not in the 'Home Currency'.

• If the 'Gain/Loss: Deposit Amount' > 'Gain/Loss: Receipt Amount' then the receipt on the deposit will result in a currency gain.
• If the 'Gain/Loss: Deposit Amount' < 'Gain/Loss: Receipt Amount' then the receipt on the deposit will result in a currency loss. 

This value is a looked up 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non-editable text box to show the date range of the 'Rate' (Exchange Rate) on the 'Gain/Loss: Deposit Exchange Table'. This is only displayed and required for all "Included" Receipts that are 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 is formatted based on the User Preference for 'Date Format'.

This value is a looked up 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non-editable text box to show the 'Calculation Method' and 'Rate' being used for the conversion on the 'Gain/Loss: Deposit Exchange Table'. This is only displayed and required for all "Included" Receipts that are not in the 'Home Currency'. It is set as follows:

• If the 'From Currency' on the Exchange Table matches the 'Home 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 'Receipt 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 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non-editable text box that displays the Exchange Table used to calculate the 'Gain/Loss: Deposit Amount'. This is only displayed and required for all "Included" Receipts that are not in the 'Home Currency'. This will be the same Exchange Table the Receipt posted with (shown in the 'Gain/Loss: Receipt Exchange Table' field) unless that Exchange table is no longer the active exchange table being used. 

This value is a looked up 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non editable field that displays the 'Receipt Amount' converted to the 'Home Currency' using the Exchange Table the Receipt posted with (shown in 'Gain/Loss: Receipt Exchange Table' column). This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is not in the 'Home Currency'. This is formatted in the Home Currency format.

• If the 'Gain/Loss: Receipt Amount' < 'Gain/Loss: Deposit Amount' then the receipt on the deposit will result in a currency gain.
• If the 'Gain/Loss: Receipt Amount' > 'Gain/Loss: Deposit Amount' then the receipt on the deposit will result in a currency loss. 

This value is a looked up 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non-editable text box to show the date range of the 'Rate' (Exchange Rate) on the Exchange Table the Receipt posted with (shown in 'Gain/Loss: Receipt Exchange Table' column). This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is not in the 'Home Currency'.

The Date is looked-up from the posted Receipt. This is displayed as: From [Rate From] to [Rate to]. For example, "From 10/01/19 to 10/07/19". The date is formatted based on the User Preference for 'Date Format'.

This value is a looked up 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non-editable text box to show the 'Calculation Method' and 'Rate' the Receipt posted with (shown in 'Gain/Loss: Receipt Exchange Table' column). This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is not in the 'Home Currency'. 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 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is a non-editable text box that displays the Exchange Table that was assigned to the Payment Receipt (when it posted), to convert the 'Receipt Currency' to the 'Home Currency'. This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is not in the 'Home Currency'.

This value is a looked up 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.

This is used to calculate the Currency Gain/Loss for each Receipt that is NOT in the 'Home Currency'. 

This is only displayed and required for all "Included" Receipts where the 'Receipt Currency' is not in the 'Home Currency'. This is a non-editable text box that is calculated as [Gain/Loss: Deposit Amount] - [Gain/Loss: Receipt Amount]. This is formatted in the Home Currency. 

• If the 'Gain/Loss Total' = 0 then the 'Receipt' is not included in the Currency Gain/Loss Journal Entry
• If the 'Gain/Loss Total' > 0 then the 'Receipt' adds this amount to the Currency Gain/Loss Journal Entry as:
  • a 'Debit' that is coded to the Deposit Checkbook's GL Account
  • a 'Credit' that is coded to the Receipt Currency's 'Currency Gain' GL Account
• If the 'Gain/Loss Total' < 0 then the 'Receipt' adds this amount to the Currency Gain/Loss Journal Entry as: 
  • a 'Debit' that is coded to Receipt Currency's 'Currency Loss' GL Account
  • a 'Credit' that is coded to the Deposit Checkbook's GL Account

This value is a looked up 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.