Search results for query: *

dear all , I have to install accpac 5.0 on windows7. while executing setup file of SM (accpacIII) compatibility error occured. how can i fix this problem. plz guide thanks

dear all, whilie executing day-end process i encounterd error (Internal error. pcsStart error (1046 ICDEP1.C). ) can anyone help me to fix this error thanks

hi all, can any one tell me the link to download free simulator 4th eddition thanks

Hi all, i want to conatact some PMP professionals, can any one plz tell me the link of FREE simulator for PMP or any one can share me the one for latest eddition Thanks

it gives error with every field in where and from as well. I tried it with different ways with syntax error with {?pram}........... Note: I m working in CR 10

{?enterdate} was numaric when i used through crystal report select expert, and expdate is also numaric. But plz tell me why this statement gives me syntax error ... wats problem with this and o.expdate = {?enterdate} wats problem with this {?enterdate}

Dear sir its very much true that you've done 100s rather 1000s and i've done hardly 10s but plllzzz help me to getrid of this error i.e without qoutes it gives syntax error thouth its of type string... following is my complete query SELECT TOP (100) PERCENT o.expdate, M.SEGMENT2...

if i don't enlcose in qoutes it get syntex error. on the other hand string date param mismatches wity table's date field which is numeric/decimal

Dear All, I am trying to get user input for date (getting prompt to enter date) and have following satement with left outer join in my query ( and cast(o.expdate as varchar) = '{?enterdate}' ) but when i use single qoutes in '{?enterdate}' error found (faild to convert text data type to...

Dear all, I as per ur advise i use left outer join ...but still can't get desired results. plz tell me wat's wrong with this query as it doesn't give me all items from table "m" with null values in table "O" SELECT TOP (100) PERCENT m.SEGMENT2, isnull(SUM(o.UNITPRICE * o.QTYSHIPPED),0) AS...

Dear All, In my following query I join tables of sales and description of itemno SELECT TOP (100) PERCENT O.EXPDATE, O.LOCATION, M.SEGMENT2,M.SEGMENT3, O.[DESC], SUM(O.QTYSHIPPED) AS QTY, SUM(O.UNITPRICE * O.QTYSHIPPED) AS AMT, dbo.ICLOC.[DESC] AS Loc, M.OPTFLD5,icsegv.[desc] as...

there is no duplication found ... here is output of spy file.plz suggest.. thankx [d08] AS0021: ASRST [12:34:08.84].Load [d08] AS0021: ASRST [12:34:08.87].Open(PIB=2046, link=73) [d08] 0 <==[12:34:08.89;t=16;ovh=0] {view=0x008e4d94} [d08] AS0021: ASRST...

But there is no duplication, record is newly created and unique. Please guide me the tables and field values to track why and where the value is being duplicated

I have following error during compilation of script for DB tunning "Server: Msg 102, Level 15, State 1, Procedure dba_indexDefrag_sp, Line 464 Incorrect syntax near 'OBJECT_ID'." please help in fixing it...thanx

Dear all, while importing invoice in accpac 5.0, I received an error " Description: Order. Record already exists.". plz guide me the solution to fix it.

I am working in ACCPAC 5.0 with SQL-Server Express. My server is getting slow and it takes a lot of time in executing crystal reports and queries. I want to fine tune DataBase just like DB tuning in oracle. plz tell me the tool/procedure to do the job. Thanks

Dear All, plz give me solution for the following error occurred during attempt in posting (for all batches in the list) Description: Internal error. Call to pcsDelete failed. Source: 17:10:25

last few lines in the rvspy log file is given below.you plz tell me the error and how to fix it..... I am unable to do so [d20] 0 <==[16:34:46.37;t=0;ovh=0] {} [d20] AP0004: APP04 [16:34:46.37].Load [d20] AP0004: APP04 [16:34:46.37].Open(PIB=2046, link=20) [d20] 0...

Data integrity check is ok but still the error exists. wat's the solution?

I have an error while posting batch in AP module in ACCPAC 5.0 ["Internal error. APIVPT: det AP option data failed (6633 APIVPT1.C) Error Occured during posting no error batch created"] plz suggest solution as all other batches are pending due to this