Inventory Item master Master data tab Inventory data - robinfeng/beashelp GitHub Wiki
库存数据
Navigation: Inventory > Item master > Master Data tab: Inventory data No contents entries on this page Contents The warehouse data of the item is entered and displayed on this tab.
Field Description Set G/L accounts by Selection of default G/L account method from the available options for the item: • Warehouse - All G/L accounts defined at warehouse level • Item group - All G/L accounts defined at item group level • Item level - All G/L accounts defined at item level Inventory UoM Input of item type by which the inventory is managed, e.g. crate, carton, box. Primary warehouse Warehouse from which postings are done by default. If in SAP B1 Administration - System initialization - General settings - Inventory: "Auto. add all warehouses to new items", was disabled, each warehouse will still be selectable from the drop-down, even those that are not defined in the Item Master. They will be added automatically for selection. Note: if no standard warehouse is defined, various functions as allocation, backflushing, pre-assignment, reservation, MRP will not work correctly. Warehouse rule A group of warehouse rules can be stored. See Warehouse rules Valuation method This option is only relevant for continual inventory management. Selection of one of the following options: hmtoggle_plus1 Moving average Moving average - This method is based on the calculation of the average costs for the item in each purchasing and sales transaction.SAP Business One calculates it automatically in the background. beas returns this price at pricing, it is always calculated in home currency.
hmtoggle_plus1 Standard Standard pricing allows to select a fixed price, which will be used for all transactions. The standard price is stored in Item master / inventory data / item costs. The price can only be changed, as long no journal entries exist. The price is always stored in home currency. As soon a journal entry exists, the standard price can be changed only via Warehouse management - Stock transactions - Stock revaluation. If no standard price was stored, the last goods receipt price applies.
hmtoggle_plus1 FIFO Another continual inventory management system in which the first goods purchased are the first sold or issued without consideration of the current goods movements.The valuation method can only be changed as long as no material has been posted.
Pricing pre-calculation: For Fifo the following formula is used: Total value of all items currently in stock - valued by FiFo : total stock = average value
This value is used as default for all calculations and for posting in material and assemblies. For issue Fifo principle applies. If there is no stock, the last purchase price is used as reference.
hmtoggle_plus1 Series / Batches From SAP Business One 9.1 the valuation method "Series / Batches is available. This is a moving average method per series/batch.
Pricing Pre-calculation: The average price of all batches in stock is determined.
This value serves as default for all calculations and for posting in material or assemblies. For issue, the average pricing per batch applies. If there is currently no stock, the last purchase price is used as reference. Item costs Input of the costs of the item for the default calculation method. The value is updated and calculated for all inventory entries in the Moving Average and FIFO fields. Inventory Management by Warehouse This option is used to specify the calculation method for minimum and maximum inventory quantities. If the flag is set, the total quantity of the fields Minimum warehouse stock, Req. warehouse stock and Max. warehouse stock is displayed in the warehouse table. Required (purchase UoM) Input of the required inventory levels for this warehouse. Value deposited in purchasing unit, it is supported in order recommendation report, if no minimal stock was entered. The quantity required to reach to the minimum warehouse stock is displayed in the Required (purchasing UoM) field. If release of warehouse stocks under the minimum limit is selected in the document settings, the system issues warnings if the minimum warehouse stock is not reached. The system does not permit further input of inventory documents if the warehouse stock has reached the maximum quantity. Minimum Input of the minimum warehouse stock quantity for this warehouse. Maximum Input of the maximum warehouse stock quantity for this warehouse.
Another tab has been added in the Inventory Data area Field Description By Warehouse No. Warehouse stock - per warehouse By bin location Warehouse stock - per warehouse / bin location and batch / series / RFID. Only displayed if a bin location-managed inventory exists. By Batch Batch inventory, only visible for batch-managed items By series Inventory by serial numbers - only visible for serial number-managed items
By Warehouse No. Field Description Warehouse Warehouse Inventory Total stock of the item including blocked batches Unit Unit of measure Confirmed Planned issue for customer orders. No breakdown of subcomponents. Calculation according to SAP rules. Ordered Planned receipt from purchase orders. Summation according to SAP rules. Goods receipt from production All planned receipts are displayed, without consideration of any settings (blocked work orders etc). Goods issue for production All planned issues are displayed, without consideration of any settings (blocked work orders etc). Important: all previous postings for this item are considered, no matter from which warehouse. This works only if the work order was created by beas without any changes by external programs. Reserved For the future reservation system: all reservations are displayed, stock related and planned receipts. Blocked Blocks the warehouse for the item and prevents the item from being added to the warehouse or to a receipt document or issue document. Warehouse Type Type of warehouse
By bin location Field Description Warehouse Warehouse Range Storage Area Description Description of the warehouse area Bin location Bin location Batch/series If batch- or serial number-managed item: the serial number or batch RFID Sub-ID of a batch / series Inventory Current inventory at this bin location with this batch / serial number
By batch Mainly the same information sorted by batches. Information on batches is presented first. For all views, window settings can be used to select columns and to be displayed.
back to item master
返回 主页