eFactoryPro Wiki

3.3 How do I use the SPS Analytics Tool to search for Invoicing Exceptions?

Updated on

Steps in the screenshots correspond to the numbers in the headings.

1. Type the following in your address bar: https://portal.hosted-commerce.net/sps/

2. Enter your assigned user name.

3. Enter your assigned Password.

4. Click Login.

5. Click on Analytics in the upper left corner.

6. You have two options on how to get to the main screen, you can click the drop-down next to dashboard and choose Retail Analytics.

7. OR.. you can choose the drop-down next to Open and choose Retail Analytics- Visibility.

Keep in mind, that the Recent Tab will keep track of the screens you have used.  Ultimately, that may be the fastest way for you to navigate, as it will have the Invoice-specific queries listed.

8. The search criteria loads at the top of the panel.  

9. THE DEFAULT VIEW IS TODAY.  This is important, as you will most likely need to adjust this to a broader range to see more details.

Anytime you return to the screen it will default to the "today" values and you will have to reset the search criteria to the larger date range if needed.

10. If you want to further refine your search, you can choose a specific vendor from the drop-down under the Supplier Name field.

11. If you prefer to look up by Supplier number, this is visible in the next field over.  Please note that this is the EFP Vendor number, not the SAP Vendor Number.

12. You can also search by Buyer Name.

13. Finally, you can search by the EFP PO number.

14. The Lower Panel will populate  You will most likely need to scroll down to see this panel.  There are several Invoice Options displayed on this page.

15. The Blue Tile on the Far Right tells you how many POs are currently missing Invoices. You can click on the box to see the details.

16. There are various export options for the data as well.

A)  The screenshot below shows what the screen looks like once you've clicked the tile.

17. Under the Review Tab, you have the option:  Invoice Summary (by Invoice Date.) Please note that this will open in another tab.

B) The screenshot below is an example of what the expanded view looks like when you click on the tile.

19. Click on Invoice to see the Invoice Details.

20. Under the Exception Column, you can find the Invoice Exceptions.

21. Orders without Invoices contains the same information as Step #15.

22. Orders with ASN (Advanced Shipping Notice) / No Invoice will show POs for which we have received an Advance Shipping notice, but we have not received the invoice.

23. Orders with Invoice but No ASN is just the opposite.  Please note that this doesn't automatically assume there is a problem.  Some of our EDI Vendors will not be using the 856 Advance Ship Notice.

24. And finally, if you want to see Invoices that have exceptions, you would use the Invoice Line with Unit Price Exceptions.  

This may be a good place for you to do further investigation on items.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article 3.2 SPS Ad Hoc Reporting User Guide
Next Article 3.4 What is the easiest way to find and print an invoice using the SPS Fulfillment Center?