To import vendor item pricing, it seems there are two ways to do so: [LIST=1]
[*]Import on the Item record (via standard Setup > Import/Export menu)
[*]Via the Vendor record (button on items sublist "Import Price List")
[/LIST] Now, I've done many thousands of imports in the past. Something is definitely wrong here. . . I must be missing something.
The first manner has no way to indicate the currency (multiple currencies are enabled for multiple vendors). So, importing in this manner is not an option.
And, the second is simply not working. I don't understand why, though? I import a single line with one item. I'm following the directions exactly, skipping the schedule field, and trying to import, but it simply will not process:
Here's the instructions on the import page:
This file should be in CSV format and contain the following fields in this order with no header row:
[LIST]
[*]Item Name
[*]Vendor Code
[*]Purchase Price
[*]Price Schedule (optional)
[*]Currency
[/LIST] And here's a sample result:
| [h=1]Vendor Price List Import - Result[/h] |
[TABLE="border: 0, cellpadding: 0, cellspacing: 2"] [TR] [TD]THE FOLLOWING LINE(S) CONTAINED PROBLEMS AND COULD NOT BE IMPORTED:
LINE 1: 1007997-002DE23,POUND125,125.45,,British pound, REASON: INVALID ITEM ROW |
[/TD]
[/TR]
[/TABLE]
Does anybody have experience with this type of import? Please help.