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}

...following is my complete query SELECT TOP (100) PERCENT o.expdate, M.SEGMENT2, isnull(SUM(O.QTYSHIPPED),0) AS QTY, isnull(SUM(O.UNITPRICE * O.QTYSHIPPED),0) AS AMT, M.OPTFLD5,csopt.data as seg2des FROM icsegv, csopt, dbo.ICITEM AS m left outer JOIN dbo.OEINVD AS o ON m.FMTITEMNO =...

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

...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 AMT, m.OPTFLD5 from dbo.oeinvd as o left outer join dbo.icitem as m on m.fmtitemno=o.item where optfld5 in...

...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 seg3des, csopt.data as seg2des FROM icsegv, csopt, dbo.OEINVD AS O...

...0 <==[12:34:08.95;t=0;ovh=0] {buffer='\e5\1a'} [d08] AS0021: ASRST [12:34:08.95].Fetch(view=0x008e4d94) [d08] 6 <==[12:34:08.95;t=0;ovh=0] {**ERROR**} [d08] AS0021: ASRST [12:34:11.81].Get(view=0x008e4d94, field=0, size=6) [d08] 0 <==[12:34:11.81;t=0;ovh=0] {buffer='\45\58\43\4f\20\20'...

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

...[d20] 0 <==[16:34:46.37;t=0;ovh=0] {} [d20] AP0004: APP04 [16:34:46.37].Fetch(view=0x03f456d4) [d20] 1 <==[16:34:46.37;t=0;ovh=0] {**ERROR**} [d20] AP0004: APP04 [16:34:46.37].Close(view=0x03f456d4) [d20] 0 <==[16:34:46.37;t=0;ovh=0] {} [d20] AP0004: APP04...

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