| Microsoft Business Solutions is emerging as very | | | | LSTUSRED, |
| attractive vendor for mid-size companies. The | | | | GLPOSTDT, |
| strength of its products is in their cross integration | | | | PSTGSTUS, |
| potential. This integration strategy will be the | | | | CURNCYID, |
| software development direction for this Microsoft | | | | TXENGCLD |
| subdivision. Meanwhile, as of right now - we have | | | | )select |
| to recommend just to stake on it and deal with | | | | DOCTYPE = (casewhen a.Total > 0 then 1else |
| custom or in-house developed integration. | | | | 7end), |
| If you are developer who needs some sample | | | | RMDTYPAL = (casewhen a.Total > 0 then |
| code to start with - we are placing Accounts | | | | 1else 8end), |
| Receivable level integration code - it pulls info | | | | RMDNUMWK = 'SMS' + replicate('0', |
| from Microsoft RMS and places it into work tables | | | | 13 - datalength(convert(varchar(13), |
| in Great Plains. | | | | a.TransactionNumber))) +convert(varchar(13), |
| Be aware, that Microsoft Great Plains version 7.5 | | | | a.TransactionNumber) + convert(varchar(10), |
| has out of the box integration with Microsoft RMS | | | | a.StoreID), |
| 1.2, but it is on GL and POP level only. You can't | | | | DOCNUMBR = 'SMS' + replicate('0', |
| do check book reconciliation, for example. | | | | 13 - datalength(convert(varchar(13), |
| Currently Microsoft is in decision on who will be | | | | a.TransactionNumber))) +convert(varchar(13), |
| coding the integration for Great Plains 8.0 and | | | | a.TransactionNumber) + convert(varchar(10), |
| what the functionality should be. More likely - it will | | | | a.StoreID), |
| be Nodus Technologies with the integration on | | | | DOCDESCR = left(a.ReferenceNumber, 29), |
| SOP and GL level - it will deploy Great Plains | | | | DOCDATE = convert(varchar(10), a.[Time], 101), |
| Dexterity and MS SQL Server stored procs. | | | | BACHNUMB = 'SMS' |
| And here is the code, you have to deal with | | | | + replicate('0', |
| RM10301 and distribution RM, also we recommend | | | | 2 - datalength(convert(varchar(2), a.StoreID))) |
| insert new customers into RM00101 and RM00102: | | | | +convert(varchar(2), a.StoreID) |
| -- Sales Transaction Recordinsert into RM10301 | | | | + replicate('0', |
| ( | | | | 9 - datalength(convert(varchar(11), |
| DOCTYPE, | | | | a.BatchNumber))) +convert(varchar(11), |
| RMDTYPAL, | | | | a.BatchNumber), |
| RMDNUMWK, | | | | BCHSOURC = 'RM_Sales', |
| DOCNUMBR, | | | | CUSTNMBR='CASH', |
| DOCDESCR, | | | | CUSTNAME = 'CASH', |
| DOCDATE, | | | | ADRSCODE = 'PRIMARY', |
| BACHNUMB, | | | | COSTAMNT = (casewhen isnull((select |
| BCHSOURC, | | | | round(sum(round(Cost * Quantity,2)),2)from |
| CUSTNMBR, | | | | LINKEDSERVER.HQ.dbo.TransactionEntrywhere |
| CUSTNAME, | | | | TransactionNumber = a.TransactionNumber and |
| ADRSCODE, | | | | StoreID = a.StoreID),0) > 0 and a.Total > 0 |
| COSTAMNT, | | | | thenabs(isnull((select round(sum(round(Cost * |
| SLSAMNT, | | | | Quantity,2)),2)from |
| MISCAMNT, | | | | LINKEDSERVER.HQ.dbo.TransactionEntrywhere |
| FRTAMNT, | | | | TransactionNumber = a.TransactionNumber and |
| TAXAMNT, | | | | StoreID = a.StoreID),0))when isnull((select |
| DOCAMNT, | | | | round(sum(round(Cost * Quantity,2)),2)from |
| CASHAMNT, | | | | LINKEDSERVER.HQ.dbo.TransactionEntrywhere |
| CBKIDCSH, | | | | TransactionNumber = a.TransactionNumber and |
| CASHDATE, | | | | StoreID = a.StoreID),0) 0 anda.StoreID = '1' |
| DCNUMCSH, | | | | andnot exists (select 1 from RM10301 cwhere |
| CHEKAMNT, | | | | c.RMDNUMWK = 'SMS' + replicate('0', |
| CBKIDCHK, | | | | 13 - datalength(convert(varchar(13), |
| CBKIDCRD, | | | | a.TransactionNumber))) +convert(varchar(13), |
| CHEKNMBR, | | | | a.TransactionNumber) + convert(varchar(10), |
| CHEKDATE, | | | | a.StoreID) andc.RMDTYPAL = (casewhen a.Total |
| DCNUMCHK, | | | | > 0 then 1else 8end)) andnot exists (select 1 |
| CRCRDAMT, | | | | from RM00401 cwhere c.DOCNUMBR = 'SMS' + |
| DCNUMCRD, | | | | replicate('0', |
| CRCRDNAM, | | | | 13 - datalength(convert(varchar(13), |
| RCTNCCRD, | | | | a.TransactionNumber))) +convert(varchar(13), |
| CRCARDDT, | | | | a.TransactionNumber) + convert(varchar(10), |
| TRDISAMT, | | | | a.StoreID) andc.RMDTYPAL = (casewhen a.Total |
| ACCTAMNT, | | | | > 0 then 1else 8end))and a.[Time] > '01/01 |
| DISCDATE, | | | | 2004' |
| DUEDATE, | | | | Happy integrating! if you want us to do the job or |
| LSTEDTDT, | | | | use our product - give us a call 1-866-528-0577! |