How to create a filter that filters out allocated items in GI ?

Hi @skumar98 

To create filters in GI please see the example in the screenshots below.

Best Regards,

NNT

Hi @nhatnghetinh Thank you for your response. 

But the GI now does not have a dedicated field for allocated quantity. 

Sorry for insufficient information about the issue. Actually I need to first display the SO lines having allocated quantities so that it can be filtered out.

If anyone know of any GI that shows or displays the allocated quantity of SO line items wise please share with me.

Thank you

@sravikumar i believe you would need to join the SOlinesplit table to the GI which should allow you to add the IsAllocated field on the results grid.

in the screenshot you shared, is this a GI that already exists in the system 

Hi @iqraharrison Yes that GI already exists and I also tried but the records are repeating.

@sravikumar Did you get through with this? I used a left join in my GI.