Search results for query: *

I have a sales report, I need to calculate Today sales, month sales and YTD sales. I am using following formula to calculate Today and YTD figures but I am not able figure out how to calculate month's figures. I am using {?Sale -End Date} parameter Any help in month's formula would be great...

GP 8.0 SERVER: SQL FRX: 6.5.184 our B/S Report was working fine since yesterday. I think after I converted GL Account. it is not picking all the tranasctions of few GL Accounts like Retained Earnings etc Is this happening because of FRX dictionaries might have got corrupted or else. Any...

When I am clicking expansion (+),to view various module under it. it gives error says -'menu items not found' Any idea to fix this problem? Thanks -b

server :SQL SERVER 2000 CRYSTAL 9.0 I have linked two inventory table of great plains ( IV30300). This table has purchases qty (lump sum), Which I have put in detail column. the other table (iv30301) have sales against these purchases that have multiple records against one record. What I want...

is there a way to perform aging on historical stock report. I am trying to make report in crystal Thanks Ramesh

can anybody suggest, where I can learn about great plains dictionaries. it always give lot of trouble Thanks -b

I have installed smart list builder on one of test server. after inititaliation it gives error says "The great_plains.vba project reference some objects that cannot be found.These objects are listed in the file: n:\Great plains 80\Dynamics.txt" I copied dictionaries from live system to test...

WHEN I DELETING USER IN USER ACTIVITY WOINDOWS. IT GIVES ERROR ' AN OPEN OPERATION ON TABLE 'SY_END_ROUTINES_CHECK_MSTR' FAILED ACCESSING SQL DATA' IF I CLICK OK TO THIS ERROR, IT GIVES ANOTHER MESSAGE i.e. A GET/CHANGE OPERATION ON TABLE SY_CURRENT_ACTIVITY' FAILED. A RECORD WAS ALREADY...

VERSION: 8 G19 SQL SERVER 2000 Where can find and activate/install adavanced analysis cubes in Great plains or SQL SERVER Thanks -bhat

I want to make sales report by vendors in cystal. is there any table or field can be linked to sop tables to pop tables to pull sales data by vendors -bhat

we are pulling sales account from inventory. and we have following segment in COA - 11- COMPANY - 11- LOCATION -1102- DIV/LOC -110-150- DEPARTMENT -5100- NATURAL ACCOUNT We are pulling div/loc segment from site id segment is there any way we can pull department from customers Any idea...

crystal report: 9:0 sql server I have linked subreport with customerid to main report. all customers are existed in the system. despite that all customers of subreport are not showing in the main report. what ever customers are not existed in the main report. data of those customer are not...

Hi Everyone, crystal report 9.0 server: SQL I don't know I was thinking it would have been easy but i am not able figure this out In the group summary total, where ever there is no data for month column it is not displaying group total '0' and YTD data under YTD Column. Thanks for help -b

Crytal report -8.0 server: SQL server 2000 I have a report which have month data column and YTD data column. My Question: when there is no sales for month but despite having YTD sales.Customer grp total does not displayed for that customer even if that customer does have YTD sales data and...

we are on citrix and frx version is 7.5 I have send email to frx report to user. when user are opening email attachment (frd file) then they get error "error 0" and frx report is not opening. Microsoft outlook email is on the local machines Thanks for any input -b

I am trying emailing FRx Report. I have set email address in output. The report does not generate reports. Any idea would be great help Thanks -BHAT

Crystal 9.0 I have set up (?location) as parameter. it has following option; -Allow multiple value -Range values -set up location default from iv40700 table I want to print the range whatever user enters in parameter on the report but when Place parameter on page header it does not return any...

crystal 9.0 database : Great plains I have set up parameter (?location). is it posible to assign value to parameter in select expert. as below. (?location) in [{locncode.iv40700),{locncode.iv30300) and group by (?location) or any idea how the inter site transfer can be handled in crystal...

I have parameter as {?Location} = {iv30300.locncode} when I am using following formula. it gives me error "a number,currency,string is required" {?Location} in [{IV30300.TRXLOCTN},{IV30300.TRNSTLOC}] Thanks for help -b

I am making inventory report which have inter -site transfers in single table with single record with diffrent two fields transfer from and transfer to fields. This table also have transactions from sales, purchase and BOM. I want to show this single record in transfer from and transfer to...