Integrating with Sage Line 500 / Sage 1000. William Eastbury Sage User Network Tuesday, 08 June 2010. Session Content. Background Get information from an external source into Sage transactions. Get supplementary information into Sage and display it.
Integrating with Sage Line 500 / Sage 1000
Sage User Network
Tuesday, 08 June 2010
Datel NL API
Sage EI Module
And this appears
populated from sage table stockm
access to the required tables
warehouse from your table.
** USE THE WITH NOLOCK QUERY HINT
IN A PRODUCTION SAGE SYSTEM **
GRANT SELECT ON<ViewName>TO<UID>
And here is our Add-In happily running in Excel 2003, extracting budget data.
Note: There is no reason why this could not be a 2-way process, allowing you to write back the budget data to the database.
Unless you want to wait for Iron Speed to read the entire schema of all 8,000 + sage tables ! ! !
transaction-volume or real-time environments
such as B2C commerce (Although it does work)
such as EDI.
methods you could choose to use :-
Modules as a transport method into Sage.
but does require a ASP.NET (VB)
programmer for changes
Plugins for transmission into
sage. (One of which is a .net
wrapper around the Datel