Rollup of Supplier Data (supmth)
Module Name |
supmth.pc |
Description |
Rollup of Supplier Data |
Functional Area |
Inventory |
Module Type |
Business Processing |
Module Technology |
ProC |
Catalog ID |
RMS369 |
Wrapper Script |
rmswrap_multi.ksh |
Design Overview
The primary function of this batch is to convert daily transaction data to monthly data. After all data is converted, the daily information is deleted to reset the system for the next period. This is done by the batch's post processing function in prepost.
This module accumulates supplier data amounts by department/supplier/transaction type and creates or updates one supplier month row for each department/supplier combination. Based on the transaction type on supplier data, the following transactions are written to supplier month:
-
type 1 – purchases at cost (written for consignment sales and orders received at POS or online)
-
type 2 – purchases at retail (written for consignment sales and orders received at POS or online)
-
type 3 – claims at cost (written for claim dollars refunded on RTV orders)
-
type 10 – markdowns at retail (net amount based on markdowns, markups, markdown cancellations and markup cancellations)
-
type 20 – order cancellation costs (written for all supplier order cancellations)
-
type 30 – sales at retail (written for consignment stock sales)
-
type 40 – quantity failed (written for QC shipments with failed quantities)
-
type 70 – markdowns at cost (net amount based on supplier cost markdowns)