retpakr的部落格

Microsoft Business Solutions major midway bazaar ERP submission - Microsoft Great Plains has fourfold reunion options: MS SQL Scripting (stored procedures and views), ADO.Net programming, Microsoft SQL Server DTS packages. You without doubt can position such as SDK tools as eConnect. However present we would suchlike to show evidence of you how to program the simplest mortal good-natured tool: Microsoft Great Plains Integration Manager.
Multiple contemporary world in our consulting tradition we saw the need to integrate General Ledger contact from one schoolbook report and here we confer you this and even more than complex case, once thanks and debit entry amounts are contemporary on the very smudge next to their own account book of numbers. Let's deduce that we have tab delimited certificate file, GLSOURCE.txt. Here is how the band looks:

"11242004" (date) "11020016000" (debit vindication) 212446.68 (debit amount) "15260005400" (credit reason) 212446.68 (credit magnitude)

Pretty challenging, isn't it?

Let's begin

First of all and this is in all probability simplified - you have need of ODBC DSN, use Microsoft Text Driver, rework default directory, select the record and controller to tab bounded manner.

Next, friendly Microsoft Great Plains Integration Manager and originate two new queries - one will be for the Header and the 2nd for carriage lines in GL retailing. In some cases use Advanced ODBC caste of manuscript queries.

GL Header should collective by date, so in its SQL windowpane enter this:

select F1 from GLSOURCE.txt fleet by F1

Now the lines - here we have need of unionizing and checking if amount is not zero:

select F1, F2, F3, 0 from GLSOURCE.txt
where F3''
union
select F1 F4, 0,F5 from GLSOURCE.txt
where F5''

The one above is the furthermost effortful factor of this piece. Please become conscious it - we are cacophonic column into two by union, most primitive we bring into being debit entry component part and afterwards we fuse thanks part, plus we are weeding out 0 amounts.

Next - we want to knit two queries - just relationship them by F1 grazing land (date). Do it in enquiry bond. When you are finished near linking, rightly chink on the arrow, interested properties and in Select Relationship Type pane move to:

There can be 0 or more records in the tiddler for respectively register in the artist.

This is copernican - we'll have more than one dash in GL broadcasting.

The residue should be familiar for IM clinic.

Select end as GL Journal, allot group action day and delivery ID as F1 from Header query, electric switch to entries and superior them from debit and appreciation surround of the lines enquiry.

As added tools in filtering your article inquiry you could use VBA scripting and even interlingual rendition.

Translation is the way to go once you obligation to renew story numbers from the manual database beside various or translated accounts in Great Plains.

Happy integrating! if you impoverishment us to do the job - bestow us a telephone call 1-630-961-5918 or 1-866-528-0577!