Skip to content

Pickup Inventory By Due Date Report

Action: RP_PINVDUE

This report shows item in your pickup inventory that are due to be picked up during a specified date range.

Cost on Report

Pickup Inventory reports will show costs based upon the following rules: * For items sold from stock the Cost of sale is the inventory's 'Average Cost'. * For items sold that were Special Ordered, the Cost comes from PO file when the item was received and is the inventory Reorder cost at the time the item was ordered. * The system zeros the cost (0) of the pickup item when it's Revenue is accounted for on the sales ticket. The reason for this is In many states the shop owner must pay tax on the inventory value. Until the SALE's Revenue is accounted for by the shop, then the item technically still belongs to the store and inventory tax would be calculated on it's cost.

Criteria

Due date between... Compares the date information entered to the Due Date field of the Pick-up inventory form for each item in pickup inventory. The pickup item will appear on the report when one of the following situations exist:

  • The item's due date (this date is found on the Pickup Inventory form) must appear within the entered due date range OR
  • The item's actual due date is empty OR older than current system date AND the event the item's owner is a member of, has a event date within the entered due date range OR
  • The pickup item's due date is empty AND there is no event date for the item's owner
  • Leaving this date range blank (empty) will include ALL pickup inventory items in the report.

Limit to store(s).. This option is available with the optional multi-store module. It will limit the listing to inventory items to the entered stores.