Export customer and item information to Avendra via the Go Co-op.

 

Related:

•Mod #95 Modify #1 Avendra Export  

•Mod #465 Modify #2 Avendra Export  

•Mod #1069 Avendra Sales Export

•Mod #1493 Avendra Export using AWG instead of USD

•Mod #1512 Separate Avendra Sales Export by Customer GL Link Code

 

Export Requirements:

•You must have Excel 97 or higher installed on the workstation running this export utility.  

•To use the auto-email feature the workstation running the export utility must have Outlook or Outlook Express installed and configured to an active POP3 server.

 

Files Exchanged

Excel files should be placed in the entrée data files directory. These files should have been emailed to you by your NECS representative.

 

▪Catalog.xls

▪Sales Summary.xls

 

entrée V4 Settings

•Customer: Mark all your Avendra customers.

1.Go to the Customer ribbon menu > click Customer.

2.Find the Avendra Customer.

3.Click the Miscellaneous Tab and set the Matrix Code to IN.

4.Click Apply to save.

 

•Inventory: Mark all your Avendra items.

1.Go to the Inventory ribbon menu > click Inventory.

2.Find the Avendra item.

3.Go to the Cost/Price Tab.

4.Set the Matrix Code to IN.

5.Click Apply to save.

 

•The utility will maintain the matrix codes accordingly.

•Pricing for price levels 12 - 15 will be exported to Avendra because that should be where any contract pricing exists.

 

 

Update v4.2.0

Updated so that the data files will be submitted via SFTP instead of normal FTP.