Dynamics Community Forum Thread Details

below is the Report Def for the Incompatible Operand Error I am getting. I cannot figure out why!!

Can anyone help me?

Report: Item Sell / Cost List
Date/Time: 7/21/2011   8:58:00 AM
GENERAL INFORMATION:
Series:     Inventory
Main Table:       IV_Item_MSTR
Using Key:        IV_Item_MSTR_Key1
Max Records:      0
Page Orientation:       Portrait
Type:       Graphic
Skip Blank Records:     True
Suppress Decimals:      False
Six Lines/Inch:   False
First Page Header:      False
Last Page Footer:       True
Use RF For Last PF:     False
Multi-Login Report:     False
Left Margin:      0
CALCULATED FIELDS:
Calculated Field:       AdjustmentHeading
      Conditional:      ivItemPriceListDtl_SBM.Price Type > 1 AND ivItemPriceListDtl_SBM.Pri
                        ce Type < 5
      True Case:        FUNCTION_SCRIPT( RW_GetMsg 12858 )
      False Case:       ""
      Result Type:      String
      Evaluate After:
Calculated Field:       Calc Unit Price
      Calculated:       FUNCTION_SCRIPT( rw_ivCalcUnitPrice IV_Item_MSTR.Price Method IV_Item_MS
                        TR.Current Cost IV_Item_MSTR.Standard Cost ivItemCurr.Decimal Places Cur
                        rency ivItemCurr.List Price ivItemPriceListOpt.Round To ivItemPriceListO
                        pt.Round How ivItemPriceListOpt.Rounding Amount ivItemPriceList.U Of M P
                        rice ivItemPriceList.QTY In Base U Of M )
      Result Type:      Currency
      Evaluate After:
Calculated Field:       CurrIndex
      Calculated:       FUNCTION_SCRIPT( rw_Currency_GetPhantomIndex ivItemCurr.Currency Index i
                        vItemCurr.Decimal Places Currency )
      Result Type:      Integer
      Evaluate After:
Calculated Field:       IncreaseOrDecrease
      Calculated:       FUNCTION_SCRIPT( RW_ivItemPrice_GetIncOrDecString ivItemPriceListDtl_SBM
                        .Price Type ivItemPriceListDtl_SBM.Increase Or Decrease )
      Result Type:      String
      Evaluate After:
Calculated Field:       LastCost_or_BasePrice_Amount
Report: Item Sell / Cost List (continued)                                                 Page 2
Date/Time: 7/21/2011   8:58:00 AM
      Conditional:      ivItemPriceListDtl_SBM.Price Type <> 2
      True Case:        ivItemCurr.List Price
      False Case:       IV_Item_MSTR.Current Cost
      Result Type:      Currency
      Evaluate After:
Calculated Field:       LastCost_or_BasePrice_Heading
      Calculated:       FUNCTION_SCRIPT( RW_ivItemPrice_GetCostPriceHeadingText IV_Item_MSTR.Ite
                        m Number )
      Result Type:      String
      Evaluate After:
Calculated Field:       Percent
      Calculated:       FUNCTION_SCRIPT( rw_ivFormatPriceListPercent IV_Item_MSTR.Price Method i
                        vItemPriceList.U Of M Price )
      Result Type:      String
      Evaluate After:
Calculated Field:       PercentOrAmtAdjustment
      Calculated:       FUNCTION_SCRIPT( RW_GetAndFormat_AdjustmentAmtOrPct ivItemPriceListDtl_S
                        BM.U Of M Price ivItemPriceListDtl_SBM.Percentage ivItemPriceListDtl_SBM
                        .Price Type ivItemCurr.Currency Index ivItemCurr.Decimal Places Currency
                          )
      Result Type:      String
      Evaluate After:
Calculated Field:       SBM_PriceType
      Calculated:       FUNCTION_SCRIPT( RW_GetItemPriceType_SBM IV_Item_MSTR.Item Number )
      Result Type:      String
      Evaluate After:
TABLE RELATIONSHIPS:
+-- Display Name:Item Master
|   Technical Name:IV_Item_MSTR
|   Physical Name:IV00101
|
| IV_UofM_SETP_HDR_Key1
| U Of M Schedule --> U Of M Schedule
|
+----------+-- Display Name:Inventory U of M Schedule Setup
|              Technical Name:IV_UofM_SETP_HDR
|              Physical Name:IV40201
|
| GL_Account_MSTR_Key1
| IV IV Index --> Account Index
|
+----------+-- Display Name:Account Master
|              Technical Name:GL_Account_MSTR
|              Physical Name:GL00100
|
| INVALID RELATIONSHIP
| IV_Item_MSTR_QTYS_Key4
| Item Number --> Item Number
Report: Item Sell / Cost List (continued)                                                 Page 3
Date/Time: 7/21/2011   8:58:00 AM
| Master Record Type --> Record Type
|
+----------+-- Display Name:Item Quantity Master
|              Technical Name:IV_Item_MSTR_QTYS
|              Physical Name:IV00102
|
| ivItemCurrIdxID
| Item Number --> Item Number
|            --> Currency ID
|
+----------+<< Display Name:Item Currency Master
           |   Technical Name:ivItemCurr
           |   Physical Name:IV00105
           |
           | ivItemPriceListOptIdxQtyInBase
           | Item Number --> Item Number
           | Currency ID --> Currency ID
           |            --> PriceLevel
           |            --> QTY In Base U Of M
           |            --> U Of M
           |
           +----------+<< Display Name:Item Price List Options
                      |   Technical Name:ivItemPriceListOpt
                      |   Physical Name:IV00107
                      |
                      | ivItemPriceListIdx_QtyInBase
                      | Item Number --> Item Number
                      | Currency ID --> Currency ID
                      | PriceLevel --> PriceLevel
                      | QTY In Base U Of M --> QTY In Base U Of M
                      | U Of M --> U Of M
                      |            --> To QTY
                      |
                      +----------+<< Display Name:Item Price List
                                 |   Technical Name:ivItemPriceList
                                 |   Physical Name:IV00108
                                 |
                                 | ivItemPriceListDtl_SBM_Key1
                                 | Item Number --> Item Number
                                 | Currency ID --> Currency ID
                                 | PriceLevel --> PriceLevel
                                 | U Of M --> U Of M
                                 | To QTY --> To QTY
                                 |
                                 +----------+-- Display Name:Item Price List Details
                                                Technical Name:ivItemPriceListDtl_SBM
                                                Physical Name:IV00113
SORT SEGMENTS:
Item Generic Description of table IV_Item_MSTR (Nocase)
RESTRICTIONS:
Restriction:      Price Level
Report: Item Sell / Cost List (continued)                                                 Page 4
Date/Time: 7/21/2011   8:58:00 AM
      Expression:       ivItemPriceListOpt.PriceLevel = 1