Versions Compared

Version Old Version 39 New Version 40
Changes made by

Tom Williams

Tom Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FieldsDescription
Checkbook CurrencyA 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_#####.#####.
CheckbookSKA 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
Insert excerpt
Created - Global Field
Created - Global Field
nopaneltrue
 Linked Database Field: ERPx_#####.#####.
Created By
Insert excerpt
Created By- Global Field
Created By- Global Field
nopaneltrue
 Linked Database Field: ERPx_#####.#####.
CustomerSKA 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 DateA date field to enter

Identifies the date the transaction will

post to

hit the General Ledger. This defaults to blank

and is set

but is editable as long as the transaction Status is "New" and no applications have been made. If blank, the value will be automatically updated to the 'Receipt Date' on Approve or Ready to Post

. If a user manually sets this value then it is not overwritten on Approve/Ready to Post. This date must be a valid date that falls within an open fiscal period

.

  • The GL Date must be >= the 'Receipt Date'. If not, the message "GL Date must be >= the Receipt Date." will be displayed on Save. 
  • The GL Date must fall within a Fiscal Period that is open for Sales. If not, the message, "
Receipt Date is required
  • The Fiscal Period is not open." will be displayed
. This field is only editable while the transaction Status is "New" but is disabled once an application for this receipt has been made.
  • on Save.

Linked Database Field: ERPx_#####.#####.

Last Updated
Insert excerpt
Last Updated - Global Field
Last Updated - Global Field
nopaneltrue
 Linked Database Field: ERPx_#####.#####.
Last Updated By
Insert excerpt
Last Updated By- Global Field
Last Updated By- Global Field
nopaneltrue
 Linked Database Field: ERPx_#####.#####.
Receipt CurrencyA 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 IDA 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_#####.#####.
TransactionSKA 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 ToA 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 RateA 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 MethodA 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 TableA 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 CurrencyA 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 CurrencyA 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_#####.#####.

...