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