R2 Core

Rep_InvoiceDetailInfoView

New columns added to the view Rep_InvoiceDetailInfoView.

Column Name

Description

TRANSACTION_CURRENCY_COST

Line-level cost of Item, Misc, or Labor in Transaction Currency. If multi-currency is disabled, the value is displayed in the base currency as stored in R2.

TRANSACTION_CURRENCY_DISCOUNTED_AMOUNT

Line level discounted amount (post-discount and pre-tax) for item/labor lines from invoice, shown in Transaction Currency. If the invoice is a credit memo, the value appears as negative. If multi-currency is disabled, the value is displayed in the base currency as stored in R2.

TRANSACTION_CURRENCY_ID

Transaction Currency ID from Invoice Header. If multi-currency is false, the Currency ID will appear as blank.

TRANSACTION_TO_SITE_CURRENCY_RATE 

Currency conversion rate from Transaction to Site.
Transaction to Site Currency Conversion Rate
The currency conversion rate from Transaction to Site currency is pulled from the Order , where it is originally stored. The rate selected corresponds to the current date with the maximum effective date.
Example:
Site Currency: EUR
Transaction Currency: USD
Scenario 1:
If the Site to Transaction rate (EUR to USD) is defined as 0.40000000,
then the Transaction to Site rate is calculated as:
Transaction to Site Rate=1/0.40000000=2.5
Scenario 2:
If the Transaction to Site rate (USD to EUR) is directly defined as 2.5,
then the Transaction to Site rate remains:
Transaction to Site Rate=2.5

 If multi-currency is false, value is 1.

ORDER_HEADER_DEPARTMENT

Department tagged at Order level

TRANSACTION_CURRENCY_UNDISCOUNTED_AMOUNT

Line level undiscounted amount (pre-tax) for item/labor lines from invoice, shown in Transaction Currency. Credit memo values appear negative. If multi-currency is disabled, the value is displayed in the base currency as stored in R2.

TRANSACTION_CURRENCY_DISCOUNT_AMOUNT 

Line level discount amount for item/labor lines from invoice in Transaction Currency. Credit memo values appear negative. If multi-currency is disabled, the value is displayed in the base currency as stored in R2.