• System.AccessViolationException with ACCPAC.

    Hello Experts, Facing the below error while accessing the ACCPAC API. System.AccessViolationException at AccpacCOMSVR.AccpacSvrViewClass.Process() at ACCPAC.Advantage.Server.View.Process(FieldValue[], Int32[]) We have a .Net based windows service…
  • Extender

    Hi, is there anyone using the Orchid's Extender module in Accpac 2019? I want to display a message box when the next button is clicked.
  • Macro PO Order

    how to retrieve vendor number values ​​on the PO Order screen using macros Thanks,
  • Setting paper orientation in VBA

    I have a macro that prints out some reports but I need to set the paper orientation to landscape. Is there a way to set that in the macro? The Crystal Report is designed to be landscape but when I send it to the printer in the macro it prints portrait…
  • I/C Transfer Suppress Print Transfer Slip Confirmation Dialog box

    Hi, Is there a way to block the Print Transfer Slip Confirmation Dialog box from appearing for IC Transfer. We have created a custom Print form and wish to suppress the standard Print confirmation alert box which appears after Saving or Posting a Transfer…
  • AccpacPrintSetup crashing after upgrading to SAGE 2020 PU2

    In previous version, SAGE 2017. This code works fine. But after upgrading, it crashes. Dim oRpt As AccpacCOMAPI.AccpacReport oRpt = oSession.ReportSelect("APWMSSOFTRMT[APWMSSOFTRMT.RPT]", " ", " ") Dim oRptPrintSetup As AccpacCOMAPI.AccpacPrintSetup…
  • System error. Call to lnkCommitTrans failed [227]

    Hi Am getting this error when adding or posting an AR Invoice batch in Sage 300. System error. Call to lnkCommitTrans failed [227] I recently did a database move using the dump and load. Now my AR batches dont want to post. What could be the…
  • Sage GL Consolidation Module Integrate with Navision & SAP

    My company is using Accpac system but the sister organisations are using Navision and SAP. To consolidate the GL transaction, we plan to develop the interface files which generated from Navision and SAP. However, Accpac GL Consolidation Import required…
  • Unable to post via Task Scheduler - System.Runtime.InteropServices.COMException (0x80004005)

    When the user is login and the Task Scheduler fired up, the posting in SAGE is successful. But when the user is Signed Out and Task Scheduler fire up. We received an error: Error: External component has thrown an exception.. Inner: . Full: System…
  • old company data lost during creating a new company

    Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…
  • SUBVIEW.dll causing AccessViolation

    Does anyone here encounter an error for the SUBVIEW.DLL? We created a WEB API, when deployed it is fine when creating single calls. But when doing multiple calls simultaneous we got w3wp.exe error. Upon analyzing the dump file it shows: \ vi65a\SUBVIEW…
  • Print Report - Error on running connectcomaddin in macro

    Client has been running fine and this just this week we have been getting errors trying to use Financial reporter. I suspect a microsoft update but they are saying none applied. (I know don't belive them ) either way I need to know what one it was …
  • Account payables - entries

    If I'm using and external program for employee expenses report. Is it possible to import the file in accpac to create invoice in my account payables? Or, I will have to enter it manually one by one?
  • How to reduce Sage300's database

    I would like to know if there is a way or a tool that can be use to reduce Sage300 database. I have a company database of 90GB size with data since 2000.
  • Sage Accountants Network (SAN) Client Advisory Services (CAS) Program

    Deliver more value. Increase profitability. The Sage Accountants Network Client Advisory Services Program , created in partnership with Boomer Consulting, guides you to create a clear and concise strategy for increasing value and profitability by providing…
  • Accpac.exe zero file size

    it seems in the last couple days most antivirus software is flagging accpac.exe as a virus and zero file size, alternative there is some virus/malware that is specificly targeting Accpac.exe. what can be done?
  • Reconciling WIP account in PJC environment

    We are using Sage 300 Premium 2018 (Accpac) with the Job Costing module. I don't have a method of auditing the balance of the WIP balance sheet account. The balance is climbing, and it is as if transactions are being "dead-ended" there and not flushed…
  • Migration From Sage Accpac ERP 5.3 with Pervasive 8 to Sage 300 ERP 2018 with SQL Server 2017

    I have a Sage Accpac ERP 5.3 using Pervasive 8 but we want to migrate to Sage 300 ERP 2018 using SQL Server 2017 someone knows the best way and best pratices to do it please
  • Check template for reimbursement

    I'm trying to reimburse a customer, usually I could choose my my check template... now I can see where to change it because we moved our templates to another drive and I don't see where I can change it.. When I click on "browse" it stays in that folder…
  • Invalid CSV format

    HI, We have applications that generate payment batches that are imported into Sage 300 AP module. We were generating them as a Single CSV file. Everything was going well until version 2019. I realize there are a few extra fields in one of the tables…
  • Sage 300 2018 Error on export button

    Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages . As soon they click on export button the following error is received. generally user tends to run the…
  • Possibility to customize sage

    We are looking for a software for our university. Can sage customize based on our requirement.
  • Sage 300 erp 2014 (6.2) email function

    Hello, Does anyone know how to set up the email function to sent email directly from the system? How to connect The outlook to the system? Thanks.
  • Print Preview not working - Sage 300 2018 PU2

    Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018. When trying to print preview any default sage reports get error message. Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…
  • Company Profile

    SMTP checked How can you configure email to register in the outlook sent items when using office 365. Can it work when both using the desktop client and the webclient?