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.
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.
|
|
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 |