Vendor Inventory

Form ID: (PO201000)

On this form, you can maintain vendor inventory catalogs—lists of items purchased from a particular vendor and their prices. The system uses this information when users create purchase orders. For more information, see Vendor Catalogs.

You can maintain catalogs for particular vendor locations if the Business Account Locations feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Location box appears in the Summary area of the form, and the system can track the inventory of individual vendor locations.

You can import the lists of items you purchase from your vendors at their locations. You can also populate or expand a vendor's catalog manually by adding items to the table on this form. If you add an item to the current form and this vendor is not listed on the Vendors tab of the Non-Stock Items (IN202000) or Stock Items (IN202500) form for the item, this vendor is added to the list of vendors in the item's settings. Also, if you delete an item from the current form, this vendor is removed from the list of vendors in the item's settings. Similarly, the system automatically adds an item to the vendor catalog if the vendor is listed on the Vendors tab of the item settings on the Non-Stock Items or Stock Items form. The system also deletes an item from the vendor catalog if a user deletes the vendor from the item settings.

In addition, based on purchases of items from the vendor, the system may automatically add items to the vendor catalog (if they were not already listed for the vendor) and update each item's last vendor price. The option selected in the Vendor Price Update box on the Price/Discount Settings tab of the Accounts Payable Preferences (AP101000) form determines whether and when the updates occur:

  • When a purchase order containing the item is saved (if the selected option is On PO Entry).
  • On the release of a bill that includes the item (if the selected option is On AP Bill Release).
  • Under no circumstances (if the selected option is None). That is, the last vendor price will not be updated on entry or release of a vendor document, and the item will not be added to the vendor catalog for this vendor (if it was not already listed there).

In this list of items, you can maintain the alternate IDs used by the vendor. If subitems are used in your system, the vendor's inventory ID can be assigned to each inventory item–subitem pair.

Note: In documents, the prices specified on this form are used as the default prices if no vendor prices are specified on the Vendor Prices (AP202000) or Vendor Price Worksheets (AP202010) form. You cannot maintain tiered prices or promotional prices in a vendor catalog.

Form Toolbar

The form toolbar includes only standard buttons. For the list of standard buttons, see Form Toolbar and More Menu.

Selection Area

In this area, you can select a vendor (and a vendor location, if applicable) for which you want to maintain the vendor catalog. The table below then displays the inventory items you have purchased from the vendor (and location, if one is selected).

Element Description
Vendor

The vendor whose inventory catalog will be displayed. Select a vendor from the list of vendors that have been created on the Vendors (AP303000) form.

The list of vendors available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Vendors (AP303000) form. With the feature enabled, a vendor is available for selection if one of the following is true:
  • The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted.
  • A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the selected branch, or the Company Details tab of the Companies (CS101500) form for the selected company or a company within the company group.
Location

The vendor location from which the items to be listed are purchased. By default, the main location of the selected vendor is inserted, but you can select another location. Vendor locations are defined on the Vendor Locations (AP303010) form.

This box appears only if the Business Account Locations feature is enabled on the Enable/Disable Features (CS100000) form.

Warehouse A read-only box showing the default warehouse (in your company) that will receive the goods from the vendor location. This warehouse is specified for each vendor location on the Vendor Locations form.
Lead Time (Days) A read-only box showing the lead time for the selected vendor location. This lead time is specified in the Shipping Instructions section on the Purchase Settings tab of the Vendors (AP303000) or Vendor Locations form.
Currency A read-only box that showing the default currency used for transactions with this vendor. This currency is specified on the Vendors form.

This box appears only if the Multicurrency Accounting feature is enabled on the Enable/Disable Features form.

Table

In this table, you can view and edit the list of the vendor's inventory items that are available from the vendor at the selected vendor location (if applicable). The list includes items that might be purchased in the future and items that have already been purchased. If this vendor is specified for an item on the Vendors tab of the Stock Items (IN202500) or Non-Stock Items (IN202000) form, the item is listed in this table.

For each listed item (or subitem, if subitems are used in the system), you can specify the alternate ID used for the item by the vendor, and other vendor-specific information. The last column displays the vendor price (based on the purchase unit of measure) used last for this item on a document of specific type. There can be multiple lines for the same item if it is purchased in different units of measure (UOMs). To view all of the vendor's prices for a particular listed item, click the item in the table and then click Vendor Prices on the table toolbar.

