Versions Compared

Key

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

...

FieldsDescription
Checkbook CurrencyA label to identify the Currency of the Checkbook. Receipts cannot be posted if this value is missing. This is a looked-up value and is never editable by a user. Linked Database Field: ERPx_#####.#####.
CheckbookSKA label  to identify the SK value of the Checkbook. This is a looked-up value, that is primarily used for support, and is never editable by a user. Linked Database Field: ERPx_#####.#####.
Created
Insert excerpt
Created - Global Field
Created - Global Field
nopaneltrue
Linked  Linked Database Field: ERPx_#####.#####.
Created By
Insert excerpt
Created By- Global Field
Created By- Global Field
nopaneltrue
Linked  Linked Database Field: ERPx_#####.#####.
CustomerSKA label to identify the SK value of the Customer on the Transaction. This is a looked-up value, that is primarily used for support, and is never editable by a user. Linked Database Field: ERPx_#####.#####.
GL DateA date field to enter the date the transaction will post to the General Ledger. This defaults to blank and is set to the Transaction 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 for Sales. If not, the message "Receipt Date is required." 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. Linked Database Field: ERPx_#####.#####.
Last Updated
Insert excerpt
Last Updated - Global Field
Last Updated - Global Field
nopaneltrue
Linked  Linked Database Field: ERPx_#####.#####.
Last Updated By
Insert excerpt
Last Updated By- Global Field
Last Updated By- Global Field
nopaneltrue
Linked  Linked Database Field: ERPx_#####.#####.
Receipt CurrencyA label to identify the Currency of the Receipt. Receipts may not always be in the same currency as the Checkbook. This comes from the value assigned on Home tab and is not editable from here. Linked Database Field: ERPx_#####.#####.
Transaction ID - Should this be Receipt #?A label to identify the Transaction. This is a system assigned value that is not editable by a user. Linked Database Field: ERPx_#####.#####.
TransactionSKA label  to identify the SK value of the Transaction. This is a looked-up value, that is primarily used for support, and is never editable by a user. 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 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 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 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 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 based on finding 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 label 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 and is not editable from here. Linked Database Field: ERPx_#####.#####.
MC: To CurrencyA label 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 and is not editable from here. Linked Database Field: ERPx_#####.#####.

...