By using this website, you agree to our Terms of Use (click here)
I am trying to build a report from POVendorInventory table and Inventory Item table using joins. The isDefault field is unbound field and is returning null in the report. But when I do it in The Generic Inquiry getting the values from the POVendorInventory table, the default appears as a checkbox and appropriate values are displayed.
I took at look at this Vendor in the Vendor Inventory (PO201000) screen:
But, even though there are values on the screen, I don't see anything in the POVendorInventory.IsDefault field when I put it on a Generic Inquiry:
Then I checked the database and the IsDefault column doesn't exist in the POVendorInventory table so it must be something that get's calculated on-the-fly in the POVendorInventory Data Access Class.
As far as I can tell, the data seems to be derived from the InventoryItem.PreferredVendorID field.
So you might try adding a row to the join above: InventoryItem.PreferredVendorID=POVendorInventory.VendorID
Used Acumatica Build 17.204.0019 when composing this post.
Thank you, Tim!
InventoryItem.PreferredVendorID=POVendorInventory.VendorID worked perfect
Online Members
