Inventory Configuration
Setup Options > Configuration > Distribution > Inventory
This values your inventory on a first-in-first-out basis. You won't be allowed to store inventory costs in a unit of measure other than stocked and stock on hand won't be allowed to go negative in any warehouse (except for floorstock items stocked in the floorstock warehouse). This option is automatically selected if Actual costing is enabled, or if Costing per warehouse is enabled and the costing method for any warehouse is set to FIFO.
This requires entry of bins upon the receipt, issue or transfer of items and when capturing stock take information. The Purge and Archive program runs to ensure the default bin is inserted into existing lot records and their associated transactions against your traceable or ECC-controlled items. Run the Balance function of the Order Purge and Inventory Period End programs to ensure there are no quantities in ship without bin allocations and to transfer any qty on hand to the default bin.
This is only available if multiple bins is enabled and the serial tracking system is required. You typically use this to track serialized items by bin location.
Only available in a SQL environment and if multiple bins is in use. Initially, all warehouses using multiple bins are flagged as fixed bin warehouses. The Show Warehouses hyperlink lets you switch off this facility selectively for warehouses. Fixed bins requires a bin to exist in the WhmBin table before you can transact against it. If the Create bins at inventory transaction option is switched on, bins can only be created at transaction time for warehouses not using fixed bins.
The Show Warehouses hyperlink is also used to maintain the WMS control options against the warehouse (Warehouse Maintenance).
This lets you add a WMS mission when a cycle count is selected.
This lets you add a WMS mission when a pick is added.
This lets you add a WMS mission when a putaway is created.
This is the percentage by which the cost of an item received into stock (and a cost change to an item) is allowed to differ from the cost of the item on file. Although a warning is displayed if this percentage is exceeded, it only applies to cost changes made to individual items and it does not apply to receipts if your costing method is set to Standard costing (items are receipted at standard cost and, therefore, no variance occurs).
Select this to monitor inter-warehouse transfers generated from the Inventory Movements program, as well as supply chain transfers generated from the Sales Order Entry program. You must select this to perform requisition issues and/or transfers. Any stock transfers that are still in process should be completed before you enable/disable this feature. The Warehouse Exception program highlights unfinished transfers while the GIT Conversion Program program converts existing warehouse transfers to GIT transfers.
Also known as item or batch-specific costing, this applies to lot traceable and batch serialized items. It uses FIFO valuation to track and process costs and overrides any other costing method defined at company or warehouse level. Manual numbering must be set for traceable items and serialized items must be set for capture at the time of receipt and not during order entry. If you are currently using serials, then first run the Serial File Balance Report to ensure all batch serials balance.
This prints an Inventory Initial Aged Valuation report of stock quantities over the last five years. This is useful when you carry a limited stock of spare parts for component items that may have a long life and you need to provide for the depreciation of these items annually.
This stores the last cost entered for a receipt separately from the standard inventory cost. This only applies if the costing method is set to Standard, or if costing per warehouse is enabled.
Select this to add the calculated cost multiplier value to the receipt cost of an item when using the Inventory Movements program to process a receipt or a GIT transfer in. You must also select the Apply cost multiplier to process receipt option to include the cost multiplier in the last cost of the item. If not selected, then the cost multiplier defined against the item is ignored and its value is not reflected in the Last cost of the item.
This records serial number information when processing transactions for serialized stock items. Once selected, you can only deselect this option when no active orders exist for any serialized item and there is no allocated quantities of serialized items.
This allows the same serial numbers to be used for different stock codes when accepting items into stock. When receipting batch serialized items (and you have not enabled the Multiple batch serial receipts allowed option) the existing serial numbers must be stocked in the warehouse in which the receipt is being processed. This does not apply to manual serials. If this option is not selected, then you cannot receipt reserved serials into an alternate stock code from inspection.
This retains the history of header and transaction details for manual serial numbers against which a negative receipt has been processed (i.e. reversing a receipt processed against the wrong serial number). You won't be able to re-use the serial number for the same stock item. If this option is not enabled, serial history is removed if the only other transaction for the serial was a receipt (i.e. the system assumes you are reversing a receipt done against an incorrect serial number).
This enables you to alternate between entering a SYSPRO stock code or a supplier's catalogue number during Purchase Order Entry. You must enable this option before defining your supplier stock codes. If you enable this option and purchase a non-stocked item from a supplier, the system automatically creates an entry in the supplier/stock code interchange file.
This lets you hold inventory costs in a unit of measure other than the stocking unit of measure. You define the applicable cost unit of measure when adding stock items using the Stock Code Maintenance program. You cannot select this option if FIFO valuation is enabled, or if your costing method is set to FIFO or LIFO.
This depletes lots by the earliest date that a lot was received into stock. If a lot does not already exist then it retains the date of when the lot was receipted for that stock item. Upon transfer to a new warehouse, the receipt date from the original lot is used.
This depletes lots by the earliest lot expiry date. Upon transfer to a new warehouse, the receipt date is set to the transaction date. If a lot doesn't already exist, then it's created with the transaction date.
SYSPRO's Espresso Pack Size Scanning feature lets you associate a barcode or radio frequency identification (RFID) to different units of measure for an item. Then, using either the SYSPRO Espresso Missions & Tasks or Order Picking applications, you can scan the item in the warehouse to automatically add the unit of measure quantity to the picking (or moving) quantity (i.e. without having to manually enter the number of units picked).
This initially assigns each warehouse the chosen costing method. You can then change the method for specific warehouses (e.g. when high value, low usage items are stored in a separate warehouse and you require a different method of costing for accuracy. Alternatively, if you manufacture and distribute a product you may want to apply standard costing to your work in progress and average costing to your distribution warehouse). Otherwise the costing method selected is used for all warehouses.
This uses the BOM costs held against the warehouse for costing purposes for all stock items held in that warehouse. Otherwise the BOM costs held against each individual stock item are used for costing purposes and you won't be able to process the cost implosion by warehouse. You should use the Cost Implosion program to roll-up costs before selecting this option. You must select this option to be able to use the cost against an alternate route when you transfer BOM costs to Warehouse.
This determines how your inventory is valued.
This averages out the new cost and the existing cost of an item.
This lets you define a cost for each item that is only updated using the Cost Change function or Transfer BOM Costs to Warehouse Costs program.
This values your inventory according to the last cost entered when receipting the item.
This issues from the oldest bucket held on file.
This issues from the newest bucket held on file.
If you change to LIFO costing (company-wide or against a warehouse then we recommend you run the Balance function of the Inventory Period End program before you start posting transactions.
Indicate whether you want to allow stock on hand to go negative in warehouses for the selected company.
The Yes and Dependent on warehouse options do not activate negative stock for the warehouse; you must maintain details against the warehouse(s) for this option to take effect.
Indicate a specific list of warehouses in which stock is allowed (or not allowed) to go negative.
Indicate a range of warehouses in which stock is allowed (or not allowed) to go negative.
This lets you choose whether to allow or disallow negative stock for the selected warehouses.
If you don't select this option, then FIFO journals are still created, but they are not printed. It also does not prevent FIFO journals from being displayed in the Journal Entries listview of the Inventory Movements program.
This makes adjustments to lots from the most recent FIFO bucket when running the Balance function of the Inventory Period End program. This applies only when FIFO valuation is enabled.
This allows a zero cost transaction to be processed when returning stock to a FIFO/LIFO bucket that has a zero unit cost. The returned quantity is added to the FIFO/LIFO bucket, but the unit cost of the bucket remains unaffected. Otherwise a new FIFO/LIFO bucket is created with the returned quantity at the current warehouse cost. The Stock Take Confirmation program updates FIFO/LIFO buckets according to your selection here.
Copyright © 2024 SYSPRO PTY Ltd.