Sage 300

Sage menu invoked an XLSM file Inside that XLSM file I want to use the invoking Sage300 session because customer has limited licenses So do not want to login and make another session with another userid and or have to know user's password etc. sort…

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…

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…

I have a custom OE1100 screen User will ship some lines and make an invoice and of the course the question to print forms will pop up. After views settle I want to set qtyordered=0 for any open lines I know the standard _onrecordchanged events;…

Hi I need to modify the Purchase Order Invoice Entry to allow to input many Receipt at once from a copy paste The user would open the form, input Invoice Number and VendorNumber manually Then he would click on a new button to be added to the form…

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

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…

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…

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…

Hello all, Is there any possible way to automate the Sage 300 item number change process? I know there's a way to automate the database dump (using OrchidSystems Process Scheduler) prior to running it, but having the ability to schedule the item number…

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…

Hi, I have encounter this error when add the OCX screen into Visual Studio window form, using .Net Framework 3.5. Error: Failed to import the ActiveX Control. Please ensure it is properly registered Any solution to this?

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…

Hi, I'm developing an Order Entry macro, by using "AccpacOE1100UICtrl" object. This macro should be able to add an item and delete the item if the user selects a certain ship-to location. I'm able to add the item, but when deleting the item, the…

I don't need more than 10 segments for any one structure, but we have such a wide spread parts offering that I need more than 10 global segments to accomplish what I would like to. We are in the process of upgrading to Sage 300 and figuring out IC…

Datapipe report runs well in Crystal Reports preview, but when placed on desktop this error is received "..\a4wdp.c line 372". Copied datapipe.ini file for ICSLOW and commented out stock report and entered my report name and parameter. Copied same…

Hello! We have successfully implemented the web deployment on a new server with Sage 300 ERP 2014 on a Windows Server 2012 R2. Can anyone tell me where we can get some instruction on how to implement our custom screens on the web deployment? From what…