Behind the scenes of the great social conf�rence

 A social conf?rence, Laurence Parisot and Benoit Roger-Vasselin, repr?sentant of the M?def, alongside Nadine Prigent and Bernard Thibault of the CGT.
Fran?OIS Holland has donn?, Monday July 9 ? 11 h, the kick-off of the "great social conf?rence". In his speech to launch prononc? to 300 people r?unies at the I?na Palace ? Paris, the head of a insist? on the m?thode State, which contrasts with that of his pr?d?cesseur Nicolas Sarkozy: the consultation before any d?cision and respect for the social partners.
For two days, repr?sentants of salari?s unions, employers and Government Ministers will d?battre and make proposals about seven large th?mes: employment, vocational training, wages, ?galit? men and women, productive recovery, pensioners and the financing of social protection and public service. It is only ? the outcome of these r?unions that Prime Minister Jean-Marc Ayrault d?finira the road map and the timetable for the major social r?formes of the quinquennium.
The pla?t style. Fran?OIS Holland was first re?u ? camera, around 8: 30 this morning, Union leaders. His approach is naturally vant?e by members of the Government. "The pr?sident was immediately cr?? a positive, constructive climate", indicates no surprise Marisol Touraine, Minister of Social Affairs. "Fran?ois Holland made laugh in ?voquant his pr?d?cesseur", says Michel Sapin, the Minister of labour and social Dialogue. But, the social partners did ?histent nor ? is in f?liciter... for the moment. "He knows how to combine s?rieux and d?contraction," affirms Nadine Prigent, num?ro 2 of the CGT.
The m?thode also made the unanimit?. "It broke with the Government pr?c?dent m?thodes that d?cidait everything before m?me we convene, rel?ve Agn?s the Bot, n?gociatrice CFDT for employment." "We are here in a ?tat of constructive spirit." ""This is a good point of d?part", the CGT leader Bernard Thibault magnanimous conc?de.""We are here in a constructive and positive approach," said Jean - Fran?ois Pilliard, repr?sentant of the Medef.
No taboo, but a priori insurmountable divisions Derri?re this harmony of fa?ade ?mergent however many quack Pack d?j?. Because on the merits, and each of the other positions diverge. Management of emergency r?clame an all?gement of the co?t of the work, in compensation for the repeal of social VAT, and a greater flexibilit? of the march? work and redundancies. The TCG is fast d?cisions on wages, a questioning of the all?gements of employer costs and the prohibition of dismissal ?conomique. The CFDT called ? d a massive plan for employment and the formation of the ch?meurs.
In the view of all participants, the atmosphere in the round tables quiet ?tait, s?rieuse. Each could express themselves. "We had the opportunity to get our message on the co?t of the work too ?lev? for businesses and the n?cessit? to the march? of more flexible labour", is r?jouit Patrick Bernasconi, n?gociateur of the Medef ? round table on employment. "I have constat? a pleasure ? r?el dialogue", to r?jouit Michel FIR. We have parl? everything, no subject was taboo ?t?, rench?rit the Minister of work and social Dialogue. "But the divide between the employers and the unions remain the m?mes", r?sume the leader of FO, Jean-Claude Mailly.
Social dialogue version Holland was when m?me its limits. The social partners are well aware: they call the ? Government decide. "Not everything can ?tre d?l?gu? to social dialogue, said Bernard Thibault" "We must concr?tes measures quickly." "Simply ?tablir a social agenda is not enough, rench?rit Agn?s Bot (CFDT)." "It is urgent measures for r?pondre to the expectations of the salari?s and the ch?meurs". For the moment, the Government boot key. "Tomorrow, the Prime Minister announced the mati?re, the proc?dure and the calendar of the major social n?gociations", said Michel Sapin.Passer coordination ? action, it is the true d?fi that will need to raise the Government.
The 18 hours Receive the bulk of the actualit?:

R?Agir

Winter''s end may offer great skiing conditions

AppId is over the quota
AppId is over the quota

The end of the winter season may provide skiers with the best slope conditions, according to MSNBC. 

Between weather conditions, skiing prices and snow quality, late March and early April have a lot to offer those interested in taking a ski trip. According to the news source, lodging and ski lifts cost less during those times and the effects of low attendance stretch beyond short lines at the slopes, also affecting things like local restaurant and hotel reservations.

Weather is also at its prime during the final weeks of the ski season, MSNBC says. The skies tend to be clear and sunny and the snow is powdery and deep - the best type for a high-quality skiing experience. High elevations may experience snow at night, but warm up in the daytime, providing both fresh snow and comfortable skiing conditions, according to the news source.

Perhaps instead of spending a lot of money on plane tickets to far away sunny destinations, students can take a road trip to the nearest ski slopes to take advantage of the prime time for skiing.  

View the original article here

Summer Approaches: Great Deals for Dads & Grads, Vacation Travel

AppId is over the quota
AppId is over the quota
REDMOND, Wash. — May 22, 2012 — It's not your imagination; the light at the end of the tunnel is approaching fast. Whether you're a student nearing the end of a marathon of schooling, a worker bee long overdue for vacation, or a dad about to get his day in the sun, your wait is about to end. And it's high time to treat yourself.

Below you'll find a collection of great tech products and offers for yourself or loved ones on your gift list. Looking for a powerful yet light laptop, a phone that puts the focus on you, or other devices and apps? You'll find plenty to choose from.

