Make custom integer field in transaction line in cpq
Summary:
Now i have to implement onhand quantity from fusion into cpq i make data table and have onhand quantity but i want to make field with function
itemNum = "|_s_partID_l|";
orgName = "|organizationName_c|";
results = bmql("SELECT ON_HAND_QUANTITY FROM OhandData WHERE ITEM_NUMBER = $itemNum AND ORGANIZATION_NAME = $orgName");
returnValue = 0;
if (results.size() > 0) {
returnValue = results[0].get("ON_HAND_QUANTITY");
}
return returnValue;
and these value depend on Transaction and transactionline
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):