The purpose of the Checkbook Deposit Record View is to assign 'Payment Receipts' that make up a bank deposit. From here, users can create a new deposit, assign one or more Payment Receipts to it, remove payments receipts prior to posting, or delete the deposit. Deleting a deposit transaction does not delete the payment receipts that were assigned to it, it just puts them back in a status of open. When Checkbook Deposits are posted, the Checkbook Balances are updated. Deposits only have the potential of making a 'Currency Gain/Loss' Journal Entry (as the Cash / AR Journal Entry was made from the Receipt). The 'Currency Gain/Loss' Journal Entry is the summarized totals from each individual Receipts' Gain/Loss amount. A Receipt will have a Currency Gain/Loss if the Receipt was in a foreign currency AND the 'Exchange Rate' is different for the date of the Receipt and the date of the Deposit. The Currency Gain/Loss Journal Entry is always created as a manual journal entry since it must be in the Home Currency.
Software Version: YYYY.MM.DD and newer
Page Header
Header Toolbar
| Toolbar Icons | Description |
|---|---|
| Delete | Error rendering macro 'excerpt-include' : No link could be created for 'Delete RV - Global'. When a Deposit is deleted, all tagged Receipts are untagged (released) so they can be used on a different deposit. |
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| Grid Layout | Error rendering macro 'excerpt-include' : No link could be created for 'Grid Layout'. |
| Help | Error rendering macro 'excerpt-include' : No link could be created for 'Help - Global Icon'. |
| Journal Details | Error rendering macro 'excerpt-include' : No link could be created for 'Journal Details - Icon'. |
| New | Opens a new blank record for data entry. |
| Notes | Opens the Notes dialog, filtered for the appropriate Note Type(s). From here, users can add, review, or edit Notes associated with the record. This icon is always enabled. |
| Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. | |
| Save | Saves all changes. |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.Home Tab
| Fields | Description |
|---|---|
| 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:
Linked Database Field: ERPx_#####.##### |
| 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. Linked Database Field: ERPx_#####.##### |
| Deposit Amount | A non-editable text box to show the total amount of the deposit, in the checkbook's currency, displayed in the 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 as Payment Receipts are selected and/or un-selected. 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. This field is not linked to a Database Field. |
| Deposit 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". On Approve and Ready to Post the Deposit Date will default as the 'GL Date' if the 'GL Date' is blank. Linked Database Field: ERPx_#####.#####. |
| 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. Linked Database Field: ERPx_#####.##### |
| Status | Error rendering macro 'excerpt-include' : No link could be created for 'Status - Single Select RV Lookup'. Linked Database Field: ERPx_#####.##### |
Properties Tab
| Fields | Description |
|---|---|
| Checkbook Currency | A non-editable text box that displays the Currency ID of the Checkbook. Linked 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. Linked Database Field: ERPx_#####.#####. |
| Created | Error rendering macro 'excerpt-include' : No link could be created for 'Created - Global Field'. Linked Database Field: ERPx_#####.#####. |
| Created By | Error rendering macro 'excerpt-include' : No link could be created for 'Created By- Global Field'. Linked Database Field: ERPx_#####.#####. |
| GL Date | Error rendering macro 'excerpt-include' : No link could be created for 'GL Date - List View/Inquiry Field'. ERPx_#####.#####. |
| Last Updated | Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated - Global Field'. Linked Database Field: ERPx_#####.#####. |
| Last Updated By | Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated By- Global Field'. Linked Database Field: ERPx_#####.#####. |
| Transaction HeaderSK | A non-editable text box that displays the SK value of the Transaction ID. Linked Database Field: ERPx_#####.#####. |
| Transaction ID | A non-editable text box that displays the Transaction ID. Linked Database Field: ERPx_#####.#####. |
Page Detail
Open Payment Receipts Grid
The purpose of the Open Payment Receipts grid is to show all the "Posted" Payment Receipts that have not been deposited. The grid contains all the "posted" Payment Receipts, received against the Checkbook of the deposit, that have not been assigned to deposit. Fields prefixed with "MC: " are sorted at the bottom of the list and are only applicable to multi-currency transactions. The column headers in the interface do not include the MC: prefix.
| Toolbar Icons | Description |
| Excel | Error rendering macro 'excerpt-include' : No link could be created for 'Excel - Global'. |
| Fields | Description |
|---|---|
| Deposit Amount | Displays the amount of 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. If the 'Receipt Currency' matches the Checkbook's Currency, the 'Deposit Amount' will be the 'Receipt Amount'. If it does not, the 'Deposit Amount' will be the 'Receipt Amount' converted to the Checkbook's Currency. Linked Database Field: ERPx_#####.#####. |
| Payment # | Displays the 'Payment #' from the 'Payment Receipt'. 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. Linked Database Field: ERPx_#####.#####. |
| Receipt Amount | Displays the amount of the 'Payment Receipt' in the 'Currency' and currency format it was received in. Linked Database Field: ERPx_#####.##### |
| Receipt Currency | Displays the Currency ID of the currency the 'Payment Receipt' was received in. Linked Database Field: ERPx_#####.#####. |
| Receipt Date | Displays the 'Receipt Date' from the Payment Receipt. For multi-currency deposits, the exchange rate for 'Receipt Date' is compared to the exchange rate for 'Deposit Date'. Linked Database Field: ERPx_#####.#####. |
| Receipt Type | Displays the 'Receipt Type' of the Payment Receipt. The options available in this filed include all the values in the MFCashReceiptType Enumeration Class. Linked Database Field: ERPx_ARTransactionHeader.CashReceiptTypeEN. |
| Received From | 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. Linked Database Field for A/R Payment Receipts: ERPx_#####.##### Linked Database Field for A/P Payment Receipts: ERPx_#####.##### |
| Select | Error rendering macro 'excerpt-include' : No link could be created for 'Checkbox (Tag)- Global Field'. |
| Source | |
| Trans. # | The Transaction # from the Payment Receipt. This is a hyperlink that opens the record view of the selected Payment Receipt. Linked Database Field: ERPx_#####.#####. |
| MC: Dep Exchange Rate | |
| MC: Deposit Gain / Loss | |
| MC: Exchange Rate Calculation Method | |
| MC: Exchange Table | |
| MC: From Currency | |
| MC: Receipt Exchange Rate | |
| MC: To Currency |