Shop Now for Dads, Grads, Summer PC and Xbox 360 Offer for StudentsMicrosoft’s buy a PC, get an Xbox student offer is back. Students who purchase a thin, powerful Dell XPS 13, a beautifully designed HP ENVY 15 with thumping Beats Audio, or the ultra-sleek Samsung Series 5 PC will also get an Xbox 360. Together a Windows PC and Xbox 360 provide students the functionality they need for school and fun social connections they want online.The Acer Timeline X 5830T combines 9 hours of battery life with a slim and lightweight profile to deliver fantastic portability in a 15.6-inch notebook. Powered by the second-generation Intel Core i5 processor, the Timeline helps complete daily tasks faster, and its dual-tone aluminum design in cobalt blue makes it a stylish companion wherever it goes. Price: Starting at US$699.The ASUS ZENBOOK UX21E uses a precision-crafted design measuring only 3mm at the front and 9mm at the rear. The form features razor-thin edges and a curved center section, which is both practical and attractive – while accommodating the powerful computing components within. The one-of-a-kind design embodies beauty and strength in complete balance and harmony. Price: Starting at US$899.The Lenovo IdeaPad U300s series is available in Clementine Orange and Graphite Gray, complete with a long battery life and powerful capabilities in an ultraportable package. This Windows PC offers immaculate design, high-quality construction and breathtaking speed. Price: Starting at US$1199.The Windows Sony VAIO S features a hard disk drive and a state-of-the-art processor. This customizable laptop perfectly combines mobility and performance — all wrapped up in a slim, go-anywhere form factor. Price: Starting at US$799.Prepare to bring your entertainment to a whole new dimension with the Toshiba Qosmio X770. Great for games, movies and anything else you can throw at it. Available in array of colors, the one-piece magnesium-aluminum cover is both strong and beautiful. The smooth glass touch pad and textured palm rests give it a sophisticated feel, making it perfect for the tech savvy and style conscious alike. Price: Starting at US$1149.99.Windows ultralight new Toshiba Portégé Z835 Ultrabook is clad in brushed magnesium-alloy and weighs less than 2.5 pounds. It features long battery life of up to eight hours, a spill-resistant LED backlit keyboard and Toshiba Hi-Speed Start Technology, which saves time by offering a quick boot-up in a slim 0.63-inch form factor that will appeal to fashionable business professionals and consumers alike. Price: Starting at US$899.With instant mobility, ultra-responsiveness and super-slim design, the Windows Acer Aspire S3 is Acer's most mobile and responsive notebook ever. This Ultrabook is not only ultra-aerodynamic, razor thin and feather light, but delivers everything you expect from a standard-size notebook. Perfect for any traveler to enjoy life on the go in style. Price: Starting at US$799.The Windows Samsung Series 7 Slate gives PC power packed into an ultraportable device, taking mobility to a new level with a touch-focused design. This slate weighs just shy of two pounds and is only a half-inch thick, making it perfect for users who need a slim, lightweight computer but don't want to sacrifice true PC functionality. Its 170-degree viewing angle makes it easy to share and view content from anywhere. Price: Starting at US$1,299.The HTC TITAN II has the largest screen of any Windows Phone – perfect for surfing the Web and watching movies. It also comes with a 16MP camera to always get a great shot. Price: US$199.The Nokia Lumia 900 comes in a variety of colors and has a vibrant screen to surf the Web, share favorite photos and watch videos in style. Price: US$99.99.The Nokia Lumia 710 Windows Phone is fast and durable; it's the phone that keeps up with any lifestyle. Price: US$39.99.The Samsung Focus II brings your social circles into clear view. With AT&T's 4G LTE network, you get the best display and picture quality, plus fast Web access and movie, app and game downloading. Price: US$49.99Xbox 360 Special Edition Kinect Family BundleThe Xbox 360 Special Edition Kinect Family bundle features everything a family needs to get started playing together including a special edition white Xbox 360 4GB console, white Kinect sensor, white Xbox 360 wireless controller, Kinect Sports and Kinect Adventures, and a three-month subscription to Xbox LIVE Gold. Price: US$299.99.Xbox 360 Limited Edition 'Kinect Star Wars' BundleThe Xbox 360 Limited Edition "Kinect Star Wars" bundle features a custom Star Wars design, modeled after R2-D2 and C3PO, including an R2-D2 blue-and-white themed console and white Kinect sensor, a custom Xbox 360 wireless controller inspired by C3PO, unique sounds from the Star Wars universe and an Xbox 360 wired headset. The bundle also includes copies of Kinect Adventures and Kinect Star Wars, the only Star Wars game that puts you directly in the game, no controller required. Price: US$399.'Kinect Rush: A Disney•Pixar Adventure'"Kinect Rush: A Disney•Pixar Adventure" places anyone in the worlds of five beloved Disney•Pixar films from the comfort of the living room. Team up with Pixar characters to overcome puzzling obstacles and find hidden secrets. Price: US$49.99.Xbox LIVE Gold Membership gives real-time updates from ESPN and MLB.TV and unlimited access to premium entertainment from partners like UFC, Hulu Plus, Netflix, Facebook, Twitter, Last.fm and more, plus social features like Avatar Kinect*. With the best multiplayer gaming network, access to the biggest names in sports and entertainment, and all-new ways to watch, listen to and play with friends from around the world, a 12-month Xbox LIVE Gold Membership is the best value in home entertainment. Price US$59.99. (*Other subscriptions and requirements apply for some Xbox LIVE features. Kinect voice, gesture and search controls available with select Xbox LIVE content, and may vary by feature. Features and content vary by region. See xbox.com/live. Broadband internet, games and media content sold separately.)Microsoft Office 2010 and Microsoft Office for Mac 2011Microsoft Office 2010 and Microsoft Office for Mac 2011 offer the essential tools to do great work in the classroom and at home. Access, edit and share Office documents from virtually anywhere with free Office Web Apps. Price: US$119.99.The customizable OneNote travel notebook has everything you need to plan your getaway. It’s available on your PC or phone and useful for the research and planning that happens before the trip, and is absolutely invaluable once you've left home. With OneNote, you can recall any particular detail at any given moment.Want to head out of town? Get the best travel deals with Bing Travel Price Predictor. When searching for a flight, a simple green arrow tells users to "Buy Now," a red arrow means "Wait." It includes a confidence level and expected price increase or decrease over the next seven days.The Sony Bloggie Live HD Camera makes it easier than ever to stay in touch and share memories of your summer travels. This pocket HD camcorder is WiFi enabled and comes with Qik™ Video from Skype to seamlessly create, share and store videos and memories with family and friends online through blogs, Facebook and Twitter. Price: US$249.Stay connected while you’re traveling with Skype. Use Skype to make free video and voice calls to other Skype users, as well as make low-cost calls to landlines and mobiles. You can also pay for WiFi by the minute with Skype credit. Skype WiFi is available on PC, Mac and iPhone.Surprise Dad this year with the Arc Touch Mouse — the first mouse designed to flatten for portability and pop up for comfort. Its durable frame won't get worn out by repeated use, and he can toss it in his briefcase or stick it in his pocket when he's on the move. Price: US$59.95.Explorer Touch Mouse Limited EditionThe sleek and chic Explorer Touch Mouse Limited Edition is the perfect gift for your multitasking grad. It's wireless, so he or she has room to move without worrying about tangled wires, and speeds up everyday tasks with a Touch Strip optimized for quick vertical and horizontal scrolling all with the flick of a finger. Price: US$49.95.Wireless Mobile Mouse 3500 Limited Edition Artist SeriesHelp the new grad show off his or her personal style this year. The Wireless Mobile Mouse 3500 Limited Edition Artist Series combines precision, portability and style with four new and original designs by this season's hottest artists. With so many designs to choose from, treat grads to a different mouse for every day of the week — and with up to eight months of battery life, users will never have to worry about powering up their favorite accessory. Price: US$29.99.Skype Certified LifeCam StudioAway from home this summer? Plug in your Skype Certified LifeCam Studio and connect with your loved ones back home. The LifeCam Studio sets a new standard in the LifeCam family featuring all the latest and greatest features to give you the best interactive experience. When you can’t be there to share your adventures in person, LifeCam studio delivers the next best thing. Price: US$99.95

