Follow

Eview for Tracking and Reporting IBPI Vendor Purchases

These are instructions on how to create an eview to track and report your IBPI Vendor purchases. First you need to make sure you have custom properties enabled in Eautomate:

Enabling_Custom_Properties.jpg

Go to Tools \ Options \ Misc. Options and check the box to Enable Custom Properties. If your Eautomate user doesn't have sufficient rights to set this option then you may need to ask your IT to enable the option for you. 

Next you need to create the new custom property that will enable you to indicate which vendors are your IBPI vendors:

New_Attribute.jpg

Go to Tools \ Lists and Codes \ Attributes and click New.

New_Attribute_Data_Type.jpg

Create the new IBPI attribute. Select Yes/No as the data type. If you do not already have a Vendor Configuration created, you will need to create one.

Creating_Vendor_Configuration.jpg

Go to Tools \ Lists and Codes \ Configurations (custom properties). Select New and create a new configuration called Vendor. Select Vendor Properties from the Group list. If a Vendor configuration already exists then edit the existing one.

Add_Attribute_to_Vendor_Configuration.jpg

In the available attributes drop down list, select the IBPI Vendor custom property and click Quick Add. Then click Ok. Now you need to assign the new custom property to all your IBPI Vendor records.

Vendor_Record.jpg

Go to People \ Vendors and edit each of the vendor records that are IBPI vendors.

Adding_Vendor_Config_to_Vendor_Record.jpg

On the Custom Properties tab of the vendor records, select the Vendor Configuration from the drop down list under Configurations.

Adding_Attribute_to_Vendor_Record.jpg

**If you have any trouble saving this set Custom Property to YES (the OK button is grayed out, this sometimes happens because eAuto doesn't recognize the addition of a custom property as a change to the record), then just change something else like adding a space behind the name and then delete it, then the OK button will not be grayed out anymore.**

IBPI.png

Set the IBPI Vendor custom property to Yes and click Ok.

Go_to_Eviews.jpg

Next you need to go to Eviews to create two new eviews. Click the Eviews button in Eautomate.

New_Vendor_Eview.jpg

In Eviews under System \ Accounts Payable, double click on the Vendors eview and click New. This will be the new eview to show a list of all the Vendors with the IBPI custom property set to Yes.

New_Vendor_Eview_2.jpg

Give the eview a name and click Ok. 

New_Vendor_Eview_Import_New_Columns.jpg

Click Edit on the new eview. Now you need to add the IBPI custom property to the eview so you can filter the eview by the custom property. Click Import New Columns.

Add_Custom_Property_to_Vendor_Eview.jpg

Under Source, change it from Linked Views to Custom Properties. Select the IBPI Custom Property from the drop down list and click Ok.

Move_Vendor_Attribute_to_Left_on_Vendor_Eview.jpg

Move the IBPI Vendor from the right side Unselected Columns to the left side Selected Columns.

Sync_Columns_on_New_Vendor_Eview.jpg

Click on the Filters tab and click Sync with Columns. Then click Ok.

IBPI_Vendors_Eview.jpg

Now you have an eview you can filter by IBPI Vendor equals Yes to see all your IBPI Vendors. Now you need to create an eview to identify purchases from those IBPI Vendors.

New_Purchase_Orders_Eview.jpg

Under System \ Purchase Orders double click the Purchase Orders eview and click New.

Remove_Columns.jpg

Give the eview a name and remove any columns from the left Selected Columns that you don't need, to the right Unselected Columns. 

Remove_Unreceived_Sum_Function.jpg

Go to the functions tab and remove any functions for columns that you just removed. Move the unused functions from the left Selected Functions side to the right Unselected Funtions side and click Ok.

Import_Columns_on_IBPI_Vendor_Purchases_Eview.jpg

Click Edit on the eview and click Import New Columns.

Select_Custom_Property_from_Vendor_Eview.jpg

Under Linked Views, select Vendors (Vendor) from the drop down list. Find the IBPI Vendor column in the list and click Ok.

Move_IBPI_Vendor_Custom_Property_to_Left_in_IBPI_Vendor_Purchases_Eview.jpg

Move the IBPI Vendor column from the right Unselected Columns to the left Selected Columns.

Sync_Columns_on_New_IBPI_Vendor_Purchases_Eview.jpg

Click on the Filters tab and click Sync with Columns. Click Ok.

Filter_New_IBPI_Vendor_Purchases_Eview.jpg

Now you can filter the eview by a specified date range and IBPI Vendor equals Yes to see a total of all purchases from IBPI Vendors during the specified time frame.

Creating_IBPI_Vendor_Purchases_Saved_Search.jpg

You can save this search for future use. Click the down arrow next to Searches and click Save as.

Creating_IBPI_Vendor_Purchases_Saved_Search_2.jpg

Give the search a name and click Ok. 

IBPI_Vendor_Purchases_Saved_Search.jpg

It will now show in the list when clicking the down arrow next to Searches.

Right_Click_for_PO_Details.jpg

If you want more detail on any of the Purchase Orders listed in the eview you can right click on it and click Purchase Order Details.

PO_Details.jpg

This will show you the individual line items on the Purchase Order selected.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk