{"action":"created","issue":{"url":"https://api.github.com/repos/frappe/erpnext/issues/2412","labels_url":"https://api.github.com/repos/frappe/erpnext/issues/2412/labels{/name}","comments_url":"https://api.github.com/repos/frappe/erpnext/issues/2412/comments","events_url":"https://api.github.com/repos/frappe/erpnext/issues/2412/events","html_url":"https://github.com/frappe/erpnext/issues/2412","id":48775750,"number":2412,"title":"Uniqeness Checking in Supplier Invoice Number","user":{"login":"maheshengg","id":1590079,"avatar_url":"https://avatars.githubusercontent.com/u/1590079?v=3","gravatar_id":"","url":"https://api.github.com/users/maheshengg","html_url":"https://github.com/maheshengg","followers_url":"https://api.github.com/users/maheshengg/followers","following_url":"https://api.github.com/users/maheshengg/following{/other_user}","gists_url":"https://api.github.com/users/maheshengg/gists{/gist_id}","starred_url":"https://api.github.com/users/maheshengg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maheshengg/subscriptions","organizations_url":"https://api.github.com/users/maheshengg/orgs","repos_url":"https://api.github.com/users/maheshengg/repos","events_url":"https://api.github.com/users/maheshengg/events{/privacy}","received_events_url":"https://api.github.com/users/maheshengg/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"neilLasrado","id":8401344,"avatar_url":"https://avatars.githubusercontent.com/u/8401344?v=3","gravatar_id":"","url":"https://api.github.com/users/neilLasrado","html_url":"https://github.com/neilLasrado","followers_url":"https://api.github.com/users/neilLasrado/followers","following_url":"https://api.github.com/users/neilLasrado/following{/other_user}","gists_url":"https://api.github.com/users/neilLasrado/gists{/gist_id}","starred_url":"https://api.github.com/users/neilLasrado/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neilLasrado/subscriptions","organizations_url":"https://api.github.com/users/neilLasrado/orgs","repos_url":"https://api.github.com/users/neilLasrado/repos","events_url":"https://api.github.com/users/neilLasrado/events{/privacy}","received_events_url":"https://api.github.com/users/neilLasrado/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/frappe/erpnext/milestones/21","html_url":"https://github.com/frappe/erpnext/milestones/ERPNext%205.1","labels_url":"https://api.github.com/repos/frappe/erpnext/milestones/21/labels","id":987846,"number":21,"title":"ERPNext 5.1","description":null,"creator":{"login":"rmehta","id":140076,"avatar_url":"https://avatars.githubusercontent.com/u/140076?v=3","gravatar_id":"","url":"https://api.github.com/users/rmehta","html_url":"https://github.com/rmehta","followers_url":"https://api.github.com/users/rmehta/followers","following_url":"https://api.github.com/users/rmehta/following{/other_user}","gists_url":"https://api.github.com/users/rmehta/gists{/gist_id}","starred_url":"https://api.github.com/users/rmehta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmehta/subscriptions","organizations_url":"https://api.github.com/users/rmehta/orgs","repos_url":"https://api.github.com/users/rmehta/repos","events_url":"https://api.github.com/users/rmehta/events{/privacy}","received_events_url":"https://api.github.com/users/rmehta/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":2,"state":"open","created_at":"2015-02-20T05:12:00Z","updated_at":"2015-06-18T09:21:59Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2014-11-14T11:29:37Z","updated_at":"2015-06-18T09:21:59Z","closed_at":"2015-06-18T09:21:59Z","body":"Problem.\r\n\r\nDuring Entry of Purchase Invoice, many a times, due to error or accidently, it so happens that one bills is being tried by our user/s to be fed twice.\r\n\r\nExample, Let us say there is a Invoice no 3411 is already taken up for purchase invoice entry say PUR-ENTRY-1 the same number ( same invoice is also accepted by system ) say PUR-ENTRY-2\r\n\r\nWe feel there should be a check point at GRN Level as well as Purchase Entry level with following logic.\r\n\r\nIf supplier = ABC Limited and If Shipment no. is 3411, then, Only one unique GRN (once made, then \"no\" for same ABC Limited always)\r\n\r\nIf supplier = ACB Limited and If Supplier Invoice no. 3411 then Only once entry should be taken ( i.e checking if user has already entered 3411 for that supplier )\r\n\r\nNeedless to say, the Character Matching manipulation like 003411 or A3411 cannot be helped, we understand that, but exact match should not be allowed\r\n\r\nCurrent Limitation : \r\nRecently, Developers have removed the validation of supplier bill no in purchase invoice. Because, many people do not enter bill no field, in that case they were forced to enter \"NA\". The logic was, system will not validate in case bill no is \"NA\". Now this system don't work in case of multilingual, users enters \"NA\" in their language. And system tries to validate the value and it gived wrong validation. We did not find any easy solution for this, hence decided to drop the feature.\r\n\r\n\"Shipment No\" in Purchase Receipt is a custom field in your account, hence there is no unique validation.\r\n\r\nSOLUTION \r\nTo explore possibilities to cater to those who require this feature (like me)\r\nprobably you can build this around by the following logic.\r\n\r\nAccounts > Set up > Option called as Purchase Invoice Validation Required  YES/NO\r\n\r\nIf YES,\r\n\r\nValidate the Purchase Invoice No. ( for a supplier )\r\n\r\nif NO,\r\n\r\nContinue as per current\r\n\r\nSame: For Custom Fields, ( to configure the field if \"uniques\" is required or not )"},"comment":{"url":"https://api.github.com/repos/frappe/erpnext/issues/comments/113086118","html_url":"https://github.com/frappe/erpnext/issues/2412#issuecomment-113086118","issue_url":"https://api.github.com/repos/frappe/erpnext/issues/2412","id":113086118,"user":{"login":"nabinhait","id":836784,"avatar_url":"https://avatars.githubusercontent.com/u/836784?v=3","gravatar_id":"","url":"https://api.github.com/users/nabinhait","html_url":"https://github.com/nabinhait","followers_url":"https://api.github.com/users/nabinhait/followers","following_url":"https://api.github.com/users/nabinhait/following{/other_user}","gists_url":"https://api.github.com/users/nabinhait/gists{/gist_id}","starred_url":"https://api.github.com/users/nabinhait/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nabinhait/subscriptions","organizations_url":"https://api.github.com/users/nabinhait/orgs","repos_url":"https://api.github.com/users/nabinhait/repos","events_url":"https://api.github.com/users/nabinhait/events{/privacy}","received_events_url":"https://api.github.com/users/nabinhait/received_events","type":"User","site_admin":false},"created_at":"2015-06-18T09:21:59Z","updated_at":"2015-06-18T09:21:59Z","body":"@maheshengg Enable `Check Supplier Invoice Number Uniqueness` in Accounts Settings"}}