Below are the steps for running the AFSP inventory report; these reports should be completed each week on Wednesday and need to be sent before 9:30am Pacific.

REPORT PROCESS

1. Double check the IIR queue to make sure that all AFSP IIRs are in.
2. Navigate to Inventory Programs from the Today Page and click on the AFSP program:
   
    
3. Click on the Customer Area, then Standard Reports:
   
    
4. Download the Inventory Report to CSV:
   
    
5. Open the downloaded file and resave it as a .xlsx document titled "AFSP Inventory Report [date].xlsx".  CSV files do not save formatting, so resaving immediately will prevent you from losing all of your work!
    
6. Delete columns D, G - J, and L - O.  Columns A - G should now have these headers:
    
    
7. Copy columns H & I from the template here, the document will now look like this:
   
    
8. Make sure that the formulas in columns H & I are in the full document, you can do this by highlighting the first cells in each column, highlighting through the bottom of the column, then selecting "Fill Down".
       
   It should now look like this:
   
9. Select the full document using CTRL+A or by clicking the tab in the top left.  The click "Sort & Filter", "Custom Sort".  Set up the Sort Filters:
    
    
10.  Click "OK", the document should now look like this with the red on top:  
11. Then open the AFSP Inventory Set and use CTRL+F to search for "in production".  For every line that is in red (in negative), highlight the line on your Excel document with this note .   
12. Save the document and email the completed document to Nicole (nicole.schultze@kotisdesign.com) and Katarina (katarina.vukasinovic@kotisdesign.com):