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
Acumatica Generic I...
GI Results Duplicat...
 
Notifications
Clear all

Questions [Solved] GI Results Duplicating

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by byates 5 years ago
2 Posts
1 Users
1 Reactions
1,702 Views
RSS
byates
Posts: 20
 byates
Topic starter
May 3, 2021 6:17 pm
(@byates)
Eminent Member
Joined: 5 years ago

I have noticed a reoccurring theme of when I try to edit a GI and add a field that the results are duplicated and values multiplied. Obviously, I am missing something but don't know what to look for or if there is a common cause. Example below as well as the table relations. I added the POLandedCostDetail table, as I wanted the APrefnbr added, and you can see the join and I did not add a data link.

Additionally, is there a way to change the number formats in GIs?

ย 

image
image

1 Reply
byates
Posts: 20
 byates
Topic starter
May 3, 2021 6:22 pm
(@byates)
Eminent Member
Joined: 5 years ago

I believe I just solved it. Added a data link for refnbr and that seemed to do the trick. 😀ย 


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 7 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
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 ยฉ 2026 ยท AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

โ€นโ€บร—

    โ€นโ€บร—