Use Sidebar LHS to navigate
For global help click here

Retail and Warehouse Stock Replenishment

See also Retail Store Batches - sending multiple orders in a single batch to a Retail Store for when multiple orders are sent in a single shipment

A key point to note

Planning warehouse stock levels uses retail sales data less expected PO's (if ETA is less than 6 weeks (42 days) ago) - it ignores sales orders from the retail store to the warehouse

Planning retail stores replenishment uses Store Max target levels - always filling to target

Table of Contents

This training document steps through the way the franchisor warehouse manages purchasing

  • for the Franchisor Warehouse
  • for the Retail Stores (Franchisees)

Target Stock in Retail Stores

Each store has a target stock level for each item

  • Stores do not stock based on sell rate - instead a person decides to carry more or less stock of an item at the store.

Every replenishment from the Franchisor aims to achieve target stock level (after other known requirements)  

  • Change of the target stock level on any stock article is only available to the Franchisor

Articles which have a Trigger set will be refilled to target when Stock on Hand is less than or equal to the Trigger.

Refill will be in Carton Quantities if the Selling > shipping unit is set to Carton

Special Uplifts

Special uplifts can be applied to increase the targets

  1. Create a playlist and add items to it
  2. Create a special uplift list in the "Saved Lists"
  3. Copy from the playlist and set the date effective

Stock from Franchisor Warehouse to Retail Store (single click all stores)

Franchisor

Review and allocate available stock

Using existing stock (or stock expected soon) plan the shipments going today or tomorrow to the retail stores.

For items that are picked from Stock in the Franchisor Warehouse then sent to the stores - a purchase order is required from the store to the Franchisor and a matching Sales order in the Franchisor.

  1. Filter the items using multi-select of the suppliers.  
  2. Update the Grids
  3. single click create the Retail Store Purchase Orders + Franchisor Sales Orders

Multi Select only the suppliers you plan to supply from the warehouse - ie remove Drop Ship Suppliers. Drop ship suppliers will not have stock in the warehouse so no sales order / purchase order will be created.

The concept is to review all the requirements that can be fulfilled across all the retail stores at once

  • Compare requirements with stock on hand
    • Ignore un-pickable locations (pick sequence is -ve)
  • Provide visibility of expected stock ETA
  • Adjust quantities to manage scarce stock across the stores
    • (warning) If you make changes in the screen and close the screen the changes are lost.  The reason is that the next time you open it the data is likely to be different
    • (warning) if you do not adjust then sales orders will be > SOH with first picked getting the stock
  • When finished - create all the transactions at once
    • Purchase orders in every retail store
    • Mirror sales orders in the Franchisor
  • Then the sales orders are ready to be picked in the Franchisor

Screen Explained

Select the stores to plan in a single plan

Each Retail Store is a column in the grid

  • Can edit the data in the grid (hover will show original calculated value once edited)

  • The total of all stores is Requirement (Req).  
    • If manually updated (red) mouse tip will indicate original value
  • ETA is date of next PO expected
    • hover indicates list of expected PO's, Status, ETA Date and Qty
    • Purchase Order lines that were expected more than 6 week ago are ignored
  • SOH is qty in warehouse at the moment (ignores stock in unpickable locations ie pick sequence is negative)
  • PARTS - are "Buy Only" items used in repairs
  • ACCESSORIES - are any saleable product
  • Supplier filter - every stock item has a listed supplier - this is used to filter the items shown

Refill calculation:

  • Achieve Target qty for each item (set at store level)
    • Special uplift lists can increase target quantity by a %
  • PLUS order lines
    • Authorised but not picked
    • "Waiting" for stock
  • PLUS parts in repairs marked "Waiting" for stock
  • LESS current stock on hand
  • LESS current purchase orders (for this warehouse) > sent not yet counted by the store
  • INCREASED to Carton quantity if "shipping unit" is carton (will be indicated in yellow note - eg Carton quantity [50] applied for XXXX)
    •  

