SPS/EDI Setup

1. Create a new web integration

  1. Navigate to Administration -> System Setup -> Web Integrations and click the ✚ symbol to create a new web integration.
  2. In the dialog that appears, select SPS then click OK.
System Setup - Web Integrations

2. Enter the web integration setup info

2.1. Credentials

  • Enabled: This must be checked for incoming SPS files to be processed.
  • Test Mode: When checked, Test Mode directs all inbound and outbound traffic between AcctVantage and SPS to the ‘testin’ and ‘testout’ folders on the SPS SFTP site.
  • Server Address, Username and Password: This info will be provided by SPS.
  • AV SPS License Key: This is provided by AcctVantage Support.
  • Check for new Documents: This setting provides a user-managed scheduled for AcctVantage to poll the SPS server for new inbound documents.
Web Integration (SPS) - Credentials

2.2. Import Setup

  • Import Source Code: This is a 3-character code that you define. This code is used to tag transactions imported from SPS as belonging to this configuration.
  • Warehouse: This is the warehouse that any incoming sales orders (inbound EDI 850) will be associated with.
  • Default Ship Via: If not otherwise indicated, the shipping service assigned to Sales Orders created from inbound EDI 850.
  • Tax Area: If not otherwise indicated, the tax area assigned to Sales Orders created from inbound EDI 850.
  • Credit Card Receipt Type: If not otherwise indicated, the Receipt Type assigned to Sales Orders created from inbound EDI 850.
  • Auto-Send 810, 855, and 856 Documents (Not Recommended): If selected, the corresponding EDI documents will be uploaded to SPS without user interaction, based on certain Sales Order criteria.
  • Auto-Create Missing Products: If selected, any line item on an inbound EDI 850 that does not have a matching AcctVantage Product record will cause a Product record to be created automatically.
    • Default Product Class: The new Product record will be associated with the Product Class indicated here.
  • Allow Overwrite of imported shipping charges: If selected, the user may modify freight charges on Sales Orders originated from imported EDI 850.
  • Contact Name, Email, Phone: These values are included on outbound EDI 856 and 810 documents.
Web Integration (SPS) - Import Setup

3. GS1 Company Prefix

After saving the web integration settings, click over to the Shipping tab in System Setup to enter the GS1 Company Prefix.

  • GS1 Company Prefix: A unique number that will identify your company as the owner of your barcode and the product its on. It is assigned to your company by GS1 and incorporated in auto-generated SSCC numbers.
System Setup - Shipping