• User unable to promote company to Sage 300 Customer/Vendor

    Hi all, I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet. My user setting: …
  • Error while installing Workstation Setup

    Hi all, My customer is having error while installing the Workstation setup on Sage 300. Checking the log file, a lot of things cannot be found. how do I fix this? The following properties have been set: Property: [AdminUser] = true {boolean…
  • MobileX for Sage CRM

    Hi - wondering if anyone has tried this. That aside, just came to know that Sage stopped development on the CRM app 3 years back. Wondering if there are any other options out there. On a separate note- has anyone used the mobile CRM extensively? …
  • New to Sage. How to import files from OneDrive

    We are running Sage 300 2020. Our finance team has been working with Excel files on a network share and then importing to Sage 300 GL transactions. We are in the process of decommissioning an old file server and moving their files to SharePoint Document…
  • Sage 300 Web Api - Ready To Post

    I'm working on the Sage 300 Web API to pass Customer Receipt to Sage 300 version 2021. In the Github documentation, it mentioned that we could set the Batch Status as Ready To Post on the POST request. A separate PATCH request is not required as the…
  • Sage 300 2022 API

    Hello, Does Sage 2022 allow API calls via COM? We use Sage 2014 where we utilize A4WCOM.dll as a COM object. Can't seem to do the same with Sage 2022. I read somewhere that it's now a web API call Thanks for any info
  • Payment Batch Import Into Sage 300

    Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…
  • Sage 300 Integration

    Hi Everyone, I am working on one sage integration with python web application and I want to send data from python application and create customer in sage. I am using desktop version of sage. My question here is if the API https://cdn.na.sage.com/docs…
  • Session Initialization w/.NET API

    I have the following code to create a session. Session s = new Session(); s.Init("", "XY", "XY1000", "67A"); s.Open(User, Password, Company, DateTime.Today, 0); A client had been using ADMIN/ADMIN for the username and password (don't ask why they…
  • Sage .NET API Errors

    In the Session.Init method, I'm getting an error that just shows 1.4197.5 I have no idea what this means and don't see documentation anywhere that explains it. Can anyone help on what this means?
  • SAGE 300 PROJECTS AND JOB COSTING INTERGRATION WITH MICROSOFT PROJECTS

    Where can I find a document or a user guide on how to integrate Sage 300 2020 PJC and Microsoft Projects 2016. Please advice
  • Where can I find documentation about Sage 300 cloud RESTful API?

    Hi, I am trying to build a solution that should integrate with Sage 300 cloud to sync customers, projects, work orders, etc... I have looked around but could not find any documentation about Sage 300 cloud API. Could you please point me to Sage 300…
  • System.AccessViolationException with ACCPAC.

    Hello Experts, Facing the below error while accessing the ACCPAC API. System.AccessViolationException at AccpacCOMSVR.AccpacSvrViewClass.Process() at ACCPAC.Advantage.Server.View.Process(FieldValue[], Int32[]) We have a .Net based windows service…
  • UK VAT reporting for Europe

    Client in Canada has an entity that resides in the UK. They received a letter saying that they are 'required' to use MTD (Making Tax Digital) software to file their VAT returns. It seems that Sage 300 Cloud is not on their supported software list. Has…
  • Sage 300 Web API case insensitive search

    Hello, I need to do a customer search using the Sage 300 Web API, but it needs to be case insensitive as some customer names are proper and some are in all caps. According to the OData documentation I should be able to use the tolower function, but…
  • Issue with Sage 300 2020.1 integration with Sage CRM 2019 R2

    Can anyone confirm if a Sage 300 user has to be available to view Order Inquiries in Sage CRM? We are encountering an issue where the company does regularly reach their total number of users in Sage 300. It seems that when they do, if a CRM user goes…
  • Trying to set up the Sage HRMS/300 Link to run on a schedule automatically

    I'm trying to run the HRMS and Sage Link Automatically by setting it up in the Schedule Profile Configuration and Schedule User Login Configuration under Sage Payroll Link- Sage HRMS Setup. I'm following the steps provided to me in the user guide (attached…
  • Payables Workflow with PJC Retainage Integration

    Does anyone knows of a web-based Payables Workflow that is able to process and approve job-related PJC invoices with retainage? Both Pacific Technologies and Norming's solutions do not handle PJC retainage. Thanks.
  • Sage GL Consolidation Module Integrate with Navision & SAP

    My company is using Accpac system but the sister organisations are using Navision and SAP. To consolidate the GL transaction, we plan to develop the interface files which generated from Navision and SAP. However, Accpac GL Consolidation Import required…
  • Error adding an item to a sales order

    I have created a C# web service suing the Sage 300 objects, and all is working well except when I try to add another line to an existing order I get: "Order Detail. Attempt to modify a different record than was retrieved." This occurs on the code…
  • Sage 300 + CDATA JDBC Driver for sage 300 + Talend Data integration

    Hello , I'm new with sage 300 and i need to connect my Talend data integration with sage to extract data. To this i installed sage 300 on my machine i created a simple company to do the test , then installed CData JDBS Driver for sage 300 ... …
  • Is it possible to Restrict certain Customers created within Sage 300 with specific group code from getting inserted or synced to CRM?

    Hello, Is there any method/setting, that can ‘Restrict’ certain Customers (with specific Group code) that are created within Sage 300 from getting into CRM as company record? I know that if we tick the suspend A/R integration to CRM checkbox from…
  • Integrate Sage 300 (non-cloud) with a PHP website

    Hello, We have a Sage 300 On Premise (non-cloud) version. We are looking to integrate it with our e-commerce website (PHP). We want to do two-way integration. 1) : From Sage 300 to website Customer invoice, order history, tracking information from…
  • Event Viewer Exception from Accpac internal dlls

    I am using the Accpac.Advantage dlls to communicate from a third party .net app into Sage 300. The processes we are doing are simply to open a connection and then return various pieces of information from view calls (I use the CS query view through an…
  • Reconciling WIP account in PJC environment

    We are using Sage 300 Premium 2018 (Accpac) with the Job Costing module. I don't have a method of auditing the balance of the WIP balance sheet account. The balance is climbing, and it is as if transactions are being "dead-ended" there and not flushed…