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 Files

The ASW-DIS module involves purchase order tasks

SROSRO - Stockroom balance:

SROITR - Stockroom inventory transactions:

ASW-WHM Files

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:

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.