Differences

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

--- cats:procedures:reports:openpositionreport [2015/08/25 13:28] – amanda
+++ cats:procedures:reports:openpositionreport [2022/11/11 15:37] (current) – jen
@@ Line 1: / Line 1: @@
 =====Open Position Reports=====
+{{entry>0;Open Position Report;-}}
 Open position reports look at contract items to find the current position of material in CATS. Each line item on the report represents a contract item, which has a unique description plus optional identifier code.
 To create or print an open position report, select **Position Reports > Open Position** from the Main menu.
@@ Line 5: / Line 6: @@
 ====Report Filters and Options====
 Here are some of the key options for Open Position Reports.
-[{{:cats:procedures:reports:positionreports_openposfiltertype.png|Select a Report Type to View Various Contract Types}}]
+[{{:cats:procedures:reports:openpositionreport_types.png?|Select a Report Type to View Various Contract Types}}]
 ===Contract Type===
 Despite the name of this report type, you can change the default filters to see items that are in the following categories:
-  * All positions (includes all of the options below).
+  * **All** positions (includes all of the options below).
-  * Unallocated - No sales units applied against purchases and vice versa.
+  * **Unallocated** - No sales units applied against purchases and vice versa.
-  * Open - No sale invoice.
+  * **Open** - For **Purchases**, the **''Charged''** units are //less// than the **''Contract''** units. For **Sales**, the **''Billed''** (sale invoiced) units are //less// than the **''Contract''** units.
-  * Inventory - Purchase invoice but no sale invoice.
+  * **Inventory** - The **''Charged''** units are //more// than the **''Billed''** units. Only applies to **Purchase** contract items.
-  * Billed Out  - Sales invoiced)
+  * **Billed Out**  - Sales invoiced items.
-  * Open/Inventory - shows the full position of incoming and open.
+  * **Open/Inventory** - Shows items that are either Inventory or Open (see above).
-  * Open/Inventory/To-Be-Fixed - Same as above but includes unfixed items.
+  * **Open/Inventory/To-Be-Fixed** - Same as above but includes unfixed items (the number of **''Lots''** is //more// than the number **''Fixed''** on the item).
-  * Provisionally Invoiced - Items without a final sale invoice against them. Compare this to the provisionals not finalized report.
+  * **Prov Invoiced** - Items without a **final** Sale Invoice against them. Compare this to the Provisionals Not Finalized report.
-  * Unfixed - Shows only unfixed items.
+  * **Unfixed** - Shows //only// Unfixed items.
-  * Complete including receivables (or not including receivables) - Items marked complete.
+  * **Activity** - A sale or purchase invoice must have been posted against this item  during this fiscal year.
+  * **Completed Incl A/R** -
+  * **Not Completed A/R** - Items that are only missing a sale invoice.
 ===Position Date Range and Position===
-The **Position Date Range** on Screen 1 can be used in conjunction with the **Position** filter on Screen 2 to choose which type of position is used in the date range.
+The **Position Date Range** can be used in conjunction with the **Position** filter to choose which type of position is used in the date range.
-[{{:cats:procedures:reports:openpositionreport_positiononscreen2.png|Position Filter Options on Screen 2}}]
+[{{:cats:procedures:reports:openpositionreport_filter.png?|Position Filter Options}}]
-Options are:\\   - Trading - The trading position on the item screen.
+The Position Type Options are:
+  - Trading - The trading position on the item screen.
   - Shipment - The shipment position on the item screen.
   - Valuation - The valuation position on the item screen.
@@ Line 31: / Line 36: @@
 [{{:cats:procedures:reports:openpositionreport_salecontractitem1to4.png|Four Position types on the sale contract item screen.}}]
-Simply set the filters as needed and print the report to see your current physical position.
+===Financing===
+CATS allows you to label contract items (or automatically classify them) as under a type of financing. The most common option is **Consignment**. This classification is done on the item screen using the **Fin** menu choice.
+[{{:cats:procedures:reports:contractitems_financingoptiononitemscreen.png?|Financing option on item screen}}]
+The only effect this label has is to allow you to filter items on reports. You can exclude or choose to see only Consignment items on the Open Position report.
+[{{:cats:procedures:reports:openpositionreport_financingfilter.png|Exclude or see only one type of financing classification.}}]
+===Show Locations===
+This option allows you to import columns that show location-screen-level data. This may expand your report by several lines per item if an item has more than one location screen, but it allows you to see the allocations and traffic status of pieces of these items. This may help you when attempting to allocate open items.
+===Minimum Units or Weight===
+Occasionally, small pieces of items are left open or in inventory. You can choose to exclude these items from report by using a minimum weight or units filter. Select **units** or **weight** and pick a limit.\\
+[{{:cats:procedures:reports:minimumunitsfilteronreports.png|Exclude items with under one unit left open.}}]
+In the above case we will exclude items with less than one unit left open.
+You can also choose to see a report of small pieces, which will allow you to identify them in order to clean them up in the system.
+[{{:cats:procedures:reports:maximumlbsfilteronreports.png|Only show items with open weight up to 10 pounds.}}]
+In the above case we are only showing items with open weight from 0 to 10 pounds.
+===Pricing===
+If you are interested in doing so, you can exclude items that are not fixed or show only To-Be-Fixed items.
+[{{:cats:procedures:reports:openpositionreport_pricing.png?|Select pricing status as a filter on the report.}}]
+===Allocations===
+You can choose to see only unallocated items, only allocated items, or all contracts regardless of allocation.
+===Negative Inventory===
+While open sales contracts show up as negative units on the open position report, inventory can be negative if an item is overbought or oversold. This choice will eliminate negative inventory from the calculation of units on the report.
+[{{:cats:procedures:reports:openpositionreport_neginventory.png?|Include or Hide Negative Inventory}}]
+===Contract Screen Flags===
+Contract-level flags can be used to filter which contract items you see on reports. You can use the **Advanced** filter option to include or exclude items tagged with specific flags. Simply set the filters as needed and print the report to see your current physical position.
+[{{:cats:procedures:reports:openpositionreport_flags.png?|Advanced flag filter}}]
 ====Sample Report Settings====
@@ Line 41: / Line 80: @@
   * Position - Select a range of position dates to narrow the focus of the report.
   * On Screen 2: Select Position - If you have selected a position date range on Screen 1, this will allow you to specify which type of position CATS should use for the date range. Choices are Trading, Shipment, Valuation, or Differential.
+[{{:cats:procedures:reports:openpositionreport_sample.png|A Sample Open Position Report}}]
+{{tag>"open position report filters" "open position report options"}}