:Wise Money Tips

Great Plains Integration Manager scripting and translation - overview for programmer, software developer, database administrator, IT specialist

Microsoft Business Solutions main middle market ERP application - Microsoft Great Plains has multiple integration options: MS SQL Scripting (stored procedures and views), ADO.Net programming, Microsoft SQL Server DTS packages. You certainly can deploy such SDK tools as eConnect. However here we would like to show you how to program the simplest user friendly tool: Microsoft Great Plains Integration Manager.

We assume that you are familiar with Microsoft scripting technologies: Visual Basic for Application (VBA). You should be aware, however, about poor performance of Integration Manager. We recommend it for low volume of complex transactions. It is good tool, if you are importing about 100 transactions per day from text file (when you need to come through empty lines or something not matching the template to filter integration lines). If you have thousand transactions and performance is critical - switch to SQL Stored procs or Dexterity custom process server.

1. VBA Scripting - Launch Great Plains Integration Manager, open your integration, right click->Properties, switch tab to scripts, open Before Document script. Now place this code in it:

If Left(SourceFields(”F4″), 4)=”THRU” Then

SetVariable “DocDate”, Right(SourceFields(”F4″),  

End If

If IsNull(SourceFields(”F1″)) Or IsNull(SourceFields(”F7″)) Then

CancelDocument

End If

It should mean that you can create DocDate variable and assign it the value from your query field.  The second statement cancels document integration if certain condition met (when line is empty or is not actually integration line - something like comment record, etc.)

Now open Before Document Commit script and place this code there:

Dim MyTime, MyHour

MyTime = Now

MyHour = Hour(MyTime)

If Not IsNull(GetVariable(”DocDate”)) then

SetVariable “DocNumber”, GetVariable(”DocNumber”)+1

DestinationFields(”Document Number”)=”THRU”+GetVariable(”DocDate”) &”A” & GetVariable(”DocNumber”)

DestinationFields(”Posting Date”)=GetVariable(”DocDate”)

DestinationFields(”Description”)=”Client Check “+ SourceFields(”F1″)

If Not IsNull(SourceFields(”F8″)) Then

DestinationFields(”Check.Check Number”)=SourceFields(”F8″)

Else

SetVariable “DocNumber”, GetVariable(”DocNumber”)+1

DestinationFields(”Check.Check Number”)=GetVariable(”DocDate”)& MyHour&GetVariable(”DocNumber”)

End If

DestinationFields(”Check.Date”)=GetVariable(”DocDate”)

If Month(DestinationFields(”Check.Date”)+1)= Month(DestinationFields(”Check.Date”)) Then

DestinationFields(”Check.Date”)=DestinationFields(”Check.Date”)+1

End If

End If

Here you do two things.  First you construct check number, using Date and time plus Document number.  And the second is even more interesting - you alter check date.

In After Integration script place this code:

ClearVariables

It is good idea to nullify your variables.

2. Translation. Imagine that your are something like collection agency and you need to translate your vendors (from whom you purchase AR) into real vendors (banks). In AP integration open Destination Mapping, select Vendor ID, in the Rule Properties, click on the button next to Translation field, answer No, click on Translation tab and paste from Excel your translation list, something like this:

JOHNB	BANKOFAMERICA

PETERP	BANKOFAMERICA

MARTHAM	CITIBANK

Now your vendors from integration file will be replaced with real vendors from Great Plains.

Happy integrating! if you want us to do the job - 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 customization company, based in Chicago, California, Colorado, Arizona, New York, Texas, Florida, Georgia, Canada, UK, Australia 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

Comments Off

Buy Levitra from Trusted Offshore Online Pharmacy

If you do not have a normal sex life, it can be very frustrating and make you feel down and less important. Sex is a very integral part of life and is responsible for keeping two sex partners together. If there is any kind of hindrance in sex life it can cause problems for the relationship.

Erectile Dysfunction is one such factor which has caused many strained relationships. So, ED is not just a disease but is a big problem of our life. Before we discuss further, let us understand what this problem is. Erectile dysfunction is described as the inability of a man to achieve or sustain sufficient erection in order to have successful sexual intercourse. It is different from other conditions like lack of sexual desire or problems related to orgasm and ejaculation which also cause hindrance in successful intercourse.

Levitra orange pill is efficient for male with ED problems. Levitra has been recently approved for sale in US by FDA. Levitra works faster in about 16 minutes with fewer side effects as compared to Viagra.

Levitra works faster in about 16 minutes with fewer side effects as compared to Viagra.

The medicine has been approved by regulatory authorities in more than 123 countries around the world and is among the most widely prescribed medications, with more than 130 million prescriptions written for 23 million men worldwide

Comments Off

Working in an office all day, connected to an open network I need to be very protective of my computer. I don’t look at those sites I shouldn’t be looking at, I don’t download music, and I have an adware and virus protection plan I stick to religiously. Each Monday upon startup, while I’m downloading my weekend mail and listening to the weekend dramas of my collegues I update my virus definitions and proceed to scan every inch of my computer for invading viruses.

If I’ve made it through the working week I deserve a treat, so I drag my best friend out of her office and off we go to this quaint sushi bar down the street. Fire, dancing and fantastic sushi made in front of my eyes is just enough to make me forget the work piling up back at the office.

Anyway by the time I pulled myself out of sushi mode, up the stairs, and back to the office my weekly spyware scan was complete, and was congratulating me on having a “spyware and adware free computer.”

Working on the net all day every day, competent adware protection software is important. I’m always skeptical when collegues offer me a new, free adware software. So for the last 2 months I’ve been using not just one adware protection program, but the 2 best anti-adware software packages I could find…….. everything was going great until……….

It was Friday morning, just one more day till the weekend, the boss couldn’t keep quiet about this weekends’ date, blonde, funny, the complete package…………..

Anyway, I was listening with amusement to the excited rantings while my inbox filled with this mornings messages, and suddenly everything went blue……. Not just my screen, but everyone on the network……….. Everything was down, no work today………………

Monday morning came around and the boss wasn’t happy, he missed his date trying to sort out the network, no date and no second chance……..

I was in the bad books, turns out one of the “Adware Protection” software programs I had downloaded had secretly filled mine, and every computer on the network with spyware….. Not Good At All!

A weekend without sales, without a date, and more than enough stress, all because of my one mistake…….. Needless to say I am no longer in charge of spyware and adware protection at the office. The techies who had to spend the weekend fixing my mistake have now installed a new adware program on my computer, one program to take care of the lot, I don’t touch it, I don’t change any settings, and I’m happy with that…..

Finally the boss has calmed down and everything’s under control again, luckily I’ve got a great boss that can see the funny side of things ……. and I still have a job! A lesson learned is the way I’m looking at the whole situation.

My advice to anyone working online is be aware of what you are downloading to your computer, sometimes software that should be protecting is actually infecting!

You can find the Adware Protecter we now use at http://www.realtimesolutions.info

Comments Off

Business communications has always been a challenging arena for management….subject to cost, function, reliability, and other pressures and concerns. The emergence of VoIP technology….and specifically application to PBX systems via IP based protocols….has provided an enormous opportunity for companies to reap many benefits.

Many companies today have multiple office locations around the country or around the world. Currently, each office uses its own PBX system and inter-office phone calls are routed through the PSTN and charged long distance and international rates by carriers. Most companies also employ workers on a part time basis who work from their homes. Those workers get reimbursed for telecommunication expenses they incur while performing their duties. It just makes business sense for companies to explore alternatives to consolidate their telecommunication systems and reduce costs.

The answer…..purchase a Voice-over-IP enabled PBX system and deploy it in a Virtual Office setup.

Voice-over-IP (VoIP) is a fairly new technology for transporting voice calls over the Internet which allows users to realize substantial cost savings on long distance and international calls. Besides cost effectiveness, VoIP enabled PBX systems (or IP PBX) offer easy integration with existing telecommunications systems and are characterized with low operating costs as their upgrade is done through software updates rather than more expensive hardware replacement. Additionally, the technology simplifies the communication infrastructure (no need for separate voice and data cables) while offering high scalability.

Virtual Office models are used by companies that want to consolidate their communications, reduce costs and achieve more cohesive corporate images. To implement the model, a company has to install a single IP PBX system in its headquarters and distribute to employees IP phones or regular phones with VoIP adapters. Employees can make intra-office and inter-office phone calls through dialing PBX extensions. Such calls are routed through the Internet and are practically free. Company customers, on the other side, can dial a single inbound number plus extensions in order to reach the company’s employees. The latter receive the calls on their IP/Regular Phones at any location in the world with Internet connectivity.

So what kind of a VoIP PBX solution does your business need? - a turnkey Virtual Office solution that could be customized to meet your company specific needs.

My recommendation for this solution is the highly acclaimed package from Packet8. Recently 8X8, Inc’s Packet8 Virtual Office Solution for small and medium sized businesses received Network Computing Magazine’s Editor’s Choice award over competitive offerings from Covad Communications and Velocity Networks. That’s some pretty stiff competition….and says a lot about Packet8’s performance. The Packet8 Virtual Office solution received the highest overall rating for its rich feature set, call management tools and low subscription price.

The Packet8 Virtual Office is a cost-effective, easy-to-use alternative to traditional PBX systems that allows users anywhere in the world to be part of a VoIP-hosted virtual phone system that includes auto attendants, conference bridges, extension-to-extension dialing, business class voicemail and ring groups, in addition to a rich variety of other business telephone features normally found on high-end, premise based PBX systems. Their Virtual Office reduces an organization’s telecommunications total cost of ownership (TCO) with a minimal initial investment combined with unlimited local and long distance business calling throughout the United States and Canada and Packet8’s low international rates.

Now…..here’s an overview of what to look for when making the business case for investment in VoIP technology for a VoIP PBX solution:

* Ways to save money for corporations…..

- Eliminate or reduce intra-office toll charges

- Avoiding service and support contracts on existing PBX hardware

- Eliminate the need for on-going Centrex services — and charges

- Reduce expansion costs via lower costs for adds, moves and changes; lower user hardware costs

- Reduce the on-going costs for separate voice messaging systems

- Provide productivity benefits for remote and traveling workers who can be empowered with the same integrated capabilities as office workers

- Reduce user training and learning on phone and messaging systems

- Cost-effectively implement unified messaging

- Improve security

- Reduce systems downtime and improve performance

Additional benefits for call centers…..

- Virtualize call centers, allowing more flexibility in the center’s configuration….either helping consolidation efforts, or providing enterprise capabilities to telecommuting call center workers

- Improve customer support services and reduce abandoned calls and call times

- Improve customer satisfaction and reduce customer turnover via improved call center services

Cost considerations….

- VoIP telecommunication hardware and software

- IP phone sets or soft phones

- Network upgrades for possible quality of service and performance upgrades

- Implementation labor and professional services

- On-going support and administration labor

- Support and maintenance contracts

- Increased support calls and potential user downtime losses on initial deployment

- IT Training

- User Training

- Write-off, write-down and disposal costs for existing telecommunication assets

Potential project risks……

- Quality of service/performance

- User training and adoption

- Administration and support skill levels and resources

- Proprietary vs. open systems interoperability

How Does The Solution Work?

Inter/Intra office calls…….

Caller A, who is located in the corporate headquarters, wants to make a call to Caller B, who is located in the corporate headquarters or in any of the company’s offices worldwide.

Caller A picks up his VoIP device (IP phone, phone with adapter or softphone) and dials Caller B’s extension.

The VoIP PBX server searches its internal database and obtains call routing information about Caller B The VoIP PBX server routes the call to Caller B’s VoIP device.

If the destination number is unreachable, the system forwards the call to Caller B’s voicemail.

As soon as Caller B picks up his VoIP device the conversation starts.

During conversation Caller A’s VoIP device convert voice to digital packets and send them to Caller B’s VoIP device and vice versa.

Both A and B can use traditional PBX functionality, like call on hold, caller ID, call forward, etc. Calls are free

Outbound calls…….

Caller A, who is located in the corporate headquarters, wants to make a call
to Caller B, who is a company customer.

Caller A picks up his VoIP device (IP phone, phone with adapter or softphone) and dials the customer’s number.

The VoIP PBX server searches its internal database and obtains call routing
information about the VoIP carrier, who should terminate calls to Caller B’s area code.

The call is routed to the VoIP carrier.

The VoIP carrier terminates the call to Caller’s B number over the PSTN.

During conversation, Caller A can use traditional PBX functionality, like call on hold, caller ID, call forward, etc.

Calls are charged on time basis at pre-negotiated rates with the VoIP carrier

Inbound calls…..

Caller A, who is a company customer, wants to make a call to Caller B, who is a company employee.

Caller A picks up his phone and dials the company’s central access number.

The VoIP PBX server prompts the caller to enter an extension.

Caller A dials Caller B’s extension.

The VoIP PBX server searches its internal database and obtains call routing information about Caller B.

The VoIP PBX server routes the call to Caller B’s VoIP device.

During conversation, Caller B can use traditional PBX functionality, like call on hold, caller ID, call forward, etc.

Calls are either free if the company uses a local access number or charged on a time basis if the company uses a toll free one.

Voice over IP (VoIP) technologies carry great promise to reduce telecommunication and networking total cost of ownership while empowering businesses with new capabilities and agility. When making your decision on deploying a Virtual Office VoIP PBX solution consider the strategic and tangible benefits as well as the costs and risks outlined above. If it all seems too overwhelming seek out the assistance of an unbiased independent advisor such as Business-VoIP-Solution

Michael is the owner of FreedomFire Communications….including DS3-Bandwidth.com. Michael also authors Broadband Nation where you’re always welcome to drop in and catch up on the latest BroadBand news, tips, insights, and ramblings for the masses.

Comments Off

Like with abounding professions, the sentiment of the business relationship is a factor that the results of the Blue Skies Careers business. When the business was first working there was a view in mind, and that was to improve the normal quality of relationship which candidates and clients receive in recruitment business. The Blue Skies site is a good resource for marketing jobs and is certainly worth a visit.

There is one clear thing that detaches Blue Skies from their competitors, that is that at some point or other every member of their marketing recruitment team has spent time working in an marketing agency or client side. That is positive because it can guarantee BlueSkiesCareers.co.uk possess a vivid perception of what the candidates looking for jobs in marketing, and agencies that have available a job in marketing.

Blue Skies Careers has four locations, in Yorkshire, the Midlands, the North West and London; recruiting candidates seeking for a job with a marketing agency. BlueSkiesCareers.co.uk supply recruiting solutions targeted at both freelance and permanent positions.

The recruitment consultants cover innumerable particular sectors, though the most fashionable are their marketing jobs. The agency can be found highly uncomplicated to communicate with and there can often without doubt be a recruitment consultant in one of their offices who can often help you. Take a ganders at their website first, that will often give one the trust or perhaps the drive to get what the agency are really about for yourself. It’s fun and also really simple to navigate about, there are areas about everything you yourself could possibly want; search for the ideal job, press, events, ratings, clients BlueSkiesCareers.co.uk service for, and even an area where you should discover a little interview points.

Within Blue Skies, BlueSkiesCareers.co.uk possess a targeted section called b.creative. Blue Skies work a lot with the agency side of the industry and also help to exhibit quite a bit of thrilling work. The recruiters converge frequently with talented creative folk, and with folk who have experience in brand to brand marketing. If you are an art worker, copywriter or designer working on or offline, then why not use b.creative to assist you yourself acquire that next special member for your firm’s team.

Comments Off

Following the arrival of VoIP, or Voice Over Internet Protocol, the internet techies have been raving about it, and it is now one of the hottest new technologies around, but what is it and why is it talked about so much?

Well let’s begin with what VoIP is. In short, it allows you to make phone calls over the internet using your broadband connection, but has many benefits:

- You can make phone calls from virtually anywhere in the world to anywhere else using your computer.

- Depending on the speed of your connection, you are able to make several calls at the same time.

- If you move home, you are able to keep your same number, even if you move from one side of the world to the other. As you do not have an actual land line, but a converter that has a number assigned, as long as keep the converter with you, you can plug it into any broadband connection and immediately utilize your usual number for making and receiving calls.

Another benefit of VoIP, which many will find useful, and be an attractive feature for many businesses, is the ability to connect to your office phone, whether it be from a hotel or from home. This will enable company personnel to work out of the office, but still have access to all of the office phone system features.

VoIP can also be very cost effective, especially when making long-distance calls. This factor has meant that telephone service providers have to compete with VoIP, in turn ensuring pricing is much more competitive.

At the beginning, the voice quality for those using VoIP was not as good as with a traditional phone line. However the continual technological advancements have meant that the difference in quality is now not as apparent.

So how does it work?

To begin with your voice is converted into bytes so that it can be compressed, split it into packets, and transmitted over the internet. These packets, which contain a collection of information, including the origin, timestamp, and intended destination of the packet, is then converted at the receivers end so that your voice is recognised.

There are many that are already abandoning existing telephone networks and solely using VoIP. For a wealth of information on VoIP take a look at http://www.voip-serviceproviders.info.

Comments Off

As history has progressed and technology has continued to advance, life has become full of more and more good things. Without a doubt, one of the best things that our society has gained from the advances of technology is communications.

Consider for a few moments all of the amazing forms of communications that have made your life easier and more full. First and foremost in many peoples minds is the telephone. Even if you like to write letters once in a while, can you honestly imagine if letter writing and telegrams were the only way to communicate with people? Think of the countless ways that having phones have improved worldwide communications. My telephone allows me not only to call my next-door neighbor but the communications a telephone allows also enables me to call a friend who has moved to Africa in just a few moments time.

If having the telephone doesn’t impress you enough, think about the way the internet has improved communications and many other aspects of your life. The internet has literally connected people from every corner of the globe by the simple click of a button or two. Our communications with people have become easier, more frequent, and faster. You can send a message to a business parter in Tokyo and receive a reply within mere seconds. Amazing.

The improvements in communications have opened up a world of possibiility to people in the area of travel. Places that were once impossible to reach are now not only possible to reach but also convenient and quick. Each time I sit in an airport I find myself amazing by the incredible communications system that keeps air traffic in control around the world. I can definitely see how an air traffic controller is the most stressful job in the world, but there is no way the job would even be possible without the intricate communications system we have to use.

With a less advanced system of communications, life would be different for individuals around the world, but life would also be different for countries and international relations. Imagine trying to keep the peace with an overseas country by the exchange of letters? Decades would pass before any amount of substantial communication could take place. Chances are high that we would enjoy far fewer privileges to visit or move to other countries without a great communications system like what our world has in place.

Before you pick up the telephone or sit down to check your email, take a moment to be grateful for the afffects of advanced communications in your world and in your life.

Analeese Burnabaker is an author whose words are only seen through many forms of modern communications. She is very grateful. Learn more about communications at www.mycommunications.info

Comments Off

For many people in the martial arts world, it is pretty much common knowledge that, in order to fight multiple attackers, you basically should find something — anything — you can use as a weapon.

Because even something as small and ordinary as a garbage can lid or your belt can actually serve as an “equalizer” in a fight.

But, there are times when multiple attackers will surround a person and there is nothing handy to use as a weapon. No stray sticks, rocks, or even so much as a belt or object of any kind.

In cases like that — where you are being attacked from all sides by two, three, four or more people, with no weapon in site — what do you do?

The answer is simple:

You just “zone around” the nearest guy, and use him as a sort of shield from the others.

Then, while the others can’t really get at you (not while the thug you grabbed is in their way), you take him down, and “zone” around to the next guy — using the same strategy.

And you just keep doing this — one guy at a time — until you’ve finished them off or have made an escape route.

This may sound overly simplistic, but it works.

Because they can’t get at you with one of their own in the way. And you’re simply using the energy of the crowd against them — taking down each person one at a time.

One of the best ways to train this is to get four or five of your friends (the more the better) and have them sort of slowly walk towards you — like zombies from a horror movie — and you practice grabbing onto the first guy and throwing him in the way of the others…and then moving to the next nearest person.

And then just keep doing this over and over again…from one guy to the next…without getting touched by any of the people closing in on you.

The key is movement and being aware of your surroundings.

Trust me, the more you practice this, the easier it’ll be to deal with multiple attackers.

Comments Off

Tech support tells me to type ‘regedt32′ as opposed to ‘regedit’ to access the registry from the command line (Start > Run). I question the use of ‘regedt32,’ but he says to do it anyway. Whenever I use the registry editor, I recall this incident and never look up the tale of the two regs… until now.

Regedt32.exe is an alternative registry editor available with Windows NT/2000 with features of its own. Regedt32.exe does not support importing and exporting registration entries (.reg) files. Regedit has limitations of its own as quoted here:

“You cannot set the security for registry keys. You cannot view, edit, or search the value data types <>REG_EXPAND_SZ and <>REG_MULTI_SZ. If you try to view a <>REG_EXPAND_SZ value, Regedit.exe displays it as a binary data type. If you try to edit either of these data types, Regedit.exe saves it as <>REG_SZ, and the data type no longer performs its intended function. You cannot save or restore keys as hive files.”

Research indicates regedit has:

• a better search tool
• bookmarking of subkeys
• opens to last edited subtree, export and import capabilities
• all keys are visible from a window similar to Windows Explorer

Regedt32 (pre-WinXP) can:

• run in read-only mode
• allows you to edit values longer than 256 characters (who wants to do that???)
• displays subtrees in their own windows
• modify access permissions to subtrees, keys, and subkeys

In WinXP and Server 2003, the two have been replaced by a new version of regedit that has features from both. Try typing ‘regedit’ and ‘regedt32′ to see what happens. They’re the same. To prove it, while in ‘regedit,’ select ‘edit’ and you’ll see ‘permissions.’ This is a feature that was only available in the old ‘regedt32′ and not ‘regedit.’

Technically, regedt32 is a small program that runs regedit. So when typing ‘regedt32,’ it takes you to ‘regedit.’ The destination is the same either way. So type whichever is easier for you to remember. Regedit is easier for me - I had to play with the spelling of the other version until I got it right.

Now I remember that tech support was checking to see if the permissions were properly set and that was why we used ‘regedt32.’ However, someone forgot to update the script or tell him that it didn’t matter anymore when a user had WinXP. Tech support always asks what operating system at the beginning of the call, so he knew.

More registry editor resources: Microsoft has a knowledgebase article on the differences between the two. Windows IT Library has a feature comparison chart dated 2000, so it’s way old, but it will satisfy curiosity. Here’s a list of registry editor alternatives for those who wish to try something different. For tweaks, tricks, and hacks, check out WinGuides’ Registry Guide for Windows.

Meryl K. Evans (www.meryl.net),
Content Maven, is the editor of eNewsletter Journal and Shavlik’s The
Remediator Security Digest. She writes columns for PC Today, InformIT,
and MarketingProfs. Contact her to get content that inspires action or
check out her blog (www.meryl.net/blog/.

Comments Off

Past life regression, aka PLR, will often uncover the reason why we have problems with folk in our current life or why we are apprehensive of certain things. You have people around you in your current lifetime that you have remarkably met before, imagine being able to find out what happened and what your relationship was to them at that past time and remove blocks that plague you in your current time and even find out talents and bring them into your current lifetime. Past life regression, also known as PLR, is excellent. Use Regression Therapy with Anne Jirsch.

When you are having a past life regression, also known as PLR, session you go back to the life you should most need to see about in your present lifetime. This is phenomenal and can often explain a great deal about your present lifetime and help you should to move forward with your life with a greater understanding of yourself, your life and the people around you.

You can also ascertain why you are the person that you are, now that is fabulous. If you like nature maybe you were once a farmer, if you like to travel maybe you were a gypsy. Instead of minimising our strengths we acknowledge them.

Each respective experience is brilliant and unique. Other people have unearthed places they had lived in before and just knew where to go.

Comments Off