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