Stock Control Activities

Document path Reference Contents > Inventory > Stock Control Activities

Most Stock Control functions are automatically processed within the system when actions are carried out on Sales, Jobs, Purchase or Work Orders. The system records the stock transactions, if Record inventory movements history is checked in the System Preferences window.

Tip TIP: Inventory Transactions can cause part Physical quantity to go negative. This can be a useful feature. However, you may wish to have the user receive a warning when physical goes negative during a transaction. Option optStockNegativeWarn, if set to 1 or YES, will cause a message to be displayed.

Tip TIP: You can add a Scrap and Rework processing tab pane to the window using the option optStockScrapRework. This is only usefull for parts that are set to Multi-location only and not batch tracked. See below for details.

Tip TIP: You can add a warning to users of excessive adjustment using the option optStockCtrlVarWarn. Set to a non-zero % of physical for which a stock control activity and stocktake result triggers a user warning. If physical is 1 or less any quantity will trigger the warning.

Customisation CUSTOM CAPABILITY: The Negative Stock warning message text is held in string number s1860.

Customisation CUSTOM CAPABILITY: Every stock movement is processed in a common routine. For special needs the $ctask.tCustom1.$StockTransaction(pQtyIntoPhysical,pQtyIntoStockLoc,pMoveType) can be used for post-processing.

The Stock Control Activities window accessible from Process -- Inventory -- Stock Control is used for making General Issues from inventory, Returns to inventory and inventory physical stock Adjustments. You also use this window to create locations for Multi-location parts and move quantities in and out of them. Finally there is an Advanced section that enables you to adjust maintained quantities.

Typically you can enter a part number partially or in full, use the navigation buttons, use the Keyword system, click on a Parts Scratchpad line or use drag and drop from the Scratchpad or BoM Listing.

The following fields are common to all tab pane functions.

Field

Description

Part number

Parts Master. Part number unique identifier. {PTMFILE.PTMPTNO char 18}

Description

Parts Master. Part description. {PTMFILE.PTMDESC char national 30}

Stock unit of measure

Parts Master. Standard stock unit of measure. {PTMFILE.PTMSTUM char national 6}

Bulk issue when kitting

Parts Master. Bulk issue flag. {PTMFILE.PTMBULK boolean}

Preferred location

Parts Master. Stores single or preferred location. {PTMFILE.PTMSLOC char 8}

Multi-location

Parts Master. Multi stock location indicator. {PTMFILE.PTMMLOC boolean}

Batch-tracked

Parts Master. Tracked (this part traced with batch tracking). {PTMFILE.PTMTRAC boolean}

Quality assurance tested

Parts Master. Quality assurance tested (requires entries in QA system). {PTMFILE.PTMQATS boolean}

Minimum stock

Parts Master. Minimum stock level. {PTMFILE.PTMMINS number 3dp}

Re-Order level

Parts Master. Re-Order level. {PTMFILE.PTMROLE number 3dp}

Float stock

Float stock is the difference between physical stock and non-quarantined multi-location stock and should always be zero for tracked parts.

With multi-location parts it is necessary that you understand the concept of FLOAT stock. Float stock is that stock in the physical quantity that is not included in specific non-quarantine multi-location quantities. For example, if:
Physical quantity = 10
Location ABC111 = 2
Location ABC222 = 3
Location ABCQQQ = 6 Quarantined
Therefore Float Stock = 10 - 2 - 3 = 5 (the quarantined 6 are not included in the Physical quantity of 10)

Quarantined stock

The total quantity of quarantined stock.

Current Quantities

For details see the Parts Current Quantity subwindow.

Button

Action

Show History List

To obtain a listing of movement history for the selected part.

Show Log List

To show a list of transactions you have made so far in this window session.

Cancel

Aborts the process currently in session. The keyboard equivalent is the Esc key for Windows computers and Command-.(full stop or period) for the Mac.

OK

The OK button updates the data you have entered, or confirms the selection and/or processes the function you have called.

The window has seven tab panes.

Issue

Return

Adjustment

New Location

Change Location Quantity

Advanced

Scrap and Rework (only with optStockScrapRework set)

Issue

To process a general stock issue.

With this option you can issue a quantity of the part for any non-specific purpose. Directly enter the Quantity and then, if you wish, a Movement reference and comment. Confirm with an Ok or press the enter key. If you want to cancel the movement, simply change the part or click on the Cancel button. The latter will close the window.

If the part is a Multi-location part and there are locations listed, you can issue from a particular location by first selecting it in the location list. If you want to issue from float stock, do not click on the list after selecting the part.

If the part is a Tracked part, you must identify in advance of entering the quantity which Location/Batch it is being Issued from. In this case you can not Issue from float stock. On confirmation you will be asked to enter a tracking reference, which may be helpful in the future when you are looking at the destinations of tracked materials. See the Batch Identification window for details.

You can not Issue from a Quarantine location.

With an Issue, you can add a Movement Reference and Comment which will be included in the Stock History record.

