Solved

Increase decimal length past 6

  • 8 January 2022
  • 5 replies
  • 425 views
asmith50
Rank
Userlevel 3
Badge +1

I am wondering if anyone has had any luck increasing the decimal length higher than 6 (Acumatic's OOB limit)?

icon

Best answer by Naveen Boga 8 January 2022, 07:16

View original
Andrew

5 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @asmith50  In Acumatica, OOB we can not provide the decimals more than 6.

If you wanted increase the decimals more than 6 decimal, it requires small piece of customisation.

I just worked on this customisation and hope this helps you. 

Please find the source code for your reference.

 

 public class OrganizationMaint_Extension : PXGraphExtension<OrganizationMaint>
    {
        [PXMergeAttributes(Method = MergeMethod.Merge)]
        [PXRemoveBaseAttributeAttribute (typeof(PXDBShortAttribute))]
        [PXDBShort(MinValue = 0, MaxValue = 10)]
        public virtual void CommonSetup_DecPlPrcCst_CacheAttached(PXCache sender)
        {
        }
    }

 

 

 

Naveen B
Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @asmith50  I can able to add more than 6 characters. Please find the code and screenshots for reference.

using PX.Data;

namespace PX.Objects.CS
{
    public class OrganizationMaint_Extension : PXGraphExtension<OrganizationMaint>
    {
        [PXMergeAttributes(Method = MergeMethod.Merge)]
        [PXRemoveBaseAttributeAttribute(typeof(PXDBShortAttribute))]
        [PXDBShort(MinValue = 0, MaxValue = 10)]
        public virtual void CommonSetup_DecPlQty_CacheAttached(PXCache sender)
        {
        }
        #region Event Handlers

        #endregion
    }
}

 

 

 

Naveen B
wyattERP
Rank

This is pretty cool!  @Naveen B I had to increase the size of the DB field manually for it to use the additional decimal places.  Is this something you ran into as well?  I feel like you would need to modify a lot of the db schema to be decimal(23, 10) for this to work everywhere.  I really love how Acumatica just goes along with the higher precision! 

 

Just running with Naveen’s idea, you can do the same thing for Qty:

        [PXMergeAttributes(Method = MergeMethod.Merge)]
        [PXRemoveBaseAttributeAttribute (typeof(PXDBShortAttribute))]
        [PXDBShort(MinValue = 0, MaxValue = 10)]
        public virtual void CommonSetup_DecPlQty_CacheAttached(PXCache sender)
        {
        }

 

asmith50
Rank
Userlevel 3
Badge +1

@Naveen B Your customer worked great. @wyattERP when I was attempting to increase the Quantity Decimal Places I could not get the field to accept anything over 6 characters. Any ideas? Do I need to add the two public virtual void lines together?

 

using PX.Objects;
using PX.Objects.CS;

namespace PX.Objects.CS
{
  public class OrganizationMaint_Extension : PXGraphExtension<OrganizationMaint>
  {
        [PXMergeAttributes(Method = MergeMethod.Merge)]
        [PXRemoveBaseAttributeAttribute (typeof(PXDBShortAttribute))]
        [PXDBShort(MinValue = 0, MaxValue = 10)]
        public virtual void CommonSetup_DecPlPrcCst_CacheAttached(PXCache sender)
        public virtual void CommonSetup_DecPlQty_CacheAttached(PXCache sender)
        {
        }
        #region Event Handlers

    #endregion
  }
}

Andrew
Naveen Boga
Rank
Userlevel 7
Badge +17

Yes @wyattERP  That is correct. We need to modify the database field to increase Precision for the required fields.

Naveen B

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved