Grab Shipment File

Enterprise & Corporate Edition Only

To access this facility go into Import Shipment Costing and press the Options button from that menu. Select Grab Shipment File from the pop-up menu.

Use this utility to import a list of product codes, purchase order numbers, quantities and costs into the Import Costing System. The items listed in the import file will then be marked for import costing. This can save time marking items to cost manually, if a file containing information on the items shipped is available in electronic format.

File Name

Enter the location and name of the file to import. CAPITAL will remember the last file and location you specified the next time you run this utility.

Delimiter

The delimiter character to use. The default is comma but any character delimiter is acceptable. You may specify a character such as |, ^, # or other ASCII symbols, or enter the ASCII code as a number. Numbers are assumed to refer to ASCII codes, so 9 or 009 is treated as the ASCII character 9 (tab).

File Format

The Grab File utility can only import a delimited text file consisting of a product code or equivalent code (such as a barcode), a valid purchase order number, the quantity to cost, and a revised cost price if applicable. The delimiter character separates each piece of data. Each line must be terminated with a carriage return/line feed sequence.

Element No.	Meaning	Requirements & Conditions
1	Product Item Code	This must be a valid product code, alternate product code or bar code recognised by CAPITAL.
2	Purchase Order No.	The purchase order must exist in the CAPITAL system and still be on order or at least partially delivered. Closed (delivered), cancelled or suspended purchase orders will be rejected.
3	Quantity	The quantity to receive. This cannot be a negative number and it cannot be greater than the quantity left to deliver.
4	Unit Cost	If supplied, this cost is used in place of the existing purchase order unit cost. If this is left set to zero, the existing purchase order unit cost is used.

A typical file might look like the following:

ABC3913,13311,5,0

ZYA-MARKII,13311,2,0

J3713131-RN55,13312,100,12.50

Hints & Tips

You may import the same costing file multiple times or load several files at once. CAPITAL will give you the option to clear any previous selections before importing the new file.
ASCII files of fixed rows sizes are also acceptable, however the delimiter character must still be included within each row.
CAPITAL will attempt to partial match the item code if an exact match does not exist, and also cross-reference the code against bar codes and other fields such as the Alternate if applicable. See Extended Transaction Searches for more information on this subject.

____________________________