How do I run summary product reports for specific departments?

Question:

How do I run summary product reports for specific departments?

We would like to print product totals by department, by fiscal year for
specific products. For example, for departments 200, 201 and 540, we want
to see how much we spent in diapers, baby formula, baby food and other
food. We don't have separate general ledger accounts for diaper, baby
formula or baby food. How do we run these summary product reports for
specific departments by fiscal year?

Resolution:

You can use option#13 PO Report Suite on the PO Reporting menu option 10 from PO Main menu. I would fill out the screens as follows:

POREPT Purchasing Reports 2/16/1

S1 10:47:2

Type Selections, press Enter.

From Date . . . . . . . . . . . . . . . . . 07 01 11 mm/dd/yy:

To Date . . . . . . . . . . . . . . . . . . 06 30 12

P=PO Date R=Receipt Date . . . . . . . . . R P,R

Print P=POs R=Receipts B=Both . . . . . . . R P,R,B

Print D=Detail S=Summary B=Both . . . . . . S D,S,B

Select Corp/Whse . . . . . . . . . . . . . Y Y=Yes:

Select Status Codes . . . . . . . . . . . . Y

Select Vendors . . . . . . . . . . . . . .

Select Product Categories . . . . . . . . . Y

Select Products . . . . . . . . . . . . . .

Select Agents . . . . . . . . . . . . . . .

Select G/L Accts . . . . . . . . . . . . .

Select Job Numbers . . . . . . . . . . . .

Select Receivers . . . . . . . . . . . . .

Select G/L Departments . . . . . . . . . .

Select PO Departments . . . . . . . . . . .

____________________________________________________________

next screen:

POREPT Purchasing Reports 2/16/12

S2 10:48:36

Select One of the Following, press Enter.

Total

Y=Yes ( 1,2,3,4,5,6)

Corp/Whse/PO# . . . . . . . . . . . . . . . . G=GL P=PO

Corp/Whse/Status/PO# . . . . . . . . . . . . . Dept:

Corp/Whse/Vendor/PO# . . . . . . . . . . . . .

Corp/Whse/Vendor/Dept/PO# . . . . . . . . . .

Corp/Whse/Vendor/Dept/Product . . . . . . . .

Corp/Whse/Vendor/Dept/Prod Cat/Product . . . .

Corp/Dept/Product . . . . . . . . . . . . . .

Corp/Dept/Product Cat/Product . . . . . . . .

Corp/Product Cat/Product . . . . . . . . . . . Y 1

Corp/Product . . . . . . . . . . . . . . . . .

Corp/Whse/Agent/PO# . . . . . . . . . . . . .

Corp/Whse/Agent/Dept/PO# . . . . . . . . . . .

Corp/Whse/Agent/Dept/Product . . . . . . . . .

Corp/Whse/Agent/Dept/Prod Cat/Product . . . .

___________________________________________________________________

next screen:

Choose Corp/Warehouse when they are displayed

_____________________________________________________________________

next screen:

POIA84 Purchasing Status Codes Selection

Select Status Code(s), press Enter.

Next# . . . . . . . . . . Y=Yes:

New PO . . . . . . . . . .

Awaiting Approval . . . .

Printed . . . . . . . . .

Partially Received . . . . Y

Received . . . . . . . . . Y

Closed . . . . . . . . . . Y

Voided . . . . . . . . . .

Deleted . . . . . . . . .