• Data Type MD6 Rounding

    We have changed the MD6 data type to accommodate 6 decimals (11.6#). The field will accept the 6 decimals but when entering a Purchase Order however the price (GROPRI) rounds to 5 decimals when we save the order. (5.123456 saves as 5.123460) Any idea…
  • Sales Net Price Rounding to nearest 50c

    Good day A client has requested that a sales invoice total net price be rounded down to 50c for cash customers. Please see the example below: There are 2 lines on the BP customer invoice (which relate to the Sales Invoice too). The total value including…
  • 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…
  • 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…
  • Purchase order - Gross/ Net Price rounding

    Hi We are using Sage X3 Pu8 Patch 3 We purchase in manufacturing materials in high qty eg 34344 qty of caps at $0.15075 cents each. We changed MD6 gross price field to allow 5 decimals however the Net price is still rounding to 2 decimals on each…