PowerSchool ERP System Administration

Warehouse Inventory Profile

Use the Warehouse Inventory Profile to establish, access, and keep track of the following in the PowerSchool ERP Warehouse Inventory System:

  • General information such as your organization's name and the fiscal year.

  • Parameters for numbering material requests and request-fill transactions.

  • Accounts for tracking markup profit on stock items and offsetting journal entry debits and credits for inventory requests with inter-fund allocations.

  • User-defined fields for tracking information in Inventory Catalog records.

  • Settings for maintaining inventory accounts, tracking discontinued stock items, and requiring purchase orders for receiving goods.

Menu Path:  System Administration > Administration > Profiles > Warehouse Inventory Profile

Offsetting Interfund Transactions

The Warehouse Inventory Profile's Interfund Account field is used to create balancing debit and credit journal entry transactions for situations where inventory associated with a specific fund gets requested and distributed to locations that report under different funds.

Consider an example using the following data and system settings:

  • The profile's Interfund Account field is defined as 0171.

  • You have an Inventory Catalog record for Warehouse 100, Stock Item 520.

  • Inventory transactions for Warehouse 100 are written against Fund 100.

  • Inventory transactions for the Inventory Catalog record are tracked in the General Ledger using Fund 100 and Account 0180.

  • A request is submitted to Warehouse 100 for Stock Item 520. The request is for four (4) total units at $100.00 per unit.

  • Two units are charged against Budget Unit 2002018800 (tied to Fund 200), Account 400. The other two units are charged against Budget Unit 1001070200 (tied to Fund 100), Account 400.

When the request is filled and warehouse charges are interfaced to Fund Accounting, a batch journal entry is created with the following information:

Line

*Budget Organization*

Account

Debit

Credit

1

1001070200

400

200.00


2

2002018800

400

200.00


3

100

0180


400.00

4

100

0171

200.00


5

200

0171


200.00

Line 3 shows a $400.00 credit for the Inventory Catalog item's General Ledger record. However, since half of the stock was distributed to Fund 200, you need the interfund debit and credit in Line 4 and Line 5 to make the financial reporting accurate.

Fields

The Warehouse Profile page has a General section where most of the system settings are defined. The User Defined Field Titles section lets you set up labels for user-defined Inventory Catalog fields.

General Section

Use this section to define the majority of the Warehouse Inventory System’s profile settings:

Field

Description

Client

Your organization’s name as it should appear in reports. Character/40

System

Title of the software package. Character/40

Company

Software vendor that supplied this package. Character/40

Period

Current fiscal period.

  • If January begins your fiscal year, then you enter 1 for January, 2 for February, and so on.

  • If July begins your fiscal year, then enter 1 for July, 2 for August, and so on.

You can update this field as needed. The field is updated automatically when you run Warehouse Inventory’s Year End Procedures option.

Year

This field is updated when you run Warehouse Inventory’s Year End Procedures option. Integer/2

Auto Number Requests

Checkbox determining whether inventory requests are automatically numbered by the system or manually numbered by the requester. Select the box for system-assigned request numbers. For manual numbering, leave the field blank.

Next Request Number

Number the system will assign to the next inventory request entered. Only use this field if the Auto Number Requests checkbox is selected.

Profit Account

Revenue account used for tracking markup profit for a stock item. Markup profit is calculated based on a Stock Number record’s Markup Factor.

Interfund Account

Asset account used for recording offsetting journal entry debits and credits for interfund inventory transactions. The system uses this account for cases where an Inventory Catalog item is requested by and distributed to a location that reports under a different fund than the one defined for the warehouse where the item is stored.

For a details, refer to the Offsetting Interfund Transactions section above.

Next Fill ID

Next number the system will assign to an inventory transaction in which a request is filled, either through the Fill Requests option or the Update Request page’s Exception Fill item.

Approve Requests

Checkbox determining whether inventory requests require approval before they can be filled. Approval is processed with Warehouse Inventory’s Approve Requests option. Select the box to require approval for inventory requests. For requests to receive automatic approval, leave the field blank.

Fiscal Year Start Or End

Starting and ending dates for the current fiscal year. After initial setup of your Warehouse Inventory Profile, you will update these dates each year using the Year End Procedures option. The dates are referenced by Warehouse Inventory reports to determine yearly warehouse activity.

Discontinued Stock Items

Setting allowing users to control how discontinued stock items are processed for new and existing purchasing requisitions, purchase orders and change orders, as well as for warehouse requests, including batch requests.

Select:

A - Allow - Allows processing the discontinued item without any warning.
W - Warn - Issues a warning, but allows the item to be processed.
P - Prevent - Issues a warning and prevents the item from being processed.

Require Valid PO When Receiving Inventory

Checkbox determining whether users must enter a valid purchase order number from the Purchasing System to receive stock. Select the checkbox if valid purchase order numbers are required. Otherwise, users can enter any number or leave the Purchase Order/Item fields blank in the Receive Stock page.

Receive in Warehouse if PO Has Stock Number

Checkbox to prevent users from using the Purchasing System’s Received Ordered Materials option if there is a stock number associated with a purchase order line item. In this case, users will only be allowed to receive goods in the Warehouse Administrator’s Receive Stock option.

Select the checkbox to prevent the use of the Receive Ordered Materials option and require the use of the Receive Stock option for purchase order line items with stock numbers. Otherwise, leave the checkbox blank, in which case, either option can be used.

Note

The Inventory Catalog in Warehouse Inventory can only be updated with the Receive Stock option.

Inventory Accounts

Two fields for defining the range of Warehouse accounts for charging inventory costs. In the first field, enter the range’s lowest account number. In the second, enter the range’s highest account number.

Important

If accounts are entered in these fields, the Stock Number field will be required to save a purchasing requisition that uses an account in this range.

User-Defined Field Title Section

Use this section to setup field labels for user-defined Inventory Catalog fields:

Field

Description

Field 1-5

Field labels for use with the five user-defined fields available in the Inventory Catalog page’s Location tab. Character/15