Product Warehouse Description Setup - Storeroom field descriptions

Fields are presented in alphabetical order within each section.

Click one of these links to access field help for that section:

Control

Default

Control

Bill on Receipt Priced at Line Cost

If you charge your customers a flat fee to maintain their Bill on Receipt (BOR) inventory, select this option to set the selling price to the product cost. The product cost is the cost at which the product was received on purchase orders or warehouse transfers. When you select this option, standard pricing logic does not occur to determine the price of the product. When you bill at cost, you are not required to set up PD Pricing Setup records, but you must manually bill your customers for the flat fee.

This option is not selected by default, and product price is the default amount for selling price. You must create pricing records for BOR products in PD Pricing Setup. Standard Distribution SX.e pricing logic is used to determine the price of the BOR products, based on the pricing records.

Cost Adjustments Billable

This option is used to control how inventory adjustment updates are performed in Storeroom. When this option is selected, and a negative adjustment is made for a product during Storeroom Count Entry (fewer is counted than expected), it is assumed the difference has been issued. A Stock Order (SO) is created to ensure that the cost of the product is captured and the customer is billed for the amount. If a positive adjustment (more is counted than expected) is entered during Count Entry, a Return Merchandise (RM) order is created to adjust sales and inventory accounts, and credit the customer for the inventory.

If the Cost Adjustments Billable option is not selected, a stock adjustment only is made to inventory accounts for positive or negative inventory adjustments made in Storeroom. A negative adjustment is applied to customer-owned inventory first, then the remaining balance will be applied to distributor-owned inventory. Positive adjustments (returns) are added to either customer- or distributor-owned inventory, based on your selection during count entry.

This table outlines how adjustments are made based on the Cost Adjustments Billable selection, the type of adjustment (positive or negative), whether the adjustment was posted to customer- or distributor-owned inventory during Count Entry, and if the adjustment should be made to on hand or unavailable inventory balances. You can verify these adjustments by running Product Entry Physical Reconciliation Report in Distribution SX.e before performing the final Count Complete function.


ICSD Cost Adjustment Billable	Positive/Negative Adjustment	Adjust C or D Inventory	Adjust On Hand or Unavailable	Result
Billable	Positive	C	On Hand	RM order created with C inventory type product line for quantity equal to adjustment amount. No tie to original order. Product returned to customer on hand inventory (on hand increased).
Billable	Positive	C	Unavailable	RM order created with C inventory type product line for quantity equal to adjustment amount. Return/Adjustment reason of unavailable recorded against line. Product returned to customer unavailable inventory (increased).
Billable	Negative	No selection	On Hand	SO order with C inventory type product line for quantity that is equal to current customer net available. If the adjustment is greater than the net available, an additional line with a D inventory type is created for the difference. Customer on hand balance reduced by C line amount; distributor on hand reduced by D line amount.
Billable	Negative	No selection	Unavailable	Stock adjustment to decrease customer unavailable and increase customer on hand by the count adjustment amount. SO order created with C inventory type product line for quantity equal to current customer net available. If the adjustment is greater than the net available, an additional line with a D inventory type is created for the difference. Customer on hand balance reduced by C line amount; distributor on hand reduced by D line amount.
Billable	Positive	D	On Hand	RM order created with D inventory type product line for quantity equal to adjustment amount. No tie to original order. Product returned to distributor on hand inventory (on hand increased).
Billable	Positive	D	Unavailable	RM order created with D inventory type product line for quantity equal to adjustment amount. Return/Adjustment reason of unavailable recorded against line. Product returned to distributor unavailable inventory (increased).
Not billable	Positive	C	On Hand	Stock adjustment created to increase the customer’s on hand inventory balance by the count adjustment amount.
Not billable	Positive	C	Unavailable	Stock adjustment created to increase the customer’s unavailable inventory balance by the count adjustment amount.
Not billable	Negative	No selection	On Hand	Count adjustment amount is compared to customer’s on hand balance. If less than on hand, stock adjustment created to decrease the customer’s on hand balance by the count adjustment amount. If greater than on hand, stock adjustment created to decrease customer’s on hand balance to zero, then a second stock adjustment created to decrease the distributor’s on hand amount by the remainder.
Not billable	Negative	No selection	Unavailable	Count adjustment amount is compared to customer’s unavailable inventory balance. If less than unavailable, stock adjustment created to decrease the customer’s unavailable balance by the count adjustment amount. If greater than unavailable, stock adjustment created to decrease the customer’s unavailable inventory balance to zero, then a second stock adjustment created to decrease the distributor’s unavailable amount by the remainder.
Not billable	Positive	D	On Hand	Stock adjustment created to increase the distributor’s on hand inventory balance by the count adjustment amount.
Not billable	Positive	D	Unavailable	Stock adjustment created to increase the distributor’s unavailable inventory balance by the count adjustment amount.

