ABS Technical Bulletin
#15
New Material Editor
Utility Function
“Transfer
Weight”
(released
August 31, 2001)
A new ABS Material Editor Utility function,
called “Transfer Weight”, has been developed. This new function allows users to transfer weight
from one material to another, rather than changing the quantities of the two
materials affected. The transfer function logs the activity and, when necessary,
calculates a new weighted average cost/lb. or kg.
The following examples show you the “before and
after” position of the month-to-date and inventory files after six different
weight transfers are recorded. The
last example shows the decision and processing logic involved when a transfer
occurs. There are four (4) possible conditions that the program can encounter. The
resultant chemistry and cost is shown in the table at the bottom.
For example, if a transfer is made and the
new material does not exist, and the new material name is different than the
sending (parent) record, and if an average record exists, this is “Condition
3”.
The new record will retain all of the attributes of the average record, except
the actual cost/lb. or kg.
Examples
1 and 2 show the Month-To-Date and Inventory summary values before we begin the
transfer. Note the beginning weights and values:
Example (1): Beginning/Ending Month-To-Date File
From : 08/30/01 11:15 Keystone Demo System Page : 1
To : 08/31/01 24:00 M. T. D. Transactions Report Date : 08/30/01
- - - Beginning - - - - - Adjustments - -
Account Material Vendor Lbs Actual Lbs Actual
Number Name Code On Books $ Cost To Books $ Cost
A MAT A VEN A 30,000 15,000.00 0 0.00
B MAT B VEN B 50,000 40,000.00 0 0.00
2 Records ======== ========== ======== =========
80,000 0
55,000.00 0.00
Example (2): Beginning/Ending Inventory Summary
Keystone Demo System Date : 08/30/01
Page 1 of 1 Summary of Inventory Time : 11:17
File Quantity Book Actual Cost Number of
Name On-Hand Quantity of Inventory Materials
1. CRNI 80,000 80,000 55,000.00 2
============ =========== ============= =====
Total 80,000 80,000 55,000.00 2
Example (3): Average Records
Here
are the
“average”
records. Note their cost/lb.:
R A W M A T E R I A
L R E P O R
T
Date : 08/30/01
Time : 11:18
Page
1
Material Name [MAT
A ] Available
Quantity [
0]
Lot
Number
[AVERAGE ] Book
Quantity
[
0]
File
name [CRNI
] Quantity
Reserved [
0]
Class
Code
[REVERT] P.O.
Number [PO
A ]
Account Number
[A ] Re-order
Point
[
0]
Material Type [
] Date
Received
[08/30/01]
Actual Cost/Lb
[ 0.5000] Date Last
Used
[
]
Optimizing Cost/Lb [
0.4500] Unit
Weight
[
1]
Standard Cost/Lb [
0.4000] Unit Name (Desc)
[
]
Material Usage Code [C
] Solve for
Units [N-o
]
Minimum Solve Lb's [
0] Solution Accuracy
[0]
Maximum usage % [
100] Material Recovery % [
100]
Available for use [Y-es
]
Location
[MAT A ]
Print Order
[ ]
Vendor Code [VEN A
]
Furnace Codes
[ ]
Balance Element [FE
]
Tag/Tally Number [MAT A
] Balance Analysis [
73.0470 ]
Material Description[MAT
A ] Abs License
Plate
[00033]
Material Comments:
[
]
[
]
C-0.08300 MN-1.40000 SI-0.52000 CR-16.50000 NI-8.45000
Material Name [MAT B ] Available Quantity [ 0]
Lot Number [AVERAGE ] Book Quantity [ 0]
File name [CRNI ] Quantity Reserved [ 0]
Class Code [REVERT] P.O. Number [PO B ]
Account Number [B ] Re-order Point [ 0]
Material Type [ ] Date Received [08/30/01]
Actual Cost/Lb [ 0.8000] Date Last Used [ ]
Optimizing Cost/Lb [ 0.7500] Unit Weight [ 1]
Standard Cost/Lb [ 0.7000] Unit Name (Desc) [ ]
Material Usage Code [C ] Solve for Units [N-o ]
Minimum Solve Lb's [ 0] Solution Accuracy [0]
Maximum usage % [ 100] Material Recovery % [ 100]
Available for use [Y-es ] Location [MAT B ]
Print Order [ ] Vendor Code [VEN B ]
Furnace Codes [ ] Balance Element [FE ]
Tag/Tally Number [MAT B ] Balance Analysis [ 73.0470 ]
Material Description[MAT B ] Abs License Plate [00035]
Material Comments: [ ]
[ ]
C-0.08300 MN-1.40000 SI-0.52000 CR-16.50000 NI-8.45000
Example (4): Material File - Before Transfer
Here are the two materials in
inventory before we start to perform any transfers.
R A W M A T E R I A L R E P O R T Date : 08/30/01
Time : 11:20
Page 2
Material Name [MAT A ] Available Quantity [ 30,000]
Lot Number [BIN 1 ] Book Quantity [ 30,000]
File name [CRNI ] Quantity Reserved [ 0]
Class Code [REVERT] P.O. Number [PO A ]
Account Number [A ] Re-order Point [ 0]
Material Type [ ] Date Received [08/30/01]
Actual Cost/Lb [ 0.5000] Date Last Used [ ]
Optimizing Cost/Lb [ 0.4500] Unit Weight [ 1]
Standard Cost/Lb [ 0.4000] Unit Name (Desc) [ ]
Material Usage Code [C ] Solve for Units [N-o ]
Minimum Solve Lb's [ 0] Solution Accuracy [0]
Maximum usage % [ 100] Material Recovery % [ 100]
Available for use [Y-es ] Location [MAT A ]
Print Order [ ] Vendor Code [VEN A ]
Furnace Codes [ ] Balance Element [FE ]
Tag/Tally Number [MAT A ] Balance Analysis [ 73.0470 ]
Material Description[MAT A ] Abs License Plate [00037]
Material Comments: [ ]
[ ]
C-0.08300 MN-1.40000 SI-0.52000 CR-16.50000 NI-8.45000
Material Name [MAT B ] Available Quantity [ 50,000]
Lot Number [BIN 1 ] Book Quantity [ 50,000]
File name [CRNI ] Quantity Reserved [ 0]
Class Code [REVERT] P.O. Number [PO B ]
Account Number [B ] Re-order Point [ 0]
Material Type [ ] Date Received [08/30/01]
Actual Cost/Lb [ 0.8000] Date Last Used [ ]
Optimizing Cost/Lb [ 0.7500] Unit Weight [ 1]
Standard Cost/Lb [ 0.7000] Unit Name (Desc) [ ]
Material Usage Code [C ] Solve for Units [N-o ]
Minimum Solve Lb's [ 0] Solution Accuracy [0]
Maximum usage % [ 100] Material Recovery % [ 100]
Available for use [Y-es ] Location [MAT B ]
Print Order [ ] Vendor Code [VEN B ]
Furnace Codes [ ] Balance Element [FE ]
Tag/Tally Number [MAT B ] Balance Analysis [ 73.0470 ]
Material Description[MAT B ] Abs License Plate [00036]
Material Comments: [ ]
[ ]
C-0.08300 MN-1.40000 SI-0.52000 CR-16.50000 NI-8.45000
Example
(5): Transfer Occurs Now
here are the transfers that we performed:
----From----
-----To----- Weight
Name
Lot Name Lot
Transferred ----Action Taken----
1. mat a, bin 1 mat a, bin
2 3000
Created New Material
2. mat a, bin 1 mat b, bin
2 4000
Created New Material
3. mat a, bin 1 mat a, bin
2 5000
Added to Material
4. mat b, bin 1 mat b, bin
2 6000
Added to Material
5. mat b, bin 1 mat a, bin
2 7000
Added to Material
6. mat a, bin 2 mat b, bin
2 10000 Added
to Material
Example
(6): Activity
Reports for Mat A and Mat B Here are the
material activity reports for all four materials:
Keystone Demo System
Material Activity Report
Material Name: MAT A Date received : 08/30/01
Lot Number : BIN 1 Date last used:
File Name : CRNI Class Code : REVERT
P.O. Number : PO A Vendor Code : VEN A
Material Type: Account Number: A
Search Dates : 08/30/01 / 08/30/01 Abs License Plate : 00037
Activity Activity Activity Book Actual Book
Date Weight Quantity Cost/Lb $ Value
08/30/01 Book Qty Chg/Trans > 3,000 Wgt to: MAT A Lot No.BIN 2
Book Qty Chg/Trans -3,000 27,000 0.50000 13,500.00
Book Qty Chg/Trans > 4,000 Wgt to: MAT B Lot No.BIN 2
Book Qty Chg/Trans -4,000 23,000 11,500.00
Book Qty Chg/Trans -5,000 Wgt to: MAT A Lot No.BIN 2
Current Values 18,000 9,000.00
Keystone Demo System
Material Activity Report
Material Name: MAT A Date received : 08/30/01
Lot Number : BIN 2 Date last used:
File Name : CRNI Class Code : REVERT
P.O. Number : PO A Vendor Code : VEN A
Material Type: Account Number: A
Search Dates : 08/30/01 / 08/30/01 Abs License Plate : 00038
Activity Activity Activity Book Actual Book
Date Weight Quantity Cost/Lb $ Value
08/30/01 Created Via Wgt Trn 3,000 3,000 0.50000 1,500.00
Book Qty Chg/Trans > 3,000 Wgt fm: MAT A Lot No.BIN 1
Book Qty Chg/Trans 5,000 Wgt FM: MAT A Lot No.BIN 1
Book Qty Chg/Trans 7,000 Wgt FM: MAT B Lot No.BIN 1
Actual Cost/Lb ( 0) ( 0.50000) 15,000 0.64000 9,600.00
Book Qty Chg/Trans -10,000 Wgt to: MAT B Lot No.BIN 2
Current Values 5,000 3,200.00
Keystone Demo System
Material Activity Report
Material Name: MAT B Date received : 08/30/01
Lot Number : BIN 1 Date last used:
File Name : CRNI Class Code : REVERT
P.O. Number : PO B Vendor Code : VEN B
Material Type: Account Number: B
Search Dates : 08/30/01 / 08/30/01 Abs License Plate : 00036
Activity Activity Activity Book Actual Book
Date Weight Quantity Cost/Lb $ Value
08/30/01 Book Qty Chg/Trans -6,000 Wgt to: MAT B Lot No.BIN 2
Book Qty Chg/Trans -7,000 Wgt to: MAT A Lot No.BIN 2
Current Values 37,000 0.80000 29,600.00
Keystone Demo System
Material Activity Report
Material Name: MAT B Date received : 08/30/01
Lot Number : BIN 2 Date last used:
File Name : CRNI Class Code : REVERT
P.O. Number : PO B Vendor Code : VEN B
Material Type: Account Number: B
Search Dates : 08/30/01 / 08/30/01 Abs License Plate : 00039
Activity Activity Activity Book Actual Book
Date Weight Quantity Cost/Lb $ Value
08/30/01 Created Via Wgt Trn 4,000 4,000 0.50000 2,000.00
Book Qty Chg/Trans > 4,000 Wgt fm: MAT A Lot No.BIN 1
Book Qty Chg/Trans 6,000 Wgt FM: MAT B Lot No.BIN 1
Actual Cost/Lb ( 0) ( 0.50000) 10,000 0.68000 6,800.00
Book Qty Chg/Trans 10,000 Wgt FM: MAT A Lot No.BIN 2
Actual Cost/Lb ( 0) ( 0.68000) 20,000 0.66000 13,200.00
Current Values 20,000 13,200.00
Example
(7): Material
File - After Transfer Here's
what all four materials look like after the transfers:
R A W M A T E R I A L R E P O R
T
Date : 08/30/01
Time : 11:30
Page
1
Material Name [MAT
A ] Available
Quantity [
18,000]
Lot
Number [BIN 1
] Book
Quantity [
18,000]
File
name [CRNI
] Quantity
Reserved [
0]
Class
Code
[REVERT] P.O.
Number [PO
A ]
Account Number
[A ]
Re-order Point
[
0]
Material Type [
] Date
Received
[08/30/01]
Actual Cost/Lb
[ 0.5000] Date Last
Used
[
]
Optimizing Cost/Lb [
0.4500] Unit
Weight
[
1]
Standard Cost/Lb [
0.4000] Unit Name (Desc)
[
]
Material Usage Code [C
] Solve for
Units [N-o
]
Minimum Solve Lb's [
0] Solution
Accuracy
[0]
Maximum usage %
[ 100] Material
Recovery % [
100]
Available for use [Y-es
]
Location
[MAT A ]
Print
Order [
] Vendor
Code [VEN A
]
Furnace Codes
[ ]
Balance Element [FE
]
Tag/Tally Number [MAT A
] Balance
Analysis [ 73.0470
]
Material Description[MAT
A ] Abs License
Plate
[00037]
Material Comments:
[
]
[
]
C-0.08300 MN-1.40000 SI-0.52000
CR-16.50000 NI-8.45000
Material Name [MAT A
] Available Quantity [
5,000]
Lot
Number [BIN 2
] Book
Quantity [
5,000]
File
name [CRNI
] Quantity
Reserved [
0]
Class
Code
[REVERT] P.O.
Number [PO
A ]
Account Number
[A ]
Re-order Point
[
0]
Material Type [
] Date
Received
[08/30/01]
Actual Cost/Lb
[ 0.6400] Date Last
Used
[
]
Optimizing Cost/Lb [
0.4500] Unit
Weight
[
1]
Standard Cost/Lb [
0.4000] Unit Name (Desc)
[
]
Material Usage Code [C
] Solve for
Units [N-o
]
Minimum Solve Lb's [
0] Solution
Accuracy
[0]
Maximum usage %
[ 100] Material
Recovery % [
100]
Available for use [Y-es
]
Location
[
]
Print
Order [
] Vendor
Code [VEN A
]
Furnace Codes
[ ]
Balance Element [FE
]
Tag/Tally Number [MAT A
] Balance
Analysis [ 73.0470
]
Material Description[MAT
A ] Abs License
Plate
[00038]
Material Comments:
[
]
[
]
C-0.08300 MN-1.40000 SI-0.52000
CR-16.50000 NI-8.45000
R A W M A T E R I A L R E P O R
T
Date : 08/30/01
Time : 11:30
Page
2
Material Name [MAT
B ] Available
Quantity [
37,000]
Lot
Number [BIN 1
] Book
Quantity [
37,000]
File
name [CRNI
] Quantity
Reserved [
0]
Class
Code
[REVERT] P.O.
Number [PO
B ]
Account Number
[B ]
Re-order Point
[
0]
Material Type [
] Date
Received
[08/30/01]
Actual Cost/Lb
[ 0.8000] Date Last
Used
[
]
Optimizing Cost/Lb [
0.7500] Unit
Weight
[
1]
Standard Cost/Lb [
0.7000] Unit Name (Desc)
[
]
Material Usage Code [C
] Solve for
Units [N-o
]
Minimum Solve Lb's [
0] Solution
Accuracy
[0]
Maximum usage %
[ 100] Material
Recovery % [
100]
Available for use [Y-es
]
Location
[MAT B ]
Print
Order [
] Vendor
Code [VEN B
]
Furnace Codes
[ ]
Balance Element [FE
]
Tag/Tally Number [MAT B
] Balance
Analysis [ 73.0470
]
Material Description[MAT
B ] Abs License
Plate
[00036]
Material Comments:
[
]
[
]
C-0.08300 MN-1.40000 SI-0.52000
CR-16.50000 NI-8.45000
Material Name [MAT B ] Available Quantity [ 20,000]
Lot Number [BIN 2 ] Book Quantity [ 20,000]
File name [CRNI ] Quantity Reserved [ 0]
Class Code [REVERT] P.O. Number [PO B ]
Account Number [B ] Re-order Point [ 0]
Material Type [ ] Date Received [08/30/01]
Actual Cost/Lb [ 0.6600] Date Last Used [ ]
Optimizing Cost/Lb [ 0.7500] Unit Weight [ 1]
Standard Cost/Lb [ 0.7000] Unit Name (Desc) [ ]
Material Usage Code [C ] Solve for Units [N-o ]
Minimum Solve Lb's [ 0] Solution Accuracy [0]
Maximum usage % [ 100] Material Recovery % [ 100]
Available for use [Y-es ] Location [ ]
Print Order [ ] Vendor Code [VEN B ]
Furnace Codes [ ] Balance Element [FE ]
Tag/Tally Number [MAT B ] Balance Analysis [ 73.0470 ]
Material Description[MAT B ] Abs License Plate [00039]
Material Comments: [ ]
[ ]
C-0.08300 MN-1.40000 SI-0.52000 CR-16.50000 NI-8.45000
Example
(8): Beginning/Ending Inventory Summary
- After Transfer Note
the quantity and value has not changed.
Keystone Demo
System
Date : 08/30/01
Page 1
of 1 Summary of
Inventory
Time : 11:31
File
Quantity
Book Actual
Cost Number of
Name
On-Hand
Quantity of
Inventory Materials
1. CRNI
80,000
80,000
55,000.00 4
============
===========
============= =====
Total 80,000
80,000 55,000.00
4
Example
(9): Beginning/Ending Month-To-Date File
- After Transfer The Month-To-Date system
values have not changed, but since 7,000 lbs. was transferred from MAT A
(account number A) to MAT B (account number B), the adjustment column reflects
this change.
From : 08/30/01 11:15 Keystone Demo System Page : 1
To : 08/31/01 24:00 M. T. D. Transactions Report Date : 08/30/01
- - - Beginning - - - - - - - - Ending - - - -
Account Material Vendor Lbs Actual Lbs Actual
Number Name Code On Books $ Cost On Books $ Cost
A MAT A VEN A 30,000 15,000.00 23,000 12,200.00
B MAT B VEN B 50,000 40,000.00 57,000 42,800.00
2 Records ========= ============ ========= ============
80,000 80,000
55,000.00 55,000.00
From : 08/30/01 11:15 Keystone Demo System Page : 1
To : 08/31/01 24:00 M. T. D. Transactions Report Date : 08/30/01
- - - Adjustments - - -
Account Material Vendor Lbs Actual
Number Name Code To Books $ Cost
A MAT A VEN A -7,000 -2,800.00
B MAT B VEN B 7,000 2,800.00
2 Records ========= ============
0
0.00
Weight Transfer Utility - Processing Logic
|
Condition
1 |
Condition 2 |
Condition
3 |
Condition 4 |
|
Material: |
Material
Name Exists |
Material
Name Doesn’t Exist, Name is Same as Parent |
Material
Name Doesn’t Exist, Average
Exists |
Material
Name Doesn’t Exist, No Average Exists |
| Chemistry |
No
Change |
Same
as Parent |
Same
as Average |
Same
as Parent |
| Actual
Cost/Lb. |
Weighted Average
Computed |
Same
as Parent |
Same
as Parent |
Same
as Parent |
| Optimizing
Cost/Lb. |
No Change, unless
Special Option 48 is on |
Same
as Parent |
Same
as Average |
Same
as Parent |
| Standard
Cost/Lb. |
No Change |
Same
as Parent |
Same
as Average |
Same
as Parent |
| Location |
New
Value, if entered |
New
Value, if entered |
New
Value, if entered |
New
Value, if entered |
Previous Technical
Bulletin | Next
Technical Bulletin | Technical
Bulletin Listing
|
