AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Increasing decimal ...
 
Notifications
Clear all

Questions Increasing decimal lengths for qty and unit price

 
Everything Else
Last Post by Tim Rodman 4 years ago
4 Posts
3 Users
0 Reactions
2,265 Views
RSS
Andrew Smith
Posts: 16
 Andrew Smith
Topic starter
January 7, 2022 6:24 pm
(@andrew-smith)
Eminent Member
Joined: 6 years ago

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


3 Replies
Wyatt.ERP
Posts: 128
 Wyatt.ERP
January 18, 2022 9:35 am
(@wyatt-erp)
Estimable Member
Joined: 6 years ago

Interesting idea, but I don't think it's realistically possible.  The data types in the DB for Qty and Value are all capped at 6, or in some cases, 4 decimal points. 


Reply
Wyatt.ERP
Posts: 128
 Wyatt.ERP
January 21, 2022 2:10 pm
(@wyatt-erp)
Estimable Member
Joined: 6 years ago

Turns out the users on Acumatica's community forum found a way.  Thought it was really interesting way to tackle it.

https://community.acumatica.com/customizations-147/increase-decimal-length-past-6-7828

I still had to modify the DB schema to accept the higher precision, and USD is limited to 2 decimals in the ExtPrice and total fields, but it was much easier to change in the system than I had thought it would be!

image

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 10 years ago

Famed Member
Posts: 3193
February 18, 2022 9:33 am
Reply toWyatt.ERPWyatt.ERP

@wyatt-erp Interesting. I wonder how well this would survive an upgrade 😀


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 38 Online
  • 2,412 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×