Microsoft Great Plains: Interest Calculation Examp

Microsoft Great Plains: Interest Calculation Example – stored procedure for Crystal Report

by: Andrew Karasev

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 nationwide 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.DEBITAMTc.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

Happy querying and customizing! if you want us to help you give us a call 18665280577! [email protected]

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Arizona, California, Colorado, Texas, New York, Georgia, Florida, Canada, UK, Australia and having locations in multiple states and internationally , he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer

[email protected]

This article was posted on October 03, 2004

by Andrew Karasev

Adobe Photoshop levelsTurn junk into gold by clic

Adobe Photoshop levelsTurn junk into gold by clicking a button

by: Robert Kennedy

There is no doubt in my mind; Adobe Photoshop is the greatest Photo editing program in the world. Whether you are a novice or an expert Photoshop is the program for you. Photoshop is used by my children and by the movie making industry. So what exactly can I do with Photoshop? The better question is what can’t you do with Photoshop?

Today I would like to talk about the simple little function in Photoshop called ‘Levels’, the first step to improving the appearance of a photograph. There are 4 basic steps taken to enhance, brighten or retouch photos are Levels, Brightness, Variations, and Saturation, in that order.

ขThe Levels dialog box lets you correct the tonal range and color balance of an image by adjusting intensity levels of the imageกs shadows, midtones, and highlights. The Levels histogram serves as a visual guide for adjusting the imageกs key tones.ข Adobe’s official description of levels

Screen example here: http://www.weprintcolors.com/screens/screen_ps_levels.htm

Use levels to set to darkest and lightest points or sharpen the picture. From the top menu select Image, then select Adjustments, then select Levels, or if you are a ctrl key fan click ‘ctrl l’. The histogram appears; the sliders at the bottom control brightness and contrast while the sliders above control tonal values. I said we were going to keep it simple so let’s use the sliders at the top. They appear as 3 small triangles. Start to play with them. Move them left to right and right to left while watching the changes you are making to the photograph. When you are satisfied the picture appears optimized click OK. Budda boom, you’re done. How long did that take?

That was really easy and effective. If you feel adventurous repeat the process above. This time when the levels menu appears double click on the eyedropper and target your tonal areas.

Here’s a couple of helpful tips while working with Adobe Photoshop:

Click the ‘tab key’ to clear all tool bars.

To save an image for the web click ‘cntrl, shift, alt, S’

Learn how to use the ‘automate’ feature and save valuable time.

About The Author

Robert is an online leader in graphic design and print. Online since 1999, Robert has spearheaded the success of http://www.weprintcolor.com by providing the finest online graphic design system on the web.

This article was posted on December 13, 2004

by Robert Kennedy

Image Pro 9: Powered Desktop Publishing Program

Image Pro 9: Powered Desktop Publishing Program

by: Grannyกs Mettle

Microsoft provided software carrying two CDs Digital Image Suite 9 and the Digital Image Pro 9. It comes with wizards that walk you through the process, and tutorials that help you get started right away. The software also includes thousands of design templates for creating projects for home, business, and even the kids.

What makes the two applications different is the integration of the Digital Image Library with Digital Image Suite 9. With Digital Image Library, you can quickly import photos and at the same time organize them with captions, keywords, descriptions and ratings. You can sort and search the library to find photos fast, and provide a backup for your photos using the archive wizard. It also has Photo Story Lite that lets Windows XP users turn their photos into videos with background music and narration. This makes sharing your photo slide shows by email or on CDROM and VCD effortless.

On the other hand, Digital Image Pro 9 has new features that work quite well with the improved user interface. Users would definitely find the application friendly and helpful, especially with more of the tools available up front and out of the closet, so to speak.

Digital Image Pro 9 has the following features available:

Smart Erase Removes objects from a photo while filling in the area with the background texture. This works well with fairly consistent background surrounding.

Blending Brush Conceals flaws and blemishes without affecting the texture of the area.

Straighten and Auto Crop Photos can be rotated and automatically cropped when you drag a horizon line. The better to trim the extra canvas.

Gaussian Blur For that smoother blur compared to previous versions of the program.

Unsharp Mask Provides more control over sharpening that allows the users the option to choose from edge width, contrast, and noise reduction.

Multiple Selection Tools Over 60 preset shapes for marquee selection, including freehand, magic wand, and edge finder selection tools. For smoother selections, tools now have antialias and feathering options.

Rule of Thirds Displays a grid when cropping to improve the composition.

Save for Mobile Devices Reduces photos to sizes that fit mobile phones, pocket PCs, and Palm devices. Plus, the tool comes with 50 new effects filters.

Print Multiple Auto Collage Templates Compiles a huge selection of layout templates that is easy to use, with flexible multiple photo layout options.

Larger Work Space.

Compared to other photo editing software, Digital Image Pro 9 stands out with over 3,000 professionally designed layouts for crafts, gifts, cards, stickers, labels, albums, scrapbook pages, among others. The two CDs also has 5,000 images, as well as a whole range of creative text effects. In addition, the program also features standard text formatting options and spell check support.

With an abundance of creative effects and fun designs, Digital Image Pro 9 is definitely a userกs dream when it comes to simplified tools to enhance images, as well as providing a wide range of professional looking designs that can be customized with less hassle.

About The Author

Grannyกs Mettle is a 30something, professional web content writer. She has created various web content on a diverse range of topics, which includes digital printing topics, medical news, as well as legal issues. Her articles are composed of reviews, suggestions, tips and more for the printing and designing industry.

Her thoughts on writing: กWriting gives me pleasure… pleasure and excitement that you have created something to share with others. And with the wide world of the Internet, it gives me great satisfaction that my articles reach more people in the quickest time you could imagine.ก

On her spare time, she loves to stay at home, reading books on just about any topic she fancies, cooking a great meal, and taking care of her husband and kids.

For comments and inquiries about the article visit http://www.ucreative.com

[email protected]

This article was posted on March 03

by Grannyกs Mettle