Browse By Tags

  • unable to install custom module on older version

    Hi all, I have a custom module ID that I have create, build, and copied to sage300 installation folder. The module ID only consist of dll to create flat view. I am able to activate it on Sage 300 v70a. then I want to install it on test server with v69a…
  • Use SOAP Web Service to create quote issue.

    I have a integration service do so a series integration. If there is any error, when create quote SQH, it will give error: @X3.TRT/SUBSFIT$adx (149) Error 7 : Class Non-existent [M:SFIT] 0 : Sage X3 errors After restart the X3 SOAP Web Service then…
  • custom field

    Need help with new custom field formula. I create custom field "Net Available Stock" I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…
  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.
  • Product Line in Open Sales Order Report

    As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…
  • Posting AR or AP Batches using accpac advantage

    Hi all, I have already created C# program using Accpac Advantage to import AR and AP Batches into sage in Ready to Post Mode. But my client wants it to auto post after import to sage. So, is there any tutorial or example that I can reference for doing…
  • Integration between Sage 50 Canadian Edition and Wix

    I am setting up my website with Wix and am wanting to integrate my Sage 50 to it, for speed and efficiency. Is this available? (I know it is for Quickbooks, but I am happy with Sage and do not want to jump ship) If not, is it in the pipeline? James…
  • Making a custom form the default form?

    Hello, New to Sage... Probably the answer is very simple but I simply can't figure it out: How do I make a custom form (such as estimate or invoice) the default form? I am unable to save the customized form in the default folder (it says I do not have…
  • Non-existent items

    We're currently using the Sage100 C# NuGet package noted below. We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…
  • Sage50 Third party integration

    Hello, I am looking for help with the integration of Sage50 and a third-party software. Can anyone help me?
  • Pre-bill Worksheet

    Is there a way I can change the default line near the bottom of a pre-bill worksheet to show "Remaining Escrow Funds" instead of "New account balance" like it currently does?
  • Looking for developers wihh US Sage50 Integration

    Hello, I have a client in EU that needs to hire a developer for an integration with Sage50 Accountant and other versions in the US. Can anyone help me?
  • Adding Total Deposit to Left List On Manual Remittance Screen (GESFRM)

    I'm trying to add the total deposit on the left list on the Manual Remittance Screen. This value is a summation from the PAYMENTH table on the field AMTCUR and is present on the screen as "Company Total." I'm struggling with how to go about this because…
  • Graphql Work Order Production Reporting

    Hi, I have SAGEX3 release/12.17.0 build 33 and i'm trying to run the following graphql query: { xtremX3Manufacturing { workOrderProductionReporting{ query{ edges{ node{ workOrderProductionReportingLines{ query{ edges{ node{ lot } } }…
  • Menu item - type: query - "where" parameter operators

    Good morning, I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says: Only simple conditions using "le", "ge", "eq", "lt"…
  • Print report from C# program error Unknown error 0x80040200

    Hi All, I have an error when trying to print custom report from my C# program. System.Runtime.InteropServices.COMException (0x80004005): Unknown error 0x80040200 at AccpacCOMSVR.AccpacSvrReportClass.PrintReport(Boolean& pWebReportGenerated, String&…
  • Confirming of Purchase Order

    Hi All :) Good day, what are the ways to confirm PO? I know there are many processes, such as supplier confirmation and signing workflow, but I would like to customize it by having a field called 'Confirmed to'.
  • Code Generated List - Sort Column Descending By Default

    If would be wonderful if someone could assist me with the following. I have written an ASP page which displays a list of orders. This list is generated in the code and does not rely on any metadata. A snippet of the code is included below var list …
  • Display a screen field as a searchable entry in the browser object - is it possible?

    Hi there, I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…
  • SAGE 100 2018 Integration with Odoo

    Hi, We are using SAGE 100 2018 Version for the last 5 years. We would like to integrate the following records from SAGE to Odoo using API. Can anyone let me know, whether integration is possible for this records. 1. Customer 2. Work order …
  • View Archive Folder scripts from the Web Service script editor

    Hello, I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM: Unfortunately, this script does not exist in the…
  • Entry point when report is finished printing

    Hello We have the problem that sometimes the print server not prints out a report. Even though we started the print for a document (e.x. purchase order) in 4GL with the following code: For a custom development we are looking for an Entry Point which…
  • Error 26 : Internal error Inconsistent reference value (11026)

    Hello I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…
  • Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…
  • Patch creation - include inquiry screen

    Hi togehter, we successfully modified an inquiry screen (added columns, changed order of the cloumns...). Now we want to share that inquiry screen with another X3 system. Unfortunately we cannot choose inquiry screens as an object in the patch creation…