• Macro VBA Sage 300

    I found an error when running the macro file
  • 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.
  • Exceptions with Empty Messages

    Note the is a .NET application written in C#. I have an application that imports orders, purchase orders and inventory items into Sage. The customer supplies a file that contains all of the purchase orders w/items. The file is parsed into purchase orders…
  • 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…
  • VB6 IDE SignOn Manager Issue

    I just set up a fresh development environment. Windows 10 VM with Sage 300 2019 PU5. When I run a program from VB6 IDE and I'm logged into Sage 300 the program fails with a non descript error when trying to create/join the session. SessMgr.CreateSession…
  • Formula to Suppress the footer option

    I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…
  • Macro - Receipt Entry - Do not want to receive all

    Hi All, I'm making a macro to post receipt entry based on PO number and the receipt number is pre-generated. For the detail line, I do not want to receive all. But so far did not success. How to prevent receive all? Below is my code. I have set…
  • Web SDK - Insert new Shipment Entry

    Hi, this is continuation from my question "Web SDK - generating multiple code type, and set fix Index.cshtml to be display" which is solved. Below is my screen. After user sign the signature pad, I want to 1. Save the signature (DONE) 2. add new…
  • 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.
  • Add composition View to Custom View

    Hi All, I have a custom table/view that I create using Orchid Extender module Table name: VIOEDEL View ID: VI0704 Is is possible to add view composition to custom view linking them by ORDNUMBER. I want to add OE0520 (ORDDH). The reason is…
  • I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?

    [sage300erp 2018] I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?
  • 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
  • Code Generation Wizard-Duplicate Fields on View ID=OE0692

    Dear All, I am developing a project using Sage 300 Solution Wizard from Web SDK. When I am trying to generate code with ROTOID=OE0692 which is Shipment Header, using Code Generation Wizard, I get the following error. How to solve this? Thank…
  • Customization Error

    Dear All, I am creating a new tab on OE Shipment Entry. I achieve the UI that I want, and now I want send post request on a click of a button. Instead, I am getting an error: Unexpected Error: Your request could not be completed within the time…
  • Manage Customization- Remove Customization

    Dear All, how to remove the customization in the admin screen? It has too many unused test and I would like to delete it from the list. Thank you.
  • 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 .…
  • Create New Macro instead of Editing copy of other Macro

    Hi All, I am a developer working on macro. If I want to add new macro, I have to edit existing macro and delete the codes, and pretend as if it is a new macro, instead of actually add new macro .avb file. My question is, why we cannot add new macro…
  • Error adding an item to a sales order

    I have created a C# web service suing the Sage 300 objects, and all is working well except when I try to add another line to an existing order I get: "Order Detail. Attempt to modify a different record than was retrieved." This occurs on the code…
  • 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?
  • Macro fails on workstations but works fine on Server

    I updated a client from Sage 300 2017 to Sage 300 2019 and one of the macros stopped working on the workstations. They are also on a new server. The macro uses the PO Receipt screen as one of the forms. I updated that form to the new version of Sage and…
  • Sage 300 Web Screen Inquiry

    Hi, In older version I remember there is a possibility for us to custom and add more inquiry into the web screen. Now in 2019 is this features is still available? That we can add more data to be part of the standard Inquiry which is available. If yes…
  • How to create an objecthandle object without passing parameter $objecthandle$ from the macro?

    HI, Is there a way to programmatically code an objecthandle without passing it as a parameter in the Program Argument? Here is the scenario: 1. I have a vb6 program (.exe) that is supposed to run on Sage 300. This .exe program passes $objecthandle…
  • Custom UI lock SAGE 300 from exit

    Hi, Is it possible to lock Sage Desktop from exiting when we run a custom .exe program? If we run a custom macro and try to exit Sage, there will be a prompt to close the opened window first. But for an .exe program, there is no such prompt. Is there…