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...
Creating a Line Lev...
 
Notifications
Clear all

Questions Creating a Line Level Report, Bills Overview

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 6 years ago
3 Posts
2 Users
1 Reactions
2,309 Views
RSS
SynxHouston
Posts: 14
 SynxHouston
Topic starter
March 8, 2019 5:06 pm
(@synxhouston)
Eminent Member
Joined: 5 years ago

My company had a a generic inquiry that exposed AP bill activity at the line level. After yesterdays update, we found the inquiry has combined the items and we're now left with a list of bills. It's basically a list of consolidated invoices vs detailed, item level bills list. I'm guessing it may be a simple join type issue...

I've basically gotten the gist of writing GI's, only missing piece is how to make a list at the line level.

I was attempting to use the object LineNbr from table APTran to expose the bills at a line level but it seems to be consolidating them into an invoice total...

 

Has anyone experienced this issue?

Thank you


2 Replies
SynxHouston
Posts: 14
 SynxHouston
Topic starter
March 8, 2019 6:10 pm
(@synxhouston)
Eminent Member
Joined: 5 years ago

I think I've solved it, looks like someone was messing with GI and set a grouping function....

This combined the lines 


Reply
Tim Rodman reacted
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
February 12, 2020 10:47 am
(@timrodman)
Famed Member
Joined: 10 years ago

Picking up an old post here. How have you found things in practice? Personally I like to recommend only having 1-2 people with permissions to modify Generic Inquiries for exactly this reason. Then all changes go through those 1-2 people so they are aware of everything and can play referee. But I'm curious to hear whether that's the approach that you wound up taking in your environment.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 50 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
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.

‹›×

    ‹›×