• Import of miscellaneous receipts for inventory

    We are importing inventory receipts into a new warehouse. We are using the import template FTIMSR. It works fine. The issue we are having is dealing with errors and the subsequent creation of multiple misc receipt records in Sage X3. If we build a long…
  • Encounter error when running Stock Accounting Interface

    Upon running the Stock Accounting Interface interface, I consistently encounter the following error: SOOCKSE22006354 Nonexistent dimension value (STKIS Line 3) Miscellaneous issue VCRNUM=MIOCKSE23003691 Upon thorough investigation, it has come to my…
  • What is the purpose of the following: Substitution product "Field SBSITM / Screen ITS [ITS]" VS Alternate product "Field RPLITM / Screen ITM2 [ITM2]" in "Product"

    Hello All, Can someone explain the reason for these two fields listed in the subject in "Products" screen. I've read the basic break down's from "F1" help, but we are looking for more real world examples and purposes of these two fields. Could either…
  • Trying to return a Using ASYRRESTCLI.EXEC_REST_WSCLB how do I get my RETVAL to bring back more than 250 Chars?

    Hi There I am trying to return a Using ASYRRESTCLI.EXEC_REST_WSCLB how do I get my RETVAL to bring back more than 250 Chars? Here is my code
  • How to solve ‘Accounting destination’ error while creating payments in Sage X3

    Hi all, I got the issue of Accounting destination error while creating payment receiving from an open item, we are in Sage X3 V12 Does anyone here know how to solve it? Thanks for any advice,
  • Sage X3 V12 Shortcuts

    Hi everyone, I came across these excellent and useful to improve navigation on X3 V12. A. Right Panel Actions ESC + N – new ESC + B - save ESC + C - create ESC + D - delete ESC + E - cancel ESC + ALT + U - refresh ESC + ALT + P - print…
  • Purchase Receipt Function in Datalinx

    Hello Group, I'm hoping for some help or insight into an issue we've encountered using Datalinx & Sage Purchase Receipt Function. This is what we're trying to do: We are trying to use the purchase receipt function in Datalinx and receive an error…
  • Execute ACTION from STD on Sage X3

    Using Sage X3 v12 (2021R3), I try to execute on a TRT the $APRES_CHOI action from STD and SPE. My process is the following : Object called ZDK, I'm opening an action AZDK1 that opening a custom selection popup (with screens and backend-code). GACTION…
  • Counter for NACHA file

    I am creating a NACHA file for Old Second bank. Their file layout requires a count of all the detail lines. Is there a way to get a count of the detail records to show in the NACHA file? How is that done in the "Bank File Definition" screen? Recommendations…
  • How to store Blob image's type in a table ?

    I created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen…
  • Using Outlook wrt New email client for Sage X3 workflow notifications post.

    Reference: https://www.sagecity.com/us/sage_erp_x3/f/sage-x3-announcements-news-and-alerts/187389/new-email-client-for-sage-x3-workflow-notifications I am using a Microsoft Outlook account (assume name as [email protected] ) which requires FROM to…
  • SageX3 - Selection List

    Hi, in a custom selection script like this: GSELFAC = 1 : # campo che deve ritornare Filter [F:YPROD] CRITERE = "[F:YPROD]YITMREF='"+[M:POH2]ITMREF(nolign-1)+"'" NBCOL = 0 NBCOL +=1 : COL(NBCOL) = "[F:YPROD]YCODPROD" : TIT(NBCOL) = "Cod.Produttore…
  • 3rd party Webservice soap response

    I'm trying to make a call to a 3rd party webservice using Sage X3 scripts on the SDH window, i'm using the func ASYRWEBSER.EXEC_HTTP wich is working fine, it's calling the webservice and receiving the answer of the soap call. The Answer: <s:Envelope…
  • Scrolling after Saving a Change - GESBPC

    When we go into GESBPC (customers) and change the customer from Hold to Check and hit the "Save" button, it is moving the user all the way back to the top of the screen. Is there a way to turn off the automatic scroll up? We just want to save and leave…
  • Sage X3 upgrade from V PU9 to V12

    Dear Sage City forum users, we're currently looking for someone who has already tried or experienced migration from Sage X3 vPU9 to v12. We currently have one project where we've been asked to "test" this migration internally and see how this may work…
  • RTF Pasting adds many carriage returns

    Just upgraded to V12 P27 and when we copy to clipboard from an outlook email in rich text format, when we paste it into a comment box in any screen (customer, supplier, sales or purchase order etc), it is adding _many_ carriage returns after each sentence…
  • Problème importation de x3 vers web scheduling

    Bonjour, lors de l'importation de "plant" de sage x3 vers web scheduling via Analytics j'ai rencontré un problème dans le fichier FR012.json "{ "repos": [invalid authentication method: bearer]}" voici le fichier log : [18/01/2022 03:31:32]Service…
  • How to integrate Amazon and Prestashop?

    Hello everyone, I was wondering how I could integrate Amazon and Prestashop to X3? Which are the steps to follow? Please, could someone guide me? Appreciate it!
  • Graphical Query Tool executed query

    I have query in the Graphical Query Tool that I'd like to see the actual query executed. How do I see the query in SQL syntax? I want to see the tables and how / what they are joined. Is there a way of doing that?
  • 1) Mass delete BPS Invoices 2) DocLink/DocAlpha

    1) Is there a way to mass delete BPS Invoices? I have 1900 to delete. 2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha. This is the second or third time it has happened. Does anyone have advice on what might…
  • The update finished with warnings

    After installing patch 26 on v12 i get this message, but I dont know where is the log or what are the warnings????
  • Consistent Shutdown Of Syracuse Services

    Hi guys!!! I have this constant shutdown of Syracuse service I don't have the issue on a physical server except a cloud server I have tried different environments for this but the issue persist The Sage version is on 12.0.24 while Syracuse is…
  • How import assembly doc?

    Hi everybody. I need import assembly doc, but now in X3 V12 this object hasn't active import check. I try to active and create import template, but all time system says that first line are not completed, and don't create doc. First, in BBY Object…
  • Save report in server directory programmatically

    Hi Guys I've implemented create report functionality. The following part is calling report creator: Call ETAT("ZLETTREVIRR", "FILEPDF", "", 0, PROP, TPAR, TVAL) From AIMP3 Where "FILEPDF" destination - output file type pdf. I also added FICHER for saving…
  • Purchase Order import - sequence numbers

    Is it possible to import purchase orders and assign the PO number at the time of import. These PO's are coming over from the retired system and we do not want to use the sequence as part of the import. Looking at KB 95260 it implies this is not possible…