Search results for query: *

Thanks for your reply. it means I need to create separate parameters for each ?MyArray like MyArray[1] and MyArray[2] -g

Actually my boss wants to enter at least ten different multiple values to pull the report and setting up ten or more parameters are very messy. Please help me to resolve this -g

yeah, it is tricky to create numerous parameters. is there other way to handle this -g

-crystal report 9 -SQL SERVER I tried to pull items using instruction in thread767-711462. it works fine if I am pulling with one descrete value but it doesn't work if I am using multiple values or range of value. if I am changing prameter from descrete value to range or multiple values, it is...

did you say, we can run crystal report from excel. if so could you let me know how? please -g

our auditor wants entire GL database into excel sheet for audit purpose

What is other way to handle this. Can I transfer to access -g

I want to export sql data output to excel but resultant lines are more than 1.5 millions but excel sheet can handle upto 65000 lines in one sheer. Is there any way that I can transfer upto 65000 lines in one sheet and 65001 and onwards move to next sheet and so on please help? -g

we also have same problem everyday. I suggest clean activity table everynight with maintainance procudure -g

Thankyou very much for your reply. I have another question on GL year end. Now my boss is suggesting do not close year for GL but complete year end process for other modules i.e.INV/POP/SOP. we have implemented INV/SOP/POP in NOV 2004 and never closed. we have year 2004 and 2005 open for GL but...

As per thread632-701316, we can enter transactions in sub modules also for closed year. MY question is, if we enter transacitons in POP/SOP module for closed year then would it update vendor summary and customer summary windows for YTD,LTD Figures also or not -g

Hi, I want to place unmatched landed cost in my report and I am not able to identify unmatched landed cost.is there any way I can pull only unmatched landed cost -g

Try vendor inquiry for individual balances. Inquiry -> Purchasing - vendor summary inquiry

Hi, In above script, POP10500.QTYINVCD picksup the QTY if pop type is 2 (invoice) or 3 (invoice/shipment). if POPTYPE is 1(Shipment) and we match shipment then qty matched does not shows up. Do you think, for matched shipments, I should be using pop10600 and for matched landed costs,I should be...

Thanks very much.

I am trying to make crystal report for recieved but not invoiced report. I am using POP10500 AND POP10600 as main tables. What are other tables that I can use. I am not able to understand qty invoiced and qty matched fields in POP10500 Thanks -G

lUVSQL: Just a thought, it may help in valuing qty and cost. use table IV30300,IV30200,BM30200,POP30300,SOP30200 to pull quantities and cost from there for historical stock status report. -G