Articles sourced from multiple suppliers > the default supplier is set to a Phantom supplier. See Parts Price comparisons below.

Only shows items if they have a status of Active or Proposed, or a status of Runout and the Warehouse SOH > 0.

Items in Runout status with a replacement item that have a reorder level in a store and no stock in the warehouse > system Copies the runout item reorder level to the replacement item if it has none and clears out the runout item reorder level.

Yellow note indicates special information

Action = "Create Store Orders" > Creates Purchase Orders in each Retail Store AND Sales Orders in the Franchisor

A Purchase Order is created in each of the Franchisee Stores.  Note STATUS = Sent

A Purchase order can also be created manually in the Franchisee and it will create a mirror PO

Mirror Sales Orders are created in the Franchisor

Each Purchase Order that is created in a Retail Store has a mirror Sales Order in the Franchisor

Sales Order Register shows the list of the Sales Orders created in the Franchisor

  1. Note the status is AUTHORISED - ie ready to pick, Line Status is "Plan"
  2. Note the link to the Franchisee Purchase Order number - PO Status is "Sent", line status is "Plan"

Sales order created in Franchisor to Franchisee will create a mirror PO


Pick the sales order

The warehouse in/out dashboard lists all orders that need to be picked

Or find from Sales Order Finder

Pick each sales order

Sales Order Status will change to "Picking", Line status will be "Plan"

Linked purchase order in the store will not change status from "Sent" with lines at "Plan"

Picking slip - pick and update quantities

Note that the pick sequence is based on the pick sequence setting in the warehouse.

Note that items stored in carton quantities will indicate # cartons to pick and a scan will add a carton quantity

If using Store Batches

Table of Contents

/wiki/spaces/DEV/pages/33036813


Store Batches are used by Franchisors to send products to Franchisees.

Why?

  1. Deliveries are frequent

  2. It is common for a single delivery to have multiple orders

    1. Intra-Franchise Orders (Sales Order from the Franchisor to the franchisee with mirror PO created in Franchisee)

      1. New stock items / urgent stock / special requests etc

      1. Parts replenishment

      2. Accessories replenishment

      3. Consumable items

      4. etc

    2. Supplier Drop Ship via Franchisor PO's (Purchase order from the Franchisor to a Suppliers that will pack an order per store but send to the Franchisor to check )

      1. It is expected that the lines on these purchase orders may not all arrive at the same time and hence they can cross store batches - including splitting partially counted lines

  3. It is important to check at both ends - this is done using scanning

    1. Every product that departs

    2. Every product that arrives

With so many things travelling - it is common that they travel together (often mixed in the same boxes) so this process manages that

Late Store Batch emails

A problem is created when stores do not indicate acceptance of the store batch and instead simply put the stock away. 

Late store order batches emails:

  1. Emails sent after 2:30 am daily.

  2. Sent to users with 'Receive Late Store Order Batches' secure feature for stores in their context.

  3. Store order batches will be reported if they are in Despatched status and the Expected date is before today.

  4. (Expected date is set to the next working day after the batch is created.)

Starting a Store batch

The Franchisor selects a store they want to send things to.  A list of transactions that may be ready to go now are listed

Only ONE store batch exists for each store at any one time. To create a new one the current one must be processed using "All boxes Picked and Packed"

Selecting a store will find the existing store batch if one exists.

A new store batch is not created until the first scan is done of a product.

The franchisor selects one of the orders to process - the lines will now be ready to scan. 

 The status of orders included

The Status of the orders listed are as follows

  • Drop Ship via Franchisor PO's = Sent, confirmed, picked or received

  • Intra-franchise orders = Authorised or picking

Finding the store batch you want to work on

Anytime can select another one to work on then go back to one you were previously on - there is only one at a time - so can simply select the destination on the front of the form.

Intra-Franchise Orders MUST be completely picked as part of the store batch. Unpicked items will be considered short shipped.

