I’ve got what seems to be an obscure technical question, but read all the way to the end to see why it matters.
If I build a Generic Inquiry on the CustSalesPeople table, the IsDefault field appears in the SQL Trace results, showing that this value is pulled from the database. See these two screenshots:
But if I build a Generic Inquiry on the POVendorInventory table, the IsDefault field does not appear in the SQL Trace results. Somehow it must get magically pulled from the Acumatica Framework somehow. See these two screenshots:
Now for why this matters.
I’m able to use CustSalesPeople.IsDefault in a CONDITION or a JOIN, but I’m not able to use POVendorInventory.IsDefault in a CONDITION or a JOIN.
Sometimes I need to get the “default Salesperson for a Customer” so I join from Customer to CustSalesPeople and include CustSalesPeople.IsDefault=true in the join. This works great.
But what if I need to get the “default Vendor for an Item”? I’m not able to do that because I can’t join from InventoryItem to POVendorInventory and include POVendorInventory.IsDefault in the join.
I would use the InventoryItem.PreferredVendorID field for this. It works. But, as you can see in this next screenshot, it’s marked as OBSOLETE in the new DAC Schema Browser which makes me wonder if it will be removed in future Acumatica versions:
Can someone help me understand how to get the default Vendor for an Item?
Maybe