Skip to main content
Solved

How to get Default Vendor on GI?

  • June 4, 2026
  • 4 replies
  • 20 views

Forum|alt.badge.img+1

Hey there! Since “IsDefault” is non-existant in the POVendorInventory DAC how else can I bring in the default vendor for a specific inventory item?

Best answer by bwhite49

In the inventory item table there is a field called “PreferredVendorID.” You can join that field to the BAccount field in the POVendorInventory table

4 replies

bwhite49
Captain II
Forum|alt.badge.img+12
  • Captain II
  • Answer
  • June 4, 2026

In the inventory item table there is a field called “PreferredVendorID.” You can join that field to the BAccount field in the POVendorInventory table


Forum|alt.badge.img+1
  • Author
  • Varsity III
  • June 4, 2026

I tried that at first but then Acumatica told me that that field is obsolete and to use a different field (PreferredVendorID). I stopped there I guess I could have checked to see if it actually still worked in 25R1 :) 


Forum|alt.badge.img+1
  • Author
  • Varsity III
  • June 4, 2026

Hahaha I guess Preferred Vendor ID does still work :) nice thank you!


abrunner78
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • June 4, 2026

While it is non-existent, I have still been able to us it. 

Have you tried it?