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...
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,442 Views
RSS
tinamckean
Posts: 4
 tinamckean
Topic starter
March 4, 2021 3: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: 3204
 Tim Rodman
Admin
March 8, 2021 3:16 am
(@timrodman)
Famed Member
Joined: 11 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 9: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: 11 years ago

Famed Member
Posts: 3204
March 8, 2021 1: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,533 Topics
  • 11 K Posts
  • 25 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.

‹›×

    ‹›×