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?
Solved
How to get Default Vendor on GI?
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
+12In the inventory item table there is a field called “PreferredVendorID.” You can join that field to the BAccount field in the POVendorInventory table
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 :)
While it is non-existent, I have still been able to us it.
Have you tried it?
While it is non-existent, I have still been able to us it.
Have you tried it?
I did, and you can view it on the GI but you are not able to use that field as a conditional within the GI (which is what I needed) :)
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.