Search results for query: *

Yes, I was querying the header table but that's not the best way to get the PO Number when I have multiple users creating PO. That's why I was wondering if it's possible to capture the created PO number return when post.

Hello, Does anybody knows how to get the PO number that just got created/inserted? I ran the recorded vba code and it ran with no errors, but how do I know what's the PO number? I would like to put up a message box to show the created PO number that just got inserted. Thank you.

Hello, Can somebody explain to me and provide some snippet code on AccpacSessionManager vs. AccpacSession. I am a little bit confuse between the two in converting vba to .net. I know the AccpacSession uses: Session.Init("", "XY", "XY0001", "60A")...

Ok, I figured it out. We actually passing in the accpac database id to the COM. Thanks tuba2007 again for my newbie questions. As you can see. I am really new at Accpac. Your help is greatly appreciated! Thanks.

Yes, but if I recall correctly. Accpac uses DNS to log into SQL Server. My setup has multiple companies that have two DNS one DNS for each company. So when I pass in the my database name DSDAT. Which DNS will Accpac use to connect to SQL Server? Maybe I am not asking the right question. But my...

Hello, Can someone please clear a few things up for me when we're converting vba to .NET on how to handle/log in Accpac? Here's the setup. Accpac is install on APP_SERVER1 and a backup APP_SERVER2, the data is on SQL_SERVER and back a on SQL_SERVER2, and 10 users are connected via RDP to...

Cool. First time converting VBA to anyting and from Accpac does not help either. I figured out the problem by postponing the update. Thank you for your help and input. Greatly appreciated.

Oh, that's cool. But from your experience, why would the recorded macro ran fine in Accpac but converted version in the same order error out because of the update before insert? Now I am not sure where and which insert to run first before the update. If I convert vba to VB6. I am guessing the...

Yes, that's how I started. I recorded a bunch of macros and study the what it does. After that I attempted to convert the macro to .NET. The recorded macro runs fine in Accpac for creating a PO in the same order. But converting the vba to VB in the exact order it gave me that error. So that's...

So are you saying I should do my inserts like line numbers, header first before I update? Also, does the order of the insert matters? POPOR1detail1.Insert() POPOR1header.Insert() POPOR1detail5.Update()

Hello all, Can somebody please point out what I am doing wrong with the below code. Why am I getting the error "Error HRESULT E_FAIL has been returned from a call to a COM component." when I hit that line "POPOR1detail5.Update()" when trying to create a PO in Accpac 6.0 POPOR1header.Order = 1...

Please ignore the question. I found my answer. It's in the way of calling the AccpacCOMAPI.

Hello all, I was ping with a task to convert some vba process to C#. I am fairly new to Accpac and how it works. I am on Accpac 6.0 and I've recorded a vba to create a PO. I've been reading this forum on learning how to convert vba to C# and I am stuck at these lines and hoping someone can help...