Sales Order Form Personalization
Hi All,
Working in OPM Ver: 12.1.3
In Sales Order form personalization the list price 4.2 and cost is 4.26
the condition is
4.26 greater than 4.2 the message is not showing due to decimal
when i put same 4.26 greater than 4.1 then it is displaying message
below script
-------------
:ORDER.SOLD_TO_ORG_ID NOT IN(64642,64667,65003) and (select trunc(scsa_actc_cost(:line.inventory_item_id,:line.org_id) /(1-
to_char((case when (iim.attribute2 in ('SBIN', 'WBIN')) then 25
when (iim.attribute2 not in ('SBIN', 'WBIN')) then 20
end
)) /100),2) sp
from mtl_system_items_b iim
where iim.organization_id = 94
and iim.inventory_item_id = :line.inventory_item_id) > :LINE.UNIT_SELLING_PRICE