If you are implementing Storeroom in your customer’s warehouse and performing an initial physical count to set your ‘burn-off’ levels, the reference field is updated with BURN-OFF on the ICETC adjustment transactions created when you update the count. Becauue Burn-off inventory is customer-owned inventory by default, we recommend you do not select the Cost Adjustments Billable option until after you perform your initial physical burn-off count. That way, only stock adjustments, not Return Merchandise, transactions are created for the initial count.

After the adjustments to inventory are applied and the count updated, the details from the count run—date, warehouse, run number, product, expected and counted quantities and type of inventory adjusted—are copied to an internal table (ICSEPA) and the current count records (ICSEP) are removed.

Cost Used for Customer Product

Select the cost method, either Average or Fixed, to be used to determine the cost for the customer-owned products. Average cost is an on-going, perpetual weighted average for this product. The average cost is recalculated every time the on hand quantity changes, and the updated value is stored in the Customer Costs-Average field in Product Warehouse Product Setup - Costs. Fixed cost is the value you specified in the Customer Costs-Fixed field in Product Warehouse Product Setup - Costs. It is never updated by Distribution SX.e.

The cost that is used for the customer product is stored on the sales order line. It is used in the roll-up of kit costs when the kit components kits are customer-owned. No updates to General Ledger or Sales Manager are made as the customer has already paid for the product.

The cost of customer-owned and distributor-owned products are subject to the daily, monthly, and transaction limits that are established for employees and departments in Storeroom.

Customer Mark Up From

Select the cost to use to mark up from when determining a price for Storeroom-managed inventory. The cost options include Average, Standard, Replacement, and Last. During Sales Order Entry, if you use cost plus pricing to reprice the product, the cost you specify here is used. This option overrides the Mark Up From option setting in SA Admin Options > Products > Costs for this warehouse.

Managed Warehouse

Select this option to define this warehouse as a Storeroom-managed warehouse. After you set this option, you must also assign a customer to this warehouse by updating the Customer # on the General view.

Print Customer Lines on Invoice

Sales orders may contain customer-owned and distributor inventory. Customer-owned items do not carry a price or cost, and your customer may not require these items on their invoices. Use this option to indicate whether you want to include or exclude customer inventory type lines on the sales order when you print invoices during Sales Entry Processing Invoice Processing Report. Clear this option to exclude customer-owned items from invoices. During Sales Entry Processing Invoice Processing Report, any sales order lines containing customer-owned inventory (‘C’ type) are printed or suppressed based on this option. If the entire order is made up of customer-owned items, the order is invoiced as normal, but no invoice is printed. In this case, the invoice total price and total cost are zero and the customer is not charged.

Default

The Employee, Department, Project, Work Order, Machine, and Charge Number values default from the Storeroom application and are not updatable.

Days Between Counts

