How to limit a GI to inventory items with a default vendor

Hello @mikeho ,

There was a community post that may be able to help to get an idea about the IsDefault field in the POVendorInventory DAC.

https://community.acumatica.com/reports-and-generic-inquires-115/custsalespeople-isdefault-vs-povendorinventory-isdefault-7332

It may be helpful to you to create your GI.

Thank you, @YasasWithanage76. That post didn’t come up in my search.

However, I’m having difficulty figuring out how to include the InventoryItemCurySettings table in the GI. These are the fields I’m trying to display in the results:

All I need to do is make sure the results are limited to a single line per InventoryID and display the “default” PreferredVendorID.

Any suggestions regarding how to accomplish this by including the InventoryItemCurySettings table?

Hi Mike,

Can you export the GI as XML and upload it or email it to me?  I can take a look at it for you.

Best,

David

Hi David,

Please see the attached. Thanks!

Hi Mike,

Looks like that field is not actually stored in the database table which is probably why it can not be selected.  In looking at the InventoryItem table, there is a PreferredVendorID field that would need to be used in your join.  Let me know if you are able to take it from there or if you would like me to update the GI for you.

Best,

David

Thank you, @aborisova37 and @DavidEichner! Sometimes it’s the simple solutions that are hardest to see.

Is there a way to know from the DAC Browser that the POVendorInventory.IsDefault flag essentially moved to InventoryItem.PreferredVendor? This was frustrating to track down lol. I’d like to avoid this in the future if there’s a way to know that the field lives elsewhere.