{"action":"opened","issue":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/978","repository_url":"https://api.github.com/repos/kbower/tickettest1","labels_url":"https://api.github.com/repos/kbower/tickettest1/issues/978/labels{/name}","comments_url":"https://api.github.com/repos/kbower/tickettest1/issues/978/comments","events_url":"https://api.github.com/repos/kbower/tickettest1/issues/978/events","html_url":"https://github.com/kbower/tickettest1/issues/978","id":196512523,"number":978,"title":"Add configurable column(s?) for orderlines","user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-19T20:26:51Z","updated_at":"2016-12-19T20:26:51Z","closed_at":null,"body":"_Imported from trac ticket 978.\nCreated by **kbower**\nOpened in trac: Jul 20, 2011, 5:27:59 PM\nLast modified in trac: Oct 10, 2013, 5:14:11 PM_\n***\n_by kbower:_\nKanes needs a color column for the expanded order lines.\n----\n[Need] to have the VSN separate and distinct because this is essentially the manufacturer’s sku number and any mistake here when ordering a special order could have the customer receiving a pink sofa when they were expecting a beige.\n\n[Wayne]\n----\nI'm trying to determine whether modifying the sort can work as an alternative to separating the columns.  Currently when you sort the Vendor column, it alphabetizes the Vendor and then by VSN. \n\n(I wasn't asking whether it was a real concern, I was asking what exactly the real concern is: having the VSN in a separate column or being able to sort by VSN? Is this something a rule could warn for instead of someone manually checking visually??  What exactly are they looking for when they sort?)\n\nKent\n----\nKent,\nGood morning, the real concern is when selling a product that comes in several colors that you may not have the sku for because we are missing the color column and the other information indicating the color is in the VSN and usually 10 to 12 characters deep which is not displayed because of the small width of the combined column that the salesperson is likely to make a mistake in selecting the right color of the product. Hence, I think if you do not want to separate the VSN column we can add the color column which is a concatenation of ITM.COVER and ITM.COVER_ID and that would solve the problem we are having.\nThanks,\nWayne Liburd\n----\n\n**_\nAnother ticket #977 for this part:\n_**\n\nIn addition to adding COLOR column, even better: is there a rule we write that would detect the circumstance of special order and check the colors match, giving a warning if they do not?\n----\nKent,\n\nYou can alert the user if there is any group of skus on an order where the minor, vendor and family are the same but the color is different.\n\nThanks,\n\nWayne Liburd\n"}}
{"actor":{"display_login":"kbower"}}