{"id":1402,"date":"2012-01-10T16:37:00","date_gmt":"2012-01-10T13:37:00","guid":{"rendered":"http:\/\/www.MonzerOsama.com\/?p=1402"},"modified":"2013-01-01T16:53:47","modified_gmt":"2013-01-01T13:53:47","slug":"%d8%b1%d8%b3%d8%a7%d8%a6%d9%84-%d8%a7%d9%84%d8%aa%d9%86%d8%a8%d9%8a%d9%87-business-alert-%d9%81%d9%8a-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d8%ac-dynamics-gp-%d9%86%d8%b8%d8%b1%d8%a9-%d9%85%d9%86-%d8%a7","status":"publish","type":"post","link":"https:\/\/www.MonzerOsama.com\/?p=1402","title":{"rendered":"\u0631\u0633\u0627\u0626\u0644 \u0627\u0644\u062a\u0646\u0628\u064a\u0647 Business Alert \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c Dynamics GP– \u0646\u0638\u0631\u0629 \u0645\u0646 \u0627\u0644\u062f\u0627\u062e\u0644"},"content":{"rendered":"


\n\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u0630\u064a \u0633\u0646\u0637\u0631\u062d\u0647 \u0627\u0644\u064a\u0648\u0645 \u0644\u0647 \u0639\u0644\u0627\u0642\u0629 \u0628\u0627\u0644\u0645\u0648\u0636\u0648\u0639 \u0627\u0644\u0630\u064a \u062a\u062d\u062f\u062b \u0639\u0646 ” \u062a\u0646\u0628\u064a\u0647\u0627\u062a \u0627\u0644\u0639\u0645\"Sample\u0644 \u0623\u0648 \u0645\u0627 \u064a\u0633\u0645\u0649 Business Alerts “<\/a> , \u0644\u0643\u0646 \u0645\u0648\u0636\u0648\u0639\u0646\u0627 \u0627\u0644\u064a\u0648\u0645 \u0645\u0633\u062a\u0642\u0644\u0627 \u0639\u0646 \u0633\u0627\u0628\u0642\u0647 \u0643\u0648\u0646\u064a \u0633\u0623\u062a\u0639\u0645\u0642 \u0641\u064a \u0627\u0644\u062c\u0627\u0646\u0628 \u0627\u0644\u062a\u0642\u0646\u064a \u0623\u0643\u062b\u0631 \u0645\u0646 \u0627\u0644\u062c\u0627\u0646\u064a \u0627\u0644\u0648\u0638\u064a\u0641\u064a ….
\n– \u0643\u064a\u0641 \u062a\u0633\u062a\u0641\u064a\u062f Business Alerts \u0645\u0646 \u0645\u064a\u0632\u0627\u062a \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0627\u0644\u0645\u0628\u0646\u064a\u0629 \u0641\u064a SQL Server \u0644\u0645\u0631\u0627\u0642\u0628\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u063a\u064a\u0631\u0627\u062a\u0647\u0627 \u061f
\n– \u0643\u064a\u0641 \u062a\u062d\u062f\u064a\u062f \u0628\u064a\u0626\u0629 \u0627\u0644\u0639\u0645\u0644 \u0636\u0645\u0646 \u0638\u0631\u0648\u0641 \u0648\u0634\u0631\u0648\u0637 \u0645\u0639\u064a\u0646\u0629\u061f
\n– \u0648\u0643\u0630\u0644\u0643 \u0627\u0644\u0627\u0633\u062a\u0641\u0627\u062f\u0629 \u0645\u0646 \u062a\u0642\u0646\u064a\u0627\u062a \u0646\u0638\u0627\u0645 \u0627\u0644\u062a\u0631\u0627\u0633\u0644 \u0627\u0644\u0645\u062a\u0648\u0641\u0631\u0629 \u0641\u064a \u0627\u0644\u0646\u0638\u0627\u0645\u061f
\n\u0633\u0623\u062c\u064a\u0628 \u0639\u0646 \u0647\u0630\u0647 \u0627\u0644\u062a\u0633\u0627\u0624\u0644\u0627\u062a \u0627\u0644\u062a\u064a \u0633\u062a\u0641\u064a\u062f \u0627\u0644\u062a\u0642\u0646\u064a\u0646 \u0648\u062a\u0641\u062a\u062d \u0644\u0647\u0645 \u0622\u0641\u0627\u0642 \u0644\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0645\u0645\u064a\u0632\u0627\u062a \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0648\u0625\u0631\u0633\u0627\u0644 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0627\u0644\u0649 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646…<\/strong><\/p>\n

 <\/p>\n

\u062d\u064a\u0646 \u0627\u0644\u0642\u064a\u0627\u0645 \u0628\u0639\u0645\u0644 Business Alerts \u062c\u062f\u064a\u062f\u0629 \u064a\u062a\u0645 \u062a\u062e\u0632\u064a\u0646 \u0647\u0630\u0647 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u064a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629 Dynamics \u0641\u064a \u062c\u062f\u0648\u0644 \u0627\u0644\u0640 Business Alerts Rules Master \u0648\u0627\u0644\u0630\u064a \u064a\u0645\u0643\u0644\u0643 \u0641\u064a \u0627\u0644\u062f\u0627\u062a\u0627 \u0628\u064a\u0632 \u0627\u0633\u0645 SY40500 , \u064a\u062e\u0632\u0646 \u0627\u0644\u0643\u062b\u064a\u0631 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0628\u064a\u0646\u0647\u0627 \u0627\u0633\u0645 \u0627\u0644\u062f\u0627\u062a\u0627 \u0628\u064a\u0632 \u0627\u0644\u062a\u064a \u0633\u064a\u062a\u0645 \u062a\u062a\u0628\u0639\u0647\u0627 \u0648\u062a\u0627\u0631\u064a\u062e \u0628\u062f\u0623 \u0627\u0644\u062a\u062a\u0628\u0639 \u0648\u062a\u0627\u0631\u064a\u062e \u0627\u0646\u062a\u0647\u0627\u0626\u0647 \u0648\u0627\u0633\u0645 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0630\u064a \u0623\u0646\u0634\u0623 \u0623\u0648 \u063a\u064a\u0631 \u0630\u0644\u0643 \u0627\u0644\u062a\u0646\u0628\u064a\u0647 \u0648\u063a\u064a\u0631 \u0630\u0644\u0643…
\n\u0628\u0639\u062f \u0627\u0644\u0627\u0646\u062a\u0647\u0627\u0621 \u0645\u0646 \u062d\u0641\u0638 \u0627\u0644\u0640 Business Alerts \u064a\u0642\u0648\u0645 \u062c\u0631\u064a\u062a \u0628\u0644\u064a\u0646\u0632 \u0628\u0625\u0646\u0634\u0627\u0621 \u0623\u0648\u0627\u0645\u0631 \u0645\u062e\u0632\u0646\u0629 Stored Procedure \u0641\u064a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0627\u0644\u0634\u0631\u0643\u0629 \u0627\u0644\u062a\u064a \u0633\u064a\u062a\u0645 \u0645\u0631\u0627\u0642\u0628\u0629 \u0628\u064a\u0627\u0646\u0627\u062a\u0647\u0627
\n\u0648\u0628\u0639\u062f \u0630\u0644\u0643 \u0633\u064a\u062a\u0645 \u0625\u0646\u0634\u0627\u0621 \u0645\u0647\u0645\u0629 Job \u0641\u064a \u0627\u0644\u0640SQL Server \u0644\u0643\u064a \u062a\u0642\u0648\u0645 \u0628\u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u0640 Stored Procedure \u0648\u0641\u0642\u0627 \u0644\u0644\u062c\u062f\u0648\u0644\u0629 \u0627\u0644\u062a\u064a \u0642\u0627\u0645 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0628\u0625\u0646\u0634\u0627\u0626\u0647\u0627 (\u0645\u062b\u0644: \u0623\u0646 \u062a\u0639\u0645\u0644 \u0628\u0634\u0643\u0644 \u064a\u0648\u0645\u064a \\ \u0627\u0633\u0628\u0648\u0639\u064a \\ \u062a\u0627\u0631\u064a\u062e \u0627\u0646\u062a\u0647\u0627\u0626\u0647\u0627 … \u0627\u0644\u062e) \u0627\u0646\u0638\u0631 \u0627\u0644\u0635\u0648\u0631\u0629
\n\"
\n\u0644\u0646\u0648\u0636\u062d \u0623\u0643\u062b\u0631 \u0628\u0645\u062b\u0627\u0644:
\n\u0644\u0646\u0641\u0631\u0636 \u0623\u0646\u0646\u0627 \u0642\u0645\u0646\u0627 \u0628\u0639\u0645\u0644 Business Alerts \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0633\u0645\u0647\u0627 HCITY \u0648\u0638\u064a\u0641\u062a\u0647\u0627 \u0647\u064a \u0641\u062d\u0635 \u0627\u0644\u062d\u062f \u0627\u0644\u0625\u0626\u062a\u0645\u0627\u0646\u064a \u0644\u0644\u0639\u0645\u0644\u0627\u0621 \u0641\u0625\u0646\u0647 \u0633\u064a\u0646\u0634\u0626 Stored Procedure \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0642\u0627\u0639\u062f\u0629 \u0648\u064a\u0639\u0637\u064a\u0647\u0627 \u0627\u0633\u0645 \u0645\u062a\u0633\u0644\u0633\u0644 \u064a\u0628\u062f\u0623 \u0628\u0640 sm_Rule<\/p>\n

\"
\n\u0648\u0641\u064a \u0645\u062b\u0627\u0644\u0646\u0627 \u0647\u0630\u0627 \u0643\u0627\u0646 \u0627\u0644\u0627\u0633\u0645 smRuleID27 \u0648\u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u062c\u0645\u0644\u0629 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0627\u0644\u062a\u064a \u062a\u0641\u062d\u0635 \u0627\u0644\u062d\u062f \u0627\u0644\u0627\u0626\u062a\u0645\u0627\u0646\u064a \u0644\u0644\u0639\u0645\u0644\u0627\u0621 Credit Limt \u0648\u0645\u062d\u062a\u0648\u0649 \u0627\u0644\u0645\u0644\u0641 \u0647\u0648 :<\/p>\n

 <\/p>\n

\n


\ncreate procedure smRuleID27 @ruleid int as
\n\/* this procedure is for Business Alert CREDIT LIMIT *\/
\nselect RM00101_T1.CUSTNMBR into ##smRuleID27 from RM00101 RM00101_T1 WITH (NOLOCK) ,
\nRM00103 RM00103_T2 WITH (NOLOCK)
\nWHERE RM00101_T1.CUSTNMBR = RM00103_T2.CUSTNMBR AND RM00101_T1.CRLMTTYP = 2
\nAND (RM00101_T1.CRLMTAMT < RM00103_T2.CUSTBLNC) if @@rowcount > 0
\nexec smRuleCreateTask 27,HCITY
\nGO<\/strong><\/p>\n<\/blockquote>\n

\u0648\u0633\u064a\u0646\u0634\u0626 \u0628\u0639\u062f \u0630\u0644\u0643 Job \u0644\u0643\u064a(\u0627\u0646\u0638\u0631 \u0627\u0644\u0635\u0648\u0631\u0629 \u0627\u0644\u0627\u0648\u0644\u0649) \u064a\u0634\u063a\u0644 \u0647\u0630\u0627 \u0627\u0644\u0633\u062a\u0648\u0631\u062f \u0628\u0631\u0648\u0633\u064a\u062c\u0631 \u0628\u062d\u0633\u0628 \u0627\u0644\u062c\u062f\u0648\u0644\u0629 \u0627\u0644\u062a\u064a \u062d\u062f\u062f\u0646\u0627\u0647\u0627 \u0623\u062b\u0646\u0627\u0621 \u0625\u0646\u0634\u0627\u0621 \u0627\u0644\u0640 Business Alert \u0645\u0646 \u062f\u0627\u062e\u0644 \u062c\u0631\u064a\u062a \u0628\u0644\u064a\u0646\u0632.
\n<\/strong>\u0644\u0644\u0623\u0647\u0645\u064a\u0629:<\/strong><\/span>
\n1- \u0644\u0643\u064a \u062a\u0639\u0645\u0644 \u0627\u0644\u0640 Busniss Alert \u0644\u0627 \u0628\u062f \u0623\u0646 \u064a\u0643\u0648\u0646 \u0627\u0644\u0640 SQL Agent \u064a\u0639\u0645\u0644 \u0628\u0634\u0643\u0644 \u062f\u0627\u0626\u0645 ….
\n2- \u0625\u0646 \u0643\u0646\u062a \u062d\u062f\u062f\u062a \u0623\u0646 \u064a\u062a\u0645 \u0627\u0644\u062a\u0646\u0628\u064a\u0647 \u0639\u0644\u0649 \u0627\u0644\u0628\u0631\u064a\u062f (\u0633\u0648\u0627\u0621 POP \u0623\u0648 Exchange ) \u064a\u062c\u0628 \u0623\u0646 \u062a\u0643\u0648\u0646 \u0627\u0639\u062f\u0627\u062f\u062a \u0627\u0644\u0628\u0631\u064a\u062f \u0645\u062c\u0647\u0632\u0629 \u0645\u0646 \u062e\u0644\u0627\u0644 \u0627\u0644\u0640SQL Server (\u0627\u0636\u063a\u0637 \u0644\u0645\u0639\u0631\u0641\u0629 \u0637\u0631\u064a\u0642\u0629 \u0625\u0639\u062f\u0627\u062f \u0627\u0644\u0628\u0631\u064a\u062f<\/a>)
\n3- \u0623\u0633\u0645\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u062a\u064a \u062a\u062a\u0639\u0627\u0645\u0644 \u0645\u0639\u0647\u0627 \u0627\u0644\u0640 Business Alert \u0645\u0648\u062f\u062c\u0648\u0629 \u0641\u064a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629 DYNAMICS \u0648\u0647\u064a :<\/strong><\/p>\n

SY40500 , SY40506 , SY40504 , SY40505 , SY40501 SY40503 , SY40502, SY40506 <\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u0630\u064a \u0633\u0646\u0637\u0631\u062d\u0647 \u0627\u0644\u064a\u0648\u0645 \u0644\u0647 \u0639\u0644\u0627\u0642\u0629 \u0628\u0627\u0644\u0645\u0648\u0636\u0648\u0639 \u0627\u0644\u0630\u064a \u062a\u062d\u062f\u062b \u0639\u0646 ” \u062a\u0646\u0628\u064a\u0647\u0627\u062a \u0627\u0644\u0639\u0645\u0644 \u0623\u0648 \u0645\u0627 \u064a\u0633\u0645\u0649 Business Alerts “ , \u0644\u0643\u0646 \u0645\u0648\u0636\u0648\u0639\u0646\u0627 \u0627\u0644\u064a\u0648\u0645 \u0645\u0633\u062a\u0642\u0644\u0627 \u0639\u0646 \u0633\u0627\u0628\u0642\u0647 \u0643\u0648\u0646\u064a \u0633\u0623\u062a\u0639\u0645\u0642 \u0641\u064a \u0627\u0644\u062c\u0627\u0646\u0628 \u0627\u0644\u062a\u0642\u0646\u064a \u0623\u0643\u062b\u0631 \u0645\u0646 \u0627\u0644\u062c\u0627\u0646\u064a \u0627\u0644\u0648\u0638\u064a\u0641\u064a …. – \u0643\u064a\u0641 \u062a\u0633\u062a\u0641\u064a\u062f Business Alerts \u0645\u0646 \u0645\u064a\u0632\u0627\u062a \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0627\u0644\u0645\u0628\u0646\u064a\u0629 \u0641\u064a SQL Server \u0644\u0645\u0631\u0627\u0642\u0628\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u063a\u064a\u0631\u0627\u062a\u0647\u0627 \u061f – \u0643\u064a\u0641 \u062a\u062d\u062f\u064a\u062f<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[7],"tags":[20,9],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=\/wp\/v2\/posts\/1402"}],"collection":[{"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1402"}],"version-history":[{"count":2,"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=\/wp\/v2\/posts\/1402\/revisions"}],"predecessor-version":[{"id":1404,"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=\/wp\/v2\/posts\/1402\/revisions\/1404"}],"wp:attachment":[{"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.MonzerOsama.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}