Note NOTE: "SO-", "JB-", "PO-", WO-", "IN-", "CN-" are standard system prefixes for Sales, Jobs, Purchase and Work Orders, Invoices and Credit Notes respectively.

Field

Description

Multi-Locations List

List of all multi-locations for the part.

Quantity issued from stock

The movement quantity of inventory in stock units of measure.

Movement reference

Stock Movement History. Reference for the stock transaction. {STHFILE.STHREF char 15}

Movement comment

Stock Movement History. Comments on movement. {STHFILE.STHCOMM char national 30}

Multi-location

Stock Locations and Quantities. Location identifier. {STOFILE.STOLOC char 8}

Batch Id

Stock Locations and Quantities. Batch identifier. {STOFILE.STOBATC char 7}

Quarantined

Stock Locations and Quantities. Quarantine flag (qty not in PTMPHYQ). {STOFILE.STOQUAR boolean}

Back to top

Return

To process a general stock return.

A Return operates in a similar way to an Issue. The direction of movement, of course, is into the stores to increase the physical quantity.

If you want to Return into a Multi-location, select the location first. Then carry out the return in the normal way.

For a Tracked part you will be offered the opportunity of adding a Tracking reference in the same way as an Issue.

You can not Return to a Quarantine location.

With a Return, you can add a Movement Reference and Comment which will be included in the Stock History record.

Field

Description

Multi-Locations List

List of all multi-locations for the part.

Quantity returned to stock

The movement quantity of inventory in stock units of measure.

Movement reference

Stock Movement History. Reference for the stock transaction. {STHFILE.STHREF char 15}

Movement comment

Stock Movement History. Comments on movement. {STHFILE.STHCOMM char national 30}

Multi-location

Stock Locations and Quantities. Location identifier. {STOFILE.STOLOC char 8}

Batch Id

Stock Locations and Quantities. Batch identifier. {STOFILE.STOBATC char 7}

Quarantined

Stock Locations and Quantities. Quarantine flag (qty not in PTMPHYQ). {STOFILE.STOQUAR boolean}

Back to top

Adjustment

To process a stock issue quantity adjustment.

An Adjustment operates in a similar way to an Issue or a Return. The direction of movement is determined by the sign of the quantity you enter. A positive quantity will increase the physical quantity like a Return. Whereas a negative quantity will reduce physical quantity in the same way as an Issue.

The treatment of Multi-location and Tracked parts is the same as in an Issue or Return.

You can not Adjust a Quarantine location's quantity.

With an Adjustment, you can add a Movement Reference and Comment which will be included in the Stock History record.

Field

Description

Multi-Locations List

List of all multi-locations for the part.

Quantity of +- adjustment

The movement quantity of inventory in stock units of measure. Negative reduces stock.

Movement reference

Stock Movement History. Reference for the stock transaction. {STHFILE.STHREF char 15}

Movement comment

Stock Movement History. Comments on movement. {STHFILE.STHCOMM char national 30}

Multi-location

Stock Locations and Quantities. Location identifier. {STOFILE.STOLOC char 8}

Batch Id

Stock Locations and Quantities. Batch identifier. {STOFILE.STOBATC char 7}

Quarantined

Stock Locations and Quantities. Quarantine flag (qty not in PTMPHYQ). {STOFILE.STOQUAR boolean}

Back to top

New Location

To set up a new stock multi-location.

This option is only available for parts flagged as Multi-location parts. You use it to set up locations for inventory that you have not received into a particular location during another stock control process such as receiving from a Purchase or Work Order.

Having selected the part and this option, enter a quantity in the quantity field box. Then tab to the Location field and enter a location. If you then confirm the new location with an Ok the quantity will be transferred from float stock into the new location. The Part's physical quantity will not change and no Stock History record is created for the transaction.

If you decide to make it a Quarantine location, you must check the Quarantine checkbox. Having done that you will be able to add a Movement Reference and Comment.

When you create a Quarantine location, you will move the quantity out of float stock, or another location if you have one selected, into the new location. This will reduce the part's physical quantity and create a Stock History record. The Non-Conformance Report Details window will open in which you can report the quarantine reasons.

For a Tracked part you will be offered the opportunity of adding a Tracking reference in the same way as an Issue or Return. You can only create a new location for a Tracked part if there is sufficient float stock for the quantity.

Field

Description

Multi-Locations List

List of all multi-locations for the part.

Quantity in new location

The movement quantity of inventory in stock units of measure.

Movement reference

Stock Movement History. Reference for the stock transaction. {STHFILE.STHREF char 15}

Movement comment

Stock Movement History. Comments on movement. {STHFILE.STHCOMM char national 30}

Multi-location

Stock Locations and Quantities. Location identifier. {STOFILE.STOLOC char 8}

Batch Id

Stock Locations and Quantities. Batch identifier. {STOFILE.STOBATC char 7}

Quarantined

Stock Locations and Quantities. Quarantine flag (qty not in PTMPHYQ). {STOFILE.STOQUAR boolean}

Back to top

Change Location Quantity

To change a stock multi-location quantity.

