Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ajwonder

    No Supported Databases Are Set Up

    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...
  2. ajwonder

    Display Invoice Number in Subject Line, sending AP Invoices

    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...
  3. ajwonder

    Sage 300 Signon Manager does not create create session

    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.
  4. ajwonder

    Sage 300 Signon Manager does not create create session

    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...
  5. ajwonder

    ACCPACAP1500UICtrl

    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!
  6. ajwonder

    ACCPACAP1500UICtrl

    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...
  7. ajwonder

    ACCPACAP1500UICtrl

    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...
  8. ajwonder

    ACCPACAP1500UICtrl

    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...
  9. ajwonder

    Sample format for an import acceptable with Accpac

    Hi hushman, The easiest will be to export from the sample database. That will give you the exact file you require, together with relevant data.
  10. ajwonder

    Automate Import functionality

    Thanx DjangMan. I will definitely give it a bash and revert. This forum has always been the best! The support and suggestions are priceless...
  11. ajwonder

    Automate Import functionality

    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...
  12. ajwonder

    Sage ERP 300 2012 Dashboard Empty

    Anyone played with Sage ERP 300 2012 Dashboard? When opening the Accpac dashboard, the company list is empty.
  13. ajwonder

    After upgrade to sage ERP 300 2012, page setup of OE and PO reports changes to '18K' and landscape

    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...
  14. ajwonder

    After upgrade to sage ERP 300 2012, page setup of OE and PO reports changes to '18K' and landscape

    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...
  15. ajwonder

    MSVCR80.dll APPCRASH MSACCESS.EXE

    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...
  16. ajwonder

    Open Order Entry on specific Order - MS Access

    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.
  17. ajwonder

    Open Order Entry on specific Order - MS Access

    Hi Tuba - this looks promising! Thanks. Will keep you posted.
  18. ajwonder

    Open Order Entry on specific Order - MS Access

    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...
  19. ajwonder

    Open Order Entry on specific Order - MS Access

    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...

Part and Inventory Search

Back
Top