Software informational articles

Microsoft great plains integrations ? retail management check out - software

 

Microsoft Big business Solutions is emerging as very charismatic vendor for mid-size companies. The depth of its food is in their cross integration potential. This integration approach will be the software advance administration for this Microsoft subdivision. Meanwhile, as of right now - we have to commend just to stake on it and deal with custom or in-house industrial integration.

If you are developer who needs some experiment code to start with - we are introduction Financial records Receivable level integration code - it pulls info from Microsoft RMS and seats it into work tables in Great Plains.

Be aware, that Microsoft Great Plains account 7. 5 has out of the box integration with Microsoft RMS 1. 2, but it is on GL and POP level only. You can't do check book reconciliation, for example. At present Microsoft is in choice on who will be coding the integration for Great Plains 8. 0 and what the functionality ought to be. More expected - it will be Nodus Technologies with the integration on SOP and GL level - it will arrange Great Plains Adroitness and MS SQL Head waiter stored procs.

And here is the code, you have to deal with RM10301 and allotment RM, also we advocate addition new customers into RM00101 and RM00102:

-- Sales Transaction Record

insert into RM10301

(

DOCTYPE,

RMDTYPAL,

RMDNUMWK,

DOCNUMBR,

DOCDESCR,

DOCDATE,

BACHNUMB,

BCHSOURC,

CUSTNMBR,

CUSTNAME,

ADRSCODE,

COSTAMNT,

SLSAMNT,

MISCAMNT,

FRTAMNT,

TAXAMNT,

DOCAMNT,

CASHAMNT,

CBKIDCSH,

CASHDATE,

DCNUMCSH,

CHEKAMNT,

CBKIDCHK,

CBKIDCRD,

CHEKNMBR,

CHEKDATE,

DCNUMCHK,

CRCRDAMT,

DCNUMCRD,

CRCRDNAM,

RCTNCCRD,

CRCARDDT,

TRDISAMT,

ACCTAMNT,

DISCDATE,

DUEDATE,

LSTEDTDT,

LSTUSRED,

GLPOSTDT,

PSTGSTUS,

CURNCYID,

TXENGCLD

)

select

DOCTYPE = (case

when a. Total > 0 then 1

else 7

end),

RMDTYPAL = (case

when a. Total > 0 then 1

else 8

end),

RMDNUMWK = 'SMS' + replicate('0',

13 - datalength(convert(varchar(13), a. TransactionNumber))) +

convert(varchar(13), a. TransactionNumber) + convert(varchar(10), a. StoreID),

DOCNUMBR = 'SMS' + replicate('0',

13 - datalength(convert(varchar(13), a. TransactionNumber))) +

convert(varchar(13), a. TransactionNumber) + convert(varchar(10), a. StoreID),

DOCDESCR = left(a. ReferenceNumber, 29),

DOCDATE = convert(varchar(10), a. [Time], 101),

BACHNUMB = 'SMS'

+ replicate('0',

2 - datalength(convert(varchar(2), a. StoreID))) +

convert(varchar(2), a. StoreID)

+ replicate('0',

9 - datalength(convert(varchar(11), a. BatchNumber))) +

convert(varchar(11), a. BatchNumber),

BCHSOURC = 'RM_Sales',

CUSTNMBR='CASH',

CUSTNAME = 'CASH',

ADRSCODE = 'PRIMARY',

COSTAMNT = (case

when isnull((select round(sum(round(Cost * Quantity,2)),2)

from LINKEDSERVER. HQ. dbo. TransactionEntry

where TransactionNumber = a. TransactionNumber and

StoreID = a. StoreID),0) > 0 and a. Total > 0 then

abs(isnull((select round(sum(round(Cost * Quantity,2)),2)

from LINKEDSERVER. HQ. dbo. TransactionEntry

where TransactionNumber = a. TransactionNumber and

StoreID = a. StoreID),0))

when isnull((select round(sum(round(Cost * Quantity,2)),2)

from LINKEDSERVER. HQ. dbo. TransactionEntry

where TransactionNumber = a. TransactionNumber and

StoreID = a. StoreID),0) 0 and

a. StoreID = '1' and

not exists (select 1 from RM10301 c

where c. RMDNUMWK = 'SMS' + replicate('0',

13 - datalength(convert(varchar(13), a. TransactionNumber))) +

convert(varchar(13), a. TransactionNumber) + convert(varchar(10), a. StoreID) and

c. RMDTYPAL = (case

when a. Total > 0 then 1

else 8

end)) and

not exists (select 1 from RM00401 c

where c. DOCNUMBR = 'SMS' + replicate('0',

13 - datalength(convert(varchar(13), a. TransactionNumber))) +

convert(varchar(13), a. TransactionNumber) + convert(varchar(10), a. StoreID) and

c. RMDTYPAL = (case

when a. Total > 0 then 1

else 8

end))

and a. [Time] > '01/01/2004'

Happy integrating! if you want us to do the job or use our effect - give us a call 1-866-528-0577! help@albaspectrum. com

About The Author

Andrew Karasev is Chief Knowledge Detective in Alba Spectrum Technologies - USA countrywide Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Arizona, California, Colorado, Texas, Georgia, New York, Florida and having locations in manifold states and worldwide (www. albaspectrum. com), he is Dexterity, SQL, C#. Net, Precious stone Hearsay and Microsoft CRM SDK developer. akarasev@albaspectrum. com


MORE RESOURCES:
Developed by:
home | site map
goldenarticles.net © 2018