AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
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,676 Views
RSS
Andrew Smith
Posts: 16
 Andrew Smith
Topic starter
January 7, 2022 7: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 10: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 3: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: 11 years ago

Famed Member
Posts: 3204
February 18, 2022 10: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,533 Topics
  • 11 K Posts
  • 18 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×