Clean up Item Numbers
Hi Folks
One of you Gurus will know the answer to this simple question - thought I think the answer is NO.
2 Company Files - both with perpetual inventory.
#1 orders from #2 using - Supplier Item Number - however there is a lot of missmatching.
The problem is we are about to go live with a new API app, I have built, which exports PO in company #2 using - supplier item numbers in #1.
However 33% are mismatched and I am cleaning up - and trying to find short cuts.
Company #1 inventory names are the definitive - and #2 are older names.
eg. Order from #1 product 101160SD6500 - supplier item 101160SD650 - and if you go to #2 there is the same inventory number as #1 but missing an end zero - .......
To fix this line I would have to manually update the inventory name in #2 for this item to '101160SD6500 from 101160SD650 and in #1 change the Supplier Item number to '101160SD6500'
As you can imagine - over 2000 items - messy - I wanted to export #2 items and cleanup the item numbers - but you can't because this is the import matching reference to re-import.
However, in #1 I can do a bulk update of Supplier Item Numbers with a batch import.
So the question - anyway of bulk updating #2 Item Numbers (other than an API import - that uses UID numbers).
The Doc
Hi The_Doc
This has always been a limitation of MYOB, using the itemNumber as the only identifying field in an import makes it impossible to update the Item Number in bulk. Try a tool called File Utility MYOX - this is a small 3rd party tool that allows you to renumber items - the file needs to be local, so you'd need to backup restore fix backup restore and there is a fee to use this feature. Or the vendor can do the work for you, just costs more.
Others might be able to suggest alternative methods.
Regards
Gavin