Search results for query: *

@ettienne , unfortunately this accpaclogin.InitiateConnection("AS", "AS1000", VERSION, USERID, PASSWORD, MAINDB, ref errMsg); line of code works for Windows Application without WCF code (standalone application without IIS , with the same parameters given) , so it seems that it is NOT the User...

@ettienne thanks for reply but Password is UPPER case or Lower case same issue is there , the server application is hosted in the IIS 7 , client application is a windows form application , I have added the app.manifest file also , so the windows client will run on windows 7 OS as Administrator...

I'm develoing WCF with VS 2010 for Sage ACCPAC 6.0 , but when trying to login with valid login credentials , still the inner exception says invlid signon informattion , the code is listed below , need some help. The UserBL._accpacSession.Open method returns an Exception WCF server code...

this was my final solution and working fine SELECT SUM(AMTPAYMTC) AS AMTPAYMTC, IDCUST, IDRMIT FROM AROBP WHERE TRANSTYPE = 11 AND IDINVC LIKE 'PY%'

@ettienne I have included the screen in ACCPAC 6.0 , the values are not matching with the above mentioned query I need a help on the SQL Query , may be I'm referring to wrong table

I'm creating a csharp application to input Customer number and get the Advance Payment Amount from Sage ACCPAC 6.0 I'm referring the below SQL for getting the value SELECT SUM(AMTEXTNDHC) AS AMTEXTNDHC, IDCUST, IDRMIT FROM ARPJD WHERE (ACCTTYPE = 1) AND (IDCUST = '???')...

I have this csharp application where some items have 3 tax classes defined in accpac 5.5 and some items in IC 2 tax classes have been defined. So far the integration is working FINE , but for items that have been set up 2 tax classes some issue is happening as when AP invoice have undistibuted...

[sad] oh.. anyway thanks for replying

I'm developing a csharp windows application and integrating with ACCPAC 5.5 to pass data to IC module , and some times when number of users exceed the user licence limit , application passes a error "Accpac advantage error".(I'm accessing ACCPAC IC module by login as ADMIN(ADMIN user in ACCPAC)...

thanks , i'll try and see .... My SQL query was incomplete up to this time ... now there is some hope

Hi, I'm new to ACCPAC 5.5 version , just want to know how to find the Amount settled figure for a specific Invoice? , because in order to get the a report in crystal report I was trying to connect APIBH and APPYM tables together and found out only Supplier id is only link but that is not enough...