Import data not updating
I have had a problem with MYOB for a month now.
I export Customer cards no problem, in excell update the 'Item Price Level' for all to 0 to reflect Base Selling Price (some of our customers were 0, some 1, etc.) I then resave as a .txt file, and upload back into myob, replacing existing data. However when I check the customers, it has not changed/updated their Price Levels.
I have been on the phone with MYOB back in November for 6 hours .... no result.
So I thought I would leave it for a couple weeks then try again, which I did this morning. Still exactly the same problem. Then on the phone for total 3 hours, and after being transferred to a specialist in import/export, still no joy. We tried everything, including importing only 50 customer cards, using the web browser, turning off anti-virus etc. etc. but the data would not pull through to the cards. The import log says 'imported without errors' but the data does not update. She could not work out why it's not working either .... so now it's been escalated to the 'Gold team' who will call me to try and sort out. Has anyone got the same problem? I need to export/import lots of data to simplify updating info for bulk cutomers and items, eg. price lists, etc. but this is a nightmare ! It just doesn't work, and I have wasted so much time on this with no resolution ....