• 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
  • Get Rates macro and rates url

    Anyone have clients using the GetRates macro and having an issue with the website it pulls the data from? It appears the default fx.sauder.ubc.ca site as been down for a few days. Does anyone have an alternate site we can replace it with?
  • Cost Codes last used

    Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?
  • 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…
  • run macros using Windows Service (local system) - Session Could not be opened

    I have Windows Service which read some data from database then run macros to generate some reports as pdf files automatically (statement of account, Customer Aging....), when I run the service as "local system" the service can read the data from database…
  • 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…
  • Weird errors when creating a shipment

    I am trying to create a shipment in Sage v6.0. I did a recording first and feel like I have replicated in C#. the issue is that I get an error when trying to update the shipment detail after I add the lot numbers to an item. shipments.Init(); shipmentFields…
  • 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…
  • open session in Windows Service

    I created vb.net application which run some macros, as desktop application it is working well, then I converted it to Windows Service also it is working well on my device but when I moved it to Client server I got : "Connect System.Runtime.InteropServices…
  • Error Message with a Crystal Report

    We have attempted to add an optional field from ORORDDO to the picking ticket. If we run on the server, the report runs fine, but when we run on a workstation we get this error: Failed to retrieve data from the database. Has anyone seen this issue and…
  • 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…
  • Error printing custom report: Culture not supported

    We're printing a custom report (PJC) built using Crystal Report 16 and running Sage300 Premium v7.0 2023 How can we resolve the error below?
  • Stock APLETT01.rpt customization

    This is hopefully a simple request. Trying to use the stock APLETT01.rpt form and have it filter out all "inactive" vendors. Focusing on the {APVEN.SWACTV}=1 field as a record selection but cannot get it to filter. I assume it has to do with the APSLVEN…
  • 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…
  • Pay now button on invoice sent by email

    Hello community, On SAGE 300, there is a way to have a "PAY NOW" button directly on the invoices sent as pdf to customer by email. Then when the customer click on it, he got redirected to a secured web portal transiting between Sage money and third…
  • 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 -…
  • VB.Net report printing is not happy with a sage 300 session created by the program

    I have a Sage 300 program, developed in VB.Net, that generates crystal report PDFs. When I run the program from the Sage 300 desktop on my client's server, it works just fine by passing the session token as a parameter. It also works fine running…
  • Sage ERP AccPac 500

    Does anyone know if this program is capable of inserting a signature on a cheque? if so how? If not what do others use to do this?
  • Adding AR Invoice Number to E-mail Template

    Hi all, A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea? Thank you. Yours Faithfully…
  • 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…
  • 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…
  • Crystal reports

    I am trying to have a calculated cost - ie. Ic most recent * 1.8 rounded up to the next 100. Say I get 2445 that would print 2500 and then I am trying to substruct 1.00 from 2500 to get a new sales price of 2499. I am using two formulas one to get the…
  • Custom Macro Development

    Hi, Does anyone know who can create macro to import autosimply MF Issuance and MF Assembly Receipt? We have a different system to control manufacturing and I need to import this automatically and periodically (so ideally we need .exe file to execute…
  • Adding a DataSource Control and Field Edit Control Using COMAPI in C#

    I've added the DataSource Control and FEC control to my Form ok. My COMAPI session is working fine. I'm running into a couple of issues getting the FEC working. I'm getting the following error trying to set the DataSource control to active. Also I…