Services Limited
Integrated Business Solutions
|
|
Services Limited | Integrated Business Solutions | |
|---|---|---|---|
| STOCK REPORTS |
All specified Transaction Types within a selected date range.Stock Valuation
Review the value of your stock from a number of different viewpoints with the aim of controlling your stock investment.Performance
Look at items under / over a certain GP or mark up (high- or low-valued stock) or slow-moving stock.
For sales planning and the management of the number of stock lines held.
This year / Last year comparisons, demand figures.Labels
Shelf and Barcode labels.Re-Order.
A variety of reports designed to assist re-ordering.Suppliers Orders.
Stock Levels, Demand (Seasonal), Maximum Stock, lead-time etc.
On Order and Receipted Stock Print Suppliers' ProductsStocktake.
A variety of forms available and variance reports.Prices
Price List with Optional Transaction Line, Costs, Exports.Replaced by / Replaces List
Price Books: offering a range of facilities including printing replacement pages and monitoring the issuing of books. Several formats are available.
Product Code Description Date / Hr Type Qty Cost Value Stock Ref. Supp/Cust Br.
Branch CH Christchurch
HW-M M/PAC 1/10/01 15 P 6 6.50 39.00 6 531072 DOVE
15/10/01 09 P 2 5.75 11.50 2 533857 DOVE
HW-MISC 7/08/01 10 P 1 145.70 145.70 23606 MISC
21/12/01 15 P 1 1.80 1.80 SIN14327COMPDY
21/12/01 15 P 1 9.50 9.50 SIN14327COMPDY
14/01/02 15 P 1 7.75 7.75 SIN14423COMPDY
14/01/02 15 P 1 11.90 11.90 SIN14423COMPDY
Sub total 13 227.15
Total 13 227.15
Product Code Description Date / Hr Type Qty Price Value Stock Ref. Supp/Cust Br.
Branch CH Christchurch
HW-M M/PAC 30/09/01 11 S 3 12.00 36.00 3 4106 COGITO
30/11/01 16 S 2 12.00 24.00 2- 4214 FSI
HW-MISC 31/08/01 12 S 1 180.00 180.00 4044 LOREX
31/08/01 12 S 1 65.00 65.00 4056 COGITO
31/08/01 12 S 1 8.00 8.00 4056 COGITO
31/08/01 12 S 1 150.00 150.00 4057 COGITO
30/09/01 11 S 1 75.00 75.00 4101 MISC
30/09/01 11 S 1 140.00 140.00 4102 COGITO
2/11/01 13 S 1 125.00 125.00 4123 BEECH
2/11/01 13 S 1 315.50 315.50 4139 LOREX
31/12/01 17 S 1 5.00 5.00 4232 BEECH
31/12/01 17 S 1 15.00 15.00 4232 BEECH
Sub total 15 1138.50
Total 15 1138.50
Non-zero Stock
Product Code Description Units Opening Receipts Issues Adjustments Current
Branch: CH Christchurch
CODE Description 1000 6.0 6
CODE Description 3m 1.0 1
CODE Description Each 2.0 2
CODE Description 2.0 2
CODE Description Each 2.0- 2-
CODE Description Each 2.0 2
CODE Description 1.0 1
CODE Description Each 6.0 6
CODE Description Each 1.0 1
Sub total 15.0 4.0 19
Total 15.0 4.0 19
Stock On Hand
Product Code Description Units Stock Avg. Current Selling G.P. %
On hand cost value Price 1
Category PX PROTOTYPES
123HB10F Description Each 5 8.15 40.77 23.90 134.5
123HB12 Description Each 5 9.42 47.10 30.00 162.1
123HB12EFV Description 10 9.51 95.10 27.60 65.5
123HB12F Description Each 4 9.69 38.76 28.10 65.5
123HB15 Description Each 6 9.45 56.75 29.50 161.2
123HB6 Description 9 6.18 55.62 18.60 66.7
123HB6EFV Description 6 7.08 42.52 21.30 66.7
123HB6F Description 4 6.60 26.40 19.60 66.3
123HB8 Description 6 6.75 40.55 21.00 147.5
123HB8EFV Description Each 10 6.89 68.90 20.80 66.8
123HB8F Description 6 6.94 41.64 19.50 64.4
Sub total 66 554.11
Grand Total 66 554.11
Product Last Price Avg. Avg GP%
cost SCM SCX
BRANCH
SALES CODE PX PROTOTYPES
123HB10 7.907 7.928 7.928 145.1 Description
123HB10EFV 8.100 8.100 8.100 100.0 Description
123HB10F 7.958 8.153 8.153 134.5 Description
123HB12 9.389 9.420 9.420 162.1 Description
123HB12EFV 9.510 9.510 9.510 100.0 Description
123HB12F 9.690 9.690 9.690 100.0 Description
123HB15 9.214 9.458 9.458 161.2 Description
123HB6 6.180 6.180 6.180 100.0 Description
123HB6EFV 7.086 7.086 7.086 100.0 Description
123HB6F 6.600 6.600 6.600 100.0 Description
123HB8 6.737 6.759 6.759 147.5 Description
123HB8EFV 6.890 6.890 6.890 100.0 Description
123HB8F 6.781 6.940 6.940 100.0 Description
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Branch Stocks Branch Trans. to: 30/06/2004 Cost used: Average Non-Purchase Transactions also used to calculate Stock Age + Cost.
Products XXX to XXXzz Current: 01/04/01 to 30/06/02
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
01/04/01 01/04/00 01/04/99 01/04/98 01/04/97 01/07/87
Product Description Avail. Total Value to 30/06/02 to 31/03/01 to 31/03/00 to 31/03/99 to 31/03/98 to 31/03/97 Aged Cost Avg Cost +
DEMAND: YTD LYTD 12 months Valued at: 100.00% 66.67% 33.34% 0.00% 0.00% 0.00% Valuation
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
XXXX1597 RH S/LOT 12.00 107.83 12.00 8.985 26.951 *
$0.00 $0.00 $107.83 $0.00 $0.00 $0.00 $323.411
XXXX1598 LH S/LOT 11.00 11.00 26.861 *
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $295.471
XXXX325 RH S/LOT 20.00 475.40 20.00 23.770 23.770
$475.40 $0.00 $0.00 $0.00 $0.00 $0.00 $475.400
XXXX325-28 RH S/LOT 6.00 186.36 6.00 31.060 31.060
$186.36 $0.00 $0.00 $0.00 $0.00 $0.00 $186.360
XXXX327-28 RH S/LOT 6.00 200.54 6.00 33.424 33.424
$200.54 $0.00 $0.00 $0.00 $0.00 $0.00 $200.544
...
Total - XXX Desc................ 233.00 2,672.26 86.00 15.00 6.00 103.00 23.00 11.469 24.296
$2,537.85 $0.00 $134.41 $0.00 $0.00 $0.00 $5,660.905
Write down value 147.00 2,988.64 268.75 221.15 1,270.67 1,228.08
Product Code Description Purch--LY--sales Opening Purch Sales Supp. Avg. Sales O/H
Branch CH Christchurch
77654 Description 20 30 7- 20 8 RAVE 2.5 5
77655 Description 2 1 1 1 1 MISC .1 1
77656 Description 1 1 2 COMPDY .1 2
77876 Description 10 2 6- 10 2 COMD .3 2
77876A Description 12 9 1- 6 4 DOVE .9 1
78657 Description 10 1 3- 12 3 COMD .3 6
78672 Description 6 2 1- 8 6 DOVE .5 1
79011 Description 8 7 2 1 DOVE .5 1
Sub total 69 53 16 59 25 5.2 19
Total 69 53 16 59 25 5.2 19
Product Code Description Cost On Hand Issues On Order
Branch: CH Christchurch
Category: PX PROTOTYPES
CODE Description 6 4
CODE Description 1 1
CODE Description 1 1
CODE Description 1 2
CODE Description 1
Sub total 7 8 3
Cost + 4%; Exclude Non-stock
Product Code Description Units Avail. Avg. ----12 months--- Average Stock G.P.% -Performance- ----- Optimum ------
Stock Cost $ Sales Demand O/h qty turn Actual Target Stock Turn G.P.%
% chg.
Branch: CH Christchurch
CODE Description 2 55.35 24 5.2 4.65 84.2 .36 3.50 11.96 4.15 75.3
CODE Description 1 8.01 1 1.7 .59 80.8 .08 .35 37.94 .43 59.3
CODE Description Each 3 12.50 16 1.4 11.14 7944.0 74332.78-
CODE Description 2 4.33 6 2.7 2.21 296.0 8.08-
CODE Description Each 2- 5.75 20 .9 21.67 4470.1 63642.28-
CODE Description Each 2 119.00 10 1.1 8.76 2502.0 1506.21-
CODE Description 86.88 4 .3 15.98 70.1 2.17 20.00 43.85- 28.49 125.2
CODE Description Each 6 .89 3 6.1 .50 461.7 8.26-
CODE Description 1 4.76 5 1.3 3.98 77.7 .74 2.50 23.54 3.22 62.8
Sub total 15 $1,727 20.6 4.32 2521.7 2096.30- 7.85 26782.80 .31 181.9
Total 15 $1,727 20.6 4.32 2521.7 2096.30- 7.85 26782.80 .31 181.9
Product Code Description Units B/ord On Hand Y.T.D. M.T.D. 1 2 3 4 5 6 7 8 9 10 11 12
Branch CH Christchurch
CODE Description 1000 6 14 4 2 2 2 2 2 6 4
CODE Description 3m 1 1 1
CODE Description Each 2 14 2 3 2 1 1 5 2
CODE Description 2 4 2 2 2
CODE Description Each 2- 17 2 2 3 2 8 2 1
CODE Description Each 2 6 1 1 1 1 2 2 2
CODE Description 1 4 1 2 1
CODE Description Each 6 3 1 2
CODE Description Each 1 4 1 1 2 1
Sub total 19 67 6 4 8 6 1 9 6 4 23 13 9
Total 19 67 6 4 8 6 1 9 6 4 23 13 9
Price 1 - On Hand Product Description Price Branch CH Christchurch CODE Description 102.00 CODE Description 73.50 CODE Description 24.00 CODE Description 10.00 CODE Description 12.00 CODE Description 85.00 CODE Description 23.00 CODE Description 5.00 CODE Description 21.00
Branch x GROUP
Product Code Description Units Avail. Avg. ----12 months--- Average Stock G.P.% -Performance- Stock ------ Optimum ----- RoI
Stock cost $ Sales Demand O/h qty turn Actual Target value Value % chg. G.P.% %
Branch: CH Christchurch
CODE Description 1 8.01 1 1.7 .11 80.9 9 13 100.0- 48
CODE Description Each 3 12.50 16 1.4 935.70-7944.1 7433279- 18 100.0- 4762
CODE Description 2 4.33 6 2.7 2.73- 296.1 808- 12 100.0- 412
CODE Description Each 2- 5.75 20 .9 204.13-4470.1 46364229- 5 100.0- 2643
CODE Description Each 2 119.00 10 1.1 60.20-2502.0 150621- 136 100.0- 6270
CODE Description 86.88 4 .3 3.10 70.2 218 22 100.0- 731
CODE Description Each 6 .89 3 6.1 1.79- 461.8 827- 5 100.0- 228
CODE Description 1 4.76 5 1.3 .96 77.7 75 6 100.0- 335
Sub total 13 65 15.5 192.97-4505.8 869484- 100 217 1889,259-9332.5- .5-9734
Total 13 65 15.5 192.97-4505.8 869484- 100 217 1889,259-9332.5- .5-9734
Grand total 13 65 15.5 192.97-4505.8 869484- 100 217 1889,259-9332.5- .5-9734
Product Code Description Units Avail. Avg. 12 months Avg. Stock G.P.%
Stock Cost Demand stock turn
Branch CH Christchurch
CODE Description 1000 2 55.35 24 5 4.65 84.2
CODE Description 3m 1 8.01 1 1 .59 80.8
CODE Description Each 3 12.50 16 1 11.14 7944.0
CODE Description 2 4.33 6 2 2.21 296.0
CODE Description Each 2- 5.75 20 21.67 4470.1
CODE Description Each 2 119.00 10 1 8.76 2502.0
CODE Description 86.88 4 15.98 70.1
CODE Description Each 6 .89 3 6 .50 461.7
CODE Description Each 1 4.76 5 1 3.98 77.7
Sub total 15 $1,727 4.32 2521.7
Total 15 $1,727 4.32 2521.7
Grand total 15 $1,727 4.32 2521.7
Product Code Description On Hand
Branch: CH Christchurch
CODE Description 6
CODE Description 1
CODE Description 2
CODE Description 2
CODE Description 2
CODE Description 1
CODE Description 6
CODE Description 1
CODE Description
21
Sub total
21
Total
Grand total
Product Code Description Units O/Hand YTD MTD 1 2 3 4 5 6 7 8 9 10 11 12
Code Description EACH 1- 3 1 1 1 1 1 1 1 2
Code Description EACH 1 1 1 1 1 1
Code Description EACH 2 1
Code Description EACH 4 13 5 4 4 6
Code Description EACH 88 55 14 7 4 16 14 1- 13 4 8 6 22 31 8
Code Description EACH 28 58 4 12 17 7 17 15 26 21 17 34 5 10 8
Code Description EACH 67 720 93 121 130 101 273 158 142 111 114 172 356 134 155
Code Description EACH 27 110 21 21 19 28 20 31 25 9 26 26 35 27 33
Code Description EACH 10 25 6 3 3 5 7 7 7 8 11 14 3 7
Code Description EACH 14 31 4 6 7 11 2 13 2 12 9 11 13 9 19
Code Description EACH 4- 143 15 15 14 15 82 14 26 17 15 23 28 74 22
Code Description EACH 16 117 21 23 27 26 19 31 14 22 22 22 35 25 30
Supplier Our Code His Code Price Description
Product Code Description Price ex GST Retail Branch CH Christchurch CODE Description CODE Description 24.000 27.00 CODE Description 10.000 11.25 CODE Description 12.000 13.50 CODE Description 85.000 95.62 CODE Description 5.000 5.62 CODE Description 21.000 23.62
--------- SCX -------- --------------- SCM -------------
Product Code Description Last Avg. Std. Last Avg.
Branch CH Christchurch
CODE Description 8.750 8.017 8.750 8.017
Product Code Description Buy Price Retail Branch CODE Description 18.000 22.50 CODE Description 144.000 180.00 CODE Description 172.800 216.00 CODE Description 80.000 100.00 CODE Description 86.400 108.00 CODE Description 112.504 140.63 CODE Description 46.800 58.50 CODE Description 6.480 8.10 CODE Description 58.504 73.13
Code Description Suggested Your Price GST Inc On Hand Unit Ordered
Retail Cogito Retail GST Available Sold Per
CODE Description 25.00 16.50 28.13 5.00 Box
CODE Description 160.00 79.00 180.00 12.00 1000
CODE Description 192.00 174.00 216.00 1.00 1000 4.00
CODE Description 102.00 55.35 114.75 2.00 1000
CODE Description 96.00 59.10 108.00 6.00 1000
CODE Description 125.00 90.00 140.63 5.00 Box
CODE Description 52.00 42.00 58.50 7.00 Each
CODE Description 7.20 4.75 8.10 2.00 Each
CODE Description 65.00 51.87 73.13 Box 5.00
Set-ups control headings for authorised users.
Price / Costs 1-8; Tax Code; Price / Costs 1-8 Encoded; Price / Costs 1-8 with GST Encoded;
Price / Costs 1-8 with GST; GST value on 1-8; On hand Stock; Customer Orders;
Supplier Orders; Issued; Available Stock; Units; Price Date.
Re-Order Point (Ignores Max) - Free stock = 15, but EOQ makes this 20.
Product Code Description Free R/O Pt. Max. EOQ 1 mth Re-order Value
Branch CH Christchurch
FAG Cigarettes 5 20 40 10 5.0 20.0 160.00
Sub total 160.00
Total 160.00
OR
Re-Order Point (Ignores Max) - Free stock = 15, but EOQ makes this 20.
Product Code Description Free R/O Pt. Max. EOQ 1 mth Re-order Value
Branch CH Christchurch
FAG Cigarettes 5 20 40 10 5.0 30.0 240.00
Sub total 240.00
Total 240.00
Product Code Description Last Cost Yrs Sales 1 Month On Hand Cus Ord Supplier Order Pt QTY
Forecast Stock + Alloc Orders REQD
HS-FAG Cigarettes 8.00 5 20 40 30
Sub total 30
Total 30
Product Code Description Last Cost Yrs Sales Free Max QTY 1 QTY 2 Value $Diff
Forecast Stock
HS-FAG Cigarettes 8.00 5 40 30 10 104.00 136.00
Sub total 30 10 104.00 136.00
Total 30 10 104.00 136.00
To order enough stock to cover 3 month's demand with the last
6 months being given double the "weighting" of the last 12 months.
Note that the 12 Mth demand includes the last 6 months as the 6 mth
weighting is 1 i.e. included once in long term and once in short term.
"Usage": = 12 + (6*1) = 18 months.
"Divisor" required to give 3 mth's usage = 18/3 = 6
last 12 months demand = 60 (avg 5 per month)
last 6 months demand = 48 (avg 8 per month)
"recent" weighting factor = 1
Total Months Usage: Long Term Demand + (Short Term Demand * Weighting)
________________________________________________
Divisor Total Months / Months Required
e.g. 60 + (48*1)
____________ OR 108 / 6 = 18
18/3
If current free stock is 5, the report will suggest ordering a further 13.
The quantity will be adjusted by EOQ if present.
Free D e m a n d Mths Optimum Qty to Avg.
Product Code Description Units Stock Due in. 6 mths 12 mths supply stock reorder Cost Value
HS-FAG Cigarettes Pkt 5 48 60 .8 18 13 8.00 104.00
Sub total 5 48 60 13 104.00
Total 5 48 60 13 104.00
Available D e m a n d Mths Qty to Avg.
Product Code Description Units Stock Due in. 6 mths 12 mths Supply Min/Max Reorder Cost Value
HS-FAG CH Cigarettes Pkt 5 48 60 .8 18 13 8.00 104.00
Sub total 5 48 60 13 104.00
Total 5 48 60 13 104.00
Free D e m a n d Mths Optimum Qty to Avg.
Product Code Description Units Stock Due in. 6 mths 12 mths supply stock reorder Cost Value
HS-FAG Cigarettes Pkt 5 48 60 .8 18 13 8.00 104.00
Sub total 5 48 60 13 104.00
Total 5 48 60 13 104.00
Product Code Description Units Free Due in. 6 mths 12 mths Supply Min/Max Reorder Cost Value
HS-FAG Cigarettes Pkt 48 60 .8 18 8.00
Sub total 48 60
Total 48 60
Free D e m a n d Mths Optimum Qty to
Product Code Description Units Stock Due in. mths mths supply stock reorder Value
HS-FAG Cigarettes Pkt 48 60 .8 18 8.00
Sub total 48 60
Total 48 60
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Branch Stocks Branch Trans. to: 30/06/2004 Cost used: Average Non-Purchase Transactions also used to calculate Stock Age + Cost.
Products XXXX to XXXXzz Current: 01/04/01 to 30/06/02
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
01/04/01 01/04/00 01/04/99 01/04/98 01/04/97 01/07/87
Product Description Avail. Total Value to 30/06/02 to 31/03/01 to 31/03/00 to 31/03/99 to 31/03/98 to 31/03/97 Aged Cost Avg Cost +
DEMAND: YTD LYTD 12 months Valued at: 100.00% 66.67% 33.34% 0.00% 0.00% 0.00% Valuation
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
XXXX1597 RH S/LOT 12.00 107.83 12.00 8.985 26.951 *
$0.00 $0.00 $107.83 $0.00 $0.00 $0.00 $323.411
XXXX1598 LH S/LOT 11.00 11.00 26.861 *
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $295.471
XXXX325 RH S/LOT 20.00 475.40 20.00 23.770 23.770
$475.40 $0.00 $0.00 $0.00 $0.00 $0.00 $475.400
XXXX325-28 RH S/LOT 6.00 186.36 6.00 31.060 31.060
$186.36 $0.00 $0.00 $0.00 $0.00 $0.00 $186.360
XXXX327-28 RH S/LOT 6.00 200.54 6.00 33.424 33.424
$200.54 $0.00 $0.00 $0.00 $0.00 $0.00 $200.544
...
Total - XXXX Desc................ 233.00 2,672.26 86.00 15.00 6.00 103.00 23.00 11.469 24.296
$2,537.85 $0.00 $134.41 $0.00 $0.00 $0.00 $5,660.905
Write down value 147.00 2,988.64 268.75 221.15 1,270.67 1,228.08
8SCP02L1 Shelf Labels - stocktake
8SCP02L2 Barcode labels
8SCP02L3 Product Labels with Barcode and text
8SCP02L4 3-up Shelf labels for warehouse
8SCP02L5 Thin (20mm high) Bin Labels
8SCP02L6 Product Labels with text (L3), NOT Barcode
8SCP02L7 Product Labels
8SCP02E1 - For Import with 8SCX41E1
* Format: Fixed length fields
* Output: Code, Desc, Sell-1, Sell-2, category, status,
* price-date, replaces, replaced-by, sales-code,
* short desc, (Customer's Price - optional)8SCP02E2 - Stocktake Bins - Import to SCX with 8SCX42X2
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Branch, Bin 1, 2, 3 Desc.8SCP02E3 - Stock File
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Short Desc, Desc, Units, Sell 1 OR cust. price8SCP02E4 - For Import with 8SCX41X4
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, S/a, Cat, Cat-2, Short Desc,
* Desc, Units, Disc-code, Price 1, 2, 3, Cat-38SCP02E5 - Stock File
* Format: ASCII, Comma-delimited, Quotes
* Output: PLU, Desc, Code, Sell, Sell-1,
Short-desc, Cat, Cat-2, Cat-38SCP02E6 - Stock File
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Desc, Selected price, Customer's Price, Category, Cat 2, Cat 38SCP02E7 - Price Export - Import with 8SCX41X7
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Price 1, 2, 3, 4, 5, Costs: Last, Avg, Std., Aged, Flag
Bottom Line: Code, rate, code 2, low price;
Branch, product Description8SCP02E8 - Costs Export
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Cat, Desc, Cost Avg, Cost Last, Cost Std.8SCP02EC - Product File (SCM) Export
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Replaced-by, Desc8SCP02EH - Product File (SCM) Export
* Format: ASCII, Comma-delimited, Quotes
* Output: Very Full8SCP02EK - Cogito Toolkit - Import with 8SYX41TK
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Desc, Class8SCP02EM - Full Product File (SCM) Export
* Format: ASCII, Comma-delimited, Quotes
* Output: Very full8SCP02EN - Customer Price Export to Nimbus
* Format: ASCII, Comma-delimited, NO Quotes
* Output: Code, Desc, Selected price, Customer's Price
* Units, Cat 2, Cat 3,8SCP02EO - Supplier Product File - Re-load to SCX with 8SCX42XS
This version is mostly used to create a "blank" spreadsheet matching the one produced by SCP03E1.
This "blank" spreadsheet can be filled from a supplier's export, matching by description.
Load the updated spreadsheet to SCX scxp- records using 8SCX42XS.
NB: Items in [] are not filled by this program unless a valid scxp- record is found; they are for compatibility.
* Format: ASCII, Comma-delimited, Quotes
* Output: [Supplier], Product, [Supp. product],
[Supp price], [Supp. desc.],
[Price per], SCM Description,
Description parts (up to 6 for TS)8SCP02EP - Stock File
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Desc, O/Order, Avail O/Hand, Short Desc,
Units, Supplier, Avg cost, Price 1, Leadtime8SCP02EQ - Quilckbooks Product Price List export
* Format: ASCII, Comma-delimited, Quotes
* Output: Type, Product, Description, "inc acc",
"ass acc","cogs acc",cost,price,8SCP02ES - Stock File
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, Branch, On hand8SCP02ET - Stock Valuation
* Format: ASCII, Comma-delimited, Quotes
* Output: Cat, Prod, Desc, last sale date, last purch,
* Qty o/hand, Val o/h, Avg cost, Iss, Avail,
* Qty 12 mth, Qty NO sales, Val no sales.8SCP02EX - Full Stock File (SCX) Export
* Format: ASCII, Comma-delimited, Quotes
* Output: Very Full
8SCP02F1 - Product File (SCM) "Dump"
* Format: Fixed length fields
* Output: Code, Desc, Short Desc, PLU, Units, Category,
* Sales Code, Supplier, Class, Disc Code,
* Tax code, Status, SA Level, Cat2,
* (Customer's Price - optional)8SCP02F2 - Not Replaced by
Prints only items with NEITHER "replace-by" NOR "replaces"
* Format: Fixed length fields
* Output: Code, Desc, Replacement,
Std Cost, Sell Price, Available, Status8SCP02F3 - Re-code to
Used with re-coding process
* Format: Fixed length fields
* Output: Code, Status, Re-code to, Found,
Alternate, Replaces, Desc,8SCP02F4 - Extra Text report
* Format: Fixed length fields
* Output: Code, Description,
Text lines - SCM (and SCT)8SCP02F5 - Product file (SCM) - 5-line "Dump"
* Format: Fixed length fields
* Output: Very Full