Sage 300

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

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…

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…

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…

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

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.

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…

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…

Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…

If you have to print multiple instances of a (seemingly any) form (with different parameters, order number, invoice number) using the COM AccpacReport and AccpacReportSetup types they leak a lot of memory. In the space of 200 iterations there is about…

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…

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…

Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …

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…

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…

Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…

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

I need to replace my budget macro because it has been overwritten by an excel worksheet. How do I do this?

Hi all, I am making a macro program to insert OE transactions in bulk by reading a csv file with a lot of Order transaction. Some of the Order might have error while trying to insert. So, I need an indicator that this specific transaction failed or…

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…

A sage 300 company with 15 users runs into the commonly seen problem where users forget to logout at the end of the day. There is a nice feature where you can sign out users from the lanpaks licenses screens manually, but has anybody written a macro to…

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.

Note the is a .NET application written in C#. I have an application that imports orders, purchase orders and inventory items into Sage. The customer supplies a file that contains all of the purchase orders w/items. The file is parsed into purchase orders…

how to retrieve vendor number values ​​on the PO Order screen using macros Thanks,

Hi, Is there a way to block the Print Transfer Slip Confirmation Dialog box from appearing for IC Transfer. We have created a custom Print form and wish to suppress the standard Print confirmation alert box which appears after Saving or Posting a Transfer…