• SAGE 300 EMAIL INTEGRATION

    Hello everyone, How can I configure email on SAGE 300 under the company profile to invoke the a clients outlook such that also the sent statements are stored on the sent folder in the clients Outlook? I'm using SAGE 300 2022.
  • 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 :…
  • Work Order Module

    I'm new to Sage. I'm wondering if there is a module for Sage 300 that allows one to create a work order, track its progress, and interface with the inventory system so that when a tech needs a part for a repair, it can be scanned and allocated to that…
  • 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?
  • Sage 300 Standard -2023 (AP Vendor Code automation).

    Is there an AP code automation where If a vendors first letter starts with an H the auto generation vender code is H-00001 if the vendor start with a Q it is auto created to a Q-00001.
  • 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…
  • unable to install custom module on older version

    Hi all, I have a custom module ID that I have create, build, and copied to sage300 installation folder. The module ID only consist of dll to create flat view. I am able to activate it on Sage 300 v70a. then I want to install it on test server with v69a…
  • 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…
  • 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…
  • 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…
  • Print report from C# program error Unknown error 0x80040200

    Hi All, I have an error when trying to print custom report from my C# program. System.Runtime.InteropServices.COMException (0x80004005): Unknown error 0x80040200 at AccpacCOMSVR.AccpacSvrReportClass.PrintReport(Boolean& pWebReportGenerated, String&…
  • 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…
  • ACCPAK.MAK file not found

    Hi alll, I am trying to compile my module ID but having this error: makefile(19) : fatal error U1052: file 'ACCPAC.MAK' not found - Sage 300 SDK 70A is already installed and activated to few companies (I have ~15 companies, SDK is activated on…
  • Anyone know how to Insert AR Invoice C# ACCPAC.Advantage

    I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…
  • Sage 2017 How to insert AR Customer into Sage with C#

    Does anyone have a sample C# example of how to insert a customer into the AR Customers section of Sage 2017 ? I have the Visual Basic macro sample, but it looks so complicated, don't know where to start.
  • Sage Intelligence Reporting - Need currency conversion rate in Sales Master Report

    I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…
  • How to create on-demand subreports caption into number value

    So, so I have a custom report to display a list of costs, and each list displays the total cost per category and there is a navigate function using the on-demand subreport to display detailed costs per category. when I want to export the custom report…
  • Using ACCPAC.Advantage and Error updating OE Views

    Hello We have a C# program that takes as its input a text file, processes the file and then posts the OE Order using the class ACCPAC.Advantage. We open the OE Views to create the OE Order. The programs runs every 15 minutes on a Windows Server with…
  • Adding ICITEMO field to an OE picking ticket

    I am attempting to add ICITEMO fields to my OE picking ticket, but some how I cannot select the ICITEMO table in my sub report. I do not see any of the optional field table being able to be selected. Any ideas of what I am doing wrong.
  • 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…
  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…
  • Querying SQL server Invoices vs Sales History discrepancy

    I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date…
  • 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…
  • [Sage 300] I cannot add optional fields.

    Hello Team, I cannot add the optional field for A/R Documents. Previously, I used the button Create New Example: But in Sage 300 2022 the button is absent. Example: Could you clarify on how to add the button 'Create New' optional field?