Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
cats:settings:reportoptions [2016/03/01 17:01] – [Accounting Trans Reports] jen | cats:settings:reportoptions [2020/04/30 13:42] (current) – amanda | ||
---|---|---|---|
Line 1: | Line 1: | ||
=====CATS Report Options===== | =====CATS Report Options===== | ||
- | This is a list of all options available on reports. Each option is a filter that changes which records will appear on the reports. | + | This is a list of all options available on reports. Each option is a filter that changes which records will appear on the reports, how the records are displayed, or the visual output of the report. |
+ | |||
+ | To change these filters, highlight the report you want to change from the saved report format list, and click the **Modify** button. | ||
====Options Available on All Reports==== | ====Options Available on All Reports==== | ||
- | These options, found on **Screen 5**, are available on all reports. They allow users to customize the style of the report output. | + | The options |
- | [{{: | + | [{{: |
- | **As of:** | + | **Title** - The title is what will display at the top of the report. This can be left blank. |
- | **File Name** | + | **As of:** - Change the **As of** date for this report. This will force CATS to display the data as it was on a certain date. For example, if today is 09\01\2017, but you set the **As of** date to **'' |
- | **Diff Report** - No, Yes | + | This can be useful for seeing what was in warehouse as of a certain date, or what accounting entries were made after a certain date, regardless of the date of the entries. CATS keeps track of when most changes were made in the system to facilitate use of this filter. |
+ | <note important> | ||
+ | **This option only works on certain reports or for certain types of data.** | ||
+ | The **As of** date will be saved for all reports of the same type until you exit the list of saved reports. So if you print the report file **ALL WITH INVOICES**, change the **As of** date to **'' | ||
+ | Otherwise, the **As of** date resets after every printing.</ | ||
+ | <note tip>For isolated areas, the **As of** date defaults to the isolated period date.</ | ||
+ | |||
+ | **File Name** - If the output location for this report is a file, you can name the file using this option. | ||
+ | |||
+ | **Diff Report** - | ||
+ | * No - Do not treat this report as a Difference report. | ||
+ | * Yes - Save this report into the Difference Report area, allowing you to use a Difference report to find changes between printings of this report. | ||
**Separate Character** | **Separate Character** | ||
- | **Detail, Summary** | + | **Detail** - This option will show all details on the report.\\ |
+ | **Summary**- This option will show only a summary of the totals. No details shown.\\ | ||
- | **Single Space, Double Space** | + | **Single Space, Double Space** |
- | **Subtotal** - Subtotal, Do Not Subtotal, No Group Totals, No Totals, No Sub-Heading | + | **Subtotal** - Subtotal |
**Cross-Tab** - No, Top, Bottom, Cross- Tab Only | **Cross-Tab** - No, Top, Bottom, Cross- Tab Only | ||
Line 24: | Line 38: | ||
**Date Separator** - Default, "/", | **Date Separator** - Default, "/", | ||
- | **Underline** - Standard, Default, Yes, No, Standard | + | **Underline** - Standard |
**Subtotal Description** - Display, Omit, End of Total, Start of Total Line | **Subtotal Description** - Display, Omit, End of Total, Start of Total Line | ||
+ | This report option lets you move or omit the description for the subtotal line. Choosing the display option will put the description at the start of the total line. \\ | ||
**Subtotal Labels** - Default, Value | **Subtotal Labels** - Default, Value | ||
- | **HTML Styles** - Standard, Select, CATS Default | + | **HTML Styles** - Standard, Select, CATS Default\\ |
+ | Select will let user view, edit and change fonts and colors on the report.\\ | ||
**Omit As of Date** - No, Yes | **Omit As of Date** - No, Yes | ||
Line 40: | Line 56: | ||
**Show Cats Version** - Off, On | **Show Cats Version** - Off, On | ||
- | **Two- Line Heading** - Standard, No,Yes | + | **Two- Line Heading** - Standard, No, |
**Wrap Extra Columns** - Yes, No | **Wrap Extra Columns** - Yes, No | ||
Line 135: | Line 151: | ||
**Pricing** - All, Stated, To Be Fixed, Fixed, Fixed Stated, | **Pricing** - All, Stated, To Be Fixed, Fixed, Fixed Stated, | ||
- | **Open Quant Calc** - Paid/ | + | **Open Quant Calc** - "Paid/ |
**Trader** - All, Select, Exclude, Match, Match Excluded, Any, None\\ | **Trader** - All, Select, Exclude, Match, Match Excluded, Any, None\\ | ||
Line 654: | Line 670: | ||
**Units Condition**-All, | **Units Condition**-All, | ||
- | ====Exchange Trades | + | ====Futures Reporting==== |
+ | Here are some report options unique to futures reporting.\\ | ||
- | Here are some options unique to future reporting.\\ | + | ===Open |
- | + | Here are the filters unique to Open Futures Reports. | |
- | ===Open Report Screen 1=== | + | |
- | \\ | + | |
[{{: | [{{: | ||
- | **ID**-All, Select, Exclude, Match, Match Excluded\\ | + | **Date Range** - Allows you to filter by Futures Trade date. |
- | **Active Positions**- All, Active\\ | + | **ID** - All, Select, Exclude, Match, Match Excluded - Refers to the User ID that created the trade.\\ |
- | **To Be Fixed Trades**-Include, Exclude, Only TBF \\ | + | **Position** - All, Select, Spot, Futures - Choose a range of positions or Spot (current month) or Futures (all except current month).\\ |
- | **Type**- All, Hedge, Price Fix, Speculation, | + | **Broker** - All, Select, Match, Match Exclude |
- | **Include GTC Trades**- Exclude, Include, Only GTC\\ | + | **Active Positions**- All, Active - Include |
- | **Exchange/ | + | **To Be Fixed Trades** - Include, Exclude, Only TBF - To-Be-Fixed trades, created by CATS to indicate that a price-fixing has not yet been completed, can be displayed or excluded on this report.\\ |
- | **Trade No**- All, Select, Exclude, Match, Match Excluded\\ | + | **Type** - All, Hedge, Price Fix, Speculation, Combination, |
- | **Memo No**- All, Select, Exclude, Match, Match Excluded, Any, None\\ | + | **Include GTC Trades** - Exclude, Include, Only GTC\\ |
- | + | ||
- | **Memo Mode**- Memos Trades Only, Exclude Memo Trades\\ | + | |
- | + | ||
- | **Starred | + | |
- | + | ||
- | **Strategy**- All, Select, Exclude, Match, Match Excluded, Any, None\\ | + | |
- | + | ||
- | ===Liquidated Report Screen 1=== | + | |
- | \\ | + | |
- | [{{: | + | |
- | **ID**-All, Select, | + | **Exchange/ |
- | **Active Positions**- All, Active\\ | + | **Trade No** - All, Select, Exclude, Match, Match Excluded\\ |
- | **To Be Fixed Trades**-Include, | + | **Memo No** - All, Select, Exclude, Match, Match Excluded, Any, None\\ |
- | + | | |
- | **Type**- All, Hedge, Price Fix, Speculation, | + | |
- | + | ||
- | **Include GTC Trades**- Exclude, Include, Only GTC\\ | + | |
- | + | ||
- | **Exchange/ | + | |
- | + | ||
- | **Trade No**- All, Select, Exclude, Match, Match Excluded\\ | + | |
- | + | ||
- | **Memo No**- All, Select, Exclude, Match, Match Excluded, Any, None\\ | + | |
- | + | ||
**Memo Mode**- Memos Trades Only, Exclude Memo Trades\\ | **Memo Mode**- Memos Trades Only, Exclude Memo Trades\\ | ||
**Starred Trades**- Exclude, Include, Only Starred\\ | **Starred Trades**- Exclude, Include, Only Starred\\ | ||
- | **Strategy**- All, Select, Exclude, Match, Match Excluded, Any, None\\ | + | **Strategy**- All, Select, Exclude, Match, Match Excluded, Any, None\\ |
- | + | ||
- | ===Entries Report Screen 1=== | + | ===Entries Report |
- | \\ | + | The Entries report (showing all futures trades as they were entered instead of current status) has all of the report options the Open Futures report has, except for the **Include GTC** option.\\ |
[{{: | [{{: | ||
**Reversals**- Include, Exclude, Only\\ | **Reversals**- Include, Exclude, Only\\ | ||
- | **Update Price**- Yes, No, Yes/Exclude Missing\\ | + | **Update Price**- Yes, No, Yes/Exclude Missing\\ |
+ | |||
+ | ===Liquidated Report (Screen 1)=== | ||
+ | These are the same filters as for the Open Futures report, but the **Include GTC Trades** option is not available for this report. \\ | ||
+ | [{{: | ||
====Loans==== | ====Loans==== | ||
Line 763: | Line 762: | ||
===Receipt/ | ===Receipt/ | ||
\\ | \\ | ||
- | [] | + | [{{: |
**G/L Account Range**- All, Select, Match, Match Excluded\\ | **G/L Account Range**- All, Select, Match, Match Excluded\\ | ||
Line 772: | Line 771: | ||
====Invoicing Reports==== | ====Invoicing Reports==== | ||
- | ===Provisionals Not Finalized=== | + | ===Provisionals Not Finalized |
\\ | \\ | ||
[] | [] | ||
- | **Blah**- \\ | + | **Units Condition**-All, Only if Units, Only if Weights, Units or Weight, Units and Weight\\ |
+ | |||
+ | **Transaction Code**-All, Select, Exclude, Match, Match Excluded\\ | ||
+ | |||
+ | **Invoice Type**-All, A/R Sales, A/P Sales\\ | ||
+ | |||
+ | ===Provisionals Not Finalized Screen 2=== | ||
+ | \\ | ||
+ | [] | ||
+ | |||
+ | **Only if Wt/Units**- Yes, No\\ | ||
+ | |||
+ | **All, Prov no Final, Open**- All, Prov/Not Final, Open Invoices, Open or Prov/Not final, Modified/ Finalized\\ | ||
+ | |||
+ | **Show Prior Invoice**- Yes, No\\ | ||
+ | |||
+ | **Contract Price**- All, Priced, Unpriced\\ | ||
+ | |||
+ | **Date Pricefixing**- All, Yes, No\\ | ||
+ | |||
+ | **Invoice File**- Current, History\\ | ||
+ | |||
+ | ===Provisionals Not Finalized Screen 3=== | ||
+ | \\ | ||
+ | [] | ||
+ | |||
+ | **Reserve Costs**- All, Purchases, Sale\\ | ||
+ | |||
+ | **Prorate Rsv Costs**- All, None, Reserved Amount, Actual Amount\\ | ||
+ | |||
+ | **Invoice Flag**- Select Any, Select All, Exclude Any, Excluded All, Advanced\\ | ||
===Report Of Open Invoices=== | ===Report Of Open Invoices=== | ||
+ | \\ | ||
+ | [] | ||
+ | |||