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.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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