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!

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

Search results for query: *

  1. Adam007

    Override TAXCLASS1 & TAXCLAS2 in AP Batch

    Hey Ettiene, Well it wasn't the Tax Group, but some other field. Im not entirely sure if it was because i was setting a field after that was messing it up or if it was the detail lines i was adding after i set the TAXCLASS but i moved it to right before the Insert call and it's working now...
  2. Adam007

    Override TAXCLASS1 & TAXCLAS2 in AP Batch

    Hey Ettienne, I did record a macro in Accpac and all it did was set TAXCLASS1 and TAXCLASS2 to '2'. Which is what my code IS doing. any other ideas?
  3. Adam007

    Override TAXCLASS1 & TAXCLAS2 in AP Batch

    Hey Guys, I am trying to set the TAXCLASS1 & TAXCLASS2 fields while creating an AP Batch from C#. Code Sample: tempObj = header.TAXCLASS1; APINVOICE1header.Fields.get_FieldByName("TAXCLASS1").set_Value(ref tempObj); tempObj = header.TAXCLASS2...
  4. Adam007

    How to integrate GL with our system without Accpac SDK

    Hey, Just thought i would point you to a post i made the other day about C# and Accpac. http://www.tek-tips.com/viewthread.cfm?qid=1575040&page=1 Let me know if you have any problems and as a fellow .NET guy ill try to help. but is BANG on accurate.
  5. Adam007

    Cant Log In With XAPI, But COMAPI works fine

    Ok, well after doing some testing, i can now say for sure that it is NOT limiting the number of records returned from the database. So that being said i guess my problem is resolved and i would like to thank you guys for helping me out on this one. One thing tho, if you could point me in the...
  6. Adam007

    Cant Log In With XAPI, But COMAPI works fine

    @DjangMan OMG, thank you soooo much. Now i just have one more relatively simple question, from what i can infer AccpacView.InternalSet is setting the max amount of records returned from the query. Now i have checked all the Docs installed in the Pluswdev directory installed with the SDK but i...
  7. Adam007

    ACCPAC COMAPI / EXCEL / FR QUERY

    Not to be a smart ass or anything, but did you try calling Close() on the session object?
  8. Adam007

    Cant Log In With XAPI, But COMAPI works fine

    I just thought I would post the entire function so you can see the whole thing and run a test if you need / want to. Structs /// <summary> /// Represents the relavent data from the OECRDH table /// </summary> public struct OECRDH { public string ORDNUMBER; public DateTime ORDDATE...
  9. Adam007

    Cant Log In With XAPI, But COMAPI works fine

    The issue with using the CS0120 view from the COMPAI is as follows, If i run this query using the CS0120 view; SELECT CRDUNIQ, OEINVH.SHINUMBER, OECRDH.CRDDATE, OECRDH.LOCATION, OECRDH.CUSTOMER, OECRDH.PONUMBER, OECRDH.SHPCONTACT, CRDUNIQ FROM OECRDH INNER JOIN ARCUS ON ARCUS.IDCUST =...
  10. Adam007

    Cant Log In With XAPI, But COMAPI works fine

    Yeah, thats the first thing i checked. Thx for the idea though.
  11. Adam007

    Cant Log In With XAPI, But COMAPI works fine

    Hey All, I have an application that i have built and tested on 4 different machines (XP, Vista, Server 2008, Windows 7). The application is built in C# and i haven't had an issue in my test environments. Now that we are ready to start testing on the client machines, we are getting an error...
  12. Adam007

    Interop error -2147467259

    Well I'm not sure if you resolved your issue yet, but here are some things that could help. First of all you want to use the 'ACCPAC XAPI 1.1 Type Library' COM reference from your project. This will give you access to the object you need to get the job done. I know all the examples that Sage...
  13. Adam007

    Issue deploying application

    Ok, so I got it, im not sure exactly what it was but here is what i did. 1) excluded A4WCOM.dll from my installer. 2) marked my application as x86, i know this sounds weird but when it was left as 'Any CPU' it would fail to instantiate the COM interface. After i made those 2 changes together...
  14. Adam007

    Things i learned working with C# and Accpac

    Hey All, Recently I had to do a project using C# and inter operating with Accpac 5.5, I decided to post here to let everyone else know the hurtles i had to jump to get the project completed. 1) When using Accpac from C# (or VB.NET) you must make a reference to the COM component 'ACCPAC XAPI...
  15. Adam007

    Issue deploying application

    Hello ettienne, It would seem that your here again to help me out. If i knew where you lived (not eStalking you) i would definitely by you a beer. 1) Accpac 5.5 on both development machines and deployment machines. 2) C#, I think that could be the problem, A4WCOM.dll is being added to my...
  16. Adam007

    Update OEINVH shipping tracking number C#

    tuba2007, thanks to you as well. Both of you guys (yourself and ettienne) are great examples of educated people working in forums. You both deserved the stars i gave you. THANKS AGAIN YOU GUYS ROCK.
  17. Adam007

    Update OEINVH shipping tracking number C#

    ettienne, Thxs for your input, i didn't know i could drop the OECRD1headerFields = OECRD1HeaderFields; and i too am a minimalist, so you can bet thats coming out along with the DrivenBy lines. Thanks again for all your help i really appreciate it.
  18. Adam007

    Issue deploying application

    Hey All, I am having issues deploying an application that i have built using the ACCPACXAPILIb. If i deploy the application to a machine running XP everything works fine, BUT if i deploy it to Vista, Server 08 or Win 7 i get an error when trying to instantiate an instance of xapiView, it gives...
  19. Adam007

    Update OEINVH shipping tracking number C#

    Hey Guys, Sorry for the long delay responding to this, i'm usually much better at getting back to the forums. Anyways, here is the code that ended up working for my with the best performance; YES i know these are the Credit Note views, i copied the wrong code but it should still be the same...
  20. Adam007

    Update OEINVH shipping tracking number C#

    Hey tuba2007, Thanks for the quick reply. Now I'm not entirely sure this is working properly here is what i changed; foreach(string ordInv in invoices) { OEINV1header.Fields.Item("INVNUMBER").PutWithoutVerification(ordInv); OEINV1header.Browse("(INVNUMBER = '" + ordInv +...

Part and Inventory Search

Back
Top