View the original article here

Economix: Great Gatsby curve for the State

12: 46 p.m. | Updated to correct the description of the Great Gatsby curve.

Earlier this year, Alan Krueger, President of President Obama's Council of economic advisors and a former Economix assistants, presented what he called the Great Gatsby curve: that is, a chart showing the negative link between generations mobility and income inequality in rich countries. It is assumed that the greater concentration of wealth may hinder the people at the bottom to move up the ladder of income.

Dollars to doughnuts.

Since then, economic mobility project of the pastor has launched the American mobility State-level data. I thought it may be interesting to look at whether the States in which wealth is evenly also seem to provide more opportunities for upward mobility poor inhabitants.

It is extremely difficult question to answer (and the pastor report does not seek to do so), especially given the limited data available. But here is a rude, backing envelope first go.

Economic mobility project, the center of the pastor of the State; Count BureauRelative up mobility data are by Pastor economic mobility project. Researchers tracked a group of nationally representative Americans, who have been at the age of 35 and 39 at any point from 1978 to 1997 They examined how each individual incomes have changed just one decade after the number of the original revenue is collected. This measure, shown on the vertical axis here refers to the proportion of those who are in the bottom half of the distribution, which moved at least 10 percentiles.

The chart above shows the injustice of the horizontal axis, and the corresponding revenues on the vertical axis. Here you can find exact measures I used:

Pastor produced several different measures for economic mobility (none of which is directly comparable to that used in the original Gatsby curve chart, unfortunately). I focus on its metric for relative upward mobility.

This is calculated as the focus on Americans, which when checked in sometime between 1978 and 1997, were in the bottom half of the distribution of income — that is, they have less than the median American. The authors of the report consider what some of these people were able to move at least 10 percentiles up the income ladder, when interviewed again exactly a decade later.

Larger number, for each Member State means that a large part of the people at the bottom have managed to pull my own bootstraps. For example, Connecticut, about half of the people who begin at the bottom of the distribution of revenue climbed to at least 10 percentiles.

Then I looked for income distribution, called the Gini index, which runs from zero to one. With lower Gini coefficient of mean income is more evenly, and higher value means revenue is more concentrated among the wealthiest.

Bureau of census offers bit values for the Gini index of State for election years. I took an average of values for 1979 and 1989 (two years falling within the period of the study dealt with pastor) and compare those values, mobility.

