Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PrisWine

  1. PrisWine

    WCF Sage Accpac 6.0 login error

    @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...
  2. PrisWine

    WCF Sage Accpac 6.0 login error

    @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...
  3. PrisWine

    WCF Sage Accpac 6.0 login error

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

    Get Advance Amount for a Particular Customer

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

    Get Advance Amount for a Particular Customer

    @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
  6. PrisWine

    Get Advance Amount for a Particular Customer

    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 = '???')...
  7. PrisWine

    AP INVOICE Macro - TAX classes issue

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

    Find Number of Concurrent Users

    [sad] oh.. anyway thanks for replying
  9. PrisWine

    Find Number of Concurrent Users

    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)...
  10. PrisWine

    Amount Settled in AP Payment

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

    Amount Settled in AP Payment

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

Part and Inventory Search

Back
Top