Skip to main content
Answer

adding G/L accounts to Customers GI Inquiry in Receivables

  • March 27, 2023
  • 2 replies
  • 81 views
F
Jr Varsity II
Forum|alt.badge.img

I need to include the Sales Account under Customers in Receivables for a Generic Inquiry. I tried adding tables and the Location ID to pull the information but nothing is pulling. Attached is my export of the GI. What am I doing wrong? 

Thanks,

 

Framces 

 

Best answer by aaghaei

You have added the tables but forgot to join or maybe didn’t save 🤣. Add the join as follow between Customer & Location and you are good to go.

 

2 Attachments
iqraharrison

2 replies

aaghaei
Captain II
Forum|alt.badge.img+10
  • aaghaei
  • Captain II
  • Answer
  • March 27, 2023

You have added the tables but forgot to join or maybe didn’t save 🤣. Add the join as follow between Customer & Location and you are good to go.

 

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
F
Jr Varsity II
Forum|alt.badge.img

Aaghaei, 

 

Thank you this worked. 

 

Frances 

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved