NAME

LedgerSMB::Report::Inventory::Search - Search for Goods and Services in LedgerSMB

SYNPOSIS

 my $report = LedgerSMB::Report::Inventory::Search->new(%$request);
 $report->render();

DESCRIPTION

This is the main inventory item search for goods and services in LedgerSMB starting with version 1.4. Compared to LedgerSMB 1.3 this has no summary and details support and no searching for open vs closed invoices. The equivalent of a summary report is found in the inventory activities report instead.

The open/closed detection was omitted for performance reasons, and a search for unused items may take a while on larger databases.

CRITERIA PROPERTIES

In addition to standard dates, the following criteria are supported:

partnumber string

Prefix search on partnumber.

parttype string

Restriction on part type. Possible values:

all
parts
services
overhead
assemblies

description string

Full text search on description of part

partsgroup_id int

Limit search to partsgroup specified

serialnumber text

This is a serial number of the part, for a prefix search

make

Prefix search for parts with a make (and model) specified

model

Prefix search on the model of the part

drawing

Prefix search for drawing field

microfiche

Prefix search for microfiche field

status

An enumerated string, with the following significance

active: Show non-obsolete parts
obsolete: Show obsolete parts
short: Show parts below their re-order point (ROP)
unused: Show parts with no invoices or orders attached (previously orphaned)

sales_invoices bool

If true, show parts attached to sales invoices in the specified period

purchase_invoices bool

If true, show parts attached to purchase/vendor invoices in the specified period.

sales_orders

If true, search parts in sales orders in the specified period.

purchase_orders

If true, search purchase orders in the specified period.

quotations

If true, search quotations in the specified period

rfqs

If true, search Requests for Quotations for the specified period

INTERNALS

columns

name

Goods and Services

METHODS

run_report

LICENSE AND COPYRIGHT

This file is licensed under the GNU General Public License version 2, or at your option any later version. A copy of the license should have been included with your software.

LedgerSMB Documentation