By using this website, you agree to our Terms of Use (click here)
Here's an interesting scenario.
Some Data Access Class (DAC) fields in Acumatica only get calculated in the screen. So, when you drop them on a Generic Inquiry, they don't display any data. I'd seen that scenario before, but I'd only seen it be all or nothing, either the data was there or it was not.
This scenario though is new to me in that whether or not the data is there depends on what columns you've added to the Generic Inquiry.
Take this sample Item in the Stock Items (IN202500) screen and note the Default field on the VENDOR DETAILS tab:
If I create a Generic Inquiry with only these fields:
Then the Default column doesn’t get populated when you run the Generic Inquiry:
But if I add the VendorLocationID field to the Generic Inquiry:
Then the Default column gets populated correctly:
Note two screenshots ago that the Visible column is unchecked for VendorLocationID, but it can still be selected by a user with the Column Configuration icon, that was the best that I could come up with to "hide" the field:
This is strange/interesting behavior, but it's consistent with the Data Access Class (DAC) code which uses the VendorLocationID field for some reason (not sure why):
Like in Quantum Entanglement, it's in a superposition 👍
I have no idea what "Quantum Entanglement" is, but maybe that doesn't "matter" 🙂
This is extremely frustrating when you go to use this field and find out that it doesn't actually exist in the database.
Scenario: Add the default vendor to the Stock Items GI
@kyle-wright You can get the Preferred Vendor for the Item in the InventoryItemCurySettings.PreferredVendorID field.
This is how you join from InventoryItem to InventoryItemCurySettings:
