• Emailing 1000's of invoices out or Sage in error

    I had a customer that wanted to email out invoice in Sage 300 but before she selected the range of invoices, she selected delivery method of customer and clicked print. OOOHHH NNNOOO!! Panic!!. over 4000 invoices were going to either be printed or emailed…
  • Sage300 GL Financial Report print to file error

    Sage300 v6.0 using RDP. only one user has problem. FR Preview is normal. When generate report by print destination as file. a blank error message open. the file select screen's capture is adnormal If ok, it will hanged. Any hints?
  • open session in Windows Service

    I created vb.net application which run some macros, as desktop application it is working well, then I converted it to Windows Service also it is working well on my device but when I moved it to Client server I got : "Connect System.Runtime.InteropServices…
  • User Activity Report

    sage300 v7 (2023) sp1 fresh install. I can't get user activity to show any details. it comes out blank. running it as admin the company has had users using it for a month now
  • Accpac 5.5a

    Hi, we currently are using AccPac 5.5a version and we would like to see what options we have to move to newer versions. We run a small business and AccPac 5.5a is perfect for us but do realize its time to upgrade. Currently our systems run on Windows…
  • T5018 (CPRS) Print Form Option No Longer Available To User.

    Hi Everyone, We seem to be having an issue with our A/P Vendor Reports. One of our users was able to run a T5018 form from the "Print T5018 (CPRS) Forms" icon on Feb 10th. Now when she goes to run the report the icon is no longer shown, along with the…
  • Sage 2019 Payroll 7.3 and January 2023 Tax Table update

    Just putting this out there, to see if anyone has attempted to install the January 2023 Payroll Tax Table update on Sage version 2019.
  • Sage 300 Web Api - Ready To Post

    I'm working on the Sage 300 Web API to pass Customer Receipt to Sage 300 version 2021. In the Github documentation, it mentioned that we could set the Batch Status as Ready To Post on the POST request. A separate PATCH request is not required as the…
  • Sage 300 2022 API

    Hello, Does Sage 2022 allow API calls via COM? We use Sage 2014 where we utilize A4WCOM.dll as a COM object. Can't seem to do the same with Sage 2022. I read somewhere that it's now a web API call Thanks for any info
  • CS0120 data to accpac finder in COM API

    Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …
  • Banking Details Table

    Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…
  • crystal report error

    Hello, I am using SAGE/ACCPAC on a local computer and trying to run a "A/R Aged Trial Balance Report" but I am getting the following error after clicking the print button. A window with the heading " Crystal REports Windows Forms Viewer" with the…
  • Payment Batch Import Into Sage 300

    Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…
  • Sage 300 GL batch posting freezes

    Sage 300 Premium (Version 2022) SQL 2019 on Windows Server 2019 GL batch posting freezes during month end closing periods and Sage 300 becomes inaccessible for anyone who wants to further login. Other logged in users won't be able to post from GL…
  • Financial Statements fails to open in MS Office 2019 Pro Plus

    Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…
  • Inventory transfer macro is failing when negative levels allowed

    I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2 I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5. Location 1 had zero of these items and so…
  • Automatic Shipping and invoice Order Entry

    Here is our scenario. We give a customer a qoutation in Order entry. The customer then goes to the cashier to pay or payonline. Then the receipt is taken back to our sales team to ship and create invoice. Isnt there away that at the time of paying the…
  • Database error (operation=REV-POST, error=229)

    We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…
  • Sage .NET API Errors

    In the Session.Init method, I'm getting an error that just shows 1.4197.5 I have no idea what this means and don't see documentation anywhere that explains it. Can anyone help on what this means?
  • Statetement designer - not updating current year figures

    Hello, I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs…
  • Failed to import the ActiveX control. Please ensure it is properly registered.

    Hi all, We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project). The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered. We have registered the accpacic1500…
  • Accpac Plus conversion to Sage 300 (5.4) OE Error: The Price List is not in use for this item and specified customer. How do I fix this?

    I have all modules converted (OE Tax, GL, AP, AR, IC), but have error when trying to convert OE. There is nothing that indicates what Price List, Item or customer. This is Multicurrency data (CAD, USD, EUR). IC has 6 Price List (3 CAD, 3 USD), ALB, ALBX…
  • Crystal Report Error

    I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears
  • Failed to import the ActiveX Control

    Having problem with my SAGE 2020 (300 Premium) (Build 0) When I tried to add COM Components for example AP2100 (AccpacAP2100.AccpacAP2100UICtrl) and drag that to my Empty Project .NET (VB), it show's the error below (Failed to import the ActiveX…
  • Importing Transactions into Project and Job Costing

    Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…