background image

Ice Ledger

Stock Control

Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

Stock Records


Stock Record: Toolbar


The stock record screen has a toolbar with a number of buttons, including:


Opening StockUse this option to enter existing stock details. [ Opening Stock Balance ]
LogYou can make permanent notes for each item. These notes after being saved can NOT be altered. [ Logs ]
DefaultDetails in a number of predefined fields can be saved as default values. When a new stock record is created, the values for these fileds are set to the default values automatically. [ Default Values ]
RefreshIn a network environment, on a multi-user installation, you may have a stock record details open whilst the details are updated by another user on a different system. You can use this button to reload the stock record details without having to close and re-open the record.
PrintPrint stock record details based on templates created in the system report designer. [ Printing ]

Below the toolbar are a set of tabs with all the stock record details:


Stock Record: Tabs

Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock


Details Stock Record Details


Commodity CodeThis is the commodity code used for the export, Intrastat reporting.
LocationThis is a very simple but highly effective way of recording where the items are stored within the company warehousing system. It can be as simple as a short reference for a shelf or a bin or something more details that includes for example city, building / warehouse, isle, shelf, bin etc..
BarcodeEnter the text that would like to have printed as a barcode for the item.
Supplier 1You can define the preferred supplier account reference here together with their part number to the right.
Supplier 2Second supplier reference and part number.
Sale Price 1 - 4You can define up to 4 different sale prices.
Quantities
  • Reorder Level: If the stock level falls below this level, then this item will be listed in the stock re-order report.
  • Reorder Qty: When the stock re-order report is run, the re-order qty will be set to the value defined here.
  • Ordered: This is the total quantity that has been placed on order using the Purchase Order Processing.
  • In Stock: This is the total quantity that is currently in stock. This figure includes the allocated quantity, listed below.
  • Allocated: This is the total quantity that has been allocated to various Sales Orders.
  • Pre Ordered: When items are added to Sales Orders any un-allocated quantity balance is considered an being pre-ordered. This is sometimes referred to as 'back order' quantity.


Sale Nominal CodeNominal Code to be assigned automatically when the item is being sold; it can be changed at sale time.
Purchase Nominal CodeNominal Code to be assigned automatically in Purchase Orders; again this can be changed when creating a purchase order.
Tax CodeDefault Tax Code to be used for sales and purchases.
Stocked ItemIn sales & purchase orders and invoices, each item must have a stock code reference and be defined as an item within the stock system. However, if you do NOT want a particular item to be part of the stock control mechanism, you can un-check this box. The item will be treated as though it is always in stock and there are no stock adjustments made for the item. Sale of non-stock are still logged in the stock transactions.
Assembled Item.
ReminderYou can enter a short message here as a reminder so that when anyone creates a new sales order, a sales invoice or a purchase order and includes this item then the message will be displayed as a reminder.
..
..
In Transit.This is stock quantity that is on order and has been shipped by the supplier but has not yet been received or booked into stock.
Last GRN DateLast goods received note date is the date that the goods were received from the most recent purchase.
..

Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock


DiscountsYou can define up to five different (A - E) percentage discounts that are applied on the basis of quantity sold. You can define multiple quantity breaks and the five different discounts for each break. You can assign a discount band (A - E) to customer records. So, when a sales order or an invoice are created, the appropriate quantity break based discount will be applied. You can change both the discount band and the actual percentage discount that is to be applied at the time of creating a SO or an Invoice.


Stock Discounts


Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock


StockThis tab lists all purchase batches for the selected item. There are a number of options available, above the list [ List View ]:
  • Stock: Tick this box to show purchase batches that are in stock.
  • Sold: If you check this box then the system will show only those purchase batches in stock from which some items have been sold.
  • Allocated: If this box is ticked then only those purchase batches that are in stock from which some items have been allocated to sales orders are listed.
  • Transfer: Quantities from a selected purchase batch may be transferred to another stock item. For example, an item may have multiple grades with each grade having its own unique stock code. If you then wish to regrade some of the items to a different grade and transfer the stock to the relevant stock code, you may do so. Transfer of stock in this way will create a traceable stock transaction trail. [ Transfer ]
  • Consolidate: Each purchase batch with a unique production batch reference (Casting No) is stored in a distinct , identifiable location. If you wish, you may relocate / re-distribute the stock between storage locations. [ Consolidate ]
  • Move: In multi-depot setup, move stock between different depots. [ Move stock between depots ]


