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...
Add Location (state...
 
Notifications
Clear all

Questions Add Location (state) to the Invoice GI

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 5 years ago
4 Posts
2 Users
0 Reactions
1,162 Views
RSS
tinamckean
Posts: 4
 tinamckean
Topic starter
March 4, 2021 2:32 pm
(@tinamckean)
Active Member
Joined: 5 years ago

I am trying to add the state of a Location to the Invoice GI. (SO3030PL)  When I inspected the element that shows the state of the ship to location on the invoice,  I found the table to add (ARshippingAddress). When I try to customize the GI, I added the table and the field (State), but both state and state descriptor came up blank after I add them to the results grid and rerun the inquiry.  I must be doing something wrong, but can't figure out what. 

 

image
image

 

image

 

 


3 Replies
Tim Rodman
Posts: 3195
 Tim Rodman
Admin
March 8, 2021 2:16 am
(@timrodman)
Famed Member
Joined: 10 years ago

What does your join look like? I just tried it in Acumatica 2020 R2 (20.206.0011) and I had to use ARInvoice. For some reason SOInvoice didn't work for me:

image

Reply
tinamckean
 tinamckean
(@tinamckean)
Joined: 5 years ago

Active Member
Posts: 4
March 8, 2021 8:26 am
Reply toTim RodmanTim Rodman

@timrodman Thank you!  That did the trick.  Is there somewhere you can point me to learn more about how to join the tables correctly?  That is the part that I didn't have correct.


Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 10 years ago

Famed Member
Posts: 3195
March 8, 2021 12:08 pm
Reply totinamckeantinamckean
Tim Rodman

@tinamckean That's the trickiest part unfortunately. I'm building a course (click here) to cover that, but unfortunately it's not ready yet.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 22 Online
  • 2,411 Members
Our newest member: thollings
Latest Post: Generic inquiry with information from Audit history(CT301000)
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

  • Terry Payne James Taylor
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.

‹›×

    ‹›×