Stack Overflow
Stack Overflow

Questions tagged [accpac]

Accpac is the common name for the Sage ERP Accpac line of Accounting Applications, primarily serving small and medium sized businesses.

21 questions
3
votes
4 answers

ACCPAC Tables

I'm doing some work with ACCPAC and don't have the benefit of any documentation. Specifically, I'm looking for: ARCUS ARIBD ARIBH AROBL If you could tell me what the columns are as well, that'd be doubly benificial.
Matt Grande
  • 11,964
  • 6
  • 62
  • 89
3
votes
1 answer

ACCPAC Missing Method Exception

I have a ASP.NET Core 1.1 webserver running on full .NET 4.6.2. I am using the ACCPAC.Advantage.dll's (packaged in a custom NuGet bundle) to connect to a local Sage installation. Previously connections were successfully initiated and I was able to…
Jim Buck
  • 2,383
  • 23
  • 42
2
votes
2 answers

Writing to a sql database in accpac

I've got a VB script that's being run by AccPac. I want to add error logging to the script. I'd love to have that log go to a database. I've heard it's impossible to connect to a SQLdatabase from the VB script. I'd like to prove this…
baash05
  • 4,394
  • 11
  • 59
  • 97
2
votes
0 answers

Sage 300 (accpac) SDATA Create Customer

I'm trying to use SDATA to create a customer but can't seem to find the proper endpoint. I've scoured the schema and have only found wkshpcustomer, but nobody seems to know what that object is. I can, however, create an order without issue: [POST]…
Evan
  • 457
  • 3
  • 22
2
votes
2 answers

SQL Server adding one month to a date represented as an 8 digit decimal

A SQL Server application we use (accpac) represents dates as an 8 digit decimal in ISO format (example: today's date is 20100802) I need to add one month to this. I've found a way to do it, but there must be a better way. The steps of my solution…
Tim Richardson
  • 6,608
  • 6
  • 44
  • 71
2
votes
2 answers

Accpac API documentation

I'm working on a C# .NET application that needs to integrate to Accpac 5.6. I have not been able to find any useful documentation on the Accpac API. Where can I find Accpac API documentation?
JJ007
  • 43
  • 1
  • 6
1
vote
1 answer

WCF Sage Accpac 6.0 login error

I'm developing WCF with VS 2010 for Sage ACCPAC 6.0 , but when trying to login with valid login credentials , still the inner exception says invalid sign on information , the code is listed below , need some help. The UserBL._accpacSession.Open…
Sanjeewa
  • 555
  • 1
  • 9
  • 22
1
vote
0 answers

Error appears in Accpac integration

I'm trying to do an integration between sage 7.0 and 5.5 and when i try to open a session i get an error Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) I tried every solution online the target machine is set to…
SahemS
  • 11
  • 1
0
votes
1 answer

Backgroundworker / Thread.Sleep on Search

I have a BackgroundWorker that I use on a Search. Two different Searches can be done, one to a SQL DB and another to an Accpac DB. To accommodate for slow execution time to the Accpac DB, I use Thread.Sleep. The problem is, when I do a search on my…
Melanie
  • 584
  • 2
  • 11
  • 31
0
votes
1 answer

Accpac import orders with vb

I'm attempting to import orders into accpac. I've encountered a snag. I have a macro(avb) that I've used in the past to import Items, PO's and receipts. So I'm not strictly a virgin. The code is written to be portable and when given the correct…
baash05
  • 4,394
  • 11
  • 59
  • 97
0
votes
1 answer

Sage 300 (accpac) SDATA: Create Order

I'm attempting to use the Sage SDATA Rest Service to create an order. So far I can't seem to find what components make up an order in oeorders. Here's the Endpoint that I'm trying to hit: [POST]…
Evan
  • 457
  • 3
  • 22
0
votes
1 answer

How to view data before insert in VBA?

I have a VBA macro (not an Excel macro) that is pulling data from one system and inserting into another that is failing. Is there a way to write to a text file the data it is trying to insert? I want to see the state of the data before trying to…
CoffeeCoder
  • 181
  • 2
  • 2
  • 13
0
votes
2 answers

Open a sage 300 AccPac DBLink Connection to a session

I am trying to write c# code around opening a Sage 300 Connection using C#. I am using the Acccpac.Advantage DLL. Here is my code try { sage300Session.Init(sessionHandle, appID, programName, appVersion); sage300Session.Open(_user, _ppswd,…
jvoigt
  • 400
  • 4
  • 23
0
votes
1 answer

Order creation in sage accpac 300 erp version 5.5 in c#

I am new to sage Accpac Erp. I want to create order in sage accpac 300 erp version 5.5 using .net API (c#) . I am struggling to find the sites for sample code to create order in sage accpac. I referred following sites …
Ram
  • 2,532
  • 4
  • 22
  • 25
0
votes
1 answer

ACCPAC O/E import from EXCEL quote sheet

Have a head cracker here, want to bring the stress levels down and productivity up at work, so here is what I was thinking... I want to use a Excel quote form and link it to ODBC Pricelist (for item numbers and resent cost) and after the quote is…
Alex Que
  • 3
  • 2
1
2