Sage 300

Hi all, I tried to use Visual Studio 2019 with Sage 300 Solution Wizard to generate a simple screen. Right after the solution was auto generated, I use Sage 300 Code Generation Wizard to create a payment code screen. I tried to build the solution but…

I have noticed that an OCX dropped on userform1 does not colourize automatically the same way when you run it as standard screen especially the caption bar on top which I guess is not really part of std screen, but the userform1 frame (Caption and so…

I have a customer that wants to hide a field on the prepayment window on OE Order (OE1100) in the list of controls for OE1100 there is none for Prepayment window Does anyone know if there is a list ? or how to access list of fields and controls …

Hi !!, Need help on above thrown the message from one of the UIAppControls of AccpacAR3100UICtrl1 Awaiting soonest reply. thanks and regards, Joshua

If I drop v2020 OE1100 OCX on a userform in VBA I do not get Notes popups for customer code Any info would help, thanks; trying to avoid making my own little window and reading Notes tables on record change event Ron Boyd

i recorded a macro to copy orders but it does not run , I get automation error. the 'actions' don't work same problem on different version of Sage 30 Anybody know why OEORD2header.Init OEORDC1Fields("FRCUST").Value = "1100" ' From Customer Number…

Has anyone bridged the gap between web screen customizations vs legacy screen VB6 / VBA customizations? We have a client with a desire to use the web OE screen for Opportunity quotes via CRM. In the legacy screen, it's fairly easy to program the desired…

Hi all, I had some technical issue that need to seek help. May I know is there any way to prevent Rate Date in pop up screen as below to auto change when we manually key in Exchange Rate and manually key in amount (Transfer Amount, Deposit Amount)?…

When using Sage connector, is there a way to present a multiple choice pick list? If I've a list of location IDs and want to user to choose 1 or more, can an interface be presented to accomplish this similar to have a calendar widget is presented to choose…

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…

I found an error when running the macro file

not sure where this goes - but it is technical sage 300 v2021 when deployed as published app (not full desktop for rdp user) the welcome screen stays on the user screen even after menus appear. anyone seen this before ? thanks

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…

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.

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…

I have an issue in the .Net library I have no issue creating a vendor using a macro: Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkSysRW…

I have made macros that open Excel, Load Excel, Read Excel, Save Excel and make Sage 300 transactions and so on. Has anyone ever put a Sage 300 macro into standalone Excel with a full interface with the API; is this even possible. I know with a script…

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 all, I have been trying to capture the Receipt Quantity and open the linked Manufacturing Order in the Order View but the application seems to crash, can anyone help correct my code? def onOpen(): if rotoID != "MF0034": return 0 # don't do…

Hi all, I am making a project that is generated by Solution Wizard. But I am stuck at certain part, and reshuffle my strategies on how to complete the project. as we know, we can generate code by type: Flat, Process, Dynamic Query, Report, Inquiry…

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…

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 .…

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 have created external .net application to download data in excel format from Sage 300 2020 and i included that .exe inside sage.If i close the sage window, external application UI is still open..I want to close the external application if sage is closed…

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…