Recent content by BHAT100

Thanks, it worked have a great weekend Thanks -b

Hi Lbass Thanks for your reply but this formula is giving error at then saying "the ) is missing. if {SOP30200.GLPOSTDT} > {?Sale -End Date} -day({?Sale -End Date} and {SOP30200.GLPOSTDT} < {?Sale -End Date}+1 and {SOP30200.SOPTYPE} = 3 then {SOP30300.XTNDPRCE} else if {SOP30200.GLPOSTDT}...

crystal report 9.0 SQL SERVER 2000 database: great plains

month means month to date, not last full month Thanks -b

I would like display in three separate column on detail column. My report is as below: Group1: Location Group2: Salesperson Group3: Customer Group4: Item Details: where I am placing my above formula for Today, YTD and I want to place month formula also on detail column Group footer4: item...

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...

Thank you all, I have found the solutions to this. I ran financial link and reconcile the year again, it worked fine. Thanks again for help -b

I reconciled the years from 2002 to 2005.Upto 2004 it worked well but while raconciling 2005, I got the following error SQL SERVER DRIVE (SQL SERVER) VIOLATION OF PRIMARY KEY CONSTRAINT 'PKGL10110' CANNOT INSERT DUPLICATE KEY IN OBJECT 'GL10110' when I clicked OK, It gave error message that...

Thanks for urgent reply. There is no tree for this report. I run rebuild gl index in frx but I didn't reconcile GL through great plains utilities. I did click yes to message 'reconcile Year now" after combine but that message didn't take me to reconcile window under utilities and I did nothing...

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...

SET UP GL CODE IN LANDED COST ID.WHEN POP USED LANDED AT THE TIME RECIEPT. THIS A/C WOULD BE CREDITED AND AP MATCH THEN THIS ACCOUNT WOULD BE DEBITED

Thanks for your reply, I have made historical stock status report by GL posting date using iv30200, iv30300, pop30300,sop30200 and bm30200 and other tables like item master and class. Now my boss age it, when we are doing aging each item. I need document numbers(i.e. RCT,ADJ,VAR ETC) which...

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