Microsoft Business Solutions essential middle market ERP utility – Microsoft Great Plains has multiple integration alternatives: MS SQL Scripting (stored methods and views), ADO.Net programming, Microsoft SQL Server DTS programs. You actually can installation such SDK tools as eConnect. However right here we would really like to expose you how to application the handiest user pleasant tool: Microsoft Great Plains Integration Manager.
Multiple instances in our consulting exercise we saw the need to integrate General Ledger transactions from one text record and right here we come up with this or even greater complicated case, when credit and debit amounts are present at the identical line with their own account numbers. Let’s count on that we’ve got tab delimited textual content report, GLSOURCE.Txt. Here is how the road seems:
“11242004” (date) “11020016000” (debit account) 212446.Sixty eight (debit quantity) “15260005400” (credit score account) 212446.Sixty eight (credit amount)
Pretty tough, isn’t it?
Let’s begin
First of all and this might be clean – you want ODBC DSN, use Microsoft Text Driver, exchange default listing, pick the report and transfer to tab delimited kind.
Next, open Microsoft Great Plains Integration Manager and create two new queries – one could be for the Header and the second for distribution lines in GL transaction. In each cases use Advanced ODBC sort of textual content queries.
GL Header ought to combination by date, so in its SQL window enter this:
select F1 from GLSOURCE.Txt group by F1
Now the lines – here we need unionizing and checking if quantity is not 0:
pick out F1, F2, F3, 0 from GLSOURCE.Txt
where F3”
union
pick F1 F4, zero,F5 from GLSOURCE.Txt
in which F5”
The one above is the most tough a part of this text. Please recognize it – we’re splitting line into two by union, first we create debit element and then we attach credit part, plus we’re weeding out zero quantities.
Next – we need to link queries – without a doubt link them with the aid of F1 area (date). Do it in question courting. When you’re executed with linking, right click on on the arrow, open houses and in Select Relationship Type window alternate to:
There may be zero or more facts within the child for every report inside the master.
New put up-recession era lenovo ideapad 720s 15 review has new features, which didn’t exist in overdue 1990th in the course of high-tech growth. This might be in our opinion on new instructions for Microsoft Business Solutions products consulting, which includes Microsoft CRM.
New functions:
- Overall fee reduction marketing campaign. We see trendy route, while agencies lease new executives who specializes in value reduction, work force discount, secondary departments capabilities outsourcing, and so forth.
- Computer ERP structures literacy amongst mid-control. If you appearance returned to 1950th whilst control consulting was booming, then for now it’s far included in all of the MBA college applications and bosses themselves recognise the concern. The equal happens with ERP structures – managers have preferred information and might study the brand new gadget, making use of their training, enjoy and intuition
three. Databases Support price reduction – nowadays we’d dare to mention that IT department can without difficulty aid such databases as those, sitting on Microsoft SQL Server, Oracle is likewise following the idea of zero assist efforts. You don’t should rent DBA with 10 years of enjoy – which means that even small commercial enterprise could move to industry-strength database structures
- Software Customization and Development price discount – well – a lot of us in all likelihood want to buy reasonably-priced and reliable items from branch stores, manufactured in China. The identical takes place with software program improvement. Now when you have your software program product designed – you better locate the corporation to do real coding somewhere in Brazil or India. We do not need to decide – is it desirable or horrific – this is what is going on with our marketplace.
Five. Increasing Demand for Quality – this isn’t always a secret that inside the generation of internet increase – overdue 1990th – consulting organizations had to lease university graduates to do maximum complexity assignments. And market changed into tolerating this – now not any extra.
All these capabilities will enforce the consulting organizations to lessen price, searching for nation-extensive customers thru faraway aid, internet periods, abandon traditional software leads technology techniques and move to internet sales, growth the fine of their experts (we do not know the solution how)
