=====Exception Reports===== {{entry>0;Exception Reports;-}}{{entry>0;Warehouse Exposure;-}}{{entry>0;Codes and Values;-}} {{entry>0;Physical Position tied to Futures;-}}{{entry>0;Past Pickup Date of Sale;-}}{{entry>0;Reservation Report;-}}{{entry>0;Shipping Advice;-}} To access exception reports, go to **Position Reports > Exception**. Scroll and highlight the report you want. Types of Exception reports are:\\ * Physical Position Tied to Futures\\ * Past Pickup Date of Sale\\ * Warehouse Exposure\\ * Reservation Report\\ * Shipping Advice\\ * Description Codes and Values\\ {{:cats:procedures:reports:exceptionreports_accessmenu.png?|}} ====Physical Position Tied to Futures==== ====Past Pickup Date of Sale==== Go to **Position Reports > Exception > Past Pickup Date of Sale**. [{{:cats:procedures:reports:exceptionreports_pastpickupdateofsalemenu.png?|past pickup date of sale menu}}] Input the information you want to show on this report.\\ **Delivery Date Prior To**- Enter the date\\ **Accounts**- All, One Account, Account Range\\ [{{:cats:procedures:reports:exceptionreports_pastpickupdateofsaleoneaccount.png?|}}] Choose All accounts, One Account or Account Range. [{{:cats:procedures:reports:exceptionreports_pastpickupdateofsaleoneaccountrange.png?|Account Range}}] Enter the date and account information and press **Continue**. [{{:cats:procedures:reports:exceptionreports_pastpickupdateofsaleoneaccountbroker.png?|One Account}}] ====Warehouse Exposure==== A report that calculates the value of material stored in each warehouse code or account and determines your exposure based on that value. Only if the exposure balance is negative, will it show on this report.\\ Go to **Position Reports > Exception > Warehouse Exposure**. This is a standard report with no options. You will go directly to the print screen. [{{:cats:procedures:reports:exceptionreports_printoptions.png?|Print Options}}] CATS will ask to save the report. Here is a sample Warehouse Exposure exception report. [{{:cats:procedures:reports:exceptionreports_warehousereport.png?|Warehouse report}}] To check the exposure limit, you can go to **Accounting > Accts: Name/Addr > Review Account**. [{{:cats:procedures:reports:exceptionreports_checkexposurelimit.png?|}}] The **Edit account record** box will pop up. Enter the account record you want to check limits. [{{:cats:procedures:reports:exceptionreports_checkexposurelimitchooseaccount.png?|Edit account record}}] The account review screen will show. Here you can view existing exposure limits.You can change the exposure limits by choosing **Edit** from the top menu bar and typing in the exposure limit box. [{{:cats:procedures:reports:exceptionreports_changeexposurelimit.png?|Edit exposure limit}}] You can also choose **Exposure Credit > Calculate Exposure** from the top menu bar. [{{:cats:procedures:reports:exceptionreports_changeexposurecredit.png?|Change exposure limit}}] ====Reservation Report==== ====Shipping Advice==== ====Description Codes and Values==== Grade codes indicate the type of material being purchased/sold. Grades are the smallest level of material, under category and subcategory. Each grade can use a different market differential. Go to **Position Reports > Exception > Description Codes and Values**. Select the report you want to run and click **Modify**. You can also print directly from this page by pressing **Print**. [{{:cats:procedures:reports:exceptionreports_selectformatreport.png?direct&800|Select format report}}] ===Codes and Values=== Choose your **Grade/ Values Mode**- * Codes and Values * Futures Values * Destination Values Press **Select Columns** from the top menu to select the columns you want on this report. [{{:cats:procedures:reports:exceptionreports_gradesvaluesmode.png?|Grade Report Screen}}] Choose order and columns as usual ([[cats:procedures:deprecated:oldcreateareport|Creating Reports in CATS]]). **Continue** to print. Choose how you want to print the report. [{{:cats:procedures:reports:exceptionreports_printoptions.png?|Print report options}}] CATS will ask you to save your report. [{{:cats:procedures:reports:exceptionreports_editgradereportsavechanges.png?|Save changes after editing grade report}}] ===Future Values=== Follow the steps listed above and instead choose grades mode **Futures Values**. [{{:cats:procedures:reports:exceptionreports_gradereportscreen1.png?|Grade report screen 1}}] Modify the columns for this report. Make sure the columns for Future Rpt Only are selected. Proceed as usual to print and save your report.\\ [{{:cats:procedures:reports:exceptionreports_selectcolumns_001.png?direct&800|Select columns on futures report}}] A sample of future values report printed to HTML. [{{:cats:procedures:reports:exceptionreports_futuresvaluereport.png?|Future values report}}] ===Destination Values=== You can follow the steps listed above and instead choose grades mode **Destination Value.** [{{:cats:procedures:reports:exceptionreports_destinationvaluereport.png?|Destination value report screen 1}}] Modify the columns for this report. Make sure the columns for Dest Rpt Only are selected. Proceed as usual to print and save your report.\\ [{{:cats:procedures:reports:exceptionreports_selectcolumns_002.png?direct&800|Select columns on destination report}}] A sample of grade destination values report printed to HTML. [{{:cats:procedures:reports:exceptionreports_destinationvaluereporthtml.png?Destination values report|}}] {{tag>"physical position tied to futures" "past pickup date of sale" "warehouse exposure" "reservation report" "shipping advice"}} {{tag>"codes and values" "futures reports" "destination reports"}}