Inventory Management

Lower logistics costs

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

The user enters the batch numbers during stock entries for items that have a definition of batch numbers management. Then the user chooses the relevant batch numbers for stock transfer and release documents.

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.

Enables users to transfer stock from one warehouse to another. A stock transfer can also be carried out as a consignment for a customer. The items are then stored in the customer's warehouse and are sold from here.

more...

Enables users to record goods receipts and issues that are not directly related to a sales or purchasing document.

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.

Enables companies to run perpetual inventory system which reflects the value of stock postings in terms of monetary transactions in the accounting system. These monetary transactions will be carried out only when items defined as warehouse items are received or released from stock.

SAP Business One supports the following valuation methods: standard price, moving average and FIFO. The default valuation method for new items can be defined in the company level and/or in the item group level. The user can assign to each item the relevant valuation method.

Although it is not recommended from the accounting perspective, SAP Business One tolerates situations of negative inventory and performs the required adjustments to ensure accurate calculation of inventory values. This can be relevant only when using moving average and FIFO valuation methods.

Enables companies to keep track of items released for picking and manage item status and actual quantities. Use the Pick & Pack Manager to:

Create Pick Lists based on the contents of Sales Orders and/or AR Reserve Invoices
Print Pick Lists to be used by the picker when actually picking the goods in the warehouse
Copy the partially/fully picked contents of the Pick Lists into a Delivery Note, which functions as the Pack document in the system.

In addition, you can specify packaging related information.

The Pick & Pack process supports also bill of materials items of assembly and sales types.

more...

Allows users to create a list of items that can be suggested to the customer as alternatives if the required item is not available. Enables substitutes to be ranked on the basis of similarity of item, price, and/or quantity.

more...

Enables the user to 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. Difference in inventory value that results from new cost is automatically posted to defined G/L Account.

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.

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.

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

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

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 the Sales/Purchasing documents.

Inactive Items - Displays the items that according to the user's selection criteria are inactive. For example, an item which is not mentioned in a delivery for the last six months.

Item Query - Displays specific details about a selected item.

Inventory Posting List by Item - enables the user 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 a user generates 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 print the also selection criteria on a separate page.

Inventory Valuation Report - Enables the user to valuate all/part of the inventory items in all/some warehouses or locations to a selected date, according to 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. In companies who manage perpetual inventory system, this report is named Inventory Valuation Simulation Report and should be used for simulating 'what if' scenarios only. When printing the report, it is possible to print the also selection criteria on a separate page.

Serial Numbers Transactions Report - Enables the user to generate a report which lists the transactions related to the selected range of serial numbers.

Batch Number Transactions Report - Enables the user to generate a report which lists the transactions related to the selected range of batch numbers.

See also