Stock: Stock Batches Currently in Stock


  • Goods #: When a purchased stock is booked in, it is assigned a number which is unique for each batch of items that have the same production batch reference and are assigned the same storage location reference.
  • Location: Warehouse storage location reference. With careful planning, you can design storage location that encompass city, building, warehouse, isles, bins etc..
  • Casting No: For purposes of traceability, you can record manufacturer's production batch references for each batch of items that are booked into stock. This is for your information only and the details are not processed by the system.
  • Qty In: This the original quantity that was booked in to stock for the designated purchased batch.
  • Qty Alloc: Total quantity of stock that is allocated at present to various sales orders.
  • Qty Out: Total quantity that has been sold to date.
  • Qty Free: Total quantity that is available for new sales.


Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock


BOMBill of Materials. If you stock items that may be assembled from components, then you can check the option, Assembled Item ? under the Details tab to enable this BOM tab to define the assembly components. [ BOM ]


Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

AnalysisHere the system provides summary quantities, sales and costs on a monthly basis. Figures include, budgets, actual sales & purchase costs for both the current financial and last year.


Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

NotesYou may record pertinent additional details for each stock item. [ Notes ]


Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

LogsYou may record further details about each item that are permanent. Unlike the Notes, once saved, above details recorded here may not be changed. This is a design feature and is intended to be a permanent record. The date, time, workstation is and user login id are also recorded automatically. [ Logs ]


Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

ActivityAll stock booked in and out is logged in stock transactions. Here, you may examine all stock activity.


Stock Record: Stock Activity / Movements

Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

  • Type: Transaction types to be displayed in the list:
    • Increase: Stock increase transaction types, AI (adjustments in). These are transactions where the stock level of an existing batch of items is increased.
    • Decrease: Stock decrease transaction types, AO (adjustments out). These are transactions where the stock level of an existing batch of items is decreased.
    • Move In: Stock movements in, transaction types MI. Applicable to multi-depot configuration, transactions where the stock is moved in to a depot from another depot.
    • Move Out: Stock movements out, transaction types MO. Also applicable to multi-depot configuration - stock moved out from one depot to another.
    • Stock In: New batch of stock booked in i.e. stock adjustments in, transactions type GI (goods in).
    • Stock Out: Stock booked out e.g. when stock is shipped from sales orders; transactions type GO (goods out).
    • Transfer In: Stock transfer in, transactions type TI.
    • Transfer Out: Stock transfer out, transactions types TO.
    • Write Off: Stock write off, transactions type WO.
    • All: All transaction types, listed above.
    • All - In: All transactions type where the stock added, transaction types AI, GI, MI & TI.
    • All - Out: All transactions type where the stock removed, transaction types AO, GO, MO, TO & WO.
SOSales Orders. You can view a list of all current Sales Orders that contain the selected item. To view past orders, click on Show Closed. You can specify a date range of interest and view orders for all or selected customers.


Stock Record: Sales Orders


[ To customise the list view, see List View ]
  • Order #: Sales Order number. This is a hyperlink which you may click to open the designated sales order.
  • Order Date: Sales Order date.
  • A/C Ref: Customer account reference. Again, this is a hyperlink that you may click to open the customer record.
  • Customer: Customer company name - a hyperlink.
  • Order Qty:Qty ordered by the customer on the relevant sales order.
  • Alloc Qty: Quantity allocated in the designated sales order.
  • Shipped Qty: Quantity shipped to date for the given sales order.
  • Preorder: Remaining quantity that has not been shipped and no stock has been allocated.
  • Shop Status:Sales Order shipped status i.e. None - no items have been shipped; Part - some items have been shipped; Full - all ordered quantity has been shipped.
  • Closed: Is the sales order marked as closed i.e. completed. Please note that an item may be fully shipped but the sales order may still not be closed due the fact that there may be other items that are still outstanding.

Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

POThe list shows a list of purchase orders for which deliveries are expected.


Pre-Orders

The list is similar to the SO, above and shows all sales orders that have a pre-order quantity showing for the selected stock item.[ Pre Orders ].


Stock: Preorders

Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

TransitPurchase Orders with items in transit.
Opening StockEnter opening stock figures.

Index | Stock List | Stock Record | Stock Pre-Orders | Stock Adjustments | Stock Activity

Details | Discounts | Stock | BOM | Analysis | Notes | Logs | Activity' | SO | PO | Pre-Orders | Transit | Opening Stock

Follow Us on Facebook Follow Us on Twitter
Copyright © 2014 - 2017 1T Solutions Limited. All Rights Reserved.