Hello all,
I have been working on a GI where I am referencing a sub-GI. But whenever I apply any filter it throws me the following error:
How to resolve this?
Answer
Error: Multi part identifier could not be bound
Best answer by DipakNilkanth
Hi
This might be caused by specific data, as I've tried it in the 24 R1 sales demo instance. After applying filters, the GI is working fine and I'm not encountering any errors.
+11Hi
Please send the xml file of this GI so we can find out the cause of the error.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Hi
Please send the xml file of this GI so we can find out the cause of the error.
Best Regards,
NNT
Attached are the files.
+11Hi
I tested on the version_2024R1_24.107.0004 and found no errors.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Hi
I tested on the version_2024R1_24.107.0004 and found no errors.
Best Regards,
NNT
Hey
its just when I filter some value → click OK and then click on any of the column names then the error gets triggered.
+13Hi
This might be caused by specific data, as I've tried it in the 24 R1 sales demo instance. After applying filters, the GI is working fine and I'm not encountering any errors.
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
I am getting the error The multi-part identifier "PMQuote.QuoteID" could not be bound.
Relationship CROpportunityProducts Inner join PMQuote
Link CROpportunityProducts.QuoteID Equals PMQuote.QuoteID
This worked well on version prior to upgrade to 2024R1.
How can this be resolved On the DAC the QuoteID is visible on both tables
Did you figure it out? I got the exact same error on with the same tables.
It works on one GI but can’t have it working on a new one...
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.