Browse By Tags

  • SAGE 300 EMAIL INTEGRATION

    Hello everyone, How can I configure email on SAGE 300 under the company profile to invoke the a clients outlook such that also the sent statements are stored on the sent folder in the clients Outlook? I'm using SAGE 300 2022.
  • Azure VBS script makes active x error

    I used a VBS script to login to Sage300 with task scheduler this technique has worked for many sites and many years Client went to Azure hosting and now...... this line: Set Signon = CreateObject("A4wSignonMgr.AccpacSignonMgr") Makes this :…
  • Customer BP Invoice Function , Field (TAX) allows for display/input.

    Hi Sage X3 Folks! Can the 'Tax' be inputted/edited in the Customer BP invoice? I am not sure about this process. I already changed the input to enter, but still no luck. Any of you know this process?
  • Setting Zones in Sage X3

    Hey All, My company has purchased a wave picking function in Datalinx. During our first brainstorming session we've brought up Zones(zoning our warehouse). We believe we need to set zones as we go down this road. Problem is where to start? My question…
  • Creating AR Aging in Sage Intelligence Sage 100 Advanced

    We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
  • VIREBOUT DON'T DISABLE NEW BUTTON

    Hi. I have v12 (2023 R2 (12.0.34)) and I create new window type Miscelaneus and Display = Full screen. I add two new buttons with code z an i , one validating and another no validating. In SETBOUT ACTION, I add this lines: Call VIREBOUT(CHAINE…
  • Build Custom Explore Views?

    Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?
  • Making an Explore view a shortcut

    I am wondering if there is a way to make a custom view from the business insights explorer a shortcut within the Explore Tab? am I able to put a custom view in here somehow as a shortcut?
  • Use table from another folder

    Hello everyone In X3 documentation it is described that it is possible to use a table from Folder A in Folder B. https://lvexpertisex3.com/x3help/ENG/V7DEV/4gl_file.html I tried it like this: Unfortunately it doesn't work with the period between…
  • Company Copy | Customized Fields not copying over

    We are attempting to copy over all of our customized to fields from a test company to a brand new company. Is there an easy way to copy over the customized fields and panels while creating the company?
  • Filter of registers to be exported by Script from model export

    Hi, Is it possible to create an specific script, in model export, in order to filter by code some registres to be exported? I need it to check a value from a table that is not linked to the model's object Thnkx
  • Is there a way to edit Schedule of Values template?

    We are looking to edit the way our format for the schedule of values outputs & prints, is there a way to edit this? Or is this a default that is unable to change? The same goes for our estimate template.
  • Entry point not called

    Hello everyone I try to implement the entry point https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR.htm#APE_30_10 with action REQUETE. I created the entry point and the processing script in the X3 folder…
  • Customizations in X3 folder

    Hello everyone We sometimes have problems when a batch job runs more than once. In order to prevent this we want to use the entry point SERVEUR with action REQUETE https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR…
  • UDT in AP Invoice detail

    I've created a UDT in AP. Populated the data and then created a UDF in AP Invoice Detail. The Code field appears from the table but i cannot select it. what needs to be changed? UDT AP Invoice Detail UDF in AP Thanks for your assistance…
  • 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…
  • Default value for specific components

    Hello, Im looking for solution to add default component value in function GESDBY Disassembly. I tried to use something like this: $APRES_CRE For i=0 To max([M:DBY1]NBLIG -1) if [M:DBY1]ITMREF(i) = "X" [M:DBY1]PRIORD(i) = 17 Affzo [M:DBY1]PRIORD…
  • 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…
  • 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…
  • Filter by comparing 2 columns value error

    Hi all, I have this SQL query where I have a whereclause l.LineQuantity>six.TriggerQty select c.CustomerAccountNumber, c.CustomerAccountName, h.DocumentNo, si.Code as ItemCode, si.[Name] as ItemName, pg.Code as ProductGroupCode, six.TriggerQty…
  • Join tables produce ambiguous error

    Hi all, I want to join StockItems and StockItemSupplier table using Sage.ObjectStore.Join below. StockItems sis = new StockItems(); try { Sage.ObjectStore.Join join = new Sage.ObjectStore.Join(); join.RightTable = "StockItemSupplier"; join.RightTableAlias…
  • 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…
  • Manual Matching (LETTRAGE) screen - actions are not being called?

    Hello, I want to make a simple specific script modification for the manual matching screen (SPELTR) however, it seems that actions do not work on the screen. The code is as follows: $ACTION Case ACTION When "AVANTBOUT" : gosub ZSOLCPT When default…