![]() ![]() You can upload budget amounts to your budget organization for an existing account that falls within the account ranges assigned to your budget organization. ![]() You can determine the correct display size and attributes (alphabetic, numeric, right-justify zero-fill, and so on) for each segment in your account using the Value Sets window.ģ.Ğnter the accounts for which you want to upload budget information from your spreadsheet. For example, if display size is three, then your segment value would be '100,' but if your display size is four, then your segment value would be '0100'. Display size tells you how wide Budget Upload expects each segment value to be. For example, value '01' is not the same as value '1'. Make sure you specify segment values correctly. To determine the order in which your General Ledger application stores your account segments, you need to reference the GL_CODE_COMBINATIONS table.Ģ. To specify accounts in your spreadsheet:ġ.ěefore you enter account segment values into the segment columns of your spreadsheet and Budget Interface table, determine to which column you assigned each account segment using the Key Flexfield Segments window.īudget Upload assumes you enter values for account segments into your spreadsheet in the same order as you store them in General Ledger. If you do not enter a period amount for an account, your General Ledger application does not update the account balance, regardless of update logic. If you enter A (Add), Budget Upload adds the period amount to the existing account balance. If you enter R (Replace), Budget Upload replaces the existing account balance with the period amount you specify. When you enter a period amount for an account, Budget Upload updates the account balance according to the update logic you specify. For example, if your fiscal year ranges from January to December and you want to upload budget amounts for the months April, May and June, then you need to enter amounts for columns Period4_Amount through Period6_Amount. Budget Upload assumes that you enter period amounts for each account in the sequence that the period falls in the fiscal year. You can enter amounts for up to 60 periods per fiscal year.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |