Inventory Quantity Discount Price File Layout

This text file is used in the Load Special and Quantity Discount Pricing (2.2.4.6) program. The text file can be produced automatically, but will generally need to be prepared in Excel.

The filename must end with a .TXT extension.

Important Note: Items loaded from the file will completely replace any existing quantity discount item(s) for the specified Part, Unit, and Location(s) currently on file.

The text file must contain TAB-delimited fields in the following order:

Quantity Discount Price File Layout Updated: 4/22/2019 Load Special and Quantity Discount Pricing (2.2.4.6)
# Spreadsheet Column Field Note
1 A Mfr A valid Mfr Code must be used. Must be formatted as Text column type in Excel.
2 B Part Number Must exist in the system.
3 C Unit Must exist in the system.
4 D Location Leave blank to update All Locations.
5 E Action A = Add, D = Delete. Only need first 5 columns for Delete.
6 F Start Date Optional.
7 G End Date Optional.
8 H Price Code Must exist in the system.
9 I Level 1 Qty Level 1 Quantity Sold Break Point.
10 J Level 1 Discount % MR2. Optional as long as Price is supplied.
11 K Level 1 Price MR2. Optional as long as Discount % is supplied.
12 L Level 2 Qty Level 2 Quantity Sold Break Point.
13 M Level 2 Discount % Level 2 Discount Percent. MR2
14 N Level 2 Price MR2
15 O Level 3 Qty Level 3 Quantity Sold Break Point.
16 P Level 3 Discount % Level 3 Discount Percent. MR2
17 Q Level 3 Price MR2
18 R Level 4 Qty Level 4 Quantity Sold Break Point.
19 S Level 4 Discount % Level 4 Discount Percent. MR2
20 T Level 4 Price MR2
21 U Level 5 Qty Level 5 Quantity Sold Break Point.
22 V Level 5 Discount % MR2
23 W Level 5 Price MR2