Skip to Content
0
Former Member
Mar 26, 2009 at 09:16 PM

Item price import with DTW

502 Views

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.

importing-inventory-pricing

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.