Table 1. Table Toolbar

The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.

Button Description
Vendor Prices Navigates to the Vendor Prices (AP202000) form, on which you can view the available information about the prices that are used by the vendor selected in the Vendor box for the item selected in the table.
Table 2. Table Columns
Column Description
Active A check box that indicates (if selected) that this record (that is, this inventory item, or possibly subitem, purchased from this vendor) is active.
Default A read-only check box that indicates (if selected) that the selected vendor is the default vendor for this item. The state of the check box is copied by the system from the Default check box state in the row for the vendor on the Vendors tab of the Stock Items or Non-Stock Items form. If the vendor had not already been selected for the item as the default vendor on one of these forms, the check box is cleared, and you cannot select it.
All Locations

A check box that you select to indicate that the price of the specified item is the same for all locations.

This column appears only if the Business Account Locations feature is enabled on the Enable/Disable Features (CS100000) form.

Inventory ID The inventory ID of the item, as used by your company.
Description The description specified for the inventory item on the Stock Items or Non-Stock Items form. The description is read-only, and you cannot change it.
Subitem

The subitem code used with the inventory ID to denote the vendor's specific variety of the item.

This column appears only if the Inventory Subitems feature is enabled on the Enable/Disable Features form.

Important: The Inventory Subitems check box has been removed from the Enable/Disable Features form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Purchase Unit The unit of measure in which the item was purchased or can be purchased from the vendor. By default, the system populates this column with the value from the Purchase Unit box on the General tab (Unit of Measure section) of the Stock Items or Non-Stock Items form, but it can be overridden.
Vendor Inventory ID The alternate ID used by the vendor as its inventory ID for the item (or for the subitem of the item if subitems are used in your system). The system inserts the alternate ID it copies from the Vendor Inventory ID column in the row for the vendor on the Vendors tab of the Stock Items or Non-Stock Items form. If the alternate ID was saved earlier for this item on the Vendors tab of the Stock Items or Non-Stock Items form, it is copied to the Vendor Inventory ID but can be overridden.
Override A read-only check box that indicates (if selected) that for specific subitems the values in the following columns may be overridden: Add. Lead Time, Min. Order Qty., Max. Order Qty., Lot Size, and EOQ.
Add. Lead Time (Days)

The additional lead time for the selected item, which represents the additional time required by the vendor to produce, assemble, and dispatch the item. The system uses this value to calculate the lead time required to deliver the item purchased from the vendor's location to your company's warehouse by adding it to the lead time defined in the Lead Time box on the Vendors (AP303000) form.

This column appears only if the Inventory feature is enabled on the Enable/Disable Features form.

Min. Order Freq. (Days)

The minimum frequency at which the item may be purchased from this vendor location.

This column appears only if the Inventory feature is enabled on the Enable/Disable Features form.

Min. Order Qty.

The minimum quantity of the item the vendor (at this location) requires for an order being placed.

This column appears only if the Inventory feature is enabled on the Enable/Disable Features form.

Max. Order Qty.

The maximum quantity of the item the vendor (at this location) allows for an order being placed.

This column appears only if the Inventory feature is enabled on the Enable/Disable Features form.

Lot Size

The lot size of the item when purchased from this vendor location. If the lot size is not zero, the quantity on a purchase order is rounded up to match one or multiple lots. (No fractions of a lot are allowed.)

This column appears only if the Inventory feature is enabled on the Enable/Disable Features form.

EOQ

The economic order quantity for the item when purchased from this vendor location. This value represents the quantity of the item on an order that minimizes the item's holding and ordering costs.

This column appears only if the Inventory feature is enabled on the Enable/Disable Features form.

Currency ID The currency in which the last price was specified. The system inserts the Currency ID it copies from the Currency ID box on the Financial tab of the Vendors form. The value in the column is read-only, and you cannot edit it.
Last Vendor Price

The vendor price last used for the specified purchase UOM of the inventory item.

The way the price is updated is defined by the option selected in the Vendor Price Update box on the Price/Discount Settings tab of the Accounts Payable Preferences (AP101000) form. If None is selected in this box, the last vendor price cannot be updated automatically. If On PO Entry is selected, the last vendor price is updated when a purchase order is saved for the first time. If On AP Bill Release is selected, the last vendor price is updated on the release of a bill that includes the item.