• Average Cost evol./movement using Order Price rather than FIFO

    Hi, We've noticed a few funny jumps in our average costs. Please see the attached example. Is this being calculated correctly? The product is set the FIFO costing valuation method so not sure why it's using order price here and then decreasing…
  • How to change average cost lot with code

    Hi everybody. I need found system to update average cost lot without Miscelaneos Receipt /Miscelaneos Issue. For example: I have product A with 100 units of lot LOT1, and cost is 10. This stock I create with an Purchase receipt. Now, i create a…
  • 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…
  • Cumulative AUC cost versus Stock valuation report

    Hi City dwellers! nice case for you today! As always funky one! First question: Can we use the valuation report in the past for average price method? Cumulative or others. I documented a case with Sage Support but unfortunately, they were…
  • How does Average Cost Evolution screen work?

    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…
  • Subcontract standard cost VS. average cost method

    Hello, my question is in regards to which costing method is the correct/preferred method when working with subcontract orders. My company recently acquired SAGE X3 v.9 and we will start issuing subcontract orders. To add a little more complexity to…
  • How to change landed cost entered on a container after receipt?

    Hello, We enter cost using "Landed cost" from container to have average cost of a product. Many times, user either miss to enter ocean freight or duty % or other charges OR making mistake. Like to know how to change any of the component cost once…
  • 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…