• Screen Field Size

    Good day Ladies and Gents 

    Can anyone let me know if there's a way to make the fields appear larger on a screen?  It seems to dynamically change when you change the size of your screen, but ideally there are some I could make larger by default and…

  • Workflow Rule - Operations

    Good afternoon Folks 

    Does anyone have a good guide to what the operations all mean?  I'm trying to have this send 30 days before the date in the field, but I dont think create or modify will work for an even like this.  

  • Customer Entry Transaction

    Good morning 

    Does anyone know how I can view the entry transaction screen for customers? I can't seem to locate this in any of the setup function options (V11).  Thanks! 

  • 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…

  • Opening Balance Formula for SEI

    Good Day 

    I am attempting to create a trial balance that includes opening and closing balances, but I can't seem to locate where those options live in SQL or in X3.  Is this something I will have to make a formula for? If so does anyone have any advise…

  • ADC location override

    So I have been presented with an interesting challenge.

    In our company we've set X3 to batch allocate all available stock to meet all demand in the system.

    We also heavily leverage X3's ADC functionality.
    Our warehouse users are able to override…

  • Is it Possible to Import Stock Assignments?

    Here's the background here:
    We have Sales Order lines tied to a finished good produced by a work order (link is via MFGITM.VCRNUMORI / MFGITM.VCRLINORI)
    Not all our sales orders and work orders are linked this way.  Say it's 50/50 linked and not linked…

  • Format data on export by Adding characters

    hi,

    When i export some data for exemple à LOT NUMBER, i want to add a "XX" at the beginning of it when we export the data with an export template

    i take from the table OUTPUTM : [OUM]LOT

    I'm trying to use =FORMAT$

    But i'm stuck on how…

  • Updating Operating System Window 2012R2 to 2016, keeping Sage X3 V11 intact

    We have a multi tier environment for Sage X3 V11, including Web, Print, App and DB. We need to upgrade the OS to 2016 on all these server. Is there any recommendation to proceed with such update. Thanks in advance.

  • Batch server difference between U9 and V11/V12

    Hello,

    I'm curious to know what is the main reason to change the batch server from the application server to the syracuse server level. 

    Any idea about the advantage or the improvement reason behind this major modification ?

    Can we always check by…

  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might).

    I have some ideas, but I'd like to know how others…

  • Slow performance on CREATE invoice after upgrade to Sage x3 v11 patch 18

    We get more that 30 seconds to be able to CREATE an invoice.


    After create we can work/change/validate/print the invoice with no problem or delay.

    Any ideas or same problem\ solution ?

    Best Regards,

  • What's the Employees table name?

    You can manage Employees at: Common Data > Manufacturing tables > Employees

    But I can't find the corresponding table.

    Does anybody know what's the table name?

  • Need Product dimension on PPV line for STKRE

    The STKRE auto journal line 80 books PPV.  We want to pull in the Product line dimension from the product.  It is natively set to pull from CPTANALIN but that doesn't not contain the dimension.  I tried to update it to pull from STJ but that didn't work…

  • Advanced Selection Memo

    I am an end user

    There are multiple memos saved in my invoice screen, one of which it defaults to and is NOT named STD, Is this because it has somehow had something different created in it, or is always loading because its the last read? 

    If it needs to…

  • Which is the right Syracuse Hotfix for v11?

    There was a KB article #106630, which was for Syracuse 11.22.4.1, which was a hotfix for 11.22.2.1 and addressed the & being replaced with &.  But now that KB article no longer exists.  

    If you search the KB for Syracuse you'll find the original…

  • stock inter site transfert

    hi 

    is it possible to delete one item from a stock inter site Transfer

    thanks in advance

  • link between Gaccentry and Bank

    Hi.

    Is there a table, where I can find the link between Gaccentry and Bank?

    Thanks in advance.

    MatteoS

  • Connection Scanner for ADC in V12

    Good day

    Does anyone have a procedure of what is required to link a Windows mobile scanner to ADC functionality in Sage X3?

  • Stat99 Error on Accounting Interfaces due to Simulated Entry Generation User Parameter

    I think I found a Sage bug.

    I had two accountants who got vague Stat99 errors when trying to run the Stock Accounting Interface in both V11 and V12. Users with identical functional profiles and roles did not get the same errors and could run the SAI …

  • Keyboard shortcuts for side panel

    Hello all,

    I found out that in X3 V12 P18, Sage has updated the list of shortcuts for all buttons on the right panel (New, Save, Create, Delete, Cancel, Print, etc).  I would like to use these shortcuts in a V11P8 environment. Only the shortcut Esc+N for…

  • Allocation priority by qty ordered vs qty in location?

    Is it possible to designate in X3 that when a customer orders x number of a product that it will look at location 1, but if it will deplete the stock to say 20% then it moves on to location 2 rather than deplete the stock in location 1 or have a split…

  • Workflow for Receipts

    Hello everyone, first time poster here.

    We recently went live with our X3 implementation in the previous months. My knowledge of the system is rather limited but I do consider myself a very technical person. I've been tasked with a request to develop…

  • U9 to V12 Data Migration - Folder Validation in V12 runs "Dictionary Update Utilities" and deletes data types, screens, etc.

    During folder validation after importing U9 data to V12 something called "Dictionary Update Utilities" run and delete some of the following: data types, screens, tables etc.  How can I prevent this from deleting these items?

  • Setup User Profession Code

    Within the General tab of the Setup User screen there is a field for Profession Code.  

    1.  What does that equate to in the scheme of things?  (Role/Group?)

    2.  Is it necessary to have a value in that field?

    Typically we only enter Login, Menu Profile and…