Differences

This shows you the differences between two versions of the page.

--- cats:procedures:reports:exceptionreports [2016/06/21 14:27] – [Warehouse Exposure] jen
+++ cats:procedures:reports:exceptionreports [2022/08/08 18:30] (current) – ↷ Links adapted because of a move operation amanda
@@ Line 1: / Line 1: @@
 =====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\\
@@ Line 11: / Line 13: @@
 ====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.
+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.
@@ Line 18: / Line 32: @@
 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 or destination values. Press **Select Columns** from the top menu to select the columns you want on this report.
+Choose your **Grade/ Values Mode**-
-[{{:cats:procedures:reports:exceptionreports_gradereportscreen1.png?|Grade report screen 1}}]
+  * Codes and Values
-Select the columns you want on this report ([[cats:procedures:createareport|Selecting columns on a report]]).
+  * Futures Values
-[{{:cats:procedures:reports:exceptionreports_selectcolumns.png?direct&800|Select columns to show on the futures report}}]
+  * Destination Values
-Once you have modified the report press **Continue** from top menu bar. Then choose how you want to print the report.
+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.
@@ Line 37: / Line 61: @@
 ===Future Values===
-Follow the steps listed above and instead choose grade code **Future Values**. You will still need to modify the columns  for this report.
+Follow the steps listed above and instead choose grades mode **Futures Values**.
-Here is a sample grade report future values printed to HTML.
+[{{: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 grade code **Destination Value.** You will still need to modify the columns  for this report.
+You can follow the steps listed above and instead choose grades mode **Destination Value.**
-Here is a sample grade report destination values printed to HTML.
+[{{: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"}}