Inventory Book Report

Options within the Inventory Book report, found at Accounting / Accounting Reports / Inventory / Inventory Status, allow additional information to be included or excluded to tailor the report to fit specific needs.

  • Include Over-received PO Quantities – Include additional quantities received over the amount of the Purchase Order.
  • Include Products Without Bookings – Include Products regardless of whether or not a Booking exists.
  • Consolidate across locations – Combine Products with matching Product IDs and Department Categories across Locations.
  • Include Expired Bookings – By selecting this option, the report includes expired Bookings that still have quantities available. Otherwise, the Inventory Book report only includes Bookings that have valid dates.
  • Calculate Raw Ingredients – This option includes the raw materials that make up a Manufactured Product on the report.
    Note: In order to include the raw ingredients for a Manufactured Formula in this report, select both the Manufactured Formula and the associated Products. If finished goods are already available, the report will calculate only the additional raw ingredients required to fulfill the remaining quantity needed to complete the order.
  • Show ReOrder Column – If there is a re-order quantity set on the Product, this option adds that column to the report.
  • Includes all Delivery and Blend Tickets – Include all Delivery and Blend Ticket amounts even if the amount delivered is over the original amount booked for the Customer.
  • Exclude Zero Quantity Lines – Allow lines with zero quantities to be excluded.
  • 100% to Grower – Check this option if Bookings are split, but the Delivery Tickets are not entered with those splits.
  • Exclude Grower Order Bookings – This allows for the exclusion of any Bookings that were created with the Grower Order tool at Accounting / Inventory / Manage Seed Orders.