...
| Fields | Description | ||||||||
| Checkbook Currency | A non-editable text box to identify the Currency ID for the currency assigned to the Checkbook. Receipts cannot be posted if this value is missing. Linked Database Field: ERPx_#####.#####. | ||||||||
| CheckbookSK | A non-editable text box to identify the SK value of the Checkbook. This is a looked-up value, that is primarily used for support. Linked Database Field: ERPx_#####.#####. | ||||||||
| Created |
| ||||||||
| Created By |
| ||||||||
| CustomerSK | A non-editable text box to identify the SK value of the Customer on the Transaction. This is a looked-up value, that is primarily used for support. Linked Database Field: ERPx_#####.#####. | ||||||||
| GL Date | Identifies the date the transaction will hit the General Ledger. This defaults to blank but is editable as long as the transaction Status is "New" and no applications have . It is disabled when the Receipt is in a Status of Approved, Ready to Post, or Posted AND for Receipts that are not in the Home Currency, once an application for the receipt has been made. If blank, the value will be automatically updated as follows:
The GL Date must be >= the 'Receipt Date'. If not, the message "GL Date must be >= the Receipt Date." will be displayed on Save. TheThe GL Date must fall within a Fiscal Period that is open for Sales. If not, the message, "The Fiscal Period is not open." will be displayed on Save. Linked Database Field: ERPx_#####.#####. | ||||||||
| Last Updated |
| ||||||||
| Last Updated By |
| ||||||||
| Receipt Currency | A non-editable text box to identify the currency of the receipt. Receipts may not always be in the same currency as the Checkbook. Linked Database Field: ERPx_#####.#####. | ||||||||
| Transaction ID | A non-editable text box to identify the Transaction #. This is a system assigned value that is not editable by a user. Linked Database Field: ERPx_#####.#####. | ||||||||
| TransactionSK | A non-editable text box to identify the SK value of the Transaction. This is a looked-up value, that is primarily used for support. Linked Database Field: ERPx_#####.#####. | ||||||||
| MC: Exchange Date From | A date field to show the 'Start Date' of the 'Exchange Rate' from the Exchange Table assigned to this transaction. The exchange Rate is looked-up using the 'Receipt Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable from here. Linked Database Field: ERPx_#####.#####. | ||||||||
| MC: Exchange Date To | A date field to show the 'End Date' of the 'Exchange Rate' from the Exchange Table assigned to this transaction. The exchange Rate is looked-up using the 'Receipt Date', not the 'GL Date'. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable from here. Linked Database Field: ERPx_#####.#####. | ||||||||
| MC: Exchange Rate | A label to show the 'Exchange Rate' that applies to this transaction. The 'Exchange Rate' is looked-up from the 'Exchange Table' assigned to this transaction, based on the Transaction Date, not the GL Date. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable from here. Linked Database Field: ERPx_#####.#####. | ||||||||
| MC: Exchange Rate Calculation Method | A label to show the 'Calculation Method' property from the 'Exchange Table' assigned to this transaction. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value and is not editable from here. Linked Database Field: ERPx_#####.#####. | ||||||||
| MC: Exchange Table | A single-select standard lookup to select the Exchange Table assigned to this transaction. This defaults from the first Exchange Table that contains both the receipt currency and the 'Home Currency' and contains a valid Exchange Rate for the Receipt Date. If there are no Exchange Rates that cover the Receipt Date then the last Exchange Rate will be used. If there are no Exchange Tables that contain both the Receipt Currency and the Home Currency then this will be blank. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This field is editable when the transaction Status is "New" and no applications for this receipt have been made. Linked Database Field: ERPx_#####.#####. | ||||||||
| MC: From Currency | A non-editable text box to show the 'From Currency' property from the 'Exchange Table' assigned to this transaction. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value. Linked Database Field: ERPx_#####.#####. | ||||||||
| MC: To Currency | A non-editable text box to show the 'To Currency' property from the 'Exchange Table' assigned to this transaction. This field is only visible, and required to Approve and/or Post, when the 'Receipt Currency' is not in the Home Currency. This is a looked-up value. Linked Database Field: ERPx_#####.#####. |
...