Generating Opening Balance Document

This report provides the opening balance details.

Select the “Generate Opening Balance Document” link under the “Inventory Setup Reports” business component.

The “Generate Opening Balance Document” page appears.

The system displays the following:

Date Format

The format in which the date fields must be entered in this page. This format is displayed from the "User Preferences" business component based on the login user id. In case the date format is not defined, the system displays the Organization level format.

Enter the following in the “Search Criteria” group box, to search for the opening balance document:

From Opening Balance #	The starting number, in the range of opening balance document numbers for which the report is to be generated (Alphanumeric, 18). You can enter the number in full or specify it partially using the "*" character.
To Opening Balance #	The ending number, in the range of opening balance document numbers, for which the report is to be generated (Alphanumeric, 18). You can enter the number in full or specify it partially using the "*" character.

Note: Ensure that the "From Opening Balance #" is less than or equal to "To Opening Balance #".

From Opening Balance Date	The starting date, in the range of opening balance document dates for which the report is to be generated (Date format).
To Opening Balance Date	The ending date, in the range of opening balance document dates for which the report is to be generated (Date format).

Note: Ensure that the "From Opening balance Date" is less than or equal to "To Opening balance Date".

Warehouse #	The number identifying the warehouse (Alphanumeric, 10). You can enter the number in full or specify it partially using the "*" character.
Status	Use the drop-down list box to select the status of the opening balance document as "Draft", "Fresh", "Authorized" or "Cancelled". Leave this field blank to generate the opening balance document report irrespective of the status.
Part Type	Use the drop-down list box to select the type of the part as "Component", "Expendable", "Kit", "Consumable", "Raw Material", "Tool" or “Miscellaneous”. Leave this field blank to retrieve the opening balance document report irrespective of the type of part.
Part #	The number identifying the part (Alphanumeric, 40). You can enter the number in full or specify it partially using the "*" character.
Location	Use the drop-down list box to specify the location for which the report must be generated.

Click the “Search” pushbutton to display the search results.

The system displays the following in the “Search Results” multiline:

Opening Balance #	The number identifying the opening balance.
Opening Balance Date	The date of the opening balance document.
Location	The location in which the opening balance document is created.
Warehouse #	The number identifying the warehouse.
Status	The current status of the opening balance document.

Check the “Select All” box to select all the opening balance documents in the “Search Results” multiline.
Enter the following field in the” Report Options” group box:

Report Action	Use the drop-down list box to select the report action. The system lists the following options:
	Print – Select this option to print the report.
	View Report – Select this option to view the report.

Click the “Generate Opening Balance Document” link, to generate the opening balance document.