The Position Analysis report is available at Accounting Reports / Inventory / Inventory Position. This report helps determine the net inventory position on Products (approximates an amount available for sale) and values that inventory. It also assists in forecasting future seasons.
Report Selection Screen
Seasons may be defined for this report. If a season is not defined, the report is processed with all Bookings, Delivery Tickets, Blend Tickets, and Purchase Orders and is considered the current season. The defined seasons may be contiguous, but may not overlap. Select Add Row then establish a Start Date and End Date based off the Document, Start, or Expiration Date of the Bookings and Purchase Orders. If defining seasons, one season may be marked as Current.
With Include Costs/Prices option is selected, costs and prices will be included on the report.
Selecting the Include Recap option displays PO Detail, Book Detail and Include PO Freight and Add ons options. Selecting PO Detail, Book Detail or PO Freight and Add ons adds the following to the report:
- PO Detail – This displays the quantity and date of POs included in the On Order column.
- Book Detail – This displays the quantity and date of Bookings included in the Booked column.
- Include PO Freight and Add-ons – Applicable amounts included in the Unit Cost are displayed.
Report Headings
The following are descriptions of content included under each report heading on the Position Analysis report:
- Season – The defined season name followed by the date range in parentheses is displayed.
- Location – The ID of each Location to which the Product belongs is displayed.
- On Hand – For the season marked as Current, this displays the amount on hand for that Product in that Location. All other seasons do not display an On Hand amount.
- Unit Cost – For the season marked as Current, this displays the cost of the Product in that Location. The cost defined here is selected in the Report Criteria area when setting up the report. All other seasons do not display a Unit Cost.
- Extension – For the season marked as Current, this is the Amount On Hand in Inventory Units * Unit Cost / Billing Divisor. All other seasons, do not display an Extension.
- On Order – The quantity of that Location's Product unreceived on Purchase Orders for that season displays here. In addition, the quantity and date of POs display if the PO Detail option was selected.
- Unit Cost – For each of the Purchase Orders, multiply the quantity by the Purchase Order cost, add those extensions, and divide by the total On Order quantity. In addition, selecting Include PO Freight and Add ons adds the applicable amounts to the Unit Cost.
- Extension – This is the On Order quantity in Inventory Units * Unit Cost column / Billing Divisor.
- Booked – For the season marked as Current, this is the open quantity on Bookings for that season minus the loaded unprocessed Delivery Ticket and Blend Ticket quantities where the Product is also booked. For all other seasons, this is the open quantity on Bookings for that season. In addition, the quantity and date of Bookings display if Book Detail was selected.
- Unit Price – For each open Booking in that season, the Unit Price is found by multiplying the open quantity by the booked price, adding these, and dividing by the total open quantity. Deliveries are not included.
- Extension – This equals the Booked quantity in Inventory Units * Unit Price column / Billing Divisor.
- Net Position – Add the On Hand column and the On Order column, then subtract the Booked column.
- Units – This displays the Product’s Inventory Unit, Billing Unit, Package Unit, Lbs, or Tons depending on the unit selected in the Report Criteria area when setting up the report.
