Search results for query: *

Hi, here is what i want to have happen (If {CUST_ORDER_LINE.UNIT_PRICE} <= {PART.UNIT_PRICE} then [({CUST_ORDER_LINE.UNIT_PRICE} * {CUST_ORDER_LINE.TRADE_DISC_PERCENT}) when {CUST_ORDER_LINE.TRADE_DISC_PERCENT} <> 0 ] else {PART.UNIT_PRICE};) * {RECEIVABLE_LINE.QTY} i am sure it is a syntax...

Hi, I have a report where i would like to have 1 column that will look at 3 fields, (part.fabricated, part.purchased, and part.detail_only) these fields have either a "Y" or "N". What i would like to do is have a formula that says "if part.fabricated = "Y" then "F" else part.purchased ="Y" then...

Here is the selection criteria i have : ( ({PART.QTY_IN_DEMAND} <> 0.00) and ({PART.ORDER_POLICY} <> ["D", "E"]) and ({PART.DETAIL_ONLY} = "N") and {PART.ENGINEERING_MSTR} = "Q" ) OR ( ({PART.QTY_IN_DEMAND} <> 0.00) and (({PART.PLANNING_LEADTIME} = 0.00) OR ISNULL({PART.PLANNING_LEADTIME}))...

I have a report where i have figured out how to pull the most recent 12 months of part usage, here is the select statement: {INVENTORY_TRANS.PART_ID} like {?PART_ID} and {INVENTORY_TRANS.TYPE} = "O" and {INVENTORY_TRANS.TRANSACTION_DATE} >= dateadd("yyyy", -1, currentdate) and...

Hi, i know this is noob issue but i need to get transaction info for previous 12 months and previous 6 months with monthly average for each. Here is select expert: {INVENTORY_TRANS.PART_ID} like {?PART_ID} and {INVENTORY_TRANS.TRANSACTION_DATE} >= Date (0, 0, 0) makes sense to me...