RAS_EDI Digital data in and out of SAGE Line 50 Accounts  

What is RAS_EDI ?

RAS_EDI was simply about getting data in and out of SAGE - digitally.

RAS_EDI was originally developed as the missing bit of the computer jigsaw for stationery dealers using SAGE Line 50 Accounts.  But it was not restricted to only stationery dealers,  it could be used in any situation where data required to transferred in or out of SAGE.

RAS_EDI made the processing of data in and out of SAGE:

• Very quick
• Very easy
• Very accurate - no rekeying of information necessary

RAS_EDI processes

• Spicer product data and weekly EOS.xls files into Sage.
• VOW product data and weekly cost price files into Sage.
• Dealer's price lists and customer special prices from Excel spreadsheet into Sage.
• Customer orders from user's own customer facing websites into Sage. 
• Import from other ordering systems could be easily added.
• Spicer invoice and credit batches into Sage (opXML format).
• VOW invoice and credit batches into Sage (opXML format).
• Audit trail transactions from csv file - user tailorable.
• Orders held inside SAGE out to Spicer's or VOW's back office systems.
• Back to Back Orders inside SAGE - invoices or sales orders to purchase orders.

RAS_EDI developments over the years

• A Ledger Data In module that could import sales or purchase account data into SAGE.  This module was added as part of a project to integrate RAS_EDI more closely with an individual client's daily order processing application.
• Batch mode operation was enabled for the Product Data In,  Orders In,  Transaction Data In and Ledger Data In modules.  This mode of operation enabled users to process their data with a single click.  It also permited any of the batch processes to be instigated from within another application.
• General purpose import modules for both product data and order data files.
• A reports module that could run quite complex bespoke reports to get data out of SAGE into csv files.
• Import modules for orders coming from Superstat, OfficePoint and CommerceXchange were added.

Additional benefits

• Single master menu which ran all RAS_EDI tasks.
• Direct import into SAGE.
• Fast and accurate one pass import into SAGE with no re-keying of any data.
• Included a reports module which supplemented the SAGE report generator, and in particular, provided some reports that were not available or did not work properly inside SAGE.
• Could download data files directly from Spicers' and VOW's ftp servers,  downloads could be individually scheduled.

Want to know more - read the following pdfs

RAS_EDI summary information (pdf file)

Find out what's new in version 2012 (pdf file)

Read a longer overview of how RAS_EDI operated for stationery dealers (pdf file)