ProjectManagement for Engineering Companies > Logistics > Inventory Management

See also


 

Enables users to manage all the items purchased, manufactured, sold, or kept in stock. Services can also be defined as items, although they are relevant only for sales. 

 

For each item, users enter the data relevant for a particular area in the system. This data is used automatically by the system for purchasing, sales, production, inventory management, and accounting.

 

Provides optimum support for business processes. Helps create orders, delivery notes, and outgoing invoices, automatically calculating prices, sales units, and gross profit. Enables complete control over stock quantities at all times and lets users analyze the financial aspects of stockholding at the same time. Allows users to control production on the basis of the items that are used for production and on the basis of the finished product and any by-products created.


The following business goals and objectives can be achieved through the implementation of these processes:


Inventory ManagementLink to Business Scenario Maps
Serial Numbers ManagementSAP Component or Feature Available

Helps to track items, such as computers, using their serial numbers. The serial number can provide additional information such as an item's manufacturing date, warranty data, and so on.

The work method is to enter serial numbers during stock entries for items that have a definition of serial numbers management, and to choose relevant serial numbers for stock transfer and release documents.

To fully utilize this functionality, the following products should be evaluated

  • SAP Business One
  •  
    Customer/Vendor Catalog NumbersSAP Component or Feature Available

    Enables users to enter for each item the catalog number as it is used by each customer and/or vendor. Also enables this number to be displayed on the purchasing and sales documents and to be printed on the other relevant documents. 

    To fully utilize this functionality, the following products should be evaluated

  • SAP Business One
  •  
    Inventory RevaluationSAP Component or Feature Available

    Users can change manually the cost price of inventory items that have been valuated according to moving average, standard price, or FIFO valuation method.

    Once you change the cost price of an item, SAP Business One recalculates the item value according to the updated cost price. Differences in inventory value that result from new costs are automatically posted to a defined G/L account.



    To fully utilize this functionality, the following products should be evaluated

  • SAP Business One
  •  
    Price ListsSAP Component or Feature Available

    Enables the user to create an unlimited number of price lists for the items defined in SAP Business One. The pricelists can either be independent or based on an existing price list. Each price list automatically includes all items defined in the system. 

    It is possible to grant authorization different users to different pricelists, by relating each pricelist to a group. All the price lists can be updated by the user, except for the Last Purchase Price and Last Calculated price lists. These two are updated automatically by the transactions made in SAP Business One and by the inventory valuation.

    To fully utilize this functionality, the following products should be evaluated

  • SAP Business One
  •  
    Special PricesSAP Component or Feature Available
    Enables the user to create, in addition to the standard price lists, special prices for customers and vendors. The special prices can be based on standard price lists, and be updated accordingly. In addition the user can define hierarchies and expansions for special prices.  

    To fully utilize this functionality, the following products should be evaluated

  • SAP Business One
  •  
    Inventory ReportsSAP Component or Feature Available

    These reports provide a general to detailed overview of the company's inventory. The following reports are available in SAP Business One:



    Items List - enables users to generate a partial/full list of the items defined in SAP Business One, according to user-defined selection criteria.



    Last Prices Report - shows the last purchasing and sales prices of an item. Users can generate the report in general or for a specific business partner. This report is available directly from sales and purchasing documents. 



    Inactive Items - displays the items that are inactive, according to user-defined selection criteria, for example, items that have not been mentioned in a delivery for the last six months.



    Item Query - displays specific details about a selected item.



    Inventory Posting List by Item - enables users to hide transactions that affect the cost of the items, but have no impact on their quantities.



    Inventory Status - displays the committed, ordered, in stock, and available quantities of the selected items. 



    Inventory in Warehouse Report - displays the balance of the selected items in the selected warehouses or selected locations. 



    Inventory Audit Report - provides an audit trail and information regarding the source of the posted inventory transactions in the chart of accounts. When users generate this report, a comparison between the accounting view (stock balance accounts) and logistics view (stock values displayed by the audit report) can be made to obtain information regarding value changes in inventory accounts. When printing the report, it is possible to also print the selection criteria on a separate page.

    Inventory Valuation Report - enables users to valuate all/part of the inventory items in all/some warehouses or locations to a selected date, according to a selected calculation method. If the company manages a non-perpetual inventory system, this report takes the price assigned to items in the A/P invoice into consideration when the A/P invoice is based on a goods receipt PO. When printing the report, it is possible to also print the selection criteria on a separate page.

    Serial Numbers Transactions Report - enables users to generate a report that lists the transactions related to the selected range of serial numbers.

    Batch Number Transactions Report - enables users to generate a report that lists the transactions related to the selected range of batch numbers.    



     

    To fully utilize this functionality, the following products should be evaluated

  • SAP Business One
  •  
    SAP Product Available Partner Product Available SAP Product Available with Future Releases Partner Product Available with Future Releases Future Focus