|
|
|
|
This page allows you to select the financial year for which you want to update the statistics. Tell me more...
Select the "Update Statistics" link under the "Stock Maintenance" business component
The “Update Statistics” page appears.
Enter the following fields:
|
Financial Year |
Use the drop-down list box to specify the financial year for which you wish to update the stock statistics. All the financial years defined, that are on or before the current system date and mapped to the login OU’s Company and closed for all the FBs of the login OU’s warehouses will be displayed here in ascending order. The system lists only the financial years for which statistics has not been updated previously. The system displays the first value by default. |
|
Financial Year Start Date |
The date on which the financial year commences. The system displays the start date for the corresponding financial year. |
|
Financial Year End Date |
The date on which the financial year concludes. The system displays the end date for the financial year |
|
Financial Period |
Use the drop-down list box to select the financial period for which you wish to calculate the closing quantity and value. All the financial periods defined for the selected financial year will be displayed here in ascending order. The system lists only the financial periods, which are in closed status for all the FBs of the login OU’s warehouses for which statistics has not been updated previously. The system displays the first value by default. |
|
Financial Period From |
The date on which the financial period commences. The system retrieves the start date for the corresponding financial period. |
|
Financial Period To |
The date on which the financial period closes. The system retrieves the closure date for the corresponding financial period. |
Click the “Update Statistics” pushbutton to calculate the financial period closing quantity and value.
The system calculates the financial period closing quantity and closing value for each of the item/variant in each warehouse as follows:
Period Closing Qty. = Period Opening Qty. + Opening balance qty +Receipt Qty. + Return Qty. + Adjustment Qty. + Stock Transfer In Qty. - Issue Qty. – Stock Transfer Out Qty.
Period Closing Value = Period Opening Value + Opening balance value + Receipt Value + Return Value + Adjustment Value + Std Cost Revaluation Value + Stock Transfer In Value - Issue Value – Stock Transfer Out Value
To proceed, carry out the following
Select the “View Statistics” link beneath the “Update Statistics” pushbutton to view the statistics for the financial year/period.
Update Statistics - An Overview
|
|
The start date and end date for the selected financial year are retrieved and displayed. The system verifies the company that is mapped to the login OU from organizational setup and retrieves the financial years defined for the company. You can also specify the financial period for the corresponding financial year that you have selected. The system checks whether there are any opening balance, stock issue, stock return, stock receipt, stock adjustment and standard cost revaluation transactions in “Authorized” or “Deleted” statuses. If transactions exist in other statuses, the system displays an error message.
The system checks if the selected financial period is the first period for that financial year. If so, the system takes the value as zero for period opening balance quantity and period opening value. If the selected period is not the first period, the system considers the previous period’s closing quantity and value as the selected period’s opening quantity and value. The system retrieves the issue quantity and issue value from the “Stock Issue” component for the selected financial period. The system checks the transaction date to retrieve the period in which the transaction occurred. Similarly, the system retrieves the return quantity and return value from the “Stock Return” component, receipt quantity and receipt value from the “Stock Receipt” component, adjustment quantity and adjustment value from the “Stock Adjustments” component, stock transfer in quantity, stock transfer out quantity, stock transfer in value and stock transfer out value from the “Stock Maintenance” component
