Microsoft Dynamics GP, the inheritor to Nice Plains Dynamics Software program and eEnterprise, is a extremely popular ERP platform, deployed as a again workplace and built-in with numerous enterprise administration programs. Among the many most typical GPP MRP integration eventualities are EDI digital doc administration interface and e-commerce. Contemplate and evaluate the methodology, integration instruments and software program growth, programming strategies and customization choices.
1. EDI. Digital doc administration is a reliably developed know-how that's often applied within the type of recordsdata or textual content streams of fastened size. A more recent method might incorporate a brand new technology of comparable EDI in conceptual XML streams. Once we discuss GP, we must always count on two forms of EDI integration - when you're a provider (on this case, you get formatted EDI or both orders for processing gross sales orders, or invoices, or invoices for accounts receivable); and when you're a buyer (on this case, you place orders for the acquisition of EDI to your suppliers). From a technological viewpoint, EDI is just not significantly tough in the usual and even within the configuration and programming. Microsoft Dynamics GP, beginning with model 8.0, is supported on a single database platform - Microsoft SQL Server. The present model of Microsoft Nice Plains is 10.0, obtainable on MS SQL Server 2005 or 2000. You program EDI streams utilizing the SQL choice command, and textual content fields are formatted utilizing transformation or conversion constructions. Once you import exterior EDI streams, it is best to think about using eConnect when creating SOP accounts.
2. E-commerce. In case you are an e-commerce programmer, please take your time to be taught eConnect applied sciences. You've got in all probability heard about eConnect and that it was initially meant for e-commerce software program builders. We want to perceive the popularization of eConnect and say the next: if you're integrating e-commerce from scratch, it is best to submit orders and e-commerce accounts to the GP tables: SOP10100, SOP10200. Nonetheless, try to be conscious that eConnect has already executed this be just right for you in eConnect enterprise objects - encrypted saved procedures. There are a number of conditions the place you will need to overcome the constraints of eConnect. First, it’s the truth that eConnect replicates the enterprise logic of Dexterity (DYNAMICS.DIC is a Microsoft Dexterity dictionary that shops all of the enterprise logic of the core modules) and even trusting the wonderful efficiency of SQL Server, you continue to have considerations that eConnect generally is a bit sluggish if the amount of your transactions crosses hundreds of information per session. In terms of eConnect efficiency, you may take into account simplifying the combination of SQL saved procedures utilizing inline logic. The second limitation of eConnect is the dearth of sending logic - to ship SOP packets, you could deploy the Albaspectrum publishing server.