CO can identify the pharmacies in the group that have surplus stock of the products in an order so stock can be transferred from another pharmacy rather than ordering more stock from the supplier.

If the Check for surplus stock check box was selected during order creation, the products on the Order window are shown with one of the following icons:

  • - when other stores have surplus stock of that product
  • Description: C:\Users\TANIA~1.CAL\AppData\Local\Temp\SNAGHTML1ff317fa.PNG - when no other stores have surplus stock of that product
  • Description: C:\Users\TANIA~1.CAL\AppData\Local\Temp\SNAGHTML1ff439dc.PNG - when CO is calculating the surplus stock

The Surplus stock field displays the current Stock on Hand at other store as Surplus.

To view the surplus stock of a product

1. From the CO Order window, either select a product with the blue plus icon () and click the View SOH/ Transfer button, or press [Alt+V].

The Current Stock Holding window is displayed.

a. Product: Displays the product you are viewing surplus stock for.

b. Order Quantity: Displays the quantity generated or manually added to the order.

c. Store: Shows the pharmacy that has surplus stock (where Surplus column has a positive number). Negative Surplus quantity indicates that the store has less than the quantity needed, base on their projected sales.

d. Re-Order: Displays the pharmacy's Re-order (Stocked) status of the product.

e. Surplus: Displays the surplus quantity.

f. SoH: Displays the pharmacy's current stock on hand.

g. Last Buy: Displays the pharmacy's Last Buy price.

h. The Qty field can be updated to request the stock from the pharmacy. Refer to Request a transfer from a CO order for more information.

2. Click Close to close the Current Stock Holding window and return to the order.


Q1. Does Surplus calculation consider the re-order flag? 

No, it does not.

Q2. What does Negative surplus mean?

CO reports negative surplus where the SOH is not enough for next 30 days. The surplus calculation uses the same algorithm that projected-sales order generation uses where:

  • order date is the current date
  • order period is 30 days

It calculates how much the store would need for the 30 days, then subtracts that quantity by current SOH.

Q3. What are pending transfers in CO?

Pending transfers are those that have been created in CO but have not been issued to the stores.