Again this is very serious, but it seems that is a weak negative relation in the best. (For the nerds there, R-squared is just a 0.048.)

Also I tried plotting inequalities against absolute income mobility — that is, the average percentage growth of residents income more than a decade. For example, the average New Yorker is 20 per cent increase in income.

Sources: Economic mobility project, the center of the pastor of the State; Count BureauAbsolute up mobility data are by Pastor economic mobility project. Researchers tracked a group of nationally representative Americans, who have been at the age of 35 and 39 at any point from 1978 to 1997 They examined how each individual incomes have changed just one decade after the number of the original revenue is collected. This measure, shown on the vertical axis here refers to how much these income rises.

The link here is slightly stronger, but still rather weak. (R-squared is 0.09 in this case.)

One challenge you might notice these data – except that the years just not covered, among other things, is that there is only that much variation in inequality among States. Gini coefficients range from 0.3795 to 0.471, so that the points are clustered relatively close cooperation.

Do you have any thoughts on other ways to examine how inequality affect mobility in the United States?

This post has been revised to reflect the following correction:

Correction of 18 may 2012.

At one point, an earlier version of this post misstated the relationship shown in the curve of the Great Gatsby intergenerational mobility and income inequality in rich countries. Is negative, not positive; Therefore, as the post correctly indicated greater concentration of wealth may hinder the people at the bottom to move up the ladder of income.

View the original article here

Microsoft Great Plains Dexterity Customizations

Microsoft Business Solutions is on the way to popularize it's ERP systems implementation. Right now such products as Microsoft CRM and Small Business Manager (cheap version of Microsoft Great Plains, based on the same Great Plains Dexterity runtime and DYNAMICS.DIC dictionary) are targeted to self-implementation by in-house IT group. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0. Plus you probably should know about programming language of Microsoft Great Plains - Great Plains Dexterity

If you are developer who is asked: how do we customize Great Plains with its native programming language - Great Plains Dexterity - read this and you will have the clues on where to look further.

The history of the Dexterity. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface.

1. Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases - you use Dexterity ranges and loops to manipulate the records

2. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

3. COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects - you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet.

4. Dexterity Forms - if you like VBA and are comfortable to do all the business logic in VBA - you can use Dexterity as new forms creator/editor. This is OK - but you have to purchase VBA/Modifier and Customization Site Enabler from MBS.

Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary - DYNAMICS.DIC. If you need cross dictionaries customization - consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary..

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Microsoft Great Plains Dexterity Customizations

Microsoft Business Solutions is on the way to popularize it's ERP systems implementation. Right now such products as Microsoft CRM and Small Business Manager (cheap version of Microsoft Great Plains, based on the same Great Plains Dexterity runtime and DYNAMICS.DIC dictionary) are targeted to self-implementation by in-house IT group. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0. Plus you probably should know about programming language of Microsoft Great Plains - Great Plains Dexterity

If you are developer who is asked: how do we customize Great Plains with its native programming language - Great Plains Dexterity - read this and you will have the clues on where to look further.

The history of the Dexterity. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface.

1. Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases - you use Dexterity ranges and loops to manipulate the records

2. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

3. COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects - you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet.

4. Dexterity Forms - if you like VBA and are comfortable to do all the business logic in VBA - you can use Dexterity as new forms creator/editor. This is OK - but you have to purchase VBA/Modifier and Customization Site Enabler from MBS.

Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary - DYNAMICS.DIC. If you need cross dictionaries customization - consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary..

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Microsoft Great Plains Dexterity Customizations

Microsoft Business Solutions is on the way to popularize it's ERP systems implementation. Right now such products as Microsoft CRM and Small Business Manager (cheap version of Microsoft Great Plains, based on the same Great Plains Dexterity runtime and DYNAMICS.DIC dictionary) are targeted to self-implementation by in-house IT group. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0. Plus you probably should know about programming language of Microsoft Great Plains - Great Plains Dexterity

If you are developer who is asked: how do we customize Great Plains with its native programming language - Great Plains Dexterity - read this and you will have the clues on where to look further.

The history of the Dexterity. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface.

1. Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases - you use Dexterity ranges and loops to manipulate the records

2. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

3. COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects - you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet.

4. Dexterity Forms - if you like VBA and are comfortable to do all the business logic in VBA - you can use Dexterity as new forms creator/editor. This is OK - but you have to purchase VBA/Modifier and Customization Site Enabler from MBS.

Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary - DYNAMICS.DIC. If you need cross dictionaries customization - consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary..

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Microsoft Great Plains Dexterity Customizations

Microsoft Business Solutions is on the way to popularize it's ERP systems implementation. Right now such products as Microsoft CRM and Small Business Manager (cheap version of Microsoft Great Plains, based on the same Great Plains Dexterity runtime and DYNAMICS.DIC dictionary) are targeted to self-implementation by in-house IT group. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0. Plus you probably should know about programming language of Microsoft Great Plains - Great Plains Dexterity

If you are developer who is asked: how do we customize Great Plains with its native programming language - Great Plains Dexterity - read this and you will have the clues on where to look further.

The history of the Dexterity. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface.

1. Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases - you use Dexterity ranges and loops to manipulate the records

2. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

3. COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects - you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet.

