Use this page to work with requests in a selected batch file. In the Batch Requests Update page, you can perform the following actions:
-
Review information for requests in the selected batch.
-
Add requests to the selected batch or to another batch file.
-
Change information for a batch request, delete a request's line items, or delete an entire batch request.
-
Print hard copies of batch requests or generate the Batch Request Stock Item Summary.
-
Post requests to the live database or run a test posting to look for errors.
Menu Path: Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests > select a batch file > click OK
Page Sections
The Batch Requests Update page includes the following sections:
|
Search Section |
Includes five fields for searching for requests in the batch selected in the main Batch Requests page. |
|
List Section |
Lists the requests found in a search of the current batch. When you select a request, its header record and line items display in the next two sections. |
|
Request Information Section |
Displays the fields in the current batch's header record. You can use this section and its associated Line Item section as follows:
|
|
Line Item Section |
Displays fields for adding, updating, or deleting the selected request's line items. |
Action Bar Items
The Action Bar in the Batch Requests Update page displays the following items:
|
Post |
Posts selected requests from a batch to the live Warehouse Inventory database. As an option, you can run a test posting first and generate a report to identify any data conflicts that may need to be corrected. |
|
Print Summary |
Generates the Batch Request Stock Item Summary for a selected batch. The report provides a comparison between the stock items requested and those on hand. |
Following are the procedures that can be performed in the Batch Requests Update page. Because the page is versatile, you can complete several different tasks during any given session in the page. As you become familiar with the procedures for individual tasks, you will learn how to combine them. For example, you could initially access the page to update requests in a selected batch, delete line items in another batch, and add a new batch, all without leaving the page.
For descriptions of the fields in the Request Information and Line Item sections, refer to the Fields section below.
Updating batch requests
-
Select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests to display the main Batch Requests page.
-
Select a batch, and click OK to display the Batch Requests Update page.
-
In the Search section at the top of the page, click OK to display all of the batch's requests.
You can also enter criteria in the search fields to identify specific requests, and then click Find to list them, or you can use the Advanced button to run an advanced search. -
In the List section, select the request to update, and then clickOK.
-
In the Request Information section, update the header fields as needed, and then click OK to access the Line Item section.
-
In the Line Item section, you can:
-
Change an existing line item, including its stock item, accounting distribution, and quantity.
-
Add a line item to the request by completing the fields in a blank row.
-
-
For the procedure for deleting a line item, refer to the appropriate procedure below.
-
Click OK to save the request and return to the List section.
-
To update another request, repeat Steps 4-7.
Adding new batch files
You would use this procedure after updating or adding requests in the Batch Requests Update page. For a more direct path for creating batch files, refer to Batch Requests Add Page.
-
Select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests to display the main Batch Requests page.
-
Select a batch, and then click OK to display the Batch Requests Update page.
-
Update the batch following the procedure above, or complete other procedures.
-
When you return to the Search or List section, click Add New to access the Request Information section.
-
In the Request Information section, enter a Control Number to identify the batch you are adding.
-
Complete the remaining fields in this section, which defines the batch's header.
-
Click OK to access the Line Item section.
-
In the Line Item section, complete the fields on a blank row to identify the stock item being requested.
Note
If a stock item has been discontinued, a setting in the Warehouse Inventory Profile determines whether you can enter a request for the item. -
Repeat Step 8 for each additional stock item.
-
When you finish entering line items, click OK to save the batch file.
-
If the Continuous checkbox is selected, the page refreshes so you can create another batch file by repeating Steps 4-10. For the procedure for adding a request to an existing batch, refer below.
-
If the Continuous checkbox is not selected, you return to the main Batch Requests page.
-
Adding requests to an existing batch
-
Select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests to display the main Batch Requests page.
-
Select the batch you want to add requests to, and then clickOK to display the Batch Requests Update page.
-
Click Add New.
-
In the Request Information section, complete the fields as needed.
-
Complete the section's additional fields. The Warehouse and Ship Code fields are required. All requests entered in this batch file are assigned the fiscal year you select. You cannot change the Request Year once the batch file is added.
-
Click OK to access the Line Item section.
-
In the section's blank row, complete the fields to add a line item to the request.
-
Repeat Step 7 for each additional line item.
-
Click OK to save the request.
-
If the Continuous checkbox is selected, you return to the Control Number field in the Request Information section. You can add another request by repeating Steps 4-9. To return to the Search section, click Back. You also can add a new batch. For the procedure, refer to the previous procedure (beginning with Step 5).
-
If the Continuous checkbox is not selected, you return to the Search section.
-
Deleting requests and individual line items
The following procedure allows you to delete an entire request or as an option, to select and delete individual line items within a request. For the procedure on deleting a batch, refer to Batch Requests Page.
-
Select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests to display the main Batch Requests page.
-
Select the batch containing the request or requests you want, and then click OK to display the Batch Requests Update page.
-
In the Search section, enter criteria identifying the relevant requests, and then click Find. To run an advanced search, click Advanced.
-
In the List section, select the request, and then click Delete.
-
In the Question dialog:
-
Click Line if you want to select and delete individual line items. Proceed to Step 6.
-
Click Whole to delete the selected request and all of its line items. The procedure ends, and you return to the List section. To delete another request, repeat Steps 4-5.
-
-
In the Line Item section, select a line item, and then click Delete Row on the Action Bar.
-
In the Confirmation dialog, click Yes.
If you delete the last line item in a request, you return to the List section, and the request will no longer display. -
To delete another line item in the same request, repeat Steps 6-7.
or
Click Back to return to the List section. -
When you finish, click OK to return to the List section.
-
To delete a request or line items in another request, repeat Steps 4-9.
Printing a selected request
-
Select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests to display the main Batch Requests page.
-
Select the batch containing the request or requests you want, and then click OK to display the Batch Requests Update page.
-
In the Search section:
-
To identify specific requests, enter criteria in the section's fields, and then click Find.
-
To list all requests, leave the section blank, and then click Find.
-
To run an advanced search, click Advanced.
-
-
In the List section, select the request, and then click Print.
-
In the Print window, specify how to generate the report, and then click OK. The report's default file name is brequisi.rpt.
A batch request prints the same as a regular request, except back ordered quantities are not included.
Generating the Batch Request Stock Item Summary report
This report provides a comparison between the stock items requested and the quantity that is in stock.
-
Select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests to display the main Batch Requests page.
-
Select the batch containing the request or requests you want, and then click OK to display the Batch Requests Update page.
-
In the Search section:
-
To identify specific requests, enter criteria in the section's fields, and then click Find.
-
To list all requests, leave the section blank, and then click Find.
-
To run an advanced search, click Advanced.
-
-
In the List section, select the request, and then click Print Summary on the Action Bar.
-
In the Print window, specify how to generate the report, and then click OK. The report's default file name is breqsum.rpt.
Running a test posting
Using the Batch Requests Update page's Post item on the Action Bar, you can run a test posting to determine whether a selected request is ready to post. The report will indicate any data conflicts that would prevent the request from posting. For information on conditions that constitute a data conflict, refer to Batch Requests Overview.
-
Select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests to display the main Batch Requests page.
-
Select the batch containing the request you want, and then click OK to display the Batch Requests Update page.
-
In the Search section, enter criteria to identify the request, and then click Find. To run an advanced search, click Advanced.
-
In the List section, select the request, and then click Post on the Action Bar.
-
In the Post Batch Requests dialog, click Report Only.
-
In the Print window, specify how to generate the report, and then click OK. The report's default file name is postreqt.rpt.
-
The Posting report indicates whether the request header and line items can be posted by displaying the message HEADER ADDED or LINE ADDED alongside each request or line item.
-
The report also notes when a batch request's number is already in use in the live database. In this case, the report shows the new number that would be assigned.
-
Posting a request
Following is the procedure for posting an individual request. If you want to post all the records in a batch file at the same time, refer to the procedure in Batch Requests Page.
-
Run a test posting for the request as outlined in the previous procedure. The test will identify any data conflicts that would prevent the request from posting.
-
If any conflicts are found, make the necessary corrections. For details, refer to Batch Requests Overview.
-
When you are ready to post, select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Batch Requests to display the main Batch Requests page.
-
Select the batch containing the request you want, and then click OK to display the Batch Requests Update page.
-
In the Search section, enter criteria to identify the request, and then click Find. To run an advanced search, click Advanced.
-
In the List section, select the request, and then click Post on the Action Bar.
-
In the Post Batch Requests dialog, click Post.
-
In the Question dialog, click Yes.
-
In the Print window, enter settings for generating the Batch Request Posting report, and then click OK. The report's default file name is postreq.rpt.
The system posts the batch request to the live database, generates the posting report, and displays the Batch Requests Post Results page, which also shows the effects of the posting. -
Click OK to close the Batch Requests Post Results page.
Fields
Request Information Section
The fields in this section function differently, depending on the task you are completing.
|
Field |
Description |
|---|---|
|
Control Number |
Number identifying the batch. Character/8 The number is display only if you are updating a request or deleting line items in a selected request. If using Add New to add a request, you can:
|
|
Request Year |
Defaults the fiscal year associated with the current batch. When you are updating an existing batch, the year is display only. When you are adding a new batch, you may select the current or next fiscal year, as determined by the Fund Accounting Profile. |
|
Request Number |
Number identifying a request.
|
|
Warehouse |
Code identifying the location where the requested stock items are stored. This field is verified against Warehouse Inventory’s Warehouse Code table. |
|
Date Requested |
Date when the request was submitted. The default is based on the Transaction Date in the Fund Accounting Profile. You may change the displayed date if needed. |
|
Requested By |
Person who submitted the request. Character/35 |
|
Date Required |
Required delivery date for the requested items. |
|
Ship Code |
Code identifying the location where the items are to be delivered. This field is verified against Warehouse Inventory’s Shipping Code table. |
|
Comments |
Additional information regarding the request. Character/50 |
Line Item Section
Each line in this section identifies the following: stock item, quantity requested, total cost, and distribution of expenses in Fund Accounting. You may include up to 99 items in a request.
|
Field |
Description |
|---|---|
|
Note |
If a stock item has been discontinued, a setting in the Warehouse Inventory Profile determines whether you can enter a request for the item. |
|
Item |
System-generated number identifying the line item. Display only. |
|
Stock Number |
Stock number for the requested item. This number, which is verified against the Stock Number table, combines with the warehouse code to identify a stock item in your Inventory Catalog. |
|
Description |
Description of the stock item, taken from the Stock Number table. |
|
*Budget Unit* |
Low-level Organization Chart code for the Expenditure Ledger account to charge for the current line item. Your entry becomes the default for the next line item. This field is verified against Fund Accounting’s Organization Chart. The field name is defined in the Fund Accounting Profile. |
|
Account |
Expenditure account code for the ledger account where the line item’s cost is charged. The default is the expense account from the item’s Inventory Catalog record. The organization/account combination entered must exist in Fund Accounting’s Expenditure Ledger. |
|
*Project* |
Low-level project code for the Project Ledger account where the line item’s cost is charged. This field only applies if you use project accounting. |
|
Account |
Expenditure account code for the Project Ledger account where the line item’s cost is charged. This field only applies if you use project accounting. |
|
Quantity |
Number of units requested. The system checks the available inventory when you post the batch record. Decimal/12,4 |
|
Price |
Unit price for the requested stock item, based on the Price field in the Inventory Catalog. This is either the average cost of the items in stock, last price charged on a purchase order, or a set price entered in the catalog. Depending on the Stock Number’s Auto Recalc Price checkbox:
For records with a Price field value of 0.00, the system defaults the Last Cost from the Stock Number table when receipt of the catalog item is recorded. |
|
Total Amount |
Total cost for the line item based on the unit price and the number of units requested. To calculate this value, the system multiplies the Quantity field by the Price. |