TABLE OF CONTENTS

• Description
• How does SoftLedger find the price?
• Rules
• Step By Step Instructions
  • Create
  • Use
• Important Considerations

Description

When a vendor you work with provides discounts for bulk purchasing of items, you are able to build out a pricing table within SoftLedger for added automation.

This feature, Vendor Pricing, links an Item & Vendor pair to create order quantity breakpoints (min/max values) and provide a price within that range. These prices are used when creating/updating a purchase order line with an Item. When the Item order quantity is input, we automatically populate the price based on the vendor price rules created.

How does SoftLedger find the price?

SoftLedger will;

Automated workflow - in the order provided below

• Retrieve price from a Vendor Price entry
• Retrieve price from the Item purchase price
• Retrieve price from last Shipment Receipt

Manual workflow

• If none of those requirements pass, the user has to input the price manually
• Also, if the user is not happy with the automatically retrieved price, they can still enter it manually.

Rules

Let’s get Technical

This feature allows the user to build rule based pricing for each vendor and item.

For each Vendor, you are able to select an Item & set pricing as follows:

• Price = The Price associated with the order quantity range you will be setting.

• Min and Max values: Setting the breakpoints of this item’s order quantity range for the listed price. This can be decimals, but  they cannot overlap! 

Note: This can be done in bulk via Dimension Upload

Potential Errors to consider

Example 1

A quantity value, either min or max, cannot fall within an already provided range for that item. This will create an error. Visualized below with a table.

Example 2

If a Max Value is left blank, it will be treated as infinite, which could cause overlap errors. Visualized in the table below.

Step By Step Instructions

Create

• Create or Select an existing Item - Required

• Create or Select an existing Vendor - Required

• Go to Item or Vendor Details → Pricing Tab

  • Quality of Life Note: if you’re in the Item Page, the Vendor column should show. If you’re on the Vendor Page the Item SKU should show.

Item Page

Vendor Prices for Item #3 (Peach Jam). These are the vendors that sell this item

Vendor Page

Show case Peach Jam Vendor Prices for Jam Vendor

Create a new Vendor Price using the Rules stated above!

Use

Once you have your Vendor Prices created

Create a Purchase Order

• Select desired Vendor

• Select desired Item

• Enter the order quantity

  • If the quantity is within the threshold of the Vendor Price min&max, the amount will change to the price of the Vendor Price
  • If Vendor Price is not available, the system will default the amount to the Item Purchase Price
  • If Vendor Price is not available & the Item Purchase price is also not available, the system will default to the LATEST shipment receipt line amount(cost)

Vendor Price & Purchase Price Example

Example with Vendor Price for Preach Jam & Item Purchase Price for Mango Jam

In this Example:

• Peach Jam is Quantity 9, matches the 0-10 threshold, and $50 price

Mango Jam has NO Vendor Price and defaulted to $2.99 purchase price

Item description

Shipment Receipt Example

In this example, a Wrench does not have Vendor Price nor a Purchase Price in the system, therefore defaults to the latest Shipment Receipt price.

Wrench amount is $2.00 based on the Shipment Receipt amount

Shipment Receipt for Wrench

Important Considerations

• The Icon in the amount will only show up when we found an amount in our service

  • When you override the automatically retrieved amount, that icon will disappear

• If the user does not want to specify maxValue, the null/empty value will be considered Infinite until next minValue

• If you create an entry for Vendor Pricing of an Item that has no MaxValue set(signifying no upper bound), then you cannot edit that pricing. Instead, you would need to delete that pricing entry and add in a new entry.

Quick example of this

User types: