I am setting up a test server and restored the active companies on the test server. The Sage 300 ERP 2016 Premium installation is on a Windows Server 2012 R2 server with MS-SQL Server 2012. Database setup is completed and verified but I get a "No Supported Databases Are Set Up" error. "Before...
Hi All,
I have a customer that requires the Invoice Number in the Subject Line of mailed invoices, from AR.
In OE, it is simple, since the parameter $INVOICE_NUMBER is available to use at leisure, but according to the parameter list, it is not available in AR.
Anyone with similar requests and...
Hi DJangMan,
It is a custom application that runs from MS Access. They retrieve multiple transactions from a web utility and process them in one go, using the related views.
Hi All,
I have a total anomaly when tapping into a session and/or creating a new session.
I have one instance where my normal code that usually works like a charm, opens the session manager, but on the .CreateSession fails to tap into or create the session. It jumps at the .CreateSession line...
Got it working!
The missing reference for the Customer ID that is not referenced in the UI Info, is afecARCUSidcust
Then, the event on the tabs moved from the BeforeCtlClick event procedure used in AP to OnLaunchObject on the AR event procedure.
Thank you for your assistance, DjangMan!
Hi DjangMan,
Got it working on the AP side. I had to reference the control when I declared the WithEvents and reference the index number of the adsAPDOCS instead of using the name:
Option Compare Database
Option Explicit
Dim WithEvents DocumentDS As AccpacAP1500.ACCPACDSControl
Private Sub...
Hi DjangMan,
Thank you for your reply. Do appreciate, but I need further assistance, please...
Using the BeforeCtlClick event of the ACCPACAP1500UICtrl, I could determine that the cmdPopForm1 control is called and that the OnPopupOpened event procedure is then executed, to call the...
Hi All,
I am trying my best to read the selected "document number" and "Document Type" from the Transactions tab of the AP Vendor activity screen (AP1500). The UI Info does not reflect the fields/parameters passed to open the cmdPopForm1 when you double click on the document number, or click...
Hi All,
I need to migrate master data (for a start) from GP (Great Plains) to Accpac and if data change in GP, update the records in Accpac again.
I've created stored procs in GP, that render the information and insert the data in ODBC tables, that I then manually import from the respective...
Hi tuba2007,
Thanx for your reply. Always found your tips to be useful. We are working in "DARK AFRICA" my friend - not something to laugh about. Here you work with what you have and what can withstand more than only environmental assaults.
We deleted the YYYYYY_P.ism and had to re-configure...
Background: Upgraded from Accpac 6.0 to Sage ERP 300 2012
Product upgrade 3 loaded, hotfix for assurtion print error applied
The OE Invoice and PO reports that we used in Accpac 6.0 to print on pre-printed stationary, do not print as intended. The page orientation displays correctly on the...
Background: Custom Applications with Sage ERP 300 2012 with activeX controls i.e: AccpacOE1100.ocx, result in APPCRASH
The Sage 300 ERP 2012 modules that render crystal reports, work without any problems.
The custom application (MS ACCESS) uses either VBA script or activeX API controls to...
Hi Tuba,
Works perfectly!
With Me.AccpacOE1100UICtrl
.UIAppControls("afeOEORDHordnumber").Value = MyDocNum
End With
Only still need to disable the 2 finders. Will let you know if I find the controls.
Thanks again.
Hi Tuba,
I've developedd my app in MS Access. It is just faster than VB.net
I use the Accpac controls on a form and I have the full functionality of the Accpac Module. (OE1100)
Some clients do have strange requests, but if you spoil them, they have the tendancy to request stranger things as...
Hi All,
I need to limit users to specific orders after hours.
The supervisor enters the available orders in a table and the user must only be able to process those orders.
I tried to use the default start position code, but this does not "filter" and display the selected order.
Example for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.