Critical Count: Specify the number of days between each complete count of items in your Storeroom warehouse that are identified as “critical.” Critical products are designated by setting the Critical Product option in Warehouse Products Setup - Storeroom. For example, if you specify 30 in this field, you want to count each critical item in the Storeroom every 30 days. This value is used during Product Entry Storeroom Count when you select Include Critical Products, to calculate the total number of critical products to count during that run, based on the total number of critical products and the Days Between Counts report option.
Customer Count: Specify the number of days between each complete count of items in your Storeroom warehouse that are customer-owned. These are products that exist in a Storeroom managed warehouse, that are designated as customer-owned (the option Customer Owned is selected in Product Warehouse Product Setup-Storeroom), or are not marked as customer-owned, but have only customer-owned balances. This value is used during Product Entry Storeroom Count when you select Include Customer Owned Products, to calculate the total number of customer-owned products to count during that run, based on the total number of customer-owned products and the Days Between Counts report option.
Integrity Bin Location: This field is for reference only and can be used to identify bin locations that are maintained for a specific purpose.
Licensee Count: Specify the number of days between each complete count of items in your Storeroom warehouse that are distributor-owned. These are products that exist in a Storeroom managed warehouse, that are not strictly designated as customer-owned (the option Customer Owned is not selected in Product Warehouse Product Setup-Storeroom), or products that are not marked as customer-owned but have only customer-owned balances. Distributor-owned products may carry a balance of customer-owned and distributor-owned inventory. This value is used during Product Entry Storeroom Count when you select Include Distributor Owned Products, to calculate the total number of non-customer-owned products to count during that run, based on the total number of products and the Days Between Counts report option.
Lot Count: Specify the number of days between each complete count of items in your Storeroom warehouse that are identified as lot products. These products are designated as such by selecting Lot in the Control field in Product Warehouse Product Setup-General. This value is used during Product Entry Storeroom Count when you select Include Lot Products, to calculate the total number of lot products to count during that run, based on the total number of lot products and the Days Between Counts report option.
Shelf Life Count: Specify the number of days between each complete count of items in your Storeroom warehouse that are identified as Shelf Life. These products are designated as such by selecting the Shelf Life option in Product Warehouse Product Setup-Storeroom. This value is used during Product Entry Storeroom Count when you select Include Shelf Life Products, to calculate the total number of Shelf Life products to count during that run, based on the total number of Shelf Life products and the Days Between Counts report option.

Printing

Print Auto Generated Notes on Invoice: Auto-generated notes are created during Storeroom Issue Entry and contain the information in the issue header such as Employee #, Department, Work Order #, Project, and Machine #. This information defaults from the Storeroom Warehouse record during issue entry, but can be overridden. Select this option to include the auto-generated note from the issue on the invoice when it is printed.
Print Auto Generated Notes on Pick Ticket: Auto-generated notes are created during Storeroom Issue Entry and contain the information in the issue header such as Employee #, Department, Work Order #, Project, and Machine #. This information defaults from the Storeroom Warehouse record during issue entry, but can be overridden. Select this option to include the auto-generated note from the issue on the pick ticket when it is printed.
Print Storeroom Manual Generated Notes on Invoice: Manual notes are attached to an issue during Storeroom Issue Entry by selecting the Notes button and specifying a note. If you select the Print Note option on the Notes window, and this option is also selected, the manual note is printed on the invoice that is created for the sales order. If you select the Print Note option, but this option is not selected, the note is not printed on the invoice.
Print Storeroom Manual Generated Notes on Pick Ticket: Manual notes are attached to an issue during Storeroom Issue Entry by selecting the Notes button and specifying a note. If you select the Print Note option on the Notes window, and this option is also selected, the manual note is printed on the pick ticket. If you select the Print Note option, but this option is not selected, the note is not printed on the pick ticket.
Storeroom Printer: Specify or look up the name of the printer that resides in the Storeroom warehouse. This printer can be selected when you are printing allocation reports, receipt reports, and pick tickets from Storeroom or Distribution SX.e.

Non-Stocks

Non-Stock Product Category

Specify or look up a product category to be used as the default when a nonstock item is entered on a Storeroom issue for this warehouse. Product categories are required for nonstock lines, so if no default product category is selected here, the system will use the default product category in SA Admin Options-Products-Defaults-Non-Stocks-Product Category.

The product category must first be defined in SA Table Code Values Setup.

Storeroom Warehouse Transfer Approval Type

Specify Y to set the line approval flag on a Transfer Entry Recommended Replenishment Action Report line to Approved. This will automatically approve the warehouse transfer line item on the Transfer Entry RRAR Merge Process Report. Specify No to set the status to Requested. You must manually review and approve the WT line before a warehouse transfer is created.

You must specify a warehouse in the WT Arp Whse field if you specify Yes in this field.

Storeroom Warehouse Transfer Authorized Replenishment Path Warehouse

