Known issues
      Back to home
      1. MYOB Acumatica Knowledge Base
      2. MYOB Acumatica platform
      3. Known issues

      Generic Inquiry does not convert information to a decimal using the function CDec

      The system converts eg, CDec(2.6) to CONVERT(DECIMAL, 2.6). SQL assumes DECIMAL(18,0) by default, rounding the value. This is not GI-specific; it is a bug of the Database layer

      Date: 14/05/2024

      Status: Fixed in Acumatica build 2024R2Preview2, will be merged into upcoming release 2024.2

      Reference: CE00047519

      Issue

      Generic Inquiry does not convert information to a decimal using the function CDec

      Workaround

      Use: =CDec(CDbl([InventoryItem.AVGLENGTH_Attributes])*100)/100