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.
Hello Everyone
During stock count preparation, I observed that a sales invoice already posted is holding stock. I have run the stock and quantity resynchronization functions, but the stock was not released. when i checked the invoice lines, i saw that…
Hello,
I have some questions about stock queries:
Is it possible query all the stock in a site (and not always filter by an article reference) ?
And the other question
Is it possible to query the stock with separate lines for each serial number…
All,
We have default locations setup using product-site within our system. However, there are times when we need more than one location to store products because of space & their replenishment levels. My question, can you add more default locations…
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…
Hello, am wondering if someone can explain the logic behind Product Site Default Location setup? Problem: Snap shot above is how we are picking our apparel for replenish to work, but I don't think it's setup right 100%. Does anyone have any expierence…
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…
Hello,
I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM:
Unfortunately, this script does not exist in the…
When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
How do you have a single product be put in Q status as soon as a case / pallet is made in production? I can see how to do it by "product category" but i only want a single item within that category.
Sage X3
Is it possible to turn off Automatic Allocation for one particular RAWMA in our database? We have a case where we have multiple work orders open for one part that comes in one at at time. We would like to choose ourselves which work order to consume it…
Hi, is it posible to make the products marked as "R" and/or "Q" not count as available? I'm trying to find something at Stock Management Rules but i'm having no luck.
Thanks in advance.
Bonjour,
Je souhaite savoir si dans le cadre du réapprovisionnement d'un site interne ( un site de vente à partir d'un site magasin central) il est possible de plafonner les réapprovisionnements sur une période bien déterminée? En d'autre terme, il…
Hello wise people of the Sage City,
For a customer we had allowed negative stock on ingredients/raw materials to prevent constantly having to stop production because tracking returns an error due to stock being unavailable. Allowing negative stock results…
Customer relation > Customer support:
When creating a Service Request and you perform a Service Response as part of the process.
During this process you have the opportunity to select Labour and Part consumptions in the Response - these can be billable…
Helllo,
I performed a key change on an item that had existing stock not realizing that key change does not affect stock. I have looked around in SQL and still see the old item code in STOCK, Neither code in ITMCOST, both codes in ITMMVT, and the new…
Hi!
I'm using the pre-receipt of shipments for purchase orders being imported.
Acording to the X3 help, this function should update the EXTRCPDAT of the pre-receipted order in the ORDERS table, even though it doesn't update the original expected date…
Does anyone know what this means? We don't use "preparation". We started getting this error message recently, sometimes we can blow by it and sometimes we can't. This particular product is not managed so there is nothing to allocate. When you hit ok it…
It would be beneficial to restrict user access by location type or location by utilizing an access code (similar the the PLAACS field on ITMMASTER).
The business use case is restricting production workers from issuing or transferring stock that is…
For a stock sales order, I understand that X3 checks for sufficient stock on hand at time of creating Sales Delivery. If there is insufficient stock on hand then the Sales Delivery cannot be saved. Is it possible to delay this check until validation of…
I have a question about Autoprocess shortages ( SHTAUTFLG ) functionality - a stock parameter.
There are created many sales orders, which generates shortages at stock. In different days. When a receipt is entered, due this stock parameter, the system…
Currently in the system the Stock Management Rules allows for issue rule definitions based on the stock substatuses (i.e. A1, A2, Q1, Q2, R1, R2, etc), but the Allocation and Issue rules does not allow for that level of rule specification. It would be…
I need to setup a process to manage short term rentals. I have investigated the lease contract option, but it requires Fixed Asset setup and a large amount of transaction overhead.
The best option I have found thus far is to use a Loan sales order followed…
