The Secret to Free Long Distance Phone Calls
Everyday phone service has just taken a big step into the future thanks to Comcast Cable, the largest cable provider in the country. Comcast?s Digital Voice is a telephone service that is replacing traditional services by using the latest technology. It puts your phone calls through an advanced broadband network instead of traditional telephone lines. No, that doesn?t mean you have to talk into a microphone connected to your computer. Actually, you don?t have to change what you are using now or buy any new equipment at all. Plus, you can end up saving a lot of money by choosing Digital Voice. To save even more, choose the Bundle Package and you can receive Cable TV, High Speed Broadband Internet, and Digital Voice for less than a $100...
Web Design - 7 Key Things to Avoid
A search for "web design" on Google returns more than 325 million results. So how do we start eliminating all these so called designers? Here are a few of the most common shortcomings.
Should You Design Your Own Website?
If you're anything like most small business owners, you probably think that web site design is expensive - possibly too expensive for you to justify the expense. If that's the case, then it can be tempting to just design your small business web site yourself.
Multicultural & Asian Expert Larry Moskowitz Joins Global Advertising Strategies
Multicultural & Asian expert Larry Moskowitz has joined Global Advertising Strategies as the Vice-President of Integration & Business Development.
Affiliate Marketing with Google AdWords
One of the best kept secrets in today's affiliate marketing world is the pay per click advertising version with Google AdWords. Adwords allows advertisers to place small ads on websites or on Google.
Case Watchers Make It Easy To Keep Up With Criminal Trial News
Nothing is more frustrating than trying to search for news about a specific trial, especially when the mainstream media isn't interested. Now, Case Watchers keeps readers apprised in an easy to read format.
Supermarket Selects Safefreight's GPS Fleet Management Solution for Food Logistics
Safefreight's trailer temperature monitoring and GPS fleet management solution helps food retailer and distributor with tracking, logistics, food safety and security transportation in refrigerated transport trailers - also called "reefers."
Advertising Your Business
Marketing your business is one of the most fundamental steps in achieving success. In order to have a successful, established business, its important to be sure youre advertising your business in an effective, value for money way thats likely to generate a return on investment. After all, all advertising was not created equal, and where some advertising campaigns may turn out to be incredibly successful, others will have less of a short term effect.
Affiliate Marketing Success ? 7 Essential Skills
There are some ways to help you to become a successful affiliate marketer even if you are only spending a few hours a week working at it
The most obvious is that you must enjoy the Internet
Responsibility and Choice is the Most Important Concept of Anger Management
One of the most important concepts to understand in anger management is around responsibility and choice. No-one tells you to shout, swear, throw things, scream, push them, hit them or be violent. It is in fact you who chooses to do these things & and they all constitute abuse. If this is so, then there is little justification in saying excuses such as she made me do it or it was his fault. Nobody deserves to be abused by another. This can be turned around to read "I have the right to be safe and not be abused by anyone". This is a basic human right and every person has this right.
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