{"id":5975,"date":"2017-11-06T14:12:26","date_gmt":"2017-11-06T13:12:26","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=5975&#038;lang=en"},"modified":"2017-11-20T15:53:29","modified_gmt":"2017-11-20T14:53:29","slug":"check-if-general-ledger-account-number-is-unique","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=5975","title":{"rendered":"Check if General Ledger Account Number is unique"},"content":{"rendered":"<p>To proceed with this check execute the following queries according to your database type:<\/p>\n<ul>\n<li>Access database:<br \/>\n<span lang=\"EN-GB\"><code>Select * from <\/code><\/span><span lang=\"EN-GB\"><code>[GLAccount] <\/code><\/span><span lang=\"EN-GB\"><code>where<\/code><\/span><span lang=\"EN-GB\"><code>[Number] in <\/code><br \/>\n<\/span><span lang=\"EN-GB\"><code>(Select <\/code><\/span> <span lang=\"EN-GB\"><code>[Number] <\/code><\/span><span lang=\"EN-GB\"><code>from <\/code><\/span><span lang=\"EN-GB\"><code>[GLAccount] Group <\/code> <\/span><span lang=\"EN-GB\"><code>by <\/code><\/span><span lang=\"EN-GB\"><code>[Number] having count(*) <\/code><\/span><b> <\/b><span lang=\"EN-GB\"><code>&gt;<\/code><\/span><b> <\/b><span lang=\"EN-GB\">&gt;1)<br \/>\n<\/span><span lang=\"EN-GB\"><code>order <\/code><\/span> <span lang=\"EN-GB\"><code>by <\/code><\/span><span lang=\"EN-GB\"><code>[Number], [Id]<br \/>\n<\/code><\/span><em><em><span lang=\"EN-GB\"><br \/>\n<\/span><\/em><\/em><\/li>\n<li>SQL Server database:<br \/>\n<span lang=\"EN-GB\"><code>Select * from<\/code><\/span><span lang=\"EN-GB\"><code> [GLAccount] <\/code><\/span><span lang=\"EN-GB\"><code>where <\/code><\/span><span lang=\"EN-GB\"><code>convert(varchar, [DBId])<\/code><\/span><span lang=\"EN-GB\"><code> + '-' + [Number] in<\/code><br \/>\n<\/span><span lang=\"EN-GB\"><code>(Select <\/code><\/span> <span lang=\"EN-GB\"><code>convert(varchar, [DBId])<\/code><\/span><span lang=\"EN-GB\"><code> + '-' + [Number]<br \/>\nfrom [GLAccount]<br \/>\nGroup by convert(varchar, [DBId]) + '-' + [Number] having count(*)<b> <\/b>&gt;<b> <\/b>1)<br \/>\norder by [DBId], [Number], [Id]<\/code><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To proceed with this check execute the following queries according to your database type: Access database: Select * from [GLAccount] where[Number] in (Select [Number] from [GLAccount] Group by [Number] having count(*) &gt; &gt;1) order by [Number], [Id] SQL Server database: Select * from [GLAccount] where convert(varchar, [DBId]) + &#8216;-&#8216; + [Number] in (Select convert(varchar, [DBId]) [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5975","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5975","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5975"}],"version-history":[{"count":22,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5975\/revisions"}],"predecessor-version":[{"id":6096,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5975\/revisions\/6096"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}