Information Systems:ASW Warehouse Balance Files
Overview
This page discusses the 4 warehouse files/tables that are often implicated in issues with the weekly out-of-balance reports. It was written after a thorough discussion with Protelo regarding the interface between ASW-DIS and ASW-WHM modules. This page will not have instructions to solve specific problems with these files but instead provide general insight into the matter, which has been validated by a firm that specializes in ASW; explore the categories below to find related articles.
<note>There may already exist articles related to this information. Some reorg may be necessary, but I wrote this so as to not forget this info. -norwizzle (talk)</note>
Files
These 4 files keep track of inventory transactions and balances for all items. There is a pair of item balance/transaction files for ASW Distribution (ASW-DIS), and a correlating pair for ASW Warehouse Management (WHM).
ASW-DIS
The ASW-DIS module involves purchase order tasks
SROSRO - Stockroom balance:
SROITR - Stockroom inventory transactions:
ASW-WHM
The ASW-WHM module involves tasks related to the movement of items within the warehouse (between locations). Many tasks in ASW-WHM are actually performed through another ASW modue: ASW-RFH.
WHOLOC - Warehouse occupancy:
WHOLTR - Warehouse location transactions:
Case study
DIS-to-FIN
This topic has implications in DIS-to-FIN. When purchase orders and sales orders are received and fulfilled, respectively, those transactions need to be applied to ASW-FIN. This is done during this process.