Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

A purchase run is used to determine what products need to be ordered and in what quantities. Readysell provides two basic ways to calculate this: by defining minimum and maximum stock levels for a product (Min Max), or by considering average weekly sales.

Getting Started

Child pages (Children Display)
pageGetting started with purchase runs

...

ImageFieldDescription
DeleteAllows you to delete a selected supplier or selected suppliers off the purchase run without deleting the whole purchase run
Extract ProductsBrings up the purchase run selection window so that you can extract products and their suppliers based on the criteria of this window onto the purchase run
Change Supplier

Allows all products on a single purchase run to have their supplier set to one common supplier with a single button

Once a day. A purchase order run is created for the wholesale supplier. Their may be many suppliers on the purchase run. The user clicks a single button, selects the required supplier and all purchase order lines on the purchase run change supplier to the supplier that was entered.


FilterThere is a filter on the purchase run window which can show Order Required and Order Not Required and All. This filter is just above the lines to be ordered.
Change the filter to Order Not Required, the product should show in this list, the Message tab at the bottom of the screen will show why it doesn't want to order it, you can change the Qty field to read as the quantity you wish to order of this product.
Supplier's information
FieldDescription
SiteThe site for this proposed purchase order from this supplier. If you have more than one site, your purchase run may be for all sites which means the supplier could appear more than once to show a purchase run for each site's supplier
SupplierThe supplier the products are to be ordered from (this can change should you wish to change them to a different supplier)
Value Ex TaxThe value ex tax of the purchase run generated for each supplier
Value Inc TaxThe value inc tax of the purchase run generated for each supplier
Min Order ValueThe minimum order $ value of the purchase run/order required to order from this supplier. This is Inc GST
Minimum Order VarianceThe difference between what the minimum order value is and what you've so far added to the purchase run for that supplier

...

Field

Description
ProductProduct ID and Product Name appear in this field
QtyQty that the system thinks you need to order based on the criteria you used in the extract products window
Product UnitThe unit the qty refers to that is being proposed to be ordered
Unit Quantity On HandThe qty on hand based on the default sell unit
Price ExThe price ex per unit
Value ExThe total value ex per line (Qty x Price Ex)
Value IncThe total value inc per line (Qty x Price Inc)
Lead TimeThe date the product will be due to come in to your site. From the point in time that you send the order to the supplier, to the point where it lands in your site.

Item Details

...

sub tab

FieldDescription
Count of Weekly SalesThe count of time it sold per week - used when processing a purchase run based on average weekly sales.
Qty of Weekly ShipmentsThe total qty of shipments per week - used when processing a purchase run based on average weekly sales.
Stock RequiredThis is the stock required for this item
Qty on Sales Back OrderThe qty on sales back order for this item
Qty on Purchase OrderThe qty on outstanding purchase orders for this item
Qty AllocatedThe quantity allocated for this item
Qty On HandThe quantity on hand for this item
Unit Qty on HandThe qty on hand based on the default sell unit on the product
Qty AvailableThe quantity available for this item
Net Qty On HandThe net quantity on hand
Lead TimeThe number of days that the product takes to get to your site. From the point in time that you send the order to the supplier, to the point where it lands in your site.

Message sub tab

This feeds off the product you've selected on the Item Details tab and the filter selected (i.e. All, Order Required, Order Not Required)

...

--- Additional Figures ---
Qty on Hand: 4
Net Qty on Hand: 4
Total Qty of Unit Shipments for Date Range: 0
Total Count of Sales for Date Range: 0

Product Suppliers Tab

...

Suppliers sub tab (The supplier of the product selected above)

Shows the list of products per supplier (there may be more than one)

FieldDescription
SupplierThe supplier code and the supplier name
Minimum Order QuantityIs PrimarySupplier Product IDStock LevelStock Level UpdatedCost Price Break 1-10The minimum order qty for the selected product above per supplier record
Is PrimaryFlagged with a tick for the 1 supplier who is the main supplier you get that product from
Supplier Product IDSupplier's code for the product
Stock LevelLevel of stock for this product (relevant for those suppliers we are able to get that feed from)
Stock Level UpdatedDate the stock level was last updated
Cost Price 1This field shows the cost price breakper supplier for the selected product above

Outstanding Sale Orders

...

sub tab

Any outstanding sales orders that the selected product above may be on.  (i.e. back orders)

Expand
titleShow me


FieldDescription
ProductProduct Id and Name
Qty OrderedThis field shows the quantity on an order
Qty AllocatedThis field shows the quantity allocated to an order
Qty Back OrderedThis field shows the quantity backordered on an order
Qty On ShipmentsThis field shows the quantity on shipments for an order 
Product UnitProduct unit 
Price Inc TaxThis field shows the price inc tax on an order 
Discount PercentThis field shows the discount %
Tax CodeThis field shows the product tax code
Value Inc Tax OrderedThis field shows the product value inc tax ordered 
Supply TypeProduct supply type
NoteProduct note
Backorder Date DueProduct backorder due date

General Tab

FieldDescription
Supplier Product ID
Min Order Qty (Each)
Default Buy Unit
Buy Ship Unit
Default Order Unit
Is Primary
Default Order Unit
Archived
Supplier

...

FieldDescription
Period
Product
Quantity
Value Ex Tax
Value Inc Tax
Original Cost Ex Tax
Cost Ex Tax
Discount Value
Margin
Margin Percent
Gross Profit Percent
Number of Sales
Average Sale Value Ex Tax
Last Year Value Ex Tax
Last Year Value Ex Tax Variance
Internet Sales Value Ex Tax
Last Year Internet Sales Value Ex Tax
Last Year Cost Ex Tax
Last Year Cost Ex Tax Variance
Last Year Cost Ex tax Variance Percent
Last Year Margin
Last Year Margin Variance
Last Year Margin Variance Percent
Last Year Gross Profit Percent
Last Year Gross Profit Percent Variance
Last Year Gross Profit Percent Variance Percent
Diff From Last Year Value Ex Tax
Diff From Last Year Value Ex Tax Percent
Sale Value Less Than Last Year
Sale Value Greater Than Last Year
Internet Sales Value Ex Tax Percent
Cost Ex Tax At Cody P1
Margin At Cost P1
Margin Percent At Cost P1
Gross Profit Percent At Cost P1
Last Year Cost Ex Tax Variance At Cost P1
Last Year Cost Ex Tax Variance Percent At Cost P1
Last Year Margin At Cost P1
Last Year Margin Variance At Cost P1
Last Year Margin Variance Percent At Cost P1
Last Year Gross Profit Percent At Cost P1
Last Year Gross Profit Percent Variance At Cost P1
Last Year Gross Profit Percent Variance Percent At Cost P1

Message tab

The amount of stock that will be reordered is equal to weeks of floor stock x the quantity of weekly shipments

...

FieldDescription
Site
Transaction Number
Supplier
Value Inc Tax Ordered
Value Inc Tax On Order
Minimum Order Variance
Status
Product fields

Each product has a number of fields that govern how it behaves in a purchase run. These fields are set on the Products screen. The table below shows how each field is used in a purchase run, and the tab within the Products screen where each one is located.

...