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...
Getting Branch Name...
 
Notifications
Clear all

Questions Getting Branch Name for a Journal Entry

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by gonzo 8 years ago
3 Posts
2 Users
1 Reactions
2,897 Views
RSS
gonzo
Posts: 18
 gonzo
Topic starter
June 17, 2017 12:03 am
(@gonzo)
Eminent Member
Joined: 9 years ago

Hi Everyone,

Does anyone know how to get the Branch Name for a journal entry in the Journal Transactions screen?

I know that the journal entry fields are in the PX.Objects.GL.Batch data access class, but I'm not sure how to get the Branch Name.

Any ideas?


2 Replies
John Doe Updated
Posts: 3193
 John Doe Updated
Admin
June 17, 2017 12:06 am
(@timrodman)
Famed Member
Joined: 10 years ago

Hi Gonzo,

You can join over to PX.Objects.GL.Branch and grab the AcctName field to get the Branch Name.

To join PX.Objects.GL.Batch and PX.Objects.GL.Branch together, use these fields in the join:

  • Batch.BranchID -> Branch.BranchID
Acumatica Version 6.10.0472 used when composing this response

Reply
gonzo
Posts: 18
 gonzo
Topic starter
June 17, 2017 12:07 am
(@gonzo)
Eminent Member
Joined: 9 years ago

Ah ha! There were so many "Branch" tables that I wasn't sure which one to use. That works!


Reply
John Doe Updated reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 27 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

  • John Doe Updated
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.

‹›×

    ‹›×