• SAGE 300 EMAIL INTEGRATION

    Hello everyone, How can I configure email on SAGE 300 under the company profile to invoke the a clients outlook such that also the sent statements are stored on the sent folder in the clients Outlook? I'm using SAGE 300 2022.
  • Azure VBS script makes active x error

    I used a VBS script to login to Sage300 with task scheduler this technique has worked for many sites and many years Client went to Azure hosting and now...... this line: Set Signon = CreateObject("A4wSignonMgr.AccpacSignonMgr") Makes this :…
  • Posting AR or AP Batches using accpac advantage

    Hi all, I have already created C# program using Accpac Advantage to import AR and AP Batches into sage in Ready to Post Mode. But my client wants it to auto post after import to sage. So, is there any tutorial or example that I can reference for doing…
  • Program screen ID

    hi all, I am following example on this link https://www.sagecity.com/us/sage300/b/sage_300_erp_r_and_d/posts/launching-non-sdk-programs-from-the-desktop to create a screen using C#. I am able to create and working fine. However, the details is not looking…
  • ACCPAK.MAK file not found

    Hi alll, I am trying to compile my module ID but having this error: makefile(19) : fatal error U1052: file 'ACCPAC.MAK' not found - Sage 300 SDK 70A is already installed and activated to few companies (I have ~15 companies, SDK is activated on…
  • Anyone know how to Insert AR Invoice C# ACCPAC.Advantage

    I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…
  • Sage 300 Web API - Sage 300 2020

    Getting below error when calling API for AR module. The 2 config files are enabled ( https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/110205/unable-to-make-a-get-call-using-sage-300-web-api ) and in Sage 300 USER…
  • Hide Delete Button in A/R Receipt

    I'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish
  • 430 error in macro after PU8

    Installed PU8 on server and now a macro with OCX dropped on userform1 does not work on the server where macro is being developed does weird stuff now like 1. no longer generates _OnRecordChange event 2. Set oHeader = AccpacOE1100UICtrl1.UIDSControls…
  • How to make OE CN on account and reference an OE Invoice

    on OE/CN screen you fill in OE/Invoice number and Sage loads details I have certain customers where all OE/CN are on account, trouble is once you erase the OE Invoice# the screen details erase (can we stop this from happening?) I did not want to manually…
  • AR invoice optional field setup auto

    Currently trying to insert a AR invoice detail line by line transaction and the optional field is set as auto insert under the AR/Setup optional field. . Problem: Detail lines are inserted under the AR invoice without the optional field. Source code…
  • Use Browse() with "NOT IN" where clause/filter

    Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.
  • AccpacAR3100UICtrl1 : Invalid object name 'POSTDET' error

    Hi !!, Need help on above thrown the message from one of the UIAppControls of AccpacAR3100UICtrl1 Awaiting soonest reply. thanks and regards, Joshua
  • Attempt to change read-only field 'Header Discount'. when I did not even set the HDRDISC value

    Hi, I encounter this odd behavior while creating a macro to do an OE Invoice Entry. I did not even set the "HDRDISC" value but this error 1144 " Invoice Detail Attempt to change read-only field 'Header Discount'. " keep popping up and I am not able…
  • Error "The customer or item tax class is not valid for this order." during OE Invoice Entry

    Hi All, I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…
  • How to do data filtering in macro VBA?

    Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520
  • How Company Color Code in Hex

    Hi I'm trying to get company color but I haven't the same color with Sage, Someone can help me please Dim Company As String Company = AccpacSession.CompanyID Dim System As String System = AccpacSession.Organizations(AccpacSession.CompanyID).SystemDatabaseID…
  • 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…
  • 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.
  • Order Entry Macro, how to get the order number once posted?

    I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro? I want to put it in the message box for the user.
  • Get the current company id

    Hello I Want to get the opened company id on my custom program, which argument can i use? i'm using Sage 300 2012
  • Solution/Module is not displayed correctly - Web SDK

    Dear All, I am working on Solution Wizard with Web SDK. I successfully created 2 modules, CU and SG. But the only problem is the modules is not displayed correctly. SG module is not showed in the navigation menu. But the content of SG modules is displayed…
  • PopUpDS Event

    Hi, im trying to create a macro to capture Popup data sources, and capture the events of the ds. I created this code below, then I tried to debug. But it does not capture the events of the dsPORCPLDet. Is it possible to have this function in Sage .…
  • AccpacGrid can insert maximum how many rows?

    Hi all, May I know is there any row limitation for AccpacGrid? Can populate 40,000+rows data inside AccpacGrid? Many thanks. Regards, Jessie
  • Sage 300 Remove Program Folders from Desktop

    Sage 300 2019 For modules where the user has no authorization for can the empty module folder be removed from their desktop?