Solved

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

  • 6 January 2023
  • 8 replies
  • 181 views
M
Rank
Userlevel 5
Badge +1

I’m trying to generate a GI connecting the InventoryItem table to the POVendor table.

 

 

I want to limit the results to only show the default vendor and vendor inventory ID assigned to each item. However, if an item has multiple vendors assigned the results will display multiple lines for that item.

This “IsDefault” field does not appear to exist as a field by which I can filter the results:

 

Does anyone know of another way to go about this?

icon

Best answer by aborisova37 6 January 2023, 21:51

View original

8 replies

Y
Rank
Userlevel 5
Badge +2

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.

 

M
Rank
Userlevel 5
Badge +1

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?

DavidEichner
Rank
Userlevel 7
Badge +10

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

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
M
Rank
Userlevel 5
Badge +1

Hi David,

Please see the attached. Thanks!

1 Attachment
aborisova37
Rank
Userlevel 5
Badge +1

Hi @mikeho ,

you need to add one more relation to your GI for the InventoryItem and POVendor tables as shown below:

 

~Anna
DavidEichner
Rank
Userlevel 7
Badge +10

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

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
M
Rank
Userlevel 5
Badge +1

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

Michaelh
Rank
Userlevel 5
Badge

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.

Permanent Newb, don't let the posts fool you.

Reply


Terms & ConditionsCookie settings
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