4. Dexterity Forms - if you like VBA and are comfortable to do all the business logic in VBA - you can use Dexterity as new forms creator/editor. This is OK - but you have to purchase VBA/Modifier and Customization Site Enabler from MBS.

Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary - DYNAMICS.DIC. If you need cross dictionaries customization - consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary..

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Microsoft Great Plains Dexterity Customizations

Microsoft Business Solutions is on the way to popularize it's ERP systems implementation. Right now such products as Microsoft CRM and Small Business Manager (cheap version of Microsoft Great Plains, based on the same Great Plains Dexterity runtime and DYNAMICS.DIC dictionary) are targeted to self-implementation by in-house IT group. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0. Plus you probably should know about programming language of Microsoft Great Plains - Great Plains Dexterity

If you are developer who is asked: how do we customize Great Plains with its native programming language - Great Plains Dexterity - read this and you will have the clues on where to look further.

The history of the Dexterity. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface.

1. Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases - you use Dexterity ranges and loops to manipulate the records

2. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

3. COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects - you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet.

4. Dexterity Forms - if you like VBA and are comfortable to do all the business logic in VBA - you can use Dexterity as new forms creator/editor. This is OK - but you have to purchase VBA/Modifier and Customization Site Enabler from MBS.

Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary - DYNAMICS.DIC. If you need cross dictionaries customization - consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary..

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Microsoft Great Plains Dexterity Customizations

Microsoft Business Solutions is on the way to popularize it's ERP systems implementation. Right now such products as Microsoft CRM and Small Business Manager (cheap version of Microsoft Great Plains, based on the same Great Plains Dexterity runtime and DYNAMICS.DIC dictionary) are targeted to self-implementation by in-house IT group. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0. Plus you probably should know about programming language of Microsoft Great Plains - Great Plains Dexterity

If you are developer who is asked: how do we customize Great Plains with its native programming language - Great Plains Dexterity - read this and you will have the clues on where to look further.

The history of the Dexterity. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface.

1. Native Dexterity Cursors. Dexterity was designed as platform independent programming language and so if you want your code to be operable on all currently supported databases - you use Dexterity ranges and loops to manipulate the records

2. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

3. COM Objects calls. Beginning with version 7.0 Dexterity supports COM objects - you register them as libraries in Dexterity. Refer the manual. This technique allows you to call such nice things as web services across the internet.

4. Dexterity Forms - if you like VBA and are comfortable to do all the business logic in VBA - you can use Dexterity as new forms creator/editor. This is OK - but you have to purchase VBA/Modifier and Customization Site Enabler from MBS.

Some restrictions. Great Plains is actually integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can deal with one dictionary - DYNAMICS.DIC. If you need cross dictionaries customization - consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary..

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

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. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields.

We would like to give you - programmer, software developer, database administrator the primary clues on producing EDI formatted text from Microsoft Great Plains database. Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems: Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products. In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on Pervasive SQL - IDE interface will involve ADO/ODBC or Microsoft Access programming.

1. Sample Query - The query below uses CAST construction to make the result fixed length and meet the positioning. Plus the unionizing allows to produce Header and Detail in one select statement. Here we are dealing with work Sales Documents

select

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CAST('Header' as char(10))

else CAST('Detail' as char(10))

end

as FIELD0,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then cast(a.CUSTNAME as char(65))

else cast(cast(b.QTYDMGED as decimal(19,5)) as char(65))

end

as FIELD01,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CONVERT(char(51), a.DOCDATE, 101)

else cast(b.ITEMDESC as char(51))

end

as FIELD03

--Additional fields go here

from SOP10100 a join SOP10200 b on a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join

RM00101 d on a.CUSTNMBR=d.CUSTNMBR

join

(select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE,

LNITMSEQ

as LNITMSEQ,

CMPNTSEQ

as CMPNTSEQ from SOP10200

union

select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200

group by SOPTYPE, SOPNUMBE

) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE

and ((b.LNITMSEQ=c.LNITMSEQ and b.CMPNTSEQ=c.CMPNTSEQ) or (b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1))

left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE

where a.ADDRESS3'Exported' and

a.SOPTYPE=3 and upper(d.USERDEF2)='YES'

order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc

2. Mark processed documents - for this reason we use SOP10100.ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6.0:

update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3

3. Communication with UNIX EDI Client or Server - each case requires individual approach. You may have to assign the file directory, exposed to the UNIX system or use old DOS command to move the file, or you can have automatic email. Good idea is to write communication application in your favorite programming language

4. Scheduled DTS Package - you should probably create DTS package to do all the steps: call SQL Query and save it as a file, then call DOS command or simple EXE application - which does communicate with UNIX

Happy programming! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

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. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields.

We would like to give you - programmer, software developer, database administrator the primary clues on producing EDI formatted text from Microsoft Great Plains database. Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems: Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products. In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on Pervasive SQL - IDE interface will involve ADO/ODBC or Microsoft Access programming.

1. Sample Query - The query below uses CAST construction to make the result fixed length and meet the positioning. Plus the unionizing allows to produce Header and Detail in one select statement. Here we are dealing with work Sales Documents

select

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CAST('Header' as char(10))

else CAST('Detail' as char(10))

end

as FIELD0,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then cast(a.CUSTNAME as char(65))

else cast(cast(b.QTYDMGED as decimal(19,5)) as char(65))

end

as FIELD01,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CONVERT(char(51), a.DOCDATE, 101)

else cast(b.ITEMDESC as char(51))

end

as FIELD03

