Software Information |
Microsoft Great Plains: Interest Calculation Example - Stored Procedure for Crystal Report
This is intermediate level SQL scripting article for DB Administrator, Programmer, IT Specialist Our and Microsoft Business Solutions goal here is to educate database administrator, programmer, software developer to enable them support Microsoft Great Plains for their companies. In our opinion self support is the goal of Microsoft to facilitate implementation of its products: Great Plains, Navision, Solomon, Microsoft CRM. You can do it for your company, appealing to Microsoft Business Solutions Techknowledge database. This will allow you to avoid expensive consultant visits onsite. You only need the help from professional when you plan on complex customization, interface or integration, then you can appeal to somebody who specializes in these tasks and can do inexpensive nation-wide remote support for you. Let's look at interest calculation techniques. Imagine that you are financing institution and have multiple customers in two companies, where you need to predict interest. The following procedure will do the job: CREATE PROCEDURE AST_Interest_Calculation @Company1 varchar(10), --Great Plains SQL database ID @Company2 varchar(10), @Accountfrom varchar(60), @Accountto varchar(60), @Datefrom datetime, @Dateto datetime--, as declare @char39 char --for single quote mark declare @SDatefrom as varchar(50) declare @SDateto as varchar(50) select @SDatefrom = cast(@Datefrom as varchar(50)) select @SDateto = cast(@Dateto as varchar(50)) select @char39=char(39) if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AST_INTEREST_TABLE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) CREATE TABLE [dbo].[AST_INTEREST_TABLE] ( [YEAR] [int] NULL , [MONTH] [int] NULL , [COMPANYID] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ACTNUMST] [char] (129) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [BEGINDATE] [varchar] (19) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ENDDATE] [varchar] (19) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [YEARDEGBALANCE] [numeric](19, 5) NULL , [BEGBALANCE] [numeric](38, 5) NULL , [ENDBALANCE] [numeric](38, 5) NULL , [INTERESTONBALANCE] [numeric](38, 6) NULL , [INTERESONTRANSACTIONS] [numeric](38, 8) NULL , [INTEREST] [numeric](38, 6) NULL ) ON [PRIMARY] exec(" delete AST_INTEREST_TABLE where [YEAR] = year("+ @char39 + @Datefrom + @char39 +") and [MONTH]=month("+ @char39 + @Datefrom + @char39 +") insert into AST_INTEREST_TABLE select year(X.BEGINDATE) as [YEAR], month(X.BEGINDATE) as [MONTH], X.COMPANYID, X.ACTNUMST, X.BEGINDATE as BEGINDATE, X.ENDDATE as ENDDATE, X.YEARBEGBALANCE as YEARDEGBALANCE, X.YEARBEGBALANCE+X.BEGBALANCE as BEGBALANCE, X.YEARBEGBALANCE+X.ENDBALANCE as ENDBALANCE, X.INTERESTONBALANCE as INTERESTONBALANCE, X.INTERESTONTRANSACTIONS as INTERESONTRANSACTIONS, X.INTERESTONBALANCE+X.INTERESTONTRANSACTIONS as INTEREST --into AST_INTEREST_TABLE from ( select "+ @char39+ @Company1 + @char39+" as COMPANYID, a.ACTNUMST, "+ @char39 + @Datefrom + @char39 +" as BEGINDATE, "+ @char39 + @Dateto + @char39 +" as ENDDATE, case when b.PERDBLNC is null then 0 else b.PERDBLNC end as YEARBEGBALANCE, sum ( case when (c.DEBITAMT-c.CRDTAMNT is not null and c.TRXDATE ="+ @char39 + @SDatefrom + @char39 +" and c.TRXDATE =year("+ @char39 + @Datefrom + @char39 +") where a.ACTNUMST>="+@char39+@Accountfrom+@char39 +" and a.ACTNUMST="+ @char39 + @SDatefrom + @char39 +" and c.TRXDATE =year("+ @char39 + @Datefrom + @char39 +") where a.ACTNUMST>="+@char39+@Accountfrom+@char39 +" and a.ACTNUMST MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Benefits of Integrating Online Chat Software with CRM Customer Relationship Management (CRM) is a strategy and processes used to learn more about customers' needs and behaviors in order to develop stronger relationships with them. CRM applications are traditionally developed as client-server software. Great Plains Dexterity - Microsoft Great Plains Customization Overview Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise are Dexterity-written applications. Also small business line: Microsoft Small Business Manager or Small Business Financials is written in Dexterity and uses the same code base as Great Plains. Microsoft Great Plains: Dexterity vs. eConnect - FAQ Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise was originally written in IDE and programming language - Great Plains Dexterity. Currently Microsoft is on the way of transforming its ERP applications: Great Plains, Navision, Solomon, Axapta and MS CRM to be better integrated and fit into the future of its . Destination: Desktop for Google First we had the original Google search that evolved into the leader in its class. In fact, it became so popular that the word "google" worked its way into our everyday language as a verb, as in "to google" something. Microsoft Great Plains SOP: Sales Order Processing Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).Great Plains Sales Order Processing (SOP) module forms a third of the core Inventory and Order Processing part of Great Plains. C++ Tutorial 1, Introduction to C++ Introduction to C++Why Learn C++?C++ may at first seem like a boring, confusing programming language that you can only program command prompt applications with. Well, that is what it is like in the [b]begining[/b]. A Simple Computer Software Definition What is Software?Software is a set of instruction written to interface between man and machine.Who writes this instructions?Programmers writes this instructions. When is a Software Engineer Not a Software Engineer? The title of "software engineer" has got to be among the most highly abused in the corporate high-tech world. It's also one of the most popular. EDI: Electronic Document Interchange for Microsoft Great Plains - Overview for Software Developer/Pr Microsoft Great Plains - Microsoft Business Solutions accounting and ERP system, originally targeted to mid-size - now, with advancements and increasing reliability of its database - Microsoft SQL Server, Great Plains is attractive solution for large corporation. Big companies usually have purchasing and order processing automation via so-called Electronic Document Interchange or EDI. Microsoft Great Plains: Large Scale Implementation Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM are coming up to satisfy ERP needs for large corporation, including multinationals. In this article we will be describing Microsoft Great Plains as the MRP platform, fitting to multiple industries and business niches: aerospace, defense, textile, pharmaceutical, healthcare, constructions, mining, services, distributions & logistics, wholesale & retail, public sector, chemicals, oil & gas, finance, brokerage, etc. Microsoft Great Plains on Ctree or Pervasive SQL - What to Do - Tips for IT Manager As you probably know, when Microsoft purchased Great Plains Software - the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence - via it's C-written engine Dexterity, based on the believe that C programming language is platform independent. Software Development in 2005 - Back to the Future 2005 - Back to the Future.What does the future hold? A big question and initially the answer is anything and everything. My Experience - Making a Vision into Reality Disclaimer: All the thoughts expressed are my views only! Your perception might differ.. The Software 2005 Conference - A Review The Software 2005 conference is now a wrap. This conference, presented by M. Groupware as a Document Manager: Collaboration Series #3 This article is the third of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. Inherent Dangers Of File Sharing Via The Internet. Cyberspace has opened up a new frontier with exciting possibilities of "File Sharing." We can explore any interest imaginable and research any topic of choice. Fleet Maintenance Software Reviews Innovative Maintenance Systems (IMS) is one company that offers solutions for companies in need of fleet maintenance software. One of their most popular products is Fleet Maintenance ProŽ. Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist Microsoft Business Solutions Navision serves both European and American megamarkets. It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment). Cisco Certification: Five Things To Do DURING Your CCNA Exam There are plenty of articles out there about how to prepare for the CCNA exam. However, there are also things you can do to increase your chances of success on exam day during the most important part of the entire process -- the time that you're actually taking the test. Microsoft Great Plains implementation: Restaurants Supply Chain Management Example Microsoft Great Plains serves majority of US based horizontal and vertical markets. Being relatively flexible and customizable - it can fit your specific business requirements with light or deep customization. |
home | site map | contact us |