Show/Hide Toolbars

DBA Help

Navigation: Screen Help (F1) > Inventory > Stock Items

Stock Items - Sources Tab

Scroll Prev Top Next More

(Inventory – Stock Items - Sources Tab)

 

Item suppliers and manufacturers are designated on this tab, which is only visible against P (purchased) items.

Links:

Gude   Startup Guide - Item Suppliers and Prices

Gude   Startup Guide - Item Manufacturers and Part Numbers

Gude   UM Conversion - Purchasing in a different unit of measure

 

Stock Items Sources

Screen Details

Suppliers Sub-Tab

Use this tab to designate this item’s authorized suppliers.  

Supplier

Select the supplier from the lookup.  Each supplier listed on this tab is available for selection in the MRP screen for PO generation.  

Default

Select this checkbox against the default supplier.  MRP automatically selects the default supplier during PO generation.  

Supplier Part No

You can optionally enter the supplier’s part number in this field, which flows through to the printed PO.  If you leave this field blank, the DBA item ID is used as the supplier part number.    

Description

Enter the supplier’s description, which flows through to the printed PO.  

UM

This is the supplier’s unit of measure, which flows through to the printed PO.  

Multiplier

If the supplier sells in a different unit of measure than the item’s stocking unit of measure, the Multiplier is used translate your PO order quantity into the supplier’s unit of measure quantity, using this formula;  

PO Order Qty * Multiplier = Supplier Qty

NOTE: This field is given a value of ‘1’ by default.

Using the Multiplier Wizard

Click the button in this field to launch the multiplier wizard.  

_img75

Use the wizard to enter a ratio between your quantity and the supplier’s quantity.  For example, if you stock the item in feet and the supplier sells the item by the yard, enter ‘3’ as your Stock Qty and ‘1’ yard as the Buy Qty.  The wizard calculates the multiplier for you.  Click OK and the multiplier is inserted into the Multiplier field.

NOTE: The wizard entries are not saved and stored.  Each time you launch the wizard, you must make new entries.  

Supp Price (link to Purchase Prices screen)

This read-only field displays the current supplier price for this item.  You can click the button in this field to launch the Purchase Prices screen, within which this item and supplier are selected for editing.  

 

StockItems_Sources_Pricing_Popup

Purchase Prices Screen Elements

Supp Price

This is in the supplier's currency and unit of measure.  In the PO, this price is multiplied by the supplier's Multiplier (from the Sources tab of the Stock Items screen) to determine the PO line's unit cost.  This enables yu to buy the item in a different unit of measure than your stocking unit of measure.

From Date

This date is populated by the current date at the time the purchase price record was created.   It records the price when it went into effect.

Thru Date

This is optional and is used to indicate an expiration date in cases where you quoted a special price for a limited period of time.  If the price does not have an expiration date, leave this field blank.

Notes

You can enter freeform text in this field for reference purposes.

Formula

A formula can be used to accommodate quantity price breaks.   If you wish to define a formula price, do not enter a supplier price and select the Formula check box.   You enter your price formula using the following example as a template.  The formula result establishes the Supplier Price in the supplier unit of measure and currency.   The Multiplier and  currency exchange rate will translate the Supplier Price into the PO line unit cost.

If qty<10 then result:=100

If qty>=10 then result:=75

If qty>=100 then result:=50

Manufacturers Sub-Tab  

Use this tab to designate this item’s authorized manufacturers.  

NOTE: POs are generated for the default manufacturer.  When an item has multiple manufacturers, we recommend that you create a unique Item ID to represent each manufacturer and assign only one manufacturer to each such version of the item.  Unique item numbers are essential in order to differentiate components by manufacturer among your BOM and job components.  

Manufacturer

Select the manufacturer from the lookup.  Each manufacturer listed on this tab is available for selection in the Purchase Orders screen, should you wish to select a manufacturer other than the default manufacturer.  

Default

Select this checkbox against the default manufacturer.  MRP automatically selects the default manufacturer during PO generation.  

Mfgr Part No

Enter the manufacturer’s part number in this field, which flows through to the printed PO.