Chapter 613 MRP Counts

MRP Counts help you track production and material requirements through scheduling.

Set the Ship Date on Orders to allow Big Business to intuit your production schedule. Then, change the Status of orders from Placed to Released to assign inventory to them. Big Business updates MRP Counts to help you track what is Released or still Stocked.

This chapter lists various Warehouse Counts that can be named and calculated for you.


  MRP Counts

MRP Counts show Pegged or Released Qty's as they affect what's available otherwise.

MRP Settings let you rename Released


  Warehouse Counts

Warehouse Counts track stock in your warehouse, so you know what you have where. With the MRP Add-On, they show you what you have on the shelf, in process, or already shipped but not yet invoiced, so you know you'll know what to find, where.

For example, shipping an order can automatically update Shipped Qtys on the order, which update Shipped counts for your warehouse, which show what's left available.


  Stocked Count

Stocked is a Warehouse Count that indicates how many you should find on the shelf. It is part of the MRP Add-On and differs from Whse Qty On Hand by Shipped count.

To display, open the Warehouse Quantities search, click Add (+) and select Stocked. Initially the columns for Stocked, Released, Picked, and Shipped will have no value.


  Released Count

Released is a Warehouse Count that shows quantity that is allocated to specific orders. It is part of the MRP Add-On and calculates using Order Line Item Released Quantity.

To display, open the Warehouse Quantities search, click Add (+) and select Released. This column can be renamed in MRP Settings and may be called Pegged or Allocated.


  Picked Count

Picked is a Warehouse Count that shows quantity that is has been picked for orders. It is part of the MRP Add-On and calculates using Order Line Item Picked Quantity.

To display, open the Warehouse Quantities search, click Add (+) and select Picked. This column can be renamed in MRP Settings and may be called WIP or In Process.


  Shipped Count

Shipped is a Warehouse Count that shows quantity that has shipped on open orders. It is part of the MRP Add-On and calculates using Order Line Item Shipped Quantity.

To display, open the Warehouse Quantities search, click Add (+) and select Shipped. This column can be renamed in MRP Settings and may be called Finished Goods.


  On Hand Count

On Hand is the Qty of an Item that you own as the result of accounting and inventory.

Big Business records when you buy and sell an item including the Qty and Cost that is used to compute current inventory value and cost-of-goods-sold results when you sell.

On Hand is the Qty you own and is used to compute Avg Cost for your current stock. For MRP, you may change the Label for On Hand to something like Owned to clarify.


  Allocated Count

Allocated is the Qty of an Item that you owe as the sum of Qty Open on Sales Orders.

Big Business records that a Sales Order is Placed and sets Qty Open for items ordered.

Allocated is the Qty you owe for Placed or Partial orders and is cleared when invoiced. For MRP, you might change the Label for Allocated to a name like Demand for clarity.


  Available Count

Available is the quantity of an item that you own minus the Qty committed to Orders. In other words, On Hand minus Allocated. However, in MRP you may change names.

Big Business records that a Sales Order is Placed and sets Qty Open for items ordered. Qty Open is added to Allocated, which is subtracted from On Hand to find Available.

Allocated is the Qty you owe for Placed or Partial orders and is cleared when invoiced. For MRP, you might change the Label for Allocated to a name like Demand for clarity.


  Warehouse Open

Open is the quantity of an item you have minus the quantity released to fulfill Orders. In other words, On Hand minus Released. Open is an option in Warehouses Add-On.

Big Business records that a Sales Order is Placed and sets Qty Open for items ordered. Qty Open is added to Allocated, which is subtracted from On Hand to find Available.

Allocated is the Qty you owe for Placed or Partial orders and is cleared when invoiced. For MRP, you might change the Label for Allocated to a name like Demand for clarity.


  Item Allocations

Item Allocation is automatic and determines what is available and needed for all orders.

Item Allocations set Allocated, Available, Needed for items on all Orders when Placed. These Qty's appear on the Item, Items search, and reporting for your whole inventory.

To keep real-time inventory, Item Allocations are recalculated when order are changed.
When orders are invoiced or change, Item Allocations are updated to new requirements.


  Warehouse Allocations

Warehouse Allocation occurs when an order is Released to a warehouse for fulfillment.

Mark Released is an option in the Orders list to update open orders to Released status. Pre-Release is a checkbox on the Expanded tab of the Order to update select line items.

Release or pre-release allocates inventory for the order to block its being sold to others. Open amounts for the item or its components are reduced to show reduced availability.


  Warehouse Counts

Warehouse Counts help track items through any production and fulfillment processing.

Components can be available to sell as Open stock, reserved as Released or pre-release by orders, Picked for assembly into Build or Auto-Build items, and in turn be Shipped.

Finished goods can be Open and avail. to sell, reserved by Release or pre-release items on orders, Picked for production and packaging, and Shipped and waiting for invoicing.