Importing Sales Prices

Is anyone aware of a way to import Sales Prices from an Excel file onto 
Navision into the correct Item Card?  I have thousands of items and it gets 
to be a large chore manually entering each price for each item.

"Is anyone aware of a way to import Sales Prices from an Excel file"

We use a dataport to load both sales prices and purchase prices from CSV 
files.  Ask your NAV developers about it and specify the fields you need to 
load data to.  Our file layouts are as follows:

Sales Prices Table:
Sales type
Sales code
Item No
Unit of Measure
Minimum quantity
Unit Price
Starting Date
Ending Date
Allow line discount
Allow invoice discount

Purchase Prices Table:
Vendor No
Item No
Unit of Measure
Minimum Quantity
Direct Unit Cost
Starting Date
Ending Date

HTH
-- 
_________________________
ryanb.
NA 4.00 SP1 (4.0 SP3) SQL
Running via Citrix

Yes, we have done something very similar to this, we have a full excel
pricing sheet, and in a background tab it calculates prices from
tonnes to units and places it on a normal *.xls file. With the data
port you can be very specific, even selecting which tabs and so on,