Use this screen to generate actual and target year-to-date burden rates for selected ranges of accounts and organizations. Once computed, the rates are stored in the INVT_BURD_SUM and INVT_BURD_SUM_DETL tables by account and org. The system will use these rates to value inventory burden for purchased inventory and manufacturing work-in-process/finished goods inventory. Your cost pool configuration determines how your costs will be burdened. The inventory settings in the Inventory Accounts screen will determine when raw materials will be burdened. For more information on inventory, please see the documentation for the Inventory Accounts screen.
If you do not use the Inventory or Production Control modules, or if you do not want to include variance amounts on your inventory, this process is not required.
|
|
Note: This process does not consider burden cost ceilings when building the composite rates and will not build composite rates for COM (Cost of Money). This calculation uses only YTD actual and target rates. |
|
|
Note: If you have selected the Exclude Burden from Asset Inventory checkbox in the Cost Pools screen (Projects\Maintain\Allocations) for a particular cost pool, this application excludes from its calculations any accounts classified as "asset" (ACCT.s_acct_type_cd = "A") in the Accounts screen (Accounting\Maintain\Accounts). |
If your company uses the Inventory and Production Control modules, execute this process every period immediately after running the process generated through the Compute & Print Pools Rates screen (Projects\Process\Allocations).
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to select the accounting period that you want to update as well as the accounts and organizations that should be included in the process.
Accounting Period
This non-editable field displays the "One" option. This is because you can only run this process for one accounting period at a time.
Enter, or use Lookup to select, a valid fiscal year. Note that the fiscal year must have an "O" (Open) status.
Period *
Enter, or use Lookup to select, a valid period for which you want to compute inventory burden rates.
Accounts *
Use this drop-down box to select the range of accounts that you want to include in the process. The following options are available:
All - Select this option to include all available accounts. The Start and End fields are disabled for this option.
One - Select this option to include only one account. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of accounts. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the accounts from the beginning of the available accounts to a specific account in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the accounts from a specific account to the end of all the available accounts. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting account number for the range that you want to include in the process.
If you select "One," "Range," or "To End," in the Accounts Option field, you must enter an account number in this field.
If you select "All" or "From Beginning" in the Accounts Option field, this field will be inactive.
Enter, or use Lookup to select, an ending account number for the range that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Accounts Option field, you must enter a account number in this field.
If you select "One" or "To End" in the Accounts Option field, this field will be inactive.
Organizations *
Use this drop-down box to select the range of organizations that you want to include in the process. The following options are available:
All - Select this option to include all available organizations. The Start and End fields are disabled for this option.
One - Select this option to include only one organization. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of organizations. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the organizations from the beginning of the available organizations to a specific organization in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the organizations from a specific organization to the end of all the available organizations. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting organization number for the range that you want to include in the process.
If you select "One," "Range," or "To End," in the Organizations Option field, you must enter an organization number in this field.
If you select "All" or "From Beginning" in the Organizations Option field, this field will be inactive.
Enter, or use Lookup to select, an ending organization number for the range that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Organizations Option field, you must enter a organization number in this field.
If you select "One" or "To End" in the Organizations Option field, this field will be inactive.
Use the field in this block to select an option to clear the prior year data from the INVT_BURD_SUM and INVT_BURD_SUM_DETL tables.
Select this checkbox to clear the rows from the INVT_BURD_SUM and INVT_BURD_SUM_DETL tables for all years before the selected fiscal year.
* A red asterisk denotes a required field.
Changes to this screen update the INVT_BURD_SUM and INVT_BURD_SUM_DETL tables.
