Search results for query: *

ran it with the new code and it showed 2 items only. the exp dates of the product that showed was 7/15/14

i want to use a static date range on a exp date report for products. i have the following: {TRACE.EXPIRATION_DATE} in (CurrentDate) to (CurrentDate+14) when i add it to the report i get only no records. if i create a parameter for a date range and use that instead it gives me pages of...

i have the statement below that is giving me a total amount of days a product has left until it is past it's expiration day. works great for all locations that are labeled short dated, here is the question, is also puts a '0' for the days left to exp on other location for example Quarantine...

thank you for getting back to me, looks like it worked perfectly, will check it to make sure, thank you again.

I have 1000 products with each one having up to 10 locations for that part. i am looking to show only parts with a qty that is in either QCHOLD, QUARANTINE or SHORTDATED or where there is no qty (out of stock) in any location for that part. Any ideas how to go about this. started with what is...

Yes it does, thank you very much

i am trying to create a static date range for a report.. basically i want any {PURCHASE_ORDER.DESIRED_RECV_DATE} dates that are 3 days before the currentdate to 14 days in he future. any help would be appreciated

we are trying to update the operation types for all operation.resource_id=' qc testing', when we run the script below it updates all resources besides the the "qc testing" resource. UPDATE OPERATION SET OPERATION_TYPE='QC TEST (TYPE1)',SETUP_HRS= '0', RUN_TYPE= 'HRS/LOAD', LOAD_SIZE_QTY=...

got it all worked out, thanks for all

THANKS, re ran the sql statment an got an error: invalid objetc name OPERATION CODE: UPDATE OPERATION SET OPERATION_TYPE='QC TEST (2+118)',SETUP_HRS= '0', RUN_TYPE= 'HRS/LOAD', LOAD_SIZE_QTY= '10000', RUN_HRS= '2', MOVE_HRS= '118', MINIMUM_MOVE_QTY= '', SETUP_COST_PER_HR = '0'...

I am trying to use 2 tables to update date: UPDATE OPERATION SET OPERATION_TYPE='QC TEST (2+118)',SETUP_HRS= '0', RUN_TYPE= 'HRS/LOAD', LOAD_SIZE_QTY= '10000', RUN_HRS= '2', MOVE_HRS= '118', MINIMUM_MOVE_QTY= '', SETUP_COST_PER_HR = '0', RUN_COST_PER_HR= '25', RUN_COST_PER_UNIT= '0'...

perfect, thank you.

hello, i am trying to update a time field in a table and am having issues. what i am trying to have happen is to update any desired_rls_date fields to be 2/18/2014 that are equal to or before the date below (2/18/2014) UPDATE WORK_ORDER SET DESIRED_RLS_DATE='2/18/2014' WHERE DESIRED_RLS_DATE...

oh geeze, thank you

i want to show only Purchase orders for last year and am drawing a blank on it. {PURCHASE_ORDER.ORDER_DATE}= year (2013) then says it wants a date

basic for a programmer, not for someone just learning CR. I understand that i need to write 4 running totals, one each for 30,60,90,120 days. The problem is that i don't know what formula to add to the "evaluate" in the running totals or if this is even where i add the formulas. Filed names are...

Thanks for all your help, this is beyond my writing. I think i'm also not explaining it correctly. Not sure what you wanted running totals on since i only have 1 field that has numbers in.(inv. total) i'll have to get a friend write it for me. I do appriciate all the help you gave me. Thank...

i added the date field in because the field {table.date} does not exist and i wasn't sure what you meant by the following: Now call the variables at the end in differnt formulas for display purposes: whileprintingrecords; numbervar days30 whileprintingrecords; numbervar days60 etc... Sorry...

lost me a bit but i'll work with what you gave me and go from there. thanks for all your help. whileprintingrecords; numbervar days30; numbervar days60; numbervar days90; numbervar days120; if currentdate - {RECEIVABLE.INVOICE_DATE} <= 30 then days30:=days30+ {RECEIVABLE.INVOICE_DATE} else if...

i guess what i'm trying to show is what a client has past due. i'm trying to show what invoice amounts are 30 days, 60 days, 90 days and 120 days. A customer might have 2 inv. open at this time. one inv. might be over 30 days and another might be over 60 days.i'm trying to show in columns what...