Activant Dimensions - Page 155

Chapter 5. Inventory
REGULAR PROCESSING
IMD.D
Delete Items by
Batch File
Holds item numbers
to be deleted through
Delete Items by Batch
routine.
OM3.D
Inventory
Adjustments File
- store #, batch #,
card #, item #
- adjustment type
- price/cost
changes
- quantity change
- etc.
PRICING
BD0.D
Bid/Spiff/Matrix
Detail File
Holds items on sale
(spiff) and items
quoted a special price
to a customer on a
bid. Also holds matrix
prices 10-99.
OM7.D
Price Maintenance
by Batch
Holds future price
changes by item
before making them
effective in IM2.D.
BH0.D
Bid/Spiff/Matrix
Header File
Holds heading
information for all
bids, spiffs, and
matrix pricing.:
- sale beginning
and
ending dates
-bid ex
p
iration
INVENTORY HISTORY/RANKING
IM3.D
13-Month History
Either:
13 months units
sold & purchased
Or:
26 months units
sold
Updated at month
IMH.D
Revolving History
Last 16 months of:
- YTD sales
- YTD cost of sales
- average inventory
value
Updated at month
IM12.D
13-Month Transfer
History
Adds during POS
update:
- MTD & YTD
units/cost/sales
transferred
- Periods 1-13 units
transferred
Month end shifts data
to previous period
IM8ss.D
Inventory Rank File
(ss=store #)
Created automatically
when items ranks are
calculated:
- average margin
- sales
- GMROI
PHYSICAL COUNT
IM7H.D
Inventory Count
History File
Contains the same
information as
IM7ss.D as well a
count update date for
history purposes.
TM2.D
Count by
Count Tags
- count date
- count quantity
- count cost
- tally by length
- location
IM7ss.D
Count Sheets
Count Transactions
(ss=store #)
- count date
- count quantity
- count cost
- etc.
Deleted when next
count file is built
Dimensions 14 147