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
Acumatica Generic I...
Quantity on hand wi...
 
Notifications
Clear all

Questions Quantity on hand with Receipt number

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by CRM001 3 years ago
6 Posts
3 Users
2 Reactions
1,305 Views
RSS
Terry Y
Posts: 10
 Terry Y
Topic starter
May 18, 2023 9:12 pm
(@terry5201)
Active Member
Joined: 6 years ago

I want to have a generic inquiry form with 3 columns : Inventory ID, receipt number, quantity on hand.

Does anyone knows how can I get these data from database?

I can see this form on Adjustments screen. but can not see tables it is using(Screenshot attached)

image

5 Replies
CRM001
Posts: 5
 CRM001
May 19, 2023 10:52 am
(@crm001)
Active Member
Joined: 6 years ago
image

Hi Terry,

I hope this helps. Please let me know. 

Rgds,

Claudio


Reply
Terry Y
 Terry Y
(@terry5201)
Joined: 6 years ago

Active Member
Posts: 10
May 26, 2023 12:47 am
Reply toCRM001CRM001

@crm001 Thanks, your screenshot is very helpful for me to find the right table. This guided me to the DAC Schema Browser, where I found the data I need on the INCostStatus table.


Reply
CRM001 reacted
CRM001
 CRM001
(@crm001)
Joined: 6 years ago

Active Member
Posts: 5
May 26, 2023 10:29 am
Reply toTerry YTerry Y
CRM001

@terry5201 No worries Terry. I am trying to get more active on the forum. I am still fairly new to working with Acumatica in "real life".

Rgds,

Claudio

 


Reply
Tim Rodman reacted
Rick Piester
Posts: 21
 Rick Piester
May 19, 2023 2:18 pm
(@rpiester)
Eminent Member
Joined: 3 years ago

To get quantity on hand, we use INSiteStatus.QtyOnHand


Reply
Terry Y
 Terry Y
(@terry5201)
Joined: 6 years ago

Active Member
Posts: 10
May 26, 2023 12:50 am
Reply toRick PiesterRick Piester

@rpiester I need link with inventroy receipt number, so I found INCostStatus.QtyOnHand. it works ,thanks again


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 37 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.

‹›×

    ‹›×