Sage X3

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…

Currently we do misc issues of stock for multiple reasons Stock Adjustment, R&D, Scrap, Clinical trials etc. all these reasons are pointing to an account using a customization of the journal STKIS. I would like to go 1 step further and link each Transaction…

Hi all, we are using X3 V12 and for selected customers we do keep consignment stocks. Work flow is as following: 1.) We sell certain products (full pallets) to these customers (fully invoiced) out of our normal stock. 2.) These sold articles are…

The sales order quantity for a product is 1 but the system is showing a quantity of 5. Somehow the same order has been duplicated 5 times in the workbench but the quantity on the order remains the same which is 1. What could be the cause and is there…

Is there a report that shows me the 12 month usage, current inventory, and the safety stock for all raw materials within a certain category? I buy hundreds of chemicals for my company, and I want to be able to view on one report the 12 month history/usage…

This is a very broad question because I'm continually amazed at how little I seem to know about this screen. I need to gain an understanding of which are the hard numbers that come from stock transactions vs which are screen calculated numbers that…

I am getting the following error on the CLOPER REPORT: I am doing the following on SQL select distinCt IPTDAT_0, VCRNUMORI_0, * FROM PROD.STOJOU where AGGIFAFLG_0 = 1 AND IPTDAT_0 <= '01/31/2018' I get 25 results. What do I need to do from this…

I'm trying to track the health of our shipping department and I just want to ensure I fully understand the create date in the StoJou table. does that mean when the delivered qty is taken out of stock ? and if yes, does that also mean when the shipment…