tnx for the idea but i still prefer using visual foxpro because i can view, sort and filter faster compared to using excel. in excel there's a wizard that you still need to follow step by step unlike in visual foxpro if you're familiar with sql commands you can execute it more faster.

Hi,

I think you should look in the stock.dbf using the dbuwin, Custom Line Information of an Item is the Customtext field.

Hi to all,

Has anyone encounter already a problem in customer list after doing the dedupe and NCOA processing?

We have a lot of duplicate customers with different customer number and what I did was merge the newer one to the older customer number so that the existing order transactions will be automatically transferred to that customer number. After updating the customer list, using the customer look-up we can't find some of our customer (customer has a duplicate customer number before deduping and was merged to another customer number having the same customer information) but when I generate a customer list in the List Management Module it is listed there.

I'm really puzzled with this problem, I can see the customer in LMM but cannot see it in MOM customer look up. Can someone give me a hand?

Thanks in advance.

If you need details of the product what you need to export is the stocks.dbf not the items.dbf.

Currently I use beta version of visual foxpro for viewing, sorting and exporting MOM dbf files. You can download it for free in microsoft website. Try to create a dummy mom folder for testing purposes. You can also update this folder by overwriting it with the live one.

Hope it helps.