Hi everyone - we're having an issue with Kits and ...
# general
b
Hi everyone - we're having an issue with Kits and Fair Value pricing. We have several Items that are sold as part of kits and also as an add-on to a kit or non-inventory item. When these kit components are add-ons and not part of a kit on a transaction, revenue is being misallocated. We don't see a way to write a FV formula that evaluates whether the item is a kit, a kit component, or neither. [We used such a formula in a saved search to calculate the revenue misallocation over the past 18 mos.] The necessary fields aren't in the formula helper, and I tried pasting in the formula directly, but it errors in the RA. Is it possible to write a FV formula that only comes into play if that item is a kit component? This is the formula from the revenue elment search that I tried to duplicate.
Copy code
CASE WHEN {isbomitemtype}='T' then 0 WHEN {parentbomelement} IS NOT NULL THEN {quantity}*{fairvalue}*(1-{sourcetransaction.custcol_che_overall_discount_pct}/100)ELSE{originaldiscountedsalesamount} END