Specify a warehouse to default during Storeroom Issue Entry when you enter a nonstock product and select Create WT?. This will update the ARP Whse value on the sales order line. The nonstock is included on the Transfer Entry Recommended Replenishment Action Repor for this warehouse and a warehouse transfer is created that is tied to the sales order. If the WT Appr Type is selected, the transfer is automatically approved when the Transfer Entry RRAR Merge Process Report is run.

You must enter a warehouse that is assigned to the same customer, whether it is Storeroom-managed or not. If you enter a warehouse that is not assigned to the selected customer, this message is displayed: If Managed, the ARP Whse Must be for the Same Customer (6853).

Auto Processing

Auto Inv Return Orders

Select this option to automatically invoice credits (return orders) so inventory is immediately available in Storeroom. If you do not select this option, returned product is not available for issue until invoicing is completed in Distribution SX.e.

Auto Inv Shipped Orders

Select the type of Storeroom order that will be automatically invoiced when received. Your options include Regrind In, Bill on Receipt, Both, or No (the default is No). If you select Regrind In or Both, this will include the Sales Entry Direct Orders (DO) that are created when a PO is tied to a Regrind Out transaction.

When you receive the BOR product on a purchase order or warehouse transfer in Storeroom, it is allocated to the distributor Balances-Received category. If you select No for this option, you must manually run Sales Entry Invoice Processing Report and then Sales Entry Processing Back Order Fill Report to correct the warehouse product balances. Set this field to Bill on Receipt or Both, to automate this process.

You must set up an @oewhse stored report if you do not want to use the default ranges and options of the Sales Entry Invoice Processing Report.

Note: To use specific ranges and options settings when the Sales Entry Invoice Processing Report is run, set up a stored report for automatic invoicing. The stored report must have a report name formatted as @oe[warehouse]. For example, if your Storeroom warehouse is ‘sr1’, the stored report name should be @oesr1. If you create a stored report that is not warehouse-specific, the name is @oe. If stored report is not created, the default settings on the Sales Entry Invoice Processing Report are used. The invoice and exception report print to the printer that is defined in the Storeroom Printer field in Product Warehouse Description Setup-Storeroom . If no printer is defined in that field, the Product Warehouse Description Setup-Extended Invoice Printer is used. If no invoice printer is defined, the SA Operator Setup-Preferences Default Printer is used.

Auto Rcv WT When Shipped

Select this option enable the operator to choose the Ship/Receive as Complete option in Storeroom-Receipts-Receiving-WT Ship/Receive on a warehouse transfer. If this is selected, the shipped quantity on the WT line is loaded into the WT’s received quantity, and the WT is shipped and automatically received. This option is set for the receiving warehouse.

Transfers between Storeroom-managed warehouses are only allowed if the transfer is from a warehouse that is assigned to the same customer in Product Warehouse Description Setup-General as the receiving (ship to) warehouse.

Bill On Receipt Demand Billing

This option defines how the inventory type is set on backorder Bill on Receipt items and when the customer is invoiced. Your options are Customer or Distributor.

Normally, when a backorder is created for a Bill on Receipt item, the inventory type is converted from ‘c’ustomer-owned to ‘d’istributor-owned.

If you select Customer, the inventory type remains as ‘c’ustomer-owned. When a Bill on Receipt item is received in the Storeroom, any backordered lines that are customer-owned are not filled when the Sales Entry Processing Back Order Fill Report is run. After the Bill on Receipt item is invoiced using the Sales Entry Invoice Processing Report, either automatically or manually, Sales Entry Processing Backorder Fill Report is run to fill any customer-owned open orders. If the option, Auto Inv Shipped Orders, in Product Warehouse Description Setup-Storeroom is Bill On Receipt or Both, Sales Entry Invoice Processing Report and Sales Entry Processing Backorder Fill Report run automatically.

By waiting to fill the backorders until receiving is complete you ensure the sales order that is automatically created for the Bill on Receipt items matches the full receipt quantity of the Bill on Receipt items. If the Storeroom warehouse is not set to auto invoice shipped BOR orders, you must run Sales Entry Processing Backorder Fill Report manually or schedule it as a stored report to run at the end of the day after all receiving is complete.

If you select Distributor for this option, the Bill on Receipt products are received as distributor-owned, and any backorders are filled before invoicing. The remaining stock is converted to customer-owned inventory and the customer is invoiced for this amount. The invoice in this case would not match up to the full amount received.