
Video and Audio], Broadcasting and podcasting Real Time Media On The Net

[description], Story, any other text you want to use.

Microsoft Great Plains Integrations – Retail Management sample

by: Andrew Karasev

Microsoft Business Solutions is emerging as very attractive vendor for mid-size companies. The strength of its products is in their cross integration potential. This integration strategy will be the software development direction for this Microsoft subdivision. Meanwhile, as of right now – we have to recommend just to stake on it and deal with custom or in-house developed integration.

If you are developer who needs some sample code to start with – we are placing Accounts Receivable level integration code – it pulls info from Microsoft RMS and places it into work tables in Great Plains.

Be aware, that Microsoft Great Plains version 7.5 has out of the box integration with Microsoft RMS 1.2, but it is on GL and POP level only. You can't do check book reconciliation, for example. Currently Microsoft is in decision on who will be coding the integration for Great Plains 8.0 and what the functionality should be. More likely – it will be Nodus Technologies with the integration on SOP and GL level – it will deploy Great Plains Dexterity and MS SQL Server stored procs.

And here is the code, you have to deal with RM10301 and distribution RM, also we recommend insert new customers into RM00101 and RM00102:

	-- Sales Transaction Record
	insert into RM10301
	(
		DOCTYPE,
		RMDTYPAL,
		RMDNUMWK,
		DOCNUMBR,
		DOCDESCR,
		DOCDATE,
		BACHNUMB,
		BCHSOURC,
		CUSTNMBR,
		CUSTNAME,
		ADRSCODE,
		COSTAMNT,
		SLSAMNT,
		MISCAMNT,
		FRTAMNT,
		TAXAMNT,
		DOCAMNT,
		CASHAMNT,
		CBKIDCSH,
		CASHDATE,
		DCNUMCSH,
		CHEKAMNT,
		CBKIDCHK,
		CBKIDCRD,
		CHEKNMBR,
		CHEKDATE,
		DCNUMCHK,
		CRCRDAMT,
		DCNUMCRD,
		CRCRDNAM,
		RCTNCCRD,
		CRCARDDT,
		TRDISAMT,
		ACCTAMNT,
		DISCDATE,
		DUEDATE,
		LSTEDTDT,
		LSTUSRED,
		GLPOSTDT,
		PSTGSTUS,
		CURNCYID,
		TXENGCLD
	)
	select
		DOCTYPE = (case
				when a.Total > 0 then 1
				else 7
			   end),
		RMDTYPAL = (case
				when a.Total > 0 then 1
				else 8
			   end),
		RMDNUMWK = 'SMS' + replicate('0',
			13 - datalength(convert(varchar(13), a.TransactionNumber))) +
			convert(varchar(13), a.TransactionNumber) + convert(varchar(10), a.StoreID),
		DOCNUMBR = 'SMS' + replicate('0',
			13 - datalength(convert(varchar(13), a.TransactionNumber))) +
			convert(varchar(13), a.TransactionNumber) + convert(varchar(10), a.StoreID),
		DOCDESCR = left(a.ReferenceNumber, 29),
		DOCDATE = convert(varchar(10), a.[Time], 101),
		BACHNUMB = 'SMS'
			+ replicate('0',
			2 - datalength(convert(varchar(2), a.StoreID))) +
			convert(varchar(2), a.StoreID)
			+ replicate('0',
			9 - datalength(convert(varchar(11), a.BatchNumber))) +
			convert(varchar(11), a.BatchNumber),
		BCHSOURC = 'RM_Sales',
		CUSTNMBR='CASH',
		CUSTNAME = 'CASH',
		ADRSCODE = 'PRIMARY',
		COSTAMNT = (case
				when isnull((select round(sum(round(Cost * Quantity,2)),2)
				    from LINKEDSERVER.HQ.dbo.TransactionEntry
				    where TransactionNumber = a.TransactionNumber and
					  StoreID = a.StoreID),0) > 0 and a.Total > 0 then
				abs(isnull((select round(sum(round(Cost * Quantity,2)),2)
				    from LINKEDSERVER.HQ.dbo.TransactionEntry
				    where TransactionNumber = a.TransactionNumber and
					  StoreID = a.StoreID),0))
				when isnull((select round(sum(round(Cost * Quantity,2)),2)
				    from LINKEDSERVER.HQ.dbo.TransactionEntry
				    where TransactionNumber = a.TransactionNumber and
					  StoreID = a.StoreID),0)  0 and
		a.StoreID = '1' and
		not exists (select 1 from RM10301 c
			    where c.RMDNUMWK = 'SMS' + replicate('0',
					13 - datalength(convert(varchar(13), a.TransactionNumber))) +
					convert(varchar(13), a.TransactionNumber) + convert(varchar(10), a.StoreID) and
				  c.RMDTYPAL = (case
							when a.Total > 0 then 1
							else 8
						   end)) and
		not exists (select 1 from RM00401 c
			    where c.DOCNUMBR = 'SMS' + replicate('0',
					13 - datalength(convert(varchar(13), a.TransactionNumber))) +
					convert(varchar(13), a.TransactionNumber) + convert(varchar(10), a.StoreID) and
				  c.RMDTYPAL = (case
							when a.Total > 0 then 1
							else 8
						   end))
		and a.[Time] > '01/01/2004'

Happy integrating! if you want us to do the job or use our product - give us a call 1-866-528-0577! help@albaspectrum.com

About The Author

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

akarasev@albaspectrum.com

streaming media

Real Time Media On The Net
This is one of the best resources for information on Real Time Media On The Net you can possibly find. Follow our links to find more information on Real Time Media On The Net. We hope that we have all of the Real Time Media On The Net details that you could need.
Real Time Media On The Net

Important privacy considerations when shopping for streaming media

The Internet is fast becoming the dominant medium for business and communication, but it still resembles something of a frontier, because there is little regulation. If you are looking for streaming media then you are doing so in an unregulated marketplace. Most efforts have relied on the Internet industry to police itself. Although there has been some notable success with self-policing, continued abuses have increased calls for government intervention. That's where our role in pre-checking streaming media sites comes in. Our streaming media provider is solid and reliable.

Some aspects of the Internet could undoubtedly use some regulation, but this task is not as simple as it may seem. The very nature of the Internet makes it difficult, if not impossible to regulate. However in the midst of this many streaming media retailers survive and prosper. At the same time, the absence of regulations means that everyone who uses this essentially public network can be a target for anyone who has the technical know-how and the will to invade their privacy. Privacy was foremost in our minds when sourcing the right streaming media retailer for you. Their link appears below.

While the threat from hackers is low for individuals, a more serious threat to personal privacy comes from unscrupulous streaming media companies that operate websites for quick quids. Many streaming media sites require you to register before you can use its services. Often you must provide personal information, such as your name, street address, and e-mail address. Then as you browse the site, data is collected as to which pages you visited, how long you remained on each page, the links you clicked, what terms you searched, and so on. After a number of visits to the site, a personal profile emerges. The question is, what do streaming media site operators do with this information?

Most claim that they use it to personalize your experience on the site. For instance, if a streaming media site learns that you are interested in streaming media, the next time you visit the site, you might be presented with an article or advertisements for that and related products. But some streaming media websites sell this information to marketers, which means that you may find yourself receiving unwanted catalogs from garden suppliers. Our preferred retailer does not do this.

We feel so confident that your streaming media shopping experience will be a good one that we have built this site so that you can go straight to the prime streaming media retailer without wasting a lot of time checking out vast numbers of very ordinary providers.

Real Time Media On The Net Index

Main Menu
Real Time Media On The Net
Site Map

Affiliate Ads, Links, news, etc.

News for 08-Jan-26

Source: BBC News - Home
Rockettes set for Trump inauguration

Source: BBC News - Home
Syrian girl with severe burns gets life-changing surgery

Source: BBC News - Home
Libya Malta hijack: Hijackers arrested as drama ends peacefully

Source: BBC News - Home
All heart

Source: BBC News - Home
Man 'in love' drives through airport

Source: BBC News - Home
Gorging on love

Source: BBC News - Home
Peter Frankopan: This year in history

Source: BBC News - Home
Libyan hijacker arrested in Malta

Source: BBC News - Home
Crash survivor: 'I put my seatbelt on'

Source: BBC News - Home
Is Nigeria's 'plastic rice' actually real?

Links
Links
Links

Talk On The Net MD News Medical Newscast