Browse By Tags

  • 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…
  • 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…
  • How to make OE CN on account and reference an OE Invoice

    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…
  • Credit Card Receipt Confirmation Report Customization

    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…
  • Error: Class does not support Automation or does not support expected interface VBA

    Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH") On "OnUIAppOpened()" Public WithEvents dsGLJEH As ACCPACDSControl Private…
  • Failed to import the ActiveX Control

    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…
  • Web SDK - Insert new Shipment Entry

    Hi, this is continuation from my question "Web SDK - generating multiple code type, and set fix Index.cshtml to be display" which is solved. Below is my screen. After user sign the signature pad, I want to 1. Save the signature (DONE) 2. add new…
  • Order Entry Macro, how to get the order number once posted?

    I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro? I want to put it in the message box for the user.
  • 300c Web Screens - Scrolling Windows

    FormerMember
    FormerMember
    I've recently installed 300c Webscreens which has a nice interface to it, albeit a bit limiting. The first thing everyone in the office asked, why do I have to have pages of records rather than being able to scroll through the entire list at a time…
  • Contract Billing Report Customization in Crystal

    I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…
  • recommend a Sage Specialist for writing reports in Financial Reporter

    Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.
  • Adding new Document Type for Doc Transmittal

    Hello, Using customizer, we are able to add a new document type for document transmittal into the 'other contacts' window (from maintain customers). We have created a custom table to store the value and can join back to tcicontact through the cntctkey…
  • Blank stock AP check printing and signature, Sage 500?

    Is there a way to print blank stock checks in Sage 500? My AP person doesn't want to use pre-printed checks. Also, how do I add a signature to the AP check print form, Sage 500? I'm so used to having source code, I was a former developer, so I'm having…
  • Adding Invoice number to email template for subject line.

    A client wants to add the invoice number to the emails subject line not only the $COMPANY_NAME. Is there a way to incorporate the invoice number either on the subject line or the pdf name without doing it manually? Thank you,
  • Issue with Crystal reports prompting for SQL sa password.

    We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…
  • SQL Password Prompts in -some- custom reports and intermittently Sage Inteligence

    Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…
  • How to add What's This? help to a custom field?

    I am missing the link (secret handshake) somewhere and would appreciate someone pointing me to the right direction. My goal is to enable What's This? right-click context-sensitive help for a new screen that I am building with the Sage 500 framework…
  • Invoice design

    Hi folks, I work for a foster care/adoption agency and we're trying to modify our child care cost sales invoice templates in Sage. Usually our invoices have the client listed as a county department of jobs and family services, and billed to the foster…
  • Is there a way to access the db connection(for temp tables) that Sage uses in vbscript?

    On the customization of the SO form, can we access the db connection that Sage is on for updating the temp tables, which otherwise are not accessible from another connection.
  • Looking for way to restrict labor progress entry to certain users.

    I'm looking for a method to restrict labor progress entries to certain users, user groups, ect... Possibly a vb script through customizer?
  • Cannot change script language from VBScript to JScript

    I would like to change the scripting language in an event in a Form Script Editor, when when I change the Language pulldown menu from VBScript to JScript, I get an error dialog with the text Script language changed. Modify existing script's syntax to…
  • Looking for Form_Save Event documentation

    I am trying to find documentation on what is in the oDM parameter ("data manager object") in the Form_Save subroutine in the Save Event, specifically in the Enter Receipt of Goods Form (PO Module). Can someone post info on what what I have available to…
  • Error calling DLL code from VBScript

    Back again with a specific bug... I have customized the Save Event in the frmBatch object in the Process Receipt of Good form: Sub Form_Save(oDM, bSave) Dim objApp, result Set objApp = CreateObject("LMNO.PrintNewLabel.FormSave") result = objApp.PrintBatchLabels…
  • Change default PDF Attachment on Customer Statement

    Is there a way to change the default naming convention on the PDF attachments when performing document transmittals in the AR module? MAS500 by default uses the customer number. We would like to use the customer's name so that the email looks more business…
  • How to implement Dashboards

    I'm new and would like to implement so i can learn, business insights dashboards. sage 500 7.40.8.0