Vendor Profile: Details Tab

The vendor's name.

If the selected vendor profile exists across multiple divisions, you must deactivate the profile at all divisions before you can edit or change the vendor's name. To do so, open the vendor profile at each division and deselect the Active for A/P and Active for Parts switches, then click Save. Once the profiles are deactivated at each division, change the vendor name at each division (ensuring that it is identical across all divisions), then click Save and reactivate the profiles. For more detailed steps, see Editing a Vendor Name.

The G/L Account number where the funds will be taken out of when producing checks to this vendor (optional).

The currency type the vendor accepts payments in. This may also cause a currency verbiage to be printed on the check, depending on the value loaded on the Currency screen.

Note:  If the vendor has any pending or outstanding vouchers the Currency field will be locked preventing a user from selecting a currency option from the drop down list.

Note:  The 1099 field applies if there are three categories of vendors to select from: Non-employee compensation, other income, or rent. These classifications determine in which box the amount prints on the 1099 form.

Used in the parts order calculation and represents the maximum sales increase factor allowed.

For maximum increase sales %, the system compares the last 12 months of parts sales to the previous year's sales history to determine the sale increase factor. If the value calculated is greater than the amount specified here, the factor loaded in this field is used. This only applies to parts loaded with OFC value of 1.

Used in the parts order calculation and represents the maximum sales decrease factor allowed.

For maximum decrease sales % the system compares the last 12 months of parts sales to the previous year's sales history to determine the sale decrease factor. If the value calculated is less than the amount specified here, the factor loaded in this field is used. This only applies to parts loaded with OFC value of 1.

If checked, the system automatically updates the cost field on the Parts Profile screen to newest receipted cost of the part on a Parts Order.

This option only appears if the Activate Update of Part Cost with PO Cost is set to 'Y' in the DIVTAB1 table in Green Screen.

Cost Code values and Discount values for purchases from this vendor are considered when calculating the new cost of the part.

The vendor's ordering cost for a part, factored in to the Economic Order Quantity (EOQ) The EOQ is a relationship between sales history, ordering cost, and carrying cost for a part. You want to order enough of the part to minimize the ordering costs, yet you do not want to order too many of the part or the carrying costs will increase. The EOQ will be higher for lower cost parts and lower for higher costs parts. The actual formula used is: The square root of { L12 (last 12 months sales for the part) x Ordering Cost / .12 x Net Price} equation.

Normally the ordering cost is set at $0.50 for Deere parts and $1.00 for non-Deere parts. If this vendor has an ordering cost other than these two values, enter it into the Ordering Cost field. A blank field uses the system defaults. The value loaded here applies only to parts loaded with OFC value of 1.

The Cost Code assigned to the selected vendor. This code determines the PO Cost and Landed Cost The Landed Cost of a part is the final cost of the part on an order after all applicable Order Creation and Order Update cost code factors have been applied to the Current Cost of the part. Cost factors are applied when the part is ordered and receipted into the system based on the order Type (eg. SO: Stock Order, MD: Machine Down, FI: Fill In, etc.) The Landed Cost of a part will, in turn, be factored into the Average Cost of a part (as specified in the Average Cost field of the Parts Profile tab.) For details regarding cost code logic, please see the Cost Code Logic topic in the FAQs and Troubleshooting section of the online help. For details regarding the Average Cost of a part, please see the Average Cost definition in the Glossary section of the online help. of a part when the selected vendor is placed on an order which, in turn, affects the Average Cost The average cost is automatically updated whenever parts are receipted in the system (either through inventory adjustments or parts orders). When a part is returned, the system uses the Average cost to return that part to Inventory. To calculate Average Cost, assume a part is added to the system with a cost of $10.00 and 2 parts are receipted. The average cost is $10.00 for each of these 2 parts. Now assume the cost increases to $12.00 later in the year and 1 additional part is receipted after that cost has increased. The new average cost is calculated as follows: (Old Avg Cost x Old on Hand) + (New Cost x Number of Parts Receipted at New Cost) / Old on Hand + Number of Parts Receipted OR (10.00 x 2) + (12.00 x 1) / (2 + 1) = $10.66 of the part.

Only Order Creation cost codes can be entered in this field, however if there is a matching Order Update cost code, both codes are used on any applicable orders to calculate the Landed Cost of the part.

If there is a Cost Code assigned to both the part and vendor on an order (or if the Cost Code is blank for either the part or vendor on the order), the system uses specific logic to calculate the Landed Cost of a part. For details, please see the Cost Code Logic topic.

Enter the number of order cycles to look at when calculating lead time for OFC M parts. This can be a value between 0 and 9.

A value of 0 indicates that the lead time (in weeks) on the Parts Profile should be used.

If the value is 1-9, and the number of order cycles is greater than or equal to the value in this field, then a lead time is calculated using the part's Average Order Cycle days.

For more detailed information regarding how the values entered in the Lead Time Order Cycles, Order Cycle Factor, Max Cycle Orders and Sales History Factor fields effect OFC M parts for the selected vendor, see Order Formula Code Calculations.