If I find an item which is not in my HQ database but it does exist in my SO database, the sales come through as orphan with no details in HQ. I've tried to create the item in HQ but it tells me that it already exists.....
Help?! :)
It's possible that the item exists in the HQ database but has been made inactive. Additionally, the SO item may not associate with the HQ Item.
Try this: From SO Admin, run this query: SELECT HQID, ID, ItemLookupCode FROM Item WHERE ItemLookupCode = 'X'
From HQ Admin, run this query: SELECT ID, ItemLookupCode FROM Item WHERE ItemLookupCode = 'X' Compare the HQ ID result with the SO HQID result for the item(s) in question. If they are different (or if the SO ILC has no HQID), then you have a problem.
You may be able to use an UPDATE query to set the SO HQID, but I don't think that will help with any existing transactions and may actually cause problems.
There is a procedure for merging items that might be useful. Create a new temporary ILC at HQ. Issue the WS250. Use the Merge Items procedure (you can find it on CustomerSource) to merge the old mis- or un-matched items into the new temporary ILC at HQ and SO. The procedure deletes the old ILC. You can then change the ILC from TEMP to 'real' and issue another WS250.
Good luck, Tom
Thanks very much Tom!
It turns out the item existed as an alias to another item in HQ, which meant it was an alias and an ILC in SO, which i didnt think could happen (at least should'nt have happened!!)
But i got it sorted out, thanks for your step by step SQL -usefull!
"Terrible Tom" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.