Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
Trying to create a query based on items that are out on loan to customers.
My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…
Hello
Hello to all the Sage Community,
I introduce myself i m from TUNISIA and i work on Sage Solutions since 1998 so about 26 years and i wonder if in this Community of philantrop and experience is there a Virtualmachine or Plateform to access to…
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…
Hello,
I am trying to calculate one invoicing element off of another and I seem to be running into a road block. I have tried using the "Calculation order" field, but this did not work. The next step would be using the "Action" and "Processing" fields…
I want to delete product-site records that they do not have transactions in that site.
when I use transaction mass update, it dose not check it has transaction or not and delete it directly and it is wrong because I want to delete the same record from…
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"…
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…
Hello All,
Encountering something in our Sage X3 setup that I'm having trouble hunting down the source for. We have some Inter-site orders between us and some distribution companies. For this transaction, we want the gross price to be set to 0 automatically…
Hi,
We have some quantity in Suspended transaction for a particular item, which occurred during a Shipment transaction due to the insufficient quantity. Later we received the same item using MISC Receipt, but the suspended quantity not updated, suppose…
Hello all,
I am the MIS manager for my company and have recently run into an issue with Apple devices and Sage X3. We have both Windows and Apple running in our environment. Our Apple users started reporting numerous fatal errors on their MacBook…
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…
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 online help says....
Query, Detail, Edit, Lookup, Summary
These columns represent the different facets in which the property can be used. When one of these columns is selected, the property is present in the corresponding facet. Otherwise, it…
Hi guys,
I need help!
My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis
Please how can this be achieved?
Hoping to get a positive response
Thanks
I'm looking for ideas as to the best way to consume packaging in work orders.
We sell products in various packaging....totes, drums, pails, etc.
Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
I'm updating BOMs to including a packaging code. I can copy the BOM from the original product by entering the new product code however the BOM routings are not automatically copied over. Is there a way that routings can also be copied over?
Hi All,
In my Sage X3 database journals are on hold when the accounting task active. When i post supplier invoice it does not go to GL. Any idea?? This is new database.
We have configured row level permissions on customers restricting acces to specific customer by customer categories. This works well to restrict access and visibilty of non-authorised customers in the left-list of the customer function and in the selection…
HI all, in Sage X3 v11 I need to fill a grid on click but I can't find a way to add lines to my grid, can someone share a script to help me, i'm currently working on Sage X3 SPE Script of that window?
The business need is to set up allocation rules that always allocates cases of product, regardless of the setup on the product record. For example, on the customer tab of the product record the unit is EA (each) If a case of that product is equal to 12…
I am looking for Chinese Process Flow Diagrams. We have Spanish, English, French, but I can't find a cChinese language one. We can change the language on X3 easily by switching the locale, but the flow diagrams are still in English.