This option is only available for parts flagged as Multi-location parts. This is used to change the quantity held in multi-locations. You can also use it to change the Location code for multi-location entries. It is similar to an Adjustment acting specifically on locations.

If the part is not a Tracked part, through this option you can move a quantity from and to float stock.

If it is a Tracked part, you will normally not have float stock. However you can move a quantity from a selected location by entering a negative quantity.

On confirmation, you will need to identify where you are moving the quantity to using the Batch Identification window. Select a destination from the pop-up list. The FREE destination will place the quantity into Float stock. You can then add a Tracking Reference.

Field

Description

Multi-Locations List

List of all multi-locations for the part.

Quantity into selected location

The movement quantity of inventory in stock units of measure.

Movement reference

Stock Movement History. Reference for the stock transaction. {STHFILE.STHREF char 15}

Movement comment

Stock Movement History. Comments on movement. {STHFILE.STHCOMM char national 30}

Multi-location

Stock Locations and Quantities. Location identifier. {STOFILE.STOLOC char 8}

Batch Id

Stock Locations and Quantities. Batch identifier. {STOFILE.STOBATC char 7}

Quarantined

Stock Locations and Quantities. Quarantine flag (qty not in PTMPHYQ). {STOFILE.STOQUAR boolean}

Back to top

Advanced

To manually adjust process quantities such as allocation, due to SOs, due from P/WOs and kitted.

This is a System Manager function that gives access to otherwise automatic data values in the parts master files. The user can change the stored Allocated, Due out to Sales Orders, Due in from Purchase Orders and Work Orders and Kitted to Work Orders quantities for parts.

Although these quantities are maintained automatically by the system errors can occur either due to system malfunctions, interruption of terminal processing or changes in BoM structure while an assembly is on order.

This pane is available for manual changes. It is recommended that you use the Re-set Part Process Quantities function in the Datafile Integrity Maintenance window to globally reset part process quantities.

Field

Description

Allocation

To adjust the allocation quantity held for a part.

Due out to SO

To adjust the due on SO quantity for a part.

Due in from PO or WO

Make this selection to change the value of 'Due from POs and WOs' quantity held for the part.

Kitted to WO

To change the Kitted to WOs quantity.

Change quantity by + or -

The change quantity of value in stock units of measure.

Movement reference

Stock Movement History. Reference for the stock transaction. {STHFILE.STHREF char 15}

Movement comment

Stock Movement History. Comments on movement. {STHFILE.STHCOMM char national 30}

Back to top

Scrap and Rework (only with optStockScrapRework set)

This tab pane is only visible then the option optStockScrapRework has been set up. This is only usefull for parts that are set to Multi-location only and not batch tracked.

This option is useful for users that wish to record in a standard way the movement of stock into and out of a quaranened multi-location, typically for re-working. It further provides for stock to be removed and recorded as scrap.

The option is set with three text values of your choosing seperated by commas. All thre are case-sensitive. For example:
optStockScrapRework=MAIN,SCRAP,REWORK

  1. The first parameter (MAIN) is the multi-location to which stock is returned from quarantined rework. This is optional and if left blank stock is returned from rework to float stock.
  2. The second parameter (SCRAP) is the movement referance applied to an adjustment (N) out of stock. This can be from float stock if no location is selected in the list, or any location selected. If the location is a quarantine location the adjustment movement (N) will be preceeded by a release movement (T). If you use this for scrapping sub-quality parts, you can report this with a suitable selection in Inventory History reports.
  3. The third parameter (REWORK) is the quarantine multi-location into which stock is moved for rework.

Having set up the option, opening the Stock Controls Activity window will show the tab pane. The title text above the Quantity (+ rework - scrap) will show differently depending on the part characteristics, the quantity entered and location selected in the Multi-Location List. The following table lists the alternative activities you can achieve:

Activity

How To

Mechanism

Send to RETURN

Select a non-quaqantine location, or no location if from float stock, and enter a +ve quantity.

If there is no RETURN quarantine location, one will be created. The quantity is removed from the selected location (or float stock) and quarantined (type S movement) in the RETURN location.

Return from REWORK to MAIN

Select the REWORK location in the Multi-Location List and enter a +ve quantity.

The quantity is released (type T movement) from the REWORK quarantine location. If there is a MAIN first option parameter, the quantity will be moved to that location (a MAIN location will be created if not present). If there is no MAIN option parameter, the relesed stock will go to float stock.

Scrap from Float Stock

Enter a -ve quantity without selecting a multi-location list line.

The quantity will be adjusted (type N movement) out of stock but not affect any locations. The document reference will be the second option parameter.

Scrap from Location

Enter a -ve quantity with a multi-location list line selected.

If the location is a quarantine location, the quantity will first be released (type T movement). The quantity will be adjusted (type N movement) out of stock but from the location. The document reference will be the second option parameter.

Back to top

See also: -

Compiled in Program Version 3.10. Help data last modified 12 MAR 2012 02:39. Class wStockCtl last modified 26 FEB 2012 12:10:39.

Document path Reference Contents > Inventory > Stock Control Activities