x Want to participate? Join the group to interact

  • Can X3 handle purchases where cost is negative?

    We run Sage X3 Update 9 Patch 9. The cost of a product we buy is going negative. This occurs from time to time because the product is a by-product- sometimes the supplier can sell the by-product, but other times they have to pay us to take it. …

  • STOJOU table - understanding

    Hello, I am trying to comprehend the structure of the STOJOU table for purposes of providing a cost history. Does anyone know the sources behind the numbers? I am finding it difficult determining how AMTDEV is calculated (Variance not absorbed) There…

  • Check for stock on hand when creating a Sales Delivery

    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…

  • Sage X3 Fixed assets depreciation Calculation done but cannot see the Changes in Journal Entry

    I have implemented the fixed asset in Sage X3 version PU9 as per the curriculum provided in the training by Fixed asset instructor from Sage University. Performed every step as per his instruction. only problem that I found was I cannot see the any…

  • What is an appropriate Valuation Method for Product-Sites used exclusively back to back orders / purchase orders?

    What is an appropriate Valuation Method for Product Sites used exclusively for back to back purchase orders? ie. Goods ship direct from supplier to customer. There is no receipt. This is not Stock. We sell a product from; 1. stock locations. Average…

  • The setup is incomplete : Legislation=USA Work order receipt

    When trying to run the stock interface. I am getting the following error. KB This is from our system. I do not see anything related to USA Legislation.

  • Freezing a sku/stock despite having inventory

    Is there is a way once a sku's/product available stock reaches a certain number, we can freeze the sku so the system basically thinks that it is out of stock.

  • Valuation Methods - AVG vs. Order Price

    Hello, We have an issue with our system where in for Work Orders, the Raw Materials are being posted to the G/L on the valuation basis of Historical AUC (Avg cost), but the Finished Good is being applied to the G/L based on a different valuation method…

  • Material Variance Calculation in X3

    I am working within the WIPCOST (Manufacturing Module) table and trying to determine the calculation of material variance. I put in my Work Order number in the MFGNUM field. The TXNTYP is 9 for Material Variance. Then the AMOUNT is what is booking to…

  • Material Variance Calculation in X3

    I am working within the WIPCOST (Manufacturing Module) table and trying to determine the calculation of material variance. I put in my Work Order number in the MFGNUM field. The TXNTYP is 9 for Material Variance. Then the AMOUNT is what is booking to…

*Community Hub is the new name for Sage City