Hello,
Under Vendors in Inventory you have the Vendor Number, Vendor Name, Contact, and Item Number. In GridView, these fields are accessed through the "I/C Items (2) Additional" table. The "Vendor 1 Name" field is actually the "Contact" field. I can't insert the full name from Payables because there isn't a related field. Where do I find the full name field?

Thanks
GridView 9.0E (120703), Inventory 8.1D (120126),
Payables 8.1E (121113)

Hi Mike,

The full vendor company name is not stored anywhere in Inventory. Adagio looks at the vendor record in Payables to retrieve the name when necessary, so that record sizes are minimized and allow for quicker processing.

If you want to include the vendor name in a GridView view, you can use the Edit / Insert Related Column function to grab the vendor name field from the AP vendor master file as a column for your inventory GridView inquiry.

Because I couldn't find a 'composite' table that combines IC Item (1) and IC Item (2), you have to create your view using the IC Item (2) table, and use 'Insert Related Column' function to get the vendor name and all the desired columns from IC Item (1).

Hi Mike,

It was pointed out to me that the Inventory tabled titled 'I/C Items Finder (read/only)' can be used for displaying information from all of the IC Items table.

But this doesn't solve your initial question for using Insert Related Data to get the vendor name. In order to do this, you will need to create a second view based on the AP vendor master table to include in your GV workspace, with just the vendor number and name fields. Ensure that the vendor number field has the same column title as your Inventory view. Then in your Inventory view, use a Calculated Column to GetLinkedValue from the AP vendor.

If you are using GridView 9.0F (the current version), this is much easier to do, because when you create a new calculated column, the other views in a workspace are listed in an 'External references' section, and this will do the formula syntax for you. This feature is demonstrated in the New Release video for GridView 9.0F.

Actually, you can use this formula:

to get the name of the first vendor from Payables and

to get the 2nd vendor name. I created the formulas by using "Get external data" to link from the payable transaction to vendor master to get the name, then pasted the resulting formula into the Inventory View and changed the {Vend # (2)} field to the requisite Inventory field.

While it is easier to generate these formulas using cut and paste, you can actually code to get any external data element you want from any table.

Thanks very much Andrew. Worked great. I was wondering where "@P81BVPM" is? I looked under the ADS Aliases in the Payables Data Dictionary but couldn't find it.

Hi Mike:
Look for "A/P Vendor Master" in the data dictionary.

It's not there. I have "A/P Vendor" @P81BVND but that's it. I looking in "Adagio Payables 8.1B-8.1E" dictionary.

Thanks

"@P81BVPM" is a composite dictionary that the exporter doesn't currently display. As I mentioned, I created the formula by asking GridView for the external link from the AP transaction file to the AP vendor Master.

"@P81BVND" works fine too.

Found the workbook - had to use the /h switch to display it.

Thanks