IC Reorder Quantity in Sage 300

By | February 18, 2017

The reorder quantity is the level of inventory which triggers an action to replenish that particular inventory stock. It is a minimum quantity of inventory of an item which a company holds in stock, such that, when the stock falls to this quantity, the item must be reordered.

We can set up reorder information (maximum, minimum, reorder, and projected sales quantities in item stocking units) for inventory items if we want to use the Overstocked Items report or the Reorder Report to assist you in managing your inventory.

New StuffCreate GL Batch Entry from AR Invoice Entry

Please find below screenshot for I/C Reorder Quantity Screen.IC_Reorder screen

In this example, reorder quantity is set up for all location. We want to have a minimum of 400 on hand. We don’t want to have more than 1600, we can re-order in the multiples of 250, and our projected sales quantity is 1500.

This screen below defines which vendors can supply a particular product. As Accpac itself will not know that to who purchase order to be raised.

IC_Vendor details

As you can see, Vendor 1 can supply item A1-105/0. Moving on to the Create POs from I/C screen now.

PO Create POs from IC

There are usual selection options, to choose a range of items, locations, and things like that. I want to highlight the important ones here:

  1. Run Date: This corresponds to reordering periods. Remember seasonality? If I choose a run date between January and October, Accpac will replenish inventory up to 300 units according to my setup. Any date in November or December will replenish up to 400.
  2. Reorder Quantities for: – Reorder quantities can be setup either for individual locations or for all locations. This is decided on per item basis. While generating purchase orders, you have to choose which type of reordering you are going to use.
  3. Reorder Quantity box with four options: – Use this when you are reordering in multiples of some quantity.
  4. Finally, if an item has multiple vendors, you can choose which vendor to use.

So, how does Accpac know what quantity to order? The key is in the I/C Location Details screen.

IC Location details

For a given location, Sage 300 takes the Quantity on Hand, plus Quantity on P/O, minus Quantity on S/O. This is the quantity that is theoretically available. This quantity is compared with the maximum quantity defined in I/C Reorder Quantities screen. The difference is ordered.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity-enhancing utilities that we can help you with such as GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at accpac@greytrix.com. We will be glad to assist you.