• 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 :…
  • SAGE300 - incons that you made as "float"

    Good day If you made your navigation as "float" how do you find this and change it back to "dock"? Thank you
  • Data bleed between macro screens

    I have a macro that launches a copy of the OE Order Entry. the customer runs it 3 times and gets 3 OE Windows There seems to be data bleed between the screens where data from one screen will pop up on another screen or interfere Any ideas on segregating…
  • VBA application Sage 300 2024 login error

    For years we have very successfully utilized a Back Office program that I have written in MS Access and VBA. It functions to 'bridge' our POS invoices over into Sage 300. It uses the ACCPAC COM library for login and import of invoices. This weekend…
  • SAGE300 2023 - Macros - Invalid Signon information

    I created VB.net application which run macros but I got error when tried open session the code: Session = New AccpacCOMAPI.AccpacSession Session.Init("", "XY", "XY1000", "61A") Session.Open(acc_user.ToUpper, acc_pass.ToUpper, acc_company.ToUpper…
  • 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…
  • How to Post the AR or AP Batch 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…
  • Using existing connection in Accpac Advantage

    Hi Everyone, I am now developing a .NET exe and Accpac.Advantage to open the view and import into Sage. But currently how I design is using the one sage login to open the view and do the stuff inside the program. Now I would like to change it to use…
  • Hide specific detail columns using VB/VBA

    I'm creating a customized OE Entry screen. I want all the users to have the exact same fields and detail columns. I'm able to hide fields on the header level using the code below. But I'm not sure how to hide specific detail columns. Anyone know how to…
  • How to move Sage 300 user's desktop icons (custom crystal reports) to a New Server (new Sage 300 version)

    Hi everyone, I dont remember exactly but Im sure we could copy some folders/files (\USER I think so) of Sage actual installation at server (they have Sage 300 ERP 2012) to new server installation (Sage 300 2022) so we can recreate icons users run -…
  • Use invoking session inside XLSM

    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…
  • Sage 300 API - AP Payment - updating payment batches

    i am reviewing the Sage 300 web API and looking for a means of updating a AP payment batch (eg. removing a cheque from the batch, updating cheque dates, removing invoices,etc...) and all I can see thus far is GET and POST for APPaymentAndAdjustmentBatches…
  • IC Macro fails during edit with Out Of Memory error

    I built two macros that create IC adjustments for a certain class of items for a client. Works fine on the system in my office. I coped the two macros onto the clients server and when i go to edit either macro I'm getting an 'Out of Memory' error. …
  • 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…
  • VB6 Programming question regarding OnRecordChanged

    Back on the custom OE Screen. Here is what I need to do. Currently the 'Post' button is hidden for certain users and exposed for others so they can post orders and quotes. When the 'Order' is a 'Quote' ALL the users should have the 'Post' button available…
  • Custom OE screen failing on just one workstation.

    I have a built a Custom OE screen for a client that throws up an error that says "You don't have a license for this product" when it opens. When you accept the message the OE screen closes. The screen was built in VB6 and uses a copy of the OE1100 OCX…
  • Error when create project of Sage UI Customization Wizard on Visual Studio

    Hi all, My Sage 300 version is 2023.1.0. I already have the web screen running & working fine. My Visual studio version and info below: Microsoft Visual Studio Community 2017 Version 15.9.52 VisualStudio.15.Release/15.9.52+33403.129 Microsoft…
  • How do I add a print button next to the post button in every transaction window?

    I want to add a print button at the bottom of every entry screen (AP, AR, OE, PO, JE) next to the post button. How do I achieve this?
  • Sage 300 macro won't allow an insert of the OE Order UI

    I'm trying to insert the OE Order screen into a macro and it's giving an error of 'Microsoft Visual Basic. Element not found.' I tried all of the other OE screens which worked okay. I did this because the Visual Basic project for a custom OE screen…
  • Sage's icons Too Small

    Hello Team I'm facing a small issue using Sage 300 on my new laptop, all the icons appearing too small (I customized the setting on my pc following the recommendation that I found regarding this issue but no success to fix it)
  • 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…
  • Customized Program Icon While Retaining Settings

    Hey Everyone, I would like to add program icons in Sage to print off different Crystal using the same program. Ex/ Picking slip with CR form 1, picking slip with CR form 2, etc. However, when I change the default setting of each individual icon it…
  • customizing a Sage screen in a VBA macro

    I added an additional control screen (AccpacIC3530UICtrl1) to a user form and i want to customize it to perform specific functions Such as set the default quantity to (1). And also set the location to the quantity on hand above (1) Thank…
  • 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…
  • fastest update of on-screen order

    Say I have an order of 100 OE Order detail lines and I want to process a partial list of shipments against it I have to find the grid line with the item code of the item shipping. #1 I can browse the grid using dsoeord.gonext and then see if it…