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
0
votes
1 answer

ACCPAC and Excel Spreadsheets

Is there a way to reference ACCPAC in VBA for Excel 2010? I am wondering if information from a spreadsheet could be programatically entered into our accounting database by running a macro from within Excel. I have just been studying a macro I…
armadadrive
  • 963
  • 2
  • 11
  • 42
0
votes
1 answer

ACCPAC DataDict Table

Anyone know what is being stored in the TABLEDATA column in the DATADICT table in ACCPAC database? I tried converting the binary column to text and was not successful. Please let me know if anyone can shed some insight.
sam yi
  • 4,806
  • 1
  • 29
  • 40
0
votes
1 answer

How to get OrderNumber in Sage Accpac after entering order with macro script

I have recorded the process to create an order and quote in Sage ACCPAC, and i put the code in a VB 6 application, it works perfectly and adds a new quote / order. But what i need is that i want to get the generated ordernumber or orduniq within the…
King Khan
  • 49
  • 1
  • 11
0
votes
1 answer

Sage Accpac Ireport method failed

We had a macros developed in our company that used to export files to an Excel format and then inserted those values in the Sage ACCPAC Payroll module. For some reason the code has stopped to respond, and it gives an error: method ireport of…
user1343318
  • 2,093
  • 6
  • 32
  • 59
-1
votes
1 answer

VBA xlUp error in macro

can anyone help me? i have this syntax Dim oExcel As Variant Dim oWB As Variant 'Set oWB = CreateObject("Object.Workbook") Set oExcel = CreateObject("Excel.Application") Set oWB = oExcel.Workbooks.Open("Z:\MPR\Maret 2017\31 - 03 -2017\DF\PAL -…
Fenny
  • 41
  • 9
-1
votes
2 answers

Changing a preset in ACCPAC Pro Series 6.0

I'm trying to change a preset in the Accounts Receivable section of ACCPAC Pro Series 6.0 (accounting software). I'm looking for the file, I think it's with a .prg extension, that would hold any preset information for the Accounts Receivable module…
1
2