Invoices via EDI

Purpose: To make electronic payment of invoices and at the same time add payment lines to appropriate order records in Millennium.  EDI technology facilitate importing invoices through the Millennium Acquisitions module.

Retrieve invoice from Ebsco

 

1. Log in to Ebsconet
2. Select the “My order” tab
3. On far right of resulting new bar menu select "EDI".  See screen shot above
4. Select invoices.  Pairs of files will be displayed in a list, one in txt format and one in invoice format.
5. Click on text version to check content.  Note the following information in screenshot below
   •  Invoice number
   • Invoice date
   • # of line items
   • Amount
   
6. Close file after review
7. Now open invoice version of file pair
8. Dialog box will popup.  Select Save to desktop

 NOTE: Invoice available on Ebsconet for 90 days. If missed can make special request. Need to monitor if expecting an invoice as no auto-email sent out.  Usually rep will give a heads up if expecting a large invoice such as the annual renewal or a large e-journal package.  

Import invoice to Millennium

1.  Switch to Millennium Acquisitions module interface
2.  Select import invoices icon
3. Click “get shipment”
4.  In resulting dialog box select radio button for serial invoice
5. Browse to desktop to highlight the file
6. Click open
7. Imported invoice will appear in Acq interface as part of list under the accept/reject tab
8.  Highlight the file you want to review.  See below:


9. NOTE: If any field is missing, boxes will be highlighted in red and "Skip" will appear in the action box on far right.
10. To see detailed payment history information click ‘key” icon in “Index” column.   Spot check payment history against incoming payment price to be sure the amount looks appropriate.
11. To address skip lines:
    • Double click the line with a blank title. 
    • Referring to print version of invoice, key in title and then open attached order record.  You may need to try more than one "cell" (eg. record number) to invoke a dialog box to view the individual order record needed to resolve the "skip" line.
    • From inside the resulting order record click the "Use order record" button and missing data will now appear in the line item display on the import invoices spreadhseet.  Action will change to "Accept" and highlighting will be gone. 
    • Recommend writing down the order record# on your print copy.
12. When everything looks good the invoice is ready to process. FIRST notify the LAI who handles daily posting as the volume will add as much 10-15 minutes to the posting process for that day.  (Note: As of FY2009 it is no longer necessary to break up the posting of the 1500+ line payments as both the Millennium and PeopleSoft systems can handle the volume).
13. After posting is completed, the payment lines will appear in the appropriate individual order records. 

---

Created by: Sharon Fitzgerald | Revised: 12/23/2011