Input file format

This section describes the input file format required by the Price Protection program.

The information that is required by the Price Protection Program includes the following.  This information should be provided in a CSV file (comma separated value file) with a carriage return at the end of each line, and a minimum of 6 fields and a maximum of 7 fields in each line.  The last field is used for any text notes you wish to associate with the inventory transaction records that are created by the program.

If you also wish to update foreign currency purchase order and QVL information for the vendor and item being processed, the input line for the foreign currency to be processed should be included immediately after the local currency input line.  This line starts with the Currency to be processed and includes 5 fields which are all required.

Required Information for all transactions

Division The division number in which the transaction should be processed.

Vendor Name The vendor name associated with the price protection.  The system uses the vendor name to select which purchase orders to update with the new vendor price. 

G/L ID A unique transaction identifier that is assigned to each price protection transaction.  This transaction id is written to the Project field of the journal entry that is created by the Price Protection program and it is also written to the comment that is produced by the Price Protection program and associated with the inventory transaction that is also written by the price protection program.

Inventory Item Number The Inventory Item Number of the item that is being protected.

New Vendor Protected Cost - The new vendor cost (your new purchase price) for the item in your local or house currency.

Max Qty Protected The quantity of the item that is being protected by the vendor.  The system uses the lesser of the Qty being protected or the on hand quantity for the item when adjusting your on hand inventory value for the item.

If a -1 is entered in the Max Qty protected field, the system will protect the currency on hand quantity for the item at the time that the price protection transaction is processed (it will adjust the cost for the on hand items in all locations in the current division being processed).

If a 0 is entered in the Max Qty protected field, the system will treat the transaction as a Price Change only meaning it will update the purchase orders for the vendor and item and the next cost for the item in the Catalog and Inventory Files but it will not adjust the average cost of the items that are in stock (if any).

Optional Information for all Local Currency Transactions

Comment:  If the last field in the input file is loaded, the system will create a text note or comment for the transaction which will include the GL ID and the text from the last field of the input file.  This comment will be associated with the inventory activity record that is created for the transaction.  This option is not supported for Foreign Currency Lines.  If no text is present in the input file, the system will create a comment with only the GL ID information and associated it with the Inventory activity record.

Foreign Currency Information - Optional

If you purchasing the item that is being protected in a currency that is not your local or house currency, you may also specify a Foreign Currency and a Foreign Currency Price in the Price Protection input file.  If this information is present, the Price Protection program will also update any open purchase orders or QVL records for the Vendor/Item and Currency specified.

Foreign Currency Code The Currency Code.  The price protection program will update open QVL and purchase order records for the Vendor and Item, and currency code specified.  Open purchase order lines for the vendor and item that are in house currency will be updated with the amount specified in the new vendor protected cost.

Vendor Name The vendor name associated with the price protection.  The system uses the vendor name to select which purchase orders to update with the new vendor price. 

G/L ID A unique transaction identifier that is assigned to each price protection transaction.  This transaction id is written to the Project field of the journal entry that is created by the Price Protection program and it is also written to the comment that is produced by the Price Protection program and associated with the inventory transaction that is also written by the price protection program.

Inventory Item Number The Inventory Item Number of the item that is being protected.

FC PO Price:  The new vendor price in the foreign currency being processed.

The Price Protection Information that is used by the automated processing program should be formatted as a CSV file using an excel spreadsheet with no header line.

Local Currency Line  

Div

Vendor Name

GL ID

Item#

New LC Price

Qty

Text Note

1

Bay Area Systems

PP001

AP3000

200.00

10

Text to be added to Comment.

Foreign Currency Line

Currency

Vendor Name

GL ID

Item#

FC Price

CAD

Bay Area Systems

PP001

AP3000

318.75