Adding sales order and dropship via warehouse purchase orders to a store batch

The warehouse in/out dashboard provides a right click option to add transactions to a store batch.  Alternatively a dropdown is displayed of all orders that are travelling from the franchisor to the store of the Store Batch.

If a Sales Order includes parts then the Franchisor Debtor record for this store Standard Profile must be set to Is Distributor  (B2B) .

If a Drop Ship PO via Warehouse has one or more lines with an invoice quantity already that is not linked to the Batch Box it cannot be included.

Ready to Scan

When you scan the first item - the batch is created (if there was not one already) and the first box is created and the item is added to the box. 

The sales order does not change status from "Picking" and the line remains at "Plan" - however the "Ship Quantity" will now have a value equal to the number scanned.  No Journals are written at this stage.

Right click to set a line to zero - the line will remain in "Plan" Status with the "Ship Quantity" set to zero and the line value set to zero.

Scan of items stored in carton quantities will add the carton quantity.

Scan Locks

Any user that scans into a batch is added to the locked users list. The batch cannot be completed and ready for shipping until all users with a lock have released their lock.

Lock:

  1. When a user scans an item into a box they put a lock on the batch.

  2. The user will be in the 'Show users with lock' popup grid.

  3. The lock will also show as Type Start, Notes Scan, in the Log on the Log/Audit tab.

  4. If a user has a lock on the current batch then the 'Release My Batch Lock' will be enabled.

  5. Clicking this button will release the lock.

  6. This should be done when a user has finished scanning items into a box.

  7. Removing items from a box will not release the lock.

  8. The release will also show as Type Stop, Notes Release, in the Log on the Log/Audit tab.

  9. The batch lock prevents any user from clicking 'All boxes picked/packed' until all locks on the batch have been released.

  10. The batch lock does not prevent this or other users from adding to or removing from boxes in the batch.

  11. A user with secure feature 'Override Store Batch Lock' can right click a user in the 'Show users with lock' list and override the lock.

  12. The override will also show as Type Stop, Notes Override, in the Log on the Log/Audit tab.

  13. The user who overrode will be named in the Related column.

Just keep scanning

If you print a picklist for the orders you are picking you can then walk around the warehouse picking it - and scanning items directly into a box as you go

Adding Boxes

Boxes can be added anytime.

