{"id":1386,"date":"2019-02-19T16:07:00","date_gmt":"2019-02-19T09:07:00","guid":{"rendered":"https:\/\/www.support.skybizglobal.com\/?p=1386"},"modified":"2019-02-20T14:15:47","modified_gmt":"2019-02-20T07:15:47","slug":"queries-on-how-to-check-transactions-earlier-than-the-opening-date","status":"publish","type":"post","link":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/queries-on-how-to-check-transactions-earlier-than-the-opening-date\/","title":{"rendered":"Queries on How to Check Transactions Earlier than the Opening Date"},"content":{"rendered":"<p><span style=\"color: #3366ff;\"><strong>Below are the Queries on How to Check Transactions Earlier than the Opening Date on MySQL yog, if Delete Transactions[Posted from Other Modules] is showing Empty<\/strong><\/span><\/p>\n<p><strong>1.)\u00a0SELECT * FROM JOURNAL1 WHERE D_ATE &lt;= &#8216;2016\/12\/31&#8217; AND FINCATCODE NOT IN (&#8216;B55&#8242;,&#8217;B70&#8217;);<\/strong><\/p>\n<p><strong>2.)\u00a0SELECT * FROM journal1 WHERE D_ATE &lt;= &#8216;2016\/12\/31&#8217; AND acountcode = &#8216;xxx&#8217;;\u00a0<\/strong><\/p>\n<p><strong>3.)\u00a0SELECT * FROM journal1 WHERE D_ATE &lt;= &#8216;2016\/12\/31&#8217; AND cuscode = &#8216;xxx&#8217;;<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Below are the Queries on How to Check Transactions Earlier than the Opening Date on MySQL yog, if Delete Transactions[Posted from Other Modules] is showing Empty 1.)\u00a0SELECT * FROM JOURNAL1 WHERE D_ATE &lt;= &#8216;2016\/12\/31&#8217; AND FINCATCODE NOT IN (&#8216;B55&#8242;,&#8217;B70&#8217;); 2.)\u00a0SELECT * FROM journal1 WHERE D_ATE &lt;= &#8216;2016\/12\/31&#8217; AND acountcode = &#8216;xxx&#8217;;\u00a0 3.)\u00a0SELECT * FROM journal1 ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/queries-on-how-to-check-transactions-earlier-than-the-opening-date\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,1],"tags":[],"class_list":["post-1386","post","type-post","status-publish","format-standard","hentry","category-mysql","category-financial"],"_links":{"self":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/comments?post=1386"}],"version-history":[{"count":1,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1386\/revisions"}],"predecessor-version":[{"id":1387,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1386\/revisions\/1387"}],"wp:attachment":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/media?parent=1386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/categories?post=1386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/tags?post=1386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}