{"action":"created","issue":{"url":"https://api.github.com/repos/uzerpllp/uzerp/issues/77","labels_url":"https://api.github.com/repos/uzerpllp/uzerp/issues/77/labels{/name}","comments_url":"https://api.github.com/repos/uzerpllp/uzerp/issues/77/comments","events_url":"https://api.github.com/repos/uzerpllp/uzerp/issues/77/events","html_url":"https://github.com/uzerpllp/uzerp/issues/77","id":119201680,"number":77,"title":"Warehouse locations without GL Accounts should be visible","user":{"login":"steveblamey","id":297376,"avatar_url":"https://avatars.githubusercontent.com/u/297376?v=3","gravatar_id":"","url":"https://api.github.com/users/steveblamey","html_url":"https://github.com/steveblamey","followers_url":"https://api.github.com/users/steveblamey/followers","following_url":"https://api.github.com/users/steveblamey/following{/other_user}","gists_url":"https://api.github.com/users/steveblamey/gists{/gist_id}","starred_url":"https://api.github.com/users/steveblamey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steveblamey/subscriptions","organizations_url":"https://api.github.com/users/steveblamey/orgs","repos_url":"https://api.github.com/users/steveblamey/repos","events_url":"https://api.github.com/users/steveblamey/events{/privacy}","received_events_url":"https://api.github.com/users/steveblamey/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/uzerpllp/uzerp/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/uzerpllp/uzerp/labels/Manufacturing","name":"Manufacturing","color":"ededed"},{"url":"https://api.github.com/repos/uzerpllp/uzerp/labels/minor","name":"minor","color":"ededed"}],"state":"closed","locked":false,"assignee":{"login":"steveblamey","id":297376,"avatar_url":"https://avatars.githubusercontent.com/u/297376?v=3","gravatar_id":"","url":"https://api.github.com/users/steveblamey","html_url":"https://github.com/steveblamey","followers_url":"https://api.github.com/users/steveblamey/followers","following_url":"https://api.github.com/users/steveblamey/following{/other_user}","gists_url":"https://api.github.com/users/steveblamey/gists{/gist_id}","starred_url":"https://api.github.com/users/steveblamey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steveblamey/subscriptions","organizations_url":"https://api.github.com/users/steveblamey/orgs","repos_url":"https://api.github.com/users/steveblamey/repos","events_url":"https://api.github.com/users/steveblamey/events{/privacy}","received_events_url":"https://api.github.com/users/steveblamey/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-11-27T14:08:07Z","updated_at":"2015-11-27T14:34:42Z","closed_at":"2015-11-27T14:17:57Z","body":"Warehouse locations without GL Accounts should be visible when Viewing Manufacturing Warehouse Locations"},"comment":{"url":"https://api.github.com/repos/uzerpllp/uzerp/issues/comments/160151425","html_url":"https://github.com/uzerpllp/uzerp/issues/77#issuecomment-160151425","issue_url":"https://api.github.com/repos/uzerpllp/uzerp/issues/77","id":160151425,"user":{"login":"steveblamey","id":297376,"avatar_url":"https://avatars.githubusercontent.com/u/297376?v=3","gravatar_id":"","url":"https://api.github.com/users/steveblamey","html_url":"https://github.com/steveblamey","followers_url":"https://api.github.com/users/steveblamey/followers","following_url":"https://api.github.com/users/steveblamey/following{/other_user}","gists_url":"https://api.github.com/users/steveblamey/gists{/gist_id}","starred_url":"https://api.github.com/users/steveblamey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steveblamey/subscriptions","organizations_url":"https://api.github.com/users/steveblamey/orgs","repos_url":"https://api.github.com/users/steveblamey/repos","events_url":"https://api.github.com/users/steveblamey/events{/privacy}","received_events_url":"https://api.github.com/users/steveblamey/received_events","type":"User","site_admin":false},"created_at":"2015-11-27T14:34:42Z","updated_at":"2015-11-27T14:34:42Z","body":"Use a left join for gl_accounts and gl_centres in database view wh_locationsoverview to achieve this.\n\n# Dependent views\n* view st_balancesoverview depends on view wh_locationsoverview\n* view st_movementsoverview depends on view wh_locationsoverview\n* view st_transactionsoverview depends on view wh_locationsoverview\n* view wh_transfer_rules_overview depends on view wh_locationsoverview\n* view wh_transfers_overview depends on view wh_locationsoverview\n* view reports.st_balancesoverview_detail depends on view wh_locationsoverview\n* view reports.st_stockreceivedoverview depends on view wh_locationsoverview"}}