Skip to main content
Answer

How to solve the Multi part identifier could not be bound

  • October 18, 2024
  • 5 replies
  • 597 views
J
Freshman I

Hi,

I am trying to develop a GI that shows me the main product along with its BOM and also shows the total inventory I have of each component in all warehouses.
I can't get it but when I apply a filter I automatically receive the message.

Can someone help me?

The main GI is Purchase Planning Report.

 

Best answer by amitr70

​@JavierGtz  A workaround. If you are not on SAAS or if you have a local copy of DB, plus you are good in SQL queries then you can write a view by extracting the query from Traces screen and tweaking it accordingly. I personally prefer views over acumatica native GI table and joins. 

2 Attachments
amitr70

5 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • October 21, 2024

Hi @JavierGtz ,

Are you applying the filter as a condition within the GI or as a filter on the result grid?  I don’t see the SubItemID as a field on the InventoryTotalQOH generic inquiry. 

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ 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
amitr70
J
Freshman I
  • JavierGtz
  • Author
  • Freshman I
  • October 21, 2024

Hi @JavierGtz ,

Are you applying the filter as a condition within the GI or as a filter on the result grid?  I don’t see the SubItemID as a field on the InventoryTotalQOH generic inquiry. 

Laura

Hi @lauraj46 

What I am trying to do is display the quantity that appears in the InventoryTotalQOH GI in the Purchase Planning Report.

I don't have any applied filters.

amitr70
lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • October 21, 2024

Hi @JavierGtz ,

I was able to replicate this issue.  I’m not sure about the cause.  Nested subqueries in Acumatica are a new feature in 2024 R1 and there may be some caveats.  I would suggest opening a case with support and let us know what you find out.

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
darylbowman
Laura03
Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • December 30, 2024

Hi ​@JavierGtz were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
amitr70
amitr70
Semi-Pro I
Forum|alt.badge.img
  • amitr70
  • Semi-Pro I
  • Answer
  • January 7, 2025

​@JavierGtz  A workaround. If you are not on SAAS or if you have a local copy of DB, plus you are good in SQL queries then you can write a view by extracting the query from Traces screen and tweaking it accordingly. I personally prefer views over acumatica native GI table and joins. 

{{@m!t r@nj@n}}
Chris Hackett
amitr70
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