Inventory reorder using Min-Max including committed items - Purchase Order Module

Inventory reorder using Min-Max including committed items - Purchase Order Module


Inventory reorder using Min-Max including committed items 


Inventory Reorder Process

To reorder Pedders items for a daily stock replenishment. A step process has been set to assist with selection and ordering of items.


From the main screen, side menu

Select 

1. Purchase Orders

2. File Maintenance / Reorder

3. Reorder Replenishment

4. Reorder Report

 Graphical user interface, text, application, chat or text messageDescription automatically generated



Next is displayed the protocol settings for how items a ordered and from which supplier

Graphical user interface, applicationDescription automatically generated

  1. S = Ordered by Item Code

U = Update reorder file each time to refresh daily the daily reorder 

  1. Is the selected supplier
  2. Ensures the order is located to the specific store that is placing the order
  3. Select OK to start report to create an order for all Pedders Items sold 

If any fields are not displaying similar to the above screen shot, ensure to default the field to relevant code or correct Warehouse number.

The next screen displays protocols for the reorder of items,

All fields should be defaulted as below, ensure that fields 1. “on Order and 2. “In Transit” are selected as “Y” to avoid ordering previously ordered components Graphical user interface, text, applicationDescription automatically generated

Select OK to continue and action the report. “I” is for immediate, then select OKGraphical user interface, applicationDescription automatically generated


Order will generate and update

Graphical user interface, text, applicationDescription automatically generated

Graphical user interface, application, WordDescription automatically generated

To view report as full page select the printer Icon and move to the PDF print screen.

TextDescription automatically generated with medium confidence

The order report is generated displaying the above

  1. Part number
  2. Part description
  3. Reorder quantity

 Select escape to receive update notice






Graphical user interface, application, TeamsDescription automatically generated


Inventory Reorder Review


The Reorder report is now prepared and able to be reviewed before creating a Purchase Order before to send to the local warehouse for stock replenishment

Graphical user interface, text, application, chat or text messageDescription automatically generated

Graphical user interface, applicationDescription automatically generated

Enter through next screen to produce the Reorder all Items Screen

This displays the data grid below listing all items and details present on the reorder. Graphical user interface, tableDescription automatically generated

Graphical user interface, text, application, TeamsDescription automatically generated

Using the top menu in this data grid. The order can be corrected. 

1. Entry will allow for the addition of items

2. Remove will allow for a reduction of items from the list along with Correction to alter quantities

Create Purchase Orders

After performing corrections and edits to the Reorder report it is required to create the Purchase Order to send to the warehouse 


Graphical user interface, text, application, email, TeamsDescription automatically generated

From the top menu select 1.PO
This will display the Create Purchase Order Screen

Graphical user interface, applicationDescription automatically generated

Ensure that the order date is correct, all other fields are defaulted for this process.

Select Ok to continue


The order process screen will display the Action field as “I” = Immediate

Select Ok to view the report progress screen.

This process may take an amount of time to complete.

Graphical user interface, applicationDescription automatically generated

Graphical user interface, application, TeamsDescription automatically generated


Graphical user interface, tableDescription automatically generated

The Auto Purchase Orders report is displayed, Press ESC to progress report

Graphical user interface, application, TeamsDescription automatically generated


Maintain Purchase Orders


The process of creating the Purchase Order for replenishment of daily stock on hand is now complete.

As yet the order still remains in the Store system with one more process to enable it to be sent to the local warehouse.

From the main side menu Select Maintain Purchase Orders

Graphical user interface, text, applicationDescription automatically generated







The data grid displaying all system purchase orders will be shown.

Search for 

1. The order created by the process

And 

2. The order status

If the order status displays as “Ready to Print” the order has not been pushed to the local warehouse. The status needs to be “On Order” for the process to be completed and the order sent 

Graphical user interface, application, table, ExcelDescription automatically generated

To alter this status, from the top menu select Extra 

Graphical user interfaceDescription automatically generated


From the drop-down menu select 

1. Print

Graphical user interface, text, applicationDescription automatically generated

Enter Print date

Graphical user interfaceDescription automatically generated

Graphical user interface, applicationDescription automatically generated

Confirm the Order has been printed and select OK

Return to the Order Maintenance screen 

1. Locate Order

2. Confirm Order Status now reads as On Order

This completes the process for Inventory Reorder. 

Graphical user interface, application, table, ExcelDescription automatically generated


Receipting Goods into Stock.

With the Inventory Reorder placed with the local warehouse

TextDescription automatically generated

The local warehouse will fill and despatch the order to the store.

On arrival at the store the stock item will need to be received into the system, invoicing accounted for and stock on hand and General ledger will need updating 

From the main side menu 

Select “Goods Received by Order”

Graphical user interface, application, table, ExcelDescription automatically generated

A data grid displaying Purchase orders will be displayed.

Select the Inventory reorder created that relates to the arriving stock in store

From the top menu select Goods Receipt

Graphical user interface, application, table, ExcelDescription automatically generated

Graphical user interface, applicationDescription automatically generated

Confirm the store number that is receiving the stock 

Graphical user interfaceDescription automatically generated with medium confidence

Data grid shown displays the following

1 Function for receiving stock 

2 The quantity ordered

3 Quantity being received. This amount can be altered to reflect actual quantity received

4 Back Order quantities. If filled by this order receipt the Back Order quantity will reset to 0

5 & 6 mirror the quantities in the field in the data grid above


Graphical user interface, applicationDescription automatically generated


Graphical user interface, application, tableDescription automatically generated

Graphical user interface, applicationDescription automatically generated



Graphical user interface, applicationDescription automatically generated

Graphical user interface, applicationDescription automatically generated

Graphical user interface, application, TeamsDescription automatically generated

Graphical user interface, application, table, ExcelDescription automatically generated




    • Related Articles

    • Inventory Re-Order Using Sales History - Inventory Reorder Module

      Inventory Re-Order Using Sales History The Inventory Reorder module is predominately used for reordering parts by a selected sales period, it does not consider previous items on order, but the report does show any items on order for the user to then ...
    • Reallocate committed stock from a Sales Order

      Reallocate committed stock from a Sales Order Reallocate from a sales order.mp4 (Note) this new functionality only works with stores that generate a sales order and commit stock when a booking is made, we are recommending all stores not currently ...
    • Committed Stock Report

      Committed Stock Report In Cognos reporting, go to Team Content > Franchise Reports > Inventory > Item Commitments – Sales Orders SM07 and run the report. (see below) Regards
    • Purchase Order Lock

      Release Purchase Order Update Lock  A user may get locked out of a purchase order, to unlock the Purchase Order Lock, go to the Purchase Order Module > File Maintenance/Reorder > Release Update Lock, locate the Purchase Order and select Release Lock
    • Min Max Maintenance - Merlin to Pronto

      This is the process for Franchise stores using Merlins Cobalt ERP to update their Min/Max’s in readiness for Go-Live on Pedders iQ. 1.    In Cobalt Create a Stock Level Report for a Product Group 2.    Include Reserved Stock on hand 3.    Enter the ...