Sage X3

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 to express…

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.

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…

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…

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,

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?

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…

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…

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

hi is it possible to delete one item from a stock inter site Transfer thanks in advance

Hi. Is there a table, where I can find the link between Gaccentry and Bank? Thanks in advance. MatteoS

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

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…

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…

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…

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…

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?

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…

Folder validation on Sage X3 V11 Patch 13 takes forever to complete. The process is taking over 6 hours after which the server will not be accessible. IT team will have to restart it and the validation will have to be started afresh. The applcation…

we need to allocate specific version of products to order. 2 Active versions Ex SKU1 qty 1 version A in stock SKU2 qty 1 Version B in stock If I placed a customer order for SKU1 Version A for qty 2 , in any case I would like Sage to allocate…

we have numerous companies and many sites linked to each company however our left list only displays 9 of the companies/sites I have tested increasing the number of selections in left list however that did not work. any suggestions ? or is a built…

I've started doing some very basic scripts in house but I've run into a wall recently. I'm trying to emulate the same behavior that is seen with MANHLDREL tied with the manual hold button on the SO screen. That is, when the action is triggered, a window…

Does anyone know if its possible to change the demand planning calendar to match that of the financial calendar. I have a customer who would like to match the demand numbers in x3 by month to their 445 fiscal calendard.

In requirements parameters, replanning rules, if I set the type WOF to simulation, I don't get any WOS's. When I set the method to Messages only, I get WOS's but the message is to Cancel. Also it seems to be planning for way too much expected stock. I…

I am new to Sage. I have been monitoring our batch server and queries. The past several days our batch server has shown a status of 'Stopped' but yet all jobs are running and finishing as expected. When I have gone to restart, I get a very clear message…