Automatic order import.

kelvinrp
kelvinrp Member Posts: 2
edited 2009-09-10 in NAV Three Tier
Please can anyone advise the best way to implement an automatic order import for Nav?

I already have developed an SSIS package that imports a customers PO (xml format) as a sales order into our existing ERP package. This uses T-SQL to import the data.

I know you can buy Biztalk to do but I don't want to!

Comments

  • kamranshehzad
    kamranshehzad Member Posts: 165
    you have saveral options..

    I did this in the following way.

    1- created a xml port in navision
    2- wrote a code unit that takes text stream and passes it to xml port
    3- exposed code unit as webservice
    4- called the webservice from ssis and passed the xml..

    and thats it...

    here is a small example of this. (its for items only , if you need i can provide you it for purchase)

    http://dynamicsnaverp.blogspot.com/

    regards,
    KS

Categories