Item Running Balance


Previous Page  Next Page

This form is launched from the OrderStream profile bar by clicking on the Inventory tab and then Item Running Balance.

 

Items Running Balance displays the current status and all future transactions that affect the item. It projects the on hand balance by day of each transaction and provides a very useful tool for purchasing, sales and production personnel.

 

The user is able to view all inventory quantities by locations and transactions as well as the continuing running balance for the item.

 

clip0395

 

The user must first select the item. There are two ways to do this, the user can type in the item number, or the user can click on the arrow next to the Item No. box, then use the mouse to scroll through the list to find the item. Once the item is selected, the system displays all the information related to the inventory quantities that have been entered into the Seradex system as well as the unit of measure.

 

The first line of the screen shows the current quantity found in all the locations in the company as of todays date. The subsequent lines show the user the running balance for the item starting with the Opening Balance and adjusting the quantity accordingly for all scheduled Purchase Orders, Sales Orders and Work Orders that have been created and their dates of creation. The purchase order date is the due date for the item.

 

 

 

Effect on Quantity on Hand

Transaction

Finished Good

Item on a BOM

Sales Order

Decrease

Decrease

Work Order

Increase

Decrease

Purchase Order

Increase

Increase

 

Drop Shipments and Item Running Balance

 

Dropped shipments do not show up in Item Running Balance.  Items that are non drop shipments but are received elsewhere are still owned by you there they count as inventory and will still show up.