• 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…
  • 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…
  • Error: Class does not support Automation or does not support expected interface VBA

    Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH") On "OnUIAppOpened()" Public WithEvents dsGLJEH As ACCPACDSControl Private…
  • 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
  • I want to create a simple macro that does a bank transfer

    It would need to prompt for from bank, to bank, amount, and transfer date. then offer OK or cancel. The rest of the stuff on the bank transfer screen I find not helpful.
  • Not Responding Message on macro screen

    I have a macro at a client that shows a (Not Responding) message at the top of the screen while the macro is running. It still works and completes its process. This message does NOT show on their old server when the exact same macro is run. Same version…
  • AccpacGrid CheckBox Column

    Hi, I'm trying to create a macro which uses AccpacGrid, i wanted to add a column which contain a check box or Yes or no option in the column. I can seem find the way to achieve it. Could it be done actually? Any help will be appreciated thanks
  • Specific Period Status on Fiscal Calendar

    i want to know the status of my 3rd period in 2014 is locked or not i had tried using code below Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI…
  • Macro icon order

    Hi, I have created an icon in O/E Transactions folder, but this icon is placed as the last icon in the folder. How to put this icon as the first or second icon ? Thank you.
  • Set a field as required in Order Entry/Shipment Entry

    I want my staff to mark orders/shipments as picked up or delivered using the SHIPVIA field. But even after training them they forget to enter this and leave it blank most of the time. Is there a way to make the "SHIP VIA" field required in Order Entry…
  • Record Changing Events on Popupdss

    Hi, I'm trying to custom PO Receipt Screen, I wanted to get the datasource of the popup detail line. I have set a datasource for popup using popupdss given. When I test it only trigger when events is On Record Changed, while on Changing it does not…
  • Can I use Macro to open Shipment Entry form?.

    What I would like to do is to open the form and enable/disable a field on the form based on business logic. I tried to record a Macro, but it does not open the form