Each box will indicate if it contains only parts (ie "Buy Only" SKU's - or Accessories (non part items) or both.

When ready - can create a second box.  Anytime flip between boxes the items scanned will go to the selected box

Because parts tend to go to a different area than non parts.  The boxes indicate if they have parts, some parts or no parts

Each item can only be in one box. If you have 10 of an SKU to send - you must put them all in the same box

Just Keep Scanning items into boxes - if you select "List Option" = Hide Completed  then the list will only show the items you are still trying to find

Cannot find an item

Right click to set the counted quantity to zero

The Sales Order line will remain in "Plan" status and the "Shipped Quantity" will be set to zero and the line value will now be zero.

Scanned too many warning

A warning will show at the time of an overscan

Can reduce the scan by one if you made a mistake - or clear the scan for a product completely

Set counted to zero option - The Sales Order line will remain in "Plan" status and the "Shipped Quantity" will be set to zero and the line value will now be zero.

Clear Counted - removes the count in "Shipped Quantity" on the sales order ready to start again.

Print Labels for the Boxes anytime

The labels are scannable when the box is received 

When Finished - All Boxes Picked - will move to Sealed

All users that have a lock on the batch must release their lock prior to the ability to move the store batch to sealed - see Store Batches - sending multiple orders in a single batch#AddingBoxes

Users with Secure Features#OverrideStoreBatchLock can remove others store batch locks

This process is not reversible.   Status will move to "Sealed"

 Sealing Process

The process updates all the lines on the related sales orders and drop ship purchase orders with a counted quantity and creates the intercompany invoices and removes the stock from the warehouse (where appropriate)

Warnings

If the counts are not as expected - a warning box will show and also a list of the issues found

The Details of the warning

Examples

  • Not enough were scanned

    • Intra-Franchise Orders - the line will be short shipped and the intercompany invoices will reflect the counted quantities

      • Any lines with no scan will be considered short shipped (and will trigger a warning)

    • Drop Ship PO via Franchisor - the line will be split (expecting the balance later) and only the counted qty will be invoiced

      • Any lines with no scan will be considered as expected later (and will not trigger a warning)

  • Too many were scanned (all will trigger a warning)

    • Intra-Franchise Orders - the line will be over shipped and the intercompany invoices will reflect the counted quantities

    • Drop Ship PO via Franchisor - the line will over shipped and the intercompany invoices will reflect the counted quantities

  • Not enough stock

    • A stock adjustment will be required before the stock count can be processed

The sales Order will change status to "Picked" and "Invoiced" - all lines picked will move status to "Picked" all lines with zero shipped will move status to "Unavailable" - the COGS journals will be created, the Debtor invoice created and the matching creditor invoice in the store created.

The Purchase Order (in the store) will remain in "Sent" status but will now be "Invoiced, the line status will remain in "Plan"

Print the box labels

Example label

Note that the box label is scanned in store POS on receipt of the box

Franchisor does a check scan

Note: there is a 2nd scan required in all cases

Stores can be setup to either

  1. Be able to do a single scan receipt of a box (common for non-profit share ownership stores)

  2. to not have access to single scan receipt of store batches (common for profit share ownership stores)

    1. Use Host company flag on each store “Franchisor handles stock receipt”

    2. open store batch screen for full scanning receipt of stock - do not allow single scan receipt (current functionality but not initiated by scan in POS)

      1. users with access to Warehouse in/out dashboard can initiate scan from there

      2. If a scan qty for a line is not the same as expected it must be scanned again

After prescan - status  on the batch is "Sealed"

Warehouse in/out dashboard - find the store batch out if wanting to prescan > right click to re-open pre-scan of a Batch-Box

Mark Batch as dispatched when picked up by courier

The batch cannot be received by the store until the warehouse has marked it as dispatched

From the batches screen > Mark the batch as dispatched

  1. OR from the warehouse in/out dashboard mark the batch as dispatched

When batches are dispatched from the warehouse, any drop-ship via warehouse POs in the batches will be marked as Shipped (Departed Supplier) if all non-cancelled lines in the PO are now in a dispatched batch. The POs will then not show in the Shipments In/Out dashboard.

The sales order changes status to "Dispatched" and remains "Invoiced" - the lines do not change status from "Picked" if stock is being sent or "Unavailable" if the ship qty is zero

The Purchase order remains as "Sent" and "Invoiced" and the lines change to either "Scanned" if stock is arriving or remain as "Plan" if stock is not arriving

View the expected boxes in store

From the POS screen view the expected Items by box with expected PO's listed on the top.

Single scan accept in store

San the store box label in the POS

Store does not need to scan check - simply scan the box using the POS.  All stock is now in the store inventory and can be put away.

Or right click in the shipments dashboard in the store.

PO Status will move to "Received" and "Invoiced" - the lines in any box scanned will move to "Counted" status.  The sales order and lines do not change status.

Once all boxes are received the PO status will be "Closed" and "Invoiced" and all lines (including for zero quantity) will be "Counted" status.

The Sales Order in the Franchisor will move status to "Delivered" and "Invoiced" and the lines will not change status from "Counted" for lines with a shipped quantity and "Plan" for items with no shipped quantity.


If not pre scanning then from the In Out Dashboard > Mark Dispatched (Store will have to scan each item to check)

  1. You cannot Despatch a batch unless it has a Booking Ref.

  2. You cannot Despatch a group of batches unless they all have a Booking Ref.

Dispatch when ready (can multi-select )

When batches are dispatched from the warehouse, any drop-ship via warehouse POs in the batches will be marked as Shipped (Departed Supplier) if all non-cancelled lines in the PO are now in a dispatched batch. The POs will then not show in the Shipments In/Out dashboard.

Use Dispatch Button on the batch - or MultiSelect batches then rightclick

Can review the items in each box

How do I know which box items were in ?

On the Drop ship purchase order a tool tip

In Store - view in POS of expected items

The POS has a view of inbound purchase orders.

To receipt a PO - simply scan the label

In Store - in out dashboard

If the label cannot be scanned to the POS then can use the store in/out dashboard

Each box will show as a separate line - and the number of lines that are still remaining to count (ie in plan status) will show in brackets 

Right click to process if the box label has not been kept.

In Store - Receiving the Boxes (when the store needs to scan each item)

When the box arrives in the store - from the in/out dashboard > right click to receipt

The Done Button is very important

VERY IMPORTANT to use the Done button once complete - no stock is added to the store until the done button is pressed.

If the Done button is used before all items as scanned - the unscanned items will be considered short shipped...

When is the stock moved to being in the store ?

After the DONE button - until then it is considered in transit.

ONLY COUNTED STOCK IS ADDED TO THE STORE

What if I scan too many?

There will be a warning displayed and a sound - you can manually adjust the count if you need to

if the scan is correct and more was received than sent - the system will create a purchase order variance

What if not everything is counted ?

The system will indicate and will ask you to confirm = then will create a purchase order variance

What if i get something unexpected in the box ?

The system will add it - it will become a purchase order variance

Purchase Order Discrepancies

See Purchase Order Variations

Single Step Receipt

Only available to users with the secure feature - Secure Features#SetStoreBatchCounted

  1. Show 'Set Scan to Sent or Reqd on all lines' button under items list of Scan Receipt form

  2. Will set Scan quantity to Sent quantity on all lines.

    1. If Sent quantity is null (shows as 0 in grid), will set Scan to Reqd Quantity.  Note this is different to a value of zero sent which is the case in interfranchise orders.

      1. This will allow this feature to be used for receiving warehouse purchase orders where the Sent or Invoiced quantity might not have been set.

  3. The Done button must still be clicked to finalise the process.

Accept Store Batch Box

This may be used by the Warehouse to accept a store batch box which has not been accepted by the Store

  1. Swap to the Store

  2. In / Out Dashboard

  3. Find the appropriate Store Batch

  4. Right click on Store Batch to receive

  5. Click on Accept pre-scanned Store Batch Box

Flow Process

If NOT using store batches

 Expand to see what to do when not using store batches

Update picked quantities - the pick will not be completed until all lines that cannot fulfill stock have a value.

  • when finished picking the invoices will be created (in Franchisor and also in Retail Store)

mark as delivered (if via Courier)

Enter the CON note on the sale order (enter freight estimate provided if want to compare with later actuals)

When the courier picks up a number of sales orders - multi select and mark as delivered

The sales order will be marked as delivered and invoiced

Retail Store

Receipt purchase order

The purchase order will arrive and is ready to be receipted to stock

When receipted to stock > Stock is created in the store


Drop Ship Suppliers (Franchise Drop Ship PO)

Drop Ship Suppliers are suppliers that there is no need to stock in the warehouse because they :

  1. have a short Lead time (eg same day)
  2. will create a shipment per store
  3. will ship to the warehouse where the order is checked prior to forwarding on

So replenishment of the store requirements involves creating a Drop Ship Purchase Order for those suppliers

  1. Stores Dashboard > Select a single supplier
  2. The Action Option "Create a drop ship PO per store" will be available

Limit suppliers to a single supplier in order to enable this option

Prices will be latest agreed price - maintained on Article as buy price. Note that Buy Prices may have volume price breaks

Stock on hand (SOH) is expected to be zero for all these items

Review the quantities required by the stores - update the grid directly for each store

Franchisor

Manually Create Drop Ship Via Warehouse Individually from the PO screen

Manually create a drop ship via warehouse purchase order:

  1. Switch to the franchisor.
  2. Open a Purchase Order form.
  3. Before saving, from the Status menu select 'Drop Ship via WH to Store:', select the state of the store and then the store.
  4. The store will be chosen as the Warehouse, the PO type will show as 'Franchise Drop Ship' and the franchisor warehouse address will be set as the delivery address.
  5. Select the supplier and items and process as normal.

Bulk Create for Franchisees from the Stock ReOrder Dashboard

1 purchase order per retail outlet is created - they are not automatically sent to the supplier as you may want to adjust them after talking with the supplier before sending them.

Review and Send the Drop Ship Purchase Orders

These purchase orders are created in PLAN status - find those that need action on the Purchase Reports Dashboard.  Open and email or mark sent

Open the Purchase Order > Email or Mark Sent

The purchase order is now expected at the Franchisor Warehouse

The PO ETA date will cause it to display in the warehouse in/out dashboard.  The Type is "Store via WH" (Retail Store via Franchisor Warehouse)

IF using store batches

Store batches enable sending of a group of sales orders and purchase orders all at one time.

See Retail Store Batches - sending multiple orders in a single batch to a Retail Store - start a store batch and select the purchase order.  Any lines that the supplier has sent can be added to a store batch.  Any lines the supplier has not yet sent will be able to be added to a later store batch

If not using store batches

 Click here to see what to do when not using store batches

The Franchisor opens the PO when it arrives - updates invoice quantity with counts

The Franchisor will be paying the supplier - these quantities will calculate the amount to pay the supplier.  Quantity can be greater or less than expected.  If less than expected a prompt will ask if more of the short shipped line is expected later and if so will add another line to the purchase order.

Can also update the prices per line if different to that expected

Counted Quantity will be updated by the Retail Store when they receive the purchase order


Franchisor sends to Retail Store - Marks the Purchase Order as "Shipped" status

When finished updating invoice quantity > Save > then move to Shipped status.

Retail Store

Retail Store Shipments in/out dashboard - receives and counts the Purchase Order

Count at the store (if want to)

As you can see above - the right click provides a number of options

  1. with no count = single button click - I know the count is as per expected or invoiced value
  2. Abilty to update some or all counts manually.  Recommendation is update any that are different to that expected - then use the "Set Counted to Expected When Empty" button to fill in the rest of the counts.

Propose putaway location (where will the stock end up)

Can set a single line as going to multiple locations (eg too much for one location).  Closing the form and re-opening it clears all proposed putaways.

Process all lines in plan status

Receipts the qty on the PO, Creates stock, creates intercompany invoices.


Purchasing to replenish the Franchisor Warehouse via RFQ

If a franchisor - this dashboard plans using the franchisees order history

if not a franchisor - this dashboard uses your sales order history for SKU's ticked "include in RFQ Dashboard"

This dashboard is for stock that moves regularly and does not have expiry dates

When a Franchisor - this does NOT require the Purchase Orders for each store above to have been created. The stock required in the warehouse IGNORES purchase order/ sales order transactions between the Retail Stores and the Warehouse

  • So it does not matter if you create the store orders for the warehouse before or after purchasing for the warehouse

Franchisor Warehouse Demand uses the sales in each store to calculate overall daily sell rate that the warehouse needs to support

  1. Existing purchase orders (into warehouse or Drop Ship into retail store) reduce the stock requirement for the warehouse

Not a franchisor uses the host company context you are in sales orders.

Planning

This purchasing planner uses the sell rate of each item to determine how many to purchase to cover a number of days of stock.  By default it only shows Items that need action.

  1. Pick a supplier (only a single supplier may be actioned at a time)
  2. Enter days back and days forward
    1. Sell rate (is calculated) = total sales days back / number of days
    2. Sales = sell rate * days forward
  3. Enter Part % Overhead.  Where a supplier charges in FX then an overhead can be applied
  4. Show no req: can list all items that have a sell rate regardless if they are required

Columns in the Report

  1. Daily Sell: Calculated Daily Sell rate
  2. Sales: # of items required to cover sales for the days forward
  3. Min: Min Stock Level desired after sales
  4. SOH: Current Stock on Hand
  5. PO's: Quantity expected on purchase orders in SENT Status or later and not counted
  6. Req: is requirement after considering all of the above
  7. Order: Editable column that starts with the Req value

Calculations

  1. Number of sales in the number of days back / number of days back = average daily sales
  2. Multiply by number of days forward = target
  3. LESS stock on hand
  4. ADD Target Stock level in the warehouse
  5. LESS purchase orders status SENT but not COUNTED

Changing the Order column - does not save - if you close and open the form the order column will show calculated results only, ie will be the same as Req.

Action > Create a PO with selected supplier

Use this option to create a Purchase Order on the selected supplier

Suppliers will be listed in the Stock Reorder form, Warehouse tab, Supplier filter if:

  1. There are any Active or Proposed articles that have the supplier selected as the Supplier.
  2. There are any Active or Proposed articles that have the supplier in the More Suppliers list.
  3. The supplier has the 'Is Distributor (B2B)' box ticked in the Standard Profile Extended Attributes on the Supplier/Creditor form.


uses order qty - will not be in sent status (so will need to be sent) and will open on the screen

See Purchase Order from PO to Goods Receipt for more details

Retail Markup Adjustments on Purchase Orders

PARTS ORDERS: Action > Save a version for a Parts Order

Parts typically can be sourced from multiple places with some OEM and some aftermarket or other quality levels - hence the need to review multiple quotes

Definition of a Part

Both of these tests result in a Part

  • Buy only > is "Buy Only" Stock Article and generic (can be sourced from multiple suppliers)
  • Classification = "Part"


Use this process when the products can be sourced from multiple suppliers

There can only be one parts order at any time

saves qty to the database for all items in the list - so can come back and work on the overall order later

The Parts Order is intended to be exported as a spreadsheet that is

  1. Sent to multiple suppliers to quote on
  2. Received back with quoted prices and quality comments - and uploaded

Sell rate is calculated using the Days Back and days forward based on sales orders found and does not use the stored system sell rate


Action > Create parts quote spreadsheet 

  1. Action menu:
    1. Option 'Create Parts quote spreadsheet' only available if Parts order list displayed.
    2. Option 'Import Parts quote response from ...' only available if Parts order list displayed.
    3. Option 'Create and Email Parts Purchase Orders to Suppliers'.
      1. Uses Email Template with System Usage of Created, Usage Context of Purchase and Recipient Role of Supplier, if found.
      2. Email BCCed to user.
      3. Email logged in Correspondence of supplier, purchase order and user.

send to supplier for them to quote on the XLS generated

Supplier Quality column should be one of:

  1. ORGNW - Original new
  2. OEMA - OEM grade A
  3. ORGRF - Original refurbished
  4. ORGFOG - Original FOG
  5. NG - Aftermarket / non genuine
  6. HCPY - High copy

When received back from supplier with prices / quality comments

Drag the XLS over the screen later when received - select the correct supplier it came from - ACTION> import parts quote response

Find by barcode will be used if sku not found (ie if SKU's have been merged since the spreadsheet was sent to the supplier)

Review and compare suppliers

Action > Review parts order

Supplier prices are in the currency of the supplier (essentially the raw data provided from the supplier) - so if suppliers have different currencies the price comparison may be misleading

Once an order quantity is entered for a supplier - the AUD value is calculated by converting the price from the suppliers currency and adding the Parts % overhead. Example - from below - the "weather resisitant bike mount we accepted Jacktel price of $100 USD x (1 / 0.7 ) AUD per USD x 1.15 parts % overhead = $164.29. Note also the AUD value is not an average - it is from the last column ordered - see first line below as an example


Steps

  1. Manually edit by enter quantities by supplier on any item - for example when a supplier has informed you they cannot supply the entire quantity
  2. either 
    1. Order best value where no order
    2. or create purchase orders only for those manually updated

System rules - creates Priority for cheapest price of similar quality.  Only top 3 quality levels will auto-order

Action menu, 'Order best value where no order' will order from supplier with:

    1. Lowest price of ORGNW or OEMA, if any, or
    2. Lowest price of ORGRF, if any, or
    3. Lowest price of ORGFOG
    4. If none of the above then no order will be set and the Quantity column will be highlighted blue

Create parts purchase orders

  • Created Purchase Orders are direct to sent status + Creates spreadsheets to send to supplier of the accepted order.
  1. Action menu:
    1. Option 'Create and Email Parts Purchase Orders to Suppliers'.
      1. Uses Email Template with System Usage of Created, Usage Context of Purchase and Recipient Role of Supplier, if found.
      2. Email BCCed to user.
      3. Email logged in Correspondence of supplier, purchase order and user.


Purchase orders will be received in the warehouse - see Also Purchase Order from PO to Goods ReceiptPurchase Reports DashboardPurchase Order Variations and the general help areas Purchasing Stock and Warehouse role training plans

Two types of suppliers explained - Drop Ship / Normal

There are broadly two types of suppliers - and this affects how the stores are replenished the stock items

  1. Drop Ship = Short Lead time suppliers that will create a shipment per store
  2. Normal = Longer lead time suppliers (stock needs to be held at a central warehouse

More detail

  1. "Drop Ship Suppliers" = No stock needs to be held in the Franchisor Warehouse for Suppliers with short lead times that will package per store
    1. A Drop Ship Purchase order is sent to the supplier per store (Address = Franchisor Warehouse)
    2. Franchisor checks counts the delivery at the warehouse, then sends it onto the Retail Store - where it is check counted again
  2. Normal Suppliers = Stock needs to be held in the Franchisor Warehouse
    1. Retail Store purchase order to the Franchisor
    2. A mirror sales order in the Franchisor to be picked sent from the Franchisor Warehouse

A diagram showing the different flows required by the two types of suppliers:


Internal Barcode Generation Process

When defining a SKU that requires a barcode there are two methods

  1. Use the barcode button on the SKU form (if the SKU does not already have a barcode)
  2. Import via XLS a range of SKU's with a column called "Barcode" with the value 
[AUTO]

Clicking the button will 

  1. reserve the next available barcode and put it in the SKU and Barcode fields.
  2. Can only be done for a new article with no SKU or Barcode
  3. If article is not saved then the barcode will be 'lost' and will no longer be available for auto allocation - ie once populated in the form save it or can only use it manually
  4. Any barcode already in an article SKU, Barcode or 'More Barcodes' list will be skipped.

Setting up the barcode prefix and length

  1. Two Company/Context Specific Symbols Configs need to be set up in the franchisor, if any:
    1. Key: AutoBarcodePrefix - will contain the initial characters of the barcode.
    2. Key: AutoBarcodeLength - the number of characters in the barcode.
    3. The barcode after the prefix will consist of a numeric sequence, with leading 0s to make up the length, incremented by 1 each time a new barcode is generated.
    4. Auto barcode generation will fail if the sequence is fully allocated, e.g. prefix of 710000 and barcode length 13 would have a sequence of 7 digits so barcode generation will fail after the sequence reaches 9,999,999.
    5. If the sequence length is 9 or more digits auto barcode generation will fail after the sequence number reaches 999,999,999.
    6. If you change the prefix and want the sequence to start with anything other than 1 (with leading 0s) then speak to Saasplications support and they can set this up. A prefix of 7100 and a length of 13 digits would normally start with 7100000000001.



For information about SaaSplications go to http://saasplications.com.au