WL Entry Batch Adjust Inventory overview

Warehouse Logistics > Entry > WLE Reports > WLEBA

Function acronym: WLEBA

Stock adjustment transactions that are created in TWL pass through the interface and remain in WL Transaction Inquiry until this report runs. This report picks up the stock adjustment and launches the appropriate function to update inventory control and the general ledger.

All reporting and updating for stock adjustments originates in TWL. The stock adjustment (STK) transaction passes through the interface and remains in WL Transaction Inquiry until WL Entry Batch Adjust Inventory Report picks it up and processes it.

For example, you perform a nightly cycle count and find a discrepancy. After you research the discrepancy and determine the correction you must make, you can create a stock adjustment on the Radio Frequency (RF).

Transactions that move quantities from unavailable to another status are processed before adjustments to available quantities. This ensures the on-hand quantity is adjusted before unavailable quantities are removed from it. If changes are made to the primary full case, split case, or counter locations, Product Warehouse Product Setup is updated with the information also.

Prevent journals from overlapping and causing the updates to fail. Set up your stored reports with unique operators that do not access the system to process journals. This ensures that journals opened by WL Entry Batch Adjust Inventory Report do not interfere with journals opened for other posting functions.

For example, you set up stored reports with a user’s initials. The stored report for WL Entry Batch Adjust Inventory Report is run at the same time that operator is posting cash receipts. If so, the WL Entry Batch Adjust Inventory Report goes into error status in WL Transaction Inquiry.

Serial/Lot Adjustments

You can make negative adjustments to lot products. However, the adjustment must not cause the lot quantity in Product Extended Lot# Setup to go negative, and only reduces the quantity on hand. Adjustments to quantities that are committed to orders are not permitted to go negative.

An adjustment that is for a serial/lot item may be found by WL Entry Batch Adjust Inventory Report. If there are no associated serial/lots with the adjustment, then the Roll Up Serial/Lot Costs option in SA Administrator Options-Products-Costs is ignored for that adjustment. The quantity adjusted is based on the Post to G/L By [average, standard, replacement, or last] option in SA Administrator Options-Products-Costs. The Inventory Control transaction history file, Product Unavailable Inventory Entry, has the same cost as the serial/lot detail record.