--Additional fields go here

from SOP10100 a join SOP10200 b on a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join

RM00101 d on a.CUSTNMBR=d.CUSTNMBR

join

(select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE,

LNITMSEQ

as LNITMSEQ,

CMPNTSEQ

as CMPNTSEQ from SOP10200

union

select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200

group by SOPTYPE, SOPNUMBE

) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE

and ((b.LNITMSEQ=c.LNITMSEQ and b.CMPNTSEQ=c.CMPNTSEQ) or (b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1))

left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE

where a.ADDRESS3'Exported' and

a.SOPTYPE=3 and upper(d.USERDEF2)='YES'

order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc

2. Mark processed documents - for this reason we use SOP10100.ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6.0:

update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3

3. Communication with UNIX EDI Client or Server - each case requires individual approach. You may have to assign the file directory, exposed to the UNIX system or use old DOS command to move the file, or you can have automatic email. Good idea is to write communication application in your favorite programming language

4. Scheduled DTS Package - you should probably create DTS package to do all the steps: call SQL Query and save it as a file, then call DOS command or simple EXE application - which does communicate with UNIX

Happy programming! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

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. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields.

We would like to give you - programmer, software developer, database administrator the primary clues on producing EDI formatted text from Microsoft Great Plains database. Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems: Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products. In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on Pervasive SQL - IDE interface will involve ADO/ODBC or Microsoft Access programming.

1. Sample Query - The query below uses CAST construction to make the result fixed length and meet the positioning. Plus the unionizing allows to produce Header and Detail in one select statement. Here we are dealing with work Sales Documents

select

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CAST('Header' as char(10))

else CAST('Detail' as char(10))

end

as FIELD0,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then cast(a.CUSTNAME as char(65))

else cast(cast(b.QTYDMGED as decimal(19,5)) as char(65))

end

as FIELD01,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CONVERT(char(51), a.DOCDATE, 101)

else cast(b.ITEMDESC as char(51))

end

as FIELD03

--Additional fields go here

from SOP10100 a join SOP10200 b on a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join

RM00101 d on a.CUSTNMBR=d.CUSTNMBR

join

(select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE,

LNITMSEQ

as LNITMSEQ,

CMPNTSEQ

as CMPNTSEQ from SOP10200

union

select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200

group by SOPTYPE, SOPNUMBE

) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE

and ((b.LNITMSEQ=c.LNITMSEQ and b.CMPNTSEQ=c.CMPNTSEQ) or (b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1))

left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE

where a.ADDRESS3'Exported' and

a.SOPTYPE=3 and upper(d.USERDEF2)='YES'

order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc

2. Mark processed documents - for this reason we use SOP10100.ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6.0:

update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3

3. Communication with UNIX EDI Client or Server - each case requires individual approach. You may have to assign the file directory, exposed to the UNIX system or use old DOS command to move the file, or you can have automatic email. Good idea is to write communication application in your favorite programming language

4. Scheduled DTS Package - you should probably create DTS package to do all the steps: call SQL Query and save it as a file, then call DOS command or simple EXE application - which does communicate with UNIX

Happy programming! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

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. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields.

We would like to give you - programmer, software developer, database administrator the primary clues on producing EDI formatted text from Microsoft Great Plains database. Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems: Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products. In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on Pervasive SQL - IDE interface will involve ADO/ODBC or Microsoft Access programming.

1. Sample Query - The query below uses CAST construction to make the result fixed length and meet the positioning. Plus the unionizing allows to produce Header and Detail in one select statement. Here we are dealing with work Sales Documents

select

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CAST('Header' as char(10))

else CAST('Detail' as char(10))

end

as FIELD0,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then cast(a.CUSTNAME as char(65))

else cast(cast(b.QTYDMGED as decimal(19,5)) as char(65))

end

as FIELD01,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CONVERT(char(51), a.DOCDATE, 101)

else cast(b.ITEMDESC as char(51))

end

as FIELD03

--Additional fields go here

from SOP10100 a join SOP10200 b on a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join

RM00101 d on a.CUSTNMBR=d.CUSTNMBR

join

(select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE,

LNITMSEQ

as LNITMSEQ,

CMPNTSEQ

as CMPNTSEQ from SOP10200

union

select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200

group by SOPTYPE, SOPNUMBE

) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE

and ((b.LNITMSEQ=c.LNITMSEQ and b.CMPNTSEQ=c.CMPNTSEQ) or (b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1))

left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE

where a.ADDRESS3'Exported' and

a.SOPTYPE=3 and upper(d.USERDEF2)='YES'

order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc

2. Mark processed documents - for this reason we use SOP10100.ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6.0:

update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3

3. Communication with UNIX EDI Client or Server - each case requires individual approach. You may have to assign the file directory, exposed to the UNIX system or use old DOS command to move the file, or you can have automatic email. Good idea is to write communication application in your favorite programming language

4. Scheduled DTS Package - you should probably create DTS package to do all the steps: call SQL Query and save it as a file, then call DOS command or simple EXE application - which does communicate with UNIX

Happy programming! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

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. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields.

We would like to give you - programmer, software developer, database administrator the primary clues on producing EDI formatted text from Microsoft Great Plains database. Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems: Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products. In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on Pervasive SQL - IDE interface will involve ADO/ODBC or Microsoft Access programming.

1. Sample Query - The query below uses CAST construction to make the result fixed length and meet the positioning. Plus the unionizing allows to produce Header and Detail in one select statement. Here we are dealing with work Sales Documents

select

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CAST('Header' as char(10))

else CAST('Detail' as char(10))

end

as FIELD0,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then cast(a.CUSTNAME as char(65))

else cast(cast(b.QTYDMGED as decimal(19,5)) as char(65))

end

as FIELD01,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CONVERT(char(51), a.DOCDATE, 101)

else cast(b.ITEMDESC as char(51))

end

as FIELD03

--Additional fields go here

from SOP10100 a join SOP10200 b on a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join

RM00101 d on a.CUSTNMBR=d.CUSTNMBR

join

(select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE,

LNITMSEQ

as LNITMSEQ,

CMPNTSEQ

as CMPNTSEQ from SOP10200

union

select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200

group by SOPTYPE, SOPNUMBE

) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE

and ((b.LNITMSEQ=c.LNITMSEQ and b.CMPNTSEQ=c.CMPNTSEQ) or (b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1))

left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE

where a.ADDRESS3'Exported' and

a.SOPTYPE=3 and upper(d.USERDEF2)='YES'

order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc

2. Mark processed documents - for this reason we use SOP10100.ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6.0:

update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3

3. Communication with UNIX EDI Client or Server - each case requires individual approach. You may have to assign the file directory, exposed to the UNIX system or use old DOS command to move the file, or you can have automatic email. Good idea is to write communication application in your favorite programming language

4. Scheduled DTS Package - you should probably create DTS package to do all the steps: call SQL Query and save it as a file, then call DOS command or simple EXE application - which does communicate with UNIX

Happy programming! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

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. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields.

We would like to give you - programmer, software developer, database administrator the primary clues on producing EDI formatted text from Microsoft Great Plains database. Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems: Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products. In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on Pervasive SQL - IDE interface will involve ADO/ODBC or Microsoft Access programming.

1. Sample Query - The query below uses CAST construction to make the result fixed length and meet the positioning. Plus the unionizing allows to produce Header and Detail in one select statement. Here we are dealing with work Sales Documents

select

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CAST('Header' as char(10))

else CAST('Detail' as char(10))

end

as FIELD0,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then cast(a.CUSTNAME as char(65))

else cast(cast(b.QTYDMGED as decimal(19,5)) as char(65))

end

as FIELD01,

case

when b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CONVERT(char(51), a.DOCDATE, 101)

else cast(b.ITEMDESC as char(51))

end

as FIELD03

--Additional fields go here

from SOP10100 a join SOP10200 b on a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join

RM00101 d on a.CUSTNMBR=d.CUSTNMBR

join

(select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE,

LNITMSEQ

as LNITMSEQ,

CMPNTSEQ

as CMPNTSEQ from SOP10200

union

select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200

group by SOPTYPE, SOPNUMBE

) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE

and ((b.LNITMSEQ=c.LNITMSEQ and b.CMPNTSEQ=c.CMPNTSEQ) or (b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1))

left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE

where a.ADDRESS3'Exported' and

a.SOPTYPE=3 and upper(d.USERDEF2)='YES'

order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc

2. Mark processed documents - for this reason we use SOP10100.ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6.0:

update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3

3. Communication with UNIX EDI Client or Server - each case requires individual approach. You may have to assign the file directory, exposed to the UNIX system or use old DOS command to move the file, or you can have automatic email. Good idea is to write communication application in your favorite programming language

4. Scheduled DTS Package - you should probably create DTS package to do all the steps: call SQL Query and save it as a file, then call DOS command or simple EXE application - which does communicate with UNIX

Happy programming! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Microsoft Great Plains-Payroll and human resources solutions? No longer

Microsoft Great Plains is Microsoft business solutions for the United States market and major accounting packages. Software development company to be purchased by a big player, you probably should expect some problems-in this case, the Great Plains software was purchased by Microsoft (Bill Gates Doug Burgum-owner and leader of Great Plains Software-Great Plains Dynamics/e E n t e r p r i s e friends). We will certainly affect the Microsoft business solutions, but what happened with our decision level-level, and this is a really sad story.

Let's go to the story itself was OK.. Imagine-payroll/humane resource outsourcer, a small company with customers. Old, Great Plains Dynamics Ctree or pervasive Btrieve S Q L/excellent and affordable solutions. Great Plains Software price per year $ 2 the Sun and k k salary/H of R employee's unlimited for around $ 10 at California's South enjoying the subtle to your home computer, all client is installed somewhere, there is a need to

Responsible for the over-all of a sudden a hurricane-Florida-Microsoft-but is it really a clear understanding of what is at stake--this guy inexpensive Great Plains version someone without need to delete. Good-a limit to the number of employees, and then you have the so called Great Plains small business manager MSDE and MS SQL Server 2000 standard can be used in-500 employees, as a result of this decision-in ...-Microsoft Business Solutions business is no longer a hat now will not continue.

We believe that our customers, suppliers and other cheap Accpac, Adapta soft an unlimited number of employees Payroll HR version switched to several examples of Oracle, SAP, and PeopleSoft. we have-to compete with Microsoft's right to respect for sure but what is going on is probably non-plan and the effectiveness of the solution was too fast. Of course, pervasive software and requires the completion of a contract is a good idea-but a small loyal customers have mutilation-we actually doubt this

Implementation of happiness! Give us a call to see if we have done it-!

Microsoft Great Plains-Payroll and human resources solutions? No longer

Microsoft Great Plains is Microsoft business solutions for the United States market and major accounting packages. Software development company to be purchased by a big player, you probably should expect some problems-in this case, the Great Plains software was purchased by Microsoft (Bill Gates Doug Burgum-owner and leader of Great Plains Software-Great Plains Dynamics/e E n t e r p r i s e friends). We will certainly affect the Microsoft business solutions, but what happened with our decision level-level, and this is a really sad story.

Let's go to the story itself was OK.. Imagine-payroll/humane resource outsourcer, a small company with customers. Old, Great Plains Dynamics Ctree or pervasive Btrieve S Q L/excellent and affordable solutions. Great Plains Software price per year $ 2 the Sun and k k salary/H of R employee's unlimited for around $ 10 at California's South enjoying the subtle to your home computer, all client is installed somewhere, there is a need to

Responsible for the over-all of a sudden a hurricane-Florida-Microsoft-but is it really a clear understanding of what is at stake--this guy inexpensive Great Plains version someone without need to delete. Good-a limit to the number of employees, and then you have the so called Great Plains small business manager MSDE and MS SQL Server 2000 standard can be used in-500 employees, as a result of this decision-in ...-Microsoft Business Solutions business is no longer a hat now will not continue.

We believe that our customers, suppliers and other cheap Accpac, Adapta soft an unlimited number of employees Payroll HR version switched to several examples of Oracle, SAP, and PeopleSoft. we have-to compete with Microsoft's right to respect for sure but what is going on is probably non-plan and the effectiveness of the solution was too fast. Of course, pervasive software and requires the completion of a contract is a good idea-but a small loyal customers have mutilation-we actually doubt this

Implementation of happiness! Give us a call to see if we have done it-!

Microsoft Great Plains-Payroll and human resources solutions? No longer

Microsoft Great Plains is Microsoft business solutions for the United States market and major accounting packages. Software development company to be purchased by a big player, you probably should expect some problems-in this case, the Great Plains software was purchased by Microsoft (Bill Gates Doug Burgum-owner and leader of Great Plains Software-Great Plains Dynamics/e E n t e r p r i s e friends). We will certainly affect the Microsoft business solutions, but what happened with our decision level-level, and this is a really sad story.

Let's go to the story itself was OK.. Imagine-payroll/humane resource outsourcer, a small company with customers. Old, Great Plains Dynamics Ctree or pervasive Btrieve S Q L/excellent and affordable solutions. Great Plains Software price per year $ 2 the Sun and k k salary/H of R employee's unlimited for around $ 10 at California's South enjoying the subtle to your home computer, all client is installed somewhere, there is a need to

Responsible for the over-all of a sudden a hurricane-Florida-Microsoft-but is it really a clear understanding of what is at stake--this guy inexpensive Great Plains version someone without need to delete. Good-a limit to the number of employees, and then you have the so called Great Plains small business manager MSDE and MS SQL Server 2000 standard can be used in-500 employees, as a result of this decision-in ...-Microsoft Business Solutions business is no longer a hat now will not continue.

We believe that our customers, suppliers and other cheap Accpac, Adapta soft an unlimited number of employees Payroll HR version switched to several examples of Oracle, SAP, and PeopleSoft. we have-to compete with Microsoft's right to respect for sure but what is going on is probably non-plan and the effectiveness of the solution was too fast. Of course, pervasive software and requires the completion of a contract is a good idea-but a small loyal customers have mutilation-we actually doubt this

Implementation of happiness! Give us a call to see if we have done it-!

Microsoft Great Plains-Payroll and human resources solutions? No longer

Microsoft Great Plains is Microsoft business solutions for the United States market and major accounting packages. Software development company to be purchased by a big player, you probably should expect some problems-in this case, the Great Plains software was purchased by Microsoft (Bill Gates Doug Burgum-owner and leader of Great Plains Software-Great Plains Dynamics/e E n t e r p r i s e friends). We will certainly affect the Microsoft business solutions, but what happened with our decision level-level, and this is a really sad story.

Let's go to the story itself was OK.. Imagine-payroll/humane resource outsourcer, a small company with customers. Old, Great Plains Dynamics Ctree or pervasive Btrieve S Q L/excellent and affordable solutions. Great Plains Software price per year $ 2 the Sun and k k salary/H of R employee's unlimited for around $ 10 at California's South enjoying the subtle to your home computer, all client is installed somewhere, there is a need to

Responsible for the over-all of a sudden a hurricane-Florida-Microsoft-but is it really a clear understanding of what is at stake--this guy inexpensive Great Plains version someone without need to delete. Good-a limit to the number of employees, and then you have the so called Great Plains small business manager MSDE and MS SQL Server 2000 standard can be used in-500 employees, as a result of this decision-in ...-Microsoft Business Solutions business is no longer a hat now will not continue.

We believe that our customers, suppliers and other cheap Accpac, Adapta soft an unlimited number of employees Payroll HR version switched to several examples of Oracle, SAP, and PeopleSoft. we have-to compete with Microsoft's right to respect for sure but what is going on is probably non-plan and the effectiveness of the solution was too fast. Of course, pervasive software and requires the completion of a contract is a good idea-but a small loyal customers have mutilation-we actually doubt this

Implementation of happiness! Give us a call to see if we have done it-!