Download INVENTORY CONTROL

Next Generation®
Inventory Control
Formatting of ASCII / Excel Files:
The upload ASCII / Excel option allow s the user to utilize an external ASCII or Excel file and upload
that file into the item future cost file. The Input file definition and ASCII and Excel file requirements
are listed below .
Note: The user is responsible for providing an ASCII or Excel file using the follow ing field
definitions and rules regarding the ASCII file.
Input ASCII File Definition
The follow ing fields may be imported.
(Note if the user is only loading the new material cost then the only fields required on the input file
is
the item identifier and the new material cost)
Field Header
item_id_itfptmp
nmatcst_ifcsttmp
nlabcst_ifcsttmp
novhdcst_ifcsttmp
noutcst_ifcsttmp
nincmat_ifcsttmp
ninclab_ifcsttmp
noincvhd_ifcsttmp
nincout_ifcsttmp
Field Description
Field Type
Item Identifier.
Character
New Material Cost
Decimal
New Labor Cost
Decimal
New Overhead Cost
Decimal
New Outside Cost
Decimal
New Incremental Material Decimal
New Incremental Labor
Decimal
New Incremental Overhead Decimal
New Incremental Outside
Decimal
Maximum Field Size
30
10
10
10
10
10
10
10
10
Input ASCII File Requirements
File must be in ASCII format
All records must have each field delineated by a pipe sign (< 174> ASCII Character w hich is
represented as | ).
All records must be terminated w ith a < Line > < Feed> (< 10> ASCII Characters)
ASCII file must be terminated w ith a < Carriage> < Return> < Line> < Feed> (< 13> < 10> ASCII
Characters.
All character fields must be left justified.
Decimal fields must be in decimal format:" -XXXXXX.XX" . Signed numeric fields must contain the
sign in front of the number. Decimal point must be included and contain at least one digit to the left
and tw o digits to the right of the decimal point (.i.e. –323.25) Blanks before any numbers are
assumed to be positive.
Example of ASCII file.
item_id_ifcsttmp|nmatcst_ifcsttmp|nlabcst_ifcsttmp|novhdcst_ifcsttmp|noutcst_i
fcsttmp|nincmat_ifcsttmp|ninclab_ifcsttmp|noinvcvhd_ifcsttmp|nincout_ifcsttmp
ITEMA|600.00|500.00|400.00|300.00|200.00|100.00|90.00|80.00|
ITEMB|900.00|800.00|700.00|600.00|500.00|400.00|30.00|20.00|
Release NGS-6.30
IC- 175