• 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…
  • Error when create project of Sage UI Customization Wizard on Visual Studio

    Hi all, My Sage 300 version is 2023.1.0. I already have the web screen running & working fine. My Visual studio version and info below: Microsoft Visual Studio Community 2017 Version 15.9.52 VisualStudio.15.Release/15.9.52+33403.129 Microsoft…
  • 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…
  • Sage 300 Web SDK - Error occur when build solution after using wizard to generate screen

    Hi all, I tried to use Visual Studio 2019 with Sage 300 Solution Wizard to generate a simple screen. Right after the solution was auto generated, I use Sage 300 Code Generation Wizard to create a payment code screen. I tried to build the solution but…
  • 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…
  • 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.
  • Add composition View to Custom View

    Hi All, I have a custom table/view that I create using Orchid Extender module Table name: VIOEDEL View ID: VI0704 Is is possible to add view composition to custom view linking them by ORDNUMBER. I want to add OE0520 (ORDDH). The reason is…
  • Code Generation Wizard-Duplicate Fields on View ID=OE0692

    Dear All, I am developing a project using Sage 300 Solution Wizard from Web SDK. When I am trying to generate code with ROTOID=OE0692 which is Shipment Header, using Code Generation Wizard, I get the following error. How to solve this? Thank…
  • Solution/Module is not displayed correctly - Web SDK

    Dear All, I am working on Solution Wizard with Web SDK. I successfully created 2 modules, CU and SG. But the only problem is the modules is not displayed correctly. SG module is not showed in the navigation menu. But the content of SG modules is displayed…
  • 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 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…
  • 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…
  • Report print Macros

    i have the below Exception please any help ????