I am trying to use DTW to import my item prices. I was able to upload items and warehouses fine, and although the item price import runs without error I am not getting any prices to show for my items. My items are all set with the price list of "Price List 01" simply because its the default price list. Select statements on the ITM1 table confirm this as all records have no price or currency for pricelist 1. Below are examples of the txt files I am using to import pricing.
Items
Record Key = (1,2,3, etc...)
Item Number = (1234, 2345, 3456, etc...)
Item Prices
Record Key = (1,2,3...etc..)
LineNum = 1 for "Price List 01"
Currency = blank
Price = (100, 230, 123, etc...)
I read the forum post below which confirms my item prices file format.
So basically, why does my item price import run without error, but my items don't show any prices in the db or the front end.