Budgets - Actuals Vs. Budgets
Date: Wed, 24 Mar 1999 22:02:42 -0800
Date: Thu, 25 Mar 1999 08:05:54 -0500
Date: Thu, 25 Mar 1999 09:24:30 -0500 Budget Reports
Date: Mon, 29 Mar 1999 12:42:50 -0600
Date: Fri, 26 Mar 1999 15:43:07 -0500 Budget Upload
From: Rajendra Gutta [mailto:CMCIRPG@njtransit.state.nj.us]
Date: Wed, 10 Mar 1999 00:19:59 -0500 (EST)
Date: Wed, 10 Mar 1999 08:29:39 -0500 (EST) Deleting Budgets
From: psawyer@Baxglobal.com [SMTP:psawyer@Baxglobal.com]
To: Multiple recipients of list oraapps-l@cpa.qc.ca
From: psawyer@Baxglobal.com [SMTP:psawyer@Baxglobal.com]
From: Thomas Wieczorek (s) [mailto:twieczo@cap.org]
Date: Tue, 9 Mar 1999 20:22:25 -0500 (EST) Budget on Parent Account
Acharya Achyuta aacharya@irs.co.id wrote:
Date: 7 Apr 99 05:23:29 PDT Budget Period
From: "Ahmed Mohamed Samir" asamir@purenet.com.eg
Date: Sun, 11 Apr 1999 11:57:03 PDT Passing Encumbrance entries
Date: Thu, 13 May 1999 16:24:08 +0530
Date: Thu, 13 May 1999 13:59:39 -0400
x-------------x
From: fierosrcul@yahoo.com [mailto:fierosrcul@yahoo.com]
From: Cunningham, Ronald [mailto:rcunningham@noblestar.com]
Date: Wed, 2 Jun 1999 09:44:42 -0400
Date: Fri, 04 Jun 1999 09:32:12 -0500 Entering A/c codes for creating budgets
Date: Thu, 17 Jun 1999 18:00:49 IST
Date: Thu, 17 Jun 1999 05:43:51 -0700 (PDT)
Date: Thu, 17 Jun 1999 17:53:37 GMT Encumberance for Non profit organization
Date: 15 Jun 99 14:20:55 EDT
Date: Tue, 15 Jun 1999 15:54:37 -0400
Date: 15 Jun 99 16:13:35 EDT
Date: Wed, 16 Jun 1999 09:35:01 -0400
From: Thomas Matthews [mailto:tjohnmatthews@netscape.net]
From: "Farber, Andy" farban@consumer.org
Date: Thu, 17 Jun 1999 14:59:37 -0400
Date: Thu, 17 Jun 1999 12:34:16 PDT
Date: Fri, 18 Jun 1999 11:26:24 -0400
Date: Fri, 18 Jun 1999 16:59:30 PDT
Date: 18 Jun 99 13:51:51 EDT
Date: Mon, 21 Jun 1999 10:25:27 -0500
Date: 21 Jun 99 12:26:06 EDT
Date: Mon, 21 Jun 1999 16:58:54 -0500
Date: 22 Jun 99 08:04:04 EDT
Date: Tue, 22 Jun 1999 10:52:00 -0500
From: "Dew, Jeff"
Subject: Actuals to Budget
We have a requirement to re-forecast our budget based on ytd actuals. Our
users want us to copy the budget to a new version to retain the original
budget and "play" with the numbers in the new version. Is there a way to
post actuals for one or more periods to the budget? This will enable our
users to run standard budget reports on the 'forecast' budget and see all of
the numbers in one report.
Is there a better way to do this?
Any help would be appreciated.
From: "Hinkle, Craig" CHinkle@PG.Knouse.com
Subject: RE: Actuals to Budget
Jeff,
I have a very similar requirement at our company. I use ADI to accomplish
this. You can pull both actual and budgets using the budget wizard. It is
then as simple as a cut and paste the actuals over top the budget periods
and then upload back to the budget. I have one budget call reforecast and
another called original. I can then set reports to utilize either of the
budgets plus actual. I hope this helps.
Craig Hinkle
Senior Cost Analyst
Knouse Foods Coop., Inc.
(717) 677-7111 Ext. 3290
chinkle@pg.knouse.com
From: "Farber, Andy" farban@consumer.org
Subject: RE: Actuals to Budget
We print a "Calculated Year-End Estimate" column on our monthly accounting
reports, which is computed as the YTD Actual plus the remaining budget. (We
budget by accounting control, by month).
Around the 8th month of the year, we distributed YE Estimate worksheets
(monthly accounting reports converted to Excel worksheets), and ask managers
to review the calculated YE Estimate, and either accept it or change it to a
better estimate. We then upload all the YE Estimates to a new budget
structure, and report the "Managers Year-End Estimate" for the remaining 4
months.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
From: Nancy Gaudette nancy.gaudette@esoftsolutions.com
Subject: Re: GL Budget Report
The budget trial balance report will summarize PTD or YTD activity in one column.
An FSG report will display 12 months budget data. There is a column set called
Monthly Budget that displays a column for each month, plus a total column. If your
budget organizations are defined by cost center or other accounting flexfield segment,
you may define a content set expanding that range of segment values, which will create
a report for each one of the segment values.
Nancy Gaudette
www.esoftsolutions.com
From: "Andrew Franks" AFranks@pgahq.com
Subject: GL Budget Report
Hello Everyone,
We have upload our budgets through ADI using multiple budget organizations.
Does anyone know of a report out of GL that can show me the budget
oraganizations with the uploaded account code combinations, amounts, and
the twelve month totals or do I need the create an FSG for this report?
Thanks in Advance,
Andrew
Sent: Monday, March 08, 1999 10:44 AM
Hi Guys,
I am running the budget upload program on APPS 10.7 NCA and am getting the
following error message :
-The Accounting Flexfield is either Disabled or out of date.
-The Accounting Flexfield is invalid or does not allow detail budgeting.
I checked up the effective dates of the AFF which are blank and so not
enforced. The accounting flexfield exists as a valid code combination and
Allow
Budgeting flag is enabled.
Any suggestions.
Thanks in Advance,
Raj.
From: laura.pierce@us.pwcglobal.com
Subject: RE: Budget Upload
A couple of things to check:
(1) The flag which indicates whether or not detail budgeting is allowed is
set at the indivdual *segment value* level. You would need to check this
flag for *each* segment value in the accounting flexfield combination you
are entering (as well as for the combination in the combinations form).
The same is true for the enabled flag and the effective dates. An entire
code combination may say that it is enabled; however, if an individual
segment value used in the combination (e.g. department 100) is disabled,
then you will receive the same error.
(2) On the budget organization form, ranges of accounting flexfields can
be defined to enable budgeting for account combinations. **However**,
before budgeting amounts can actually be entered for accounting flexfields
which fall within these ranges, the specific accounting flexfield
combinations must be *added* to the budget organization. This is
accomplished by running the standard request 'Program - Maintain Budget
Organization' or by clicking on the Maintain button on the Budget Org
form. You can view all of the valid accounting flexfield combinations that
have been added to the Budget Org by clicking on the Assignments button on
the Budget Org form.
Hope this helps!
Laura Pierce
PricewaterhouseCoopers
From: Rajendra Gutta CMCIRPG@njtransit.state.nj.us
Subject: Re: Budget Upload
Hi Laura,
Thanks again for the detailed reply,the issue is now resolved,i was trying to
load the CCID column
instead of the segment columns in the interface.In the case of the segment
values i had converted
them with the allow budgeting flag and allow posting defaulted to 'Y' .
Thanks,
Have a good day.
RAJ.
Sent: Tuesday, March 09, 1999 10:22 AM
Subject: Deleting Budgets
I have deleted all Organizations from the budget, however the budget
amounts are
still showing on trial balances, etc.
How do I delete this budgeted amounts?
cc: (bcc: Paul Sawyer/AMERICA/BAX)
Subject: RE: Deleting Budgets
How did you enter the budgets?
If you entered them with GLDI or with a Journal entry. You need to reload
the budgets with $0 amounts. I can give you more detail depending upon
which way you entered the budgets.
Sent: Tuesday, March 09, 1999 11:09 AM
Subject: RE: Deleting Budgets
I entered them using ADI.
Sent: Tuesday, March 09, 1999 1:26 PM
Subject: RE: Deleting Budgets
Then run the Enter Budgets, for the ALL organization. It will create a
budget worksheet on you excel spread sheet with the budget dollars. Zero
out all of the budget dollars by inputting zero's. Then upload the budget.
Make sure that you are replacing budget amounts, not appending.
From: "Farber, Andy" farban@consumer.org
Subject: RE: Deleting Budgets
Another way to zero out a budget:
If you have parent accounts set up that range the entire chart of accounts,
you can set up a mass allocation that creates a journal budget entry that is
the Current Amount * -1 ...
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Hi All,
We have 10.7 Sc 16.1 Can I define Budget amount on any Parent account ?
Regards
A K A
From: Roger Drolet rdrolet@netscape.net
Subject: Re: [Budget on Parent Account]
You cannot post or budget to a parent account. Oracle provides the
functionality to prepare Master/Detail budgets, however, you actually have to
enter budget amounts for the Master budget. Oracle does not roll up the
budgets for the children and automatically generate the Master budget.
Moreover, the sum of the detail budgets (i.e., children) do not have to equal
the Master budget. Oracle provides a Master/Detail budget report that lists
any variances between Master and Detail budgets. To utilize this
functionality, you have to define rollup groups and assign them to the
appropriate parent accounts. In addition, you have to define summary accounts
and templates that the system will use to compare the summary totals for
your Detail Budgets with the total on your Master Budget.
You can define a FSG report to derive the total amount budgeted for a Parent
Account. However, I have not been successful in printing out the variance
between actual and the derived budget for a parent account. Oracle can't
derive a value using a value that is derived. For example, the Budget amount
for the Parent account is derived by adding together the values for each
of the Detail budgets. The variance is then calculated by comparing the derived
budgets values for the Parent account with the actual values for the Parent
account.
Roger Drolet
Managing Associate
Conley, Canitano
Subject: Error in opening Budget year
Date: Sun, 11 Apr 1999 08:49:54 -0400 (EDT)
We are currently defining our budget for the first time ,we we got
the following error message when we tried to run the request to open
next year
+------------------------------------------------------------------+
Oracle General Ledger: Version : 9.0.9 - Development
Copyright (c) Oracle Corporation 1979, 1991. All rights reserved.
GLBOYR module: Open Budget Year
+--------------------------------------------------------------------+
Current system time is 11-APR-1999 15:41:19
+--------------------------------------------------------------------+
main() 11-APR-1999 15:41:19
set_of_books_id 1
budget_version_id 1000
glbbpr() 11-APR-1999 15:41:19
glbbpr() 11-APR-1999 15:41:20
glbchp_check_periods() 11-APR-1999 15:41:20
BOYR0005: One or more periods in this budget year is not defined.
x glbchp_check_periods() 11-APR-1999 15:41:20
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found
sqlerrp: sqlerrd: 0 1 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************
oracaid: oracabc: 0
oracchf: 0 oradbgf: 0 orahchf: 0 orastxtf: 2 orastxtl: 0
orastxtc:
orasfnmc: oraslnr: 0 orasfnml: 0
orahoc: 50 ormoc: 10 oracoc: 10
oranor: 0 oranpr: 10 oranex: 11
SHRD0015: glbchp_check_periods failed:
SHRD0033: Error Status: 0
SHRD0103: Function warning number: -1
*****************************************************
SHRD0044: Process logging off database and exiting ...
+--------------------------------------------------------------------+
Concurrent request completed
Current system time is 11-APR-1999 15:41:20
+--------------------------------------------------------------------+
note : all financial periods are opened/future opened
From: "Syed Mehmood Ul-Hasan" smehmoodapps@hotmail.com
Subject: Re: Error in opening Budget year
Hi Ahmed,
Please check how many adjusting periods you have defined?
This may happen if you have defined all the periods as adjusting
periods.
Regards,
Mehmood
From: "Shamica Wakade" shamica@sohm.soft.net
Subject: PO: Passing Encumbrance entries for Requistion & PO to GL
Hi All,
I have created a requistion and a PO using the same. I want the module to
pass encumbrance entries to GL.
I have set the 'Use Requisition Encumbrance' and 'Use PO Encumbrance' to
'Yes' in Financial Options. I have also given all the encumbrance types.
The 'Reserve at Completion' flag is also set to 'Yes'.
Is there anything else I need to do ?
TIA,
Shamica.
From: Debbie Anderson DANDERSON@gcrta.org
Subject: Re: PO: Passing Encumbrance entries for Requistion & PO to GL
Shamica, you have to run a concurrent process to create the journal
entries. The process is in General Ledger, "Program - Create Journals"
We have this process set up to run every 30 minutes.
Dear Friends
We have to enable Encumbrance accounting for one of
our clients. We require
some information on what journals, encumbrance and
actual, are passed from
the different subledgers to general ledger when the
modules used are Oracle
Purchasing, Accounts Payable and General Ledger.
When is the budget actually getting hit, at the time
of receiving materials
or at the time of receiving the invoice?
I'll be grateful for your help
Regards
Ushasi
Sent: Wednesday, June 02, 1999 7:20 AM
Subject: Re: AP Encumbrance Accounting
Your budget becomes encumbered at the time of the
REQUISTION. Your inventory becomes accrued for at the
time of receipt.
Sent: Wednesday, June 02, 1999 7:32 AM
Subject: RE: AP Encumbrance Accounting
Just to add to what Ushasi wrote: You have a choice of creating the
encumbrance entry at the time of requisition or at the time of purchase
order approval.
Ron
Ronald A. Cunningham
Oracle Consultant
From: "Farber, Andy" farban@consumer.org
Subject: RE: AP Encumbrance Accounting
While your funds available are reduced when your requisition (or purchase
order) is reserved, the transaction does not appear in the ledger until the
CREATE JOURNALS Program is run to create encumbrance journal entries, and
then the POSTING program is run to post them to the ledger...
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
From: "Debbie Griffin" dgriffin@fnal.gov
Subject: RE: AP Encumbrance Accounting
There is an excellent paper titled "Commitments and Obligations: Uncovering
the Mysteries of Encumbrance Accounting" written by Diana Morton and Linda
Perry, that explains the journal entries. You should be able to find it at
the OAUG website.
-- Debbie Griffin
Fermilab
dgriffin@fnal.gov
630-840-8754
From: seetha raman seeethu@hotmail.com
Subject: Budget Organization
Hi all,
I have about 100 code combination to be entered in the assignment zone of
Bud. Org. Is their any simple way of entering all the valid combination of a
range automatically.
Thanks in advance for the help
seetha
From: fierosrcul@yahoo.com
Subject: Re: Budget Organization
I often create code combinations by loading Journal
Entries for the desired accounts through ADI. Posting
a ZERO dollar journal entry is a quick and easy way to
create the CCID without going thru the backend.
Assuming these new codes fall within your existing
budget RANGE. By running the Budget MAINTAIN program,
I believe they will then be picked up under the
assignment screen automatically.
From: "Mehmood." smehmoodapps@hotmail.com
Subject: Re: Budget Organization
Hi Seetha,
Running the MAINTAIN budget org. program will automatically add the new CC's
you have created.
Regards,
Mehmood
From: Thomas Matthews tjohnmatthews@netscape.net
Subject: GL: Oracle & Non-Profit Questions
Hello,
Our organization is beginning an implementation on Apps Version 11.
Here is my question:
Q. We are using FASB 117 for the financial statement presentation of our
donations.
We have several endowments that are placed into investments to earn interest
and dividends (aka Earnings)
The rules state that in one month, we cannot spend more than the amount of
earnings for that month.
I would like to set something up in Oracle that prevents a user from entering
an expense that would cause the total expenses for that donor to exceed the
total of the earnings for that month.
I though of using budgetary control, but we would not know the breakdown of
expenses per account.
How do other non-profits handle this?
Thanks,
Tom
From: "Farber, Andy" farban@consumer.org
Subject: RE: Oracle & Non-Profit Questions
Tom,
One possibility is to implement budgetary control with a summary account
that includes all of the expenses, budgeted at ZERO dollars, and an
additional expense line that is budgeted with an estimate of the monthly
earnings.
Then, set your budgetary control to ABSOLUTE, your amount type as PTD, and
your boundary as Monthly.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
From: Thomas Matthews tjohnmatthews@netscape.net
Subject: Re: [RE: Oracle & Non-Profit Questions]
Andy,
Lets me see if I understand your suggestion:
I create a budget "ENDOWMENT"
I have a summary account (01-100-EXPENSES) Where 100=Donor
01-100-EXPENSES - $ 0.00
01-100-7000 - $1800.00
Now I am entering an invoice in AP:
Invoice Distribution Line = 01-100-7000 - $2000
What purpose does the summary account provide in this case.
In this case, Oracle would reject this because the budget is for $1,800
dollars.
But what happens when I enter a distribution line for account "01-100-7800"?? =
Thanks for your help thus far,
Tom
From: "Farber, Andy" farban@consumer.org
Subject: RE: [RE: Oracle & Non-Profit Questions]
Tom,
Try again.
Suppose the range of your expense accounts is from 4000 to 9999. Create a
summary account, EXPENSES, that ranges all expense accounts (4000 thru
9999).
Now, suppose the donor expenses are going to be charged to 4700, 7200, and
8000. Create an expense account, 9000, "BUDGETED EXPENSES".
Budget 4700, 7200, and 8000 at $0, and 9000 at the total amount permitted to
be spent in the period.
If a monthly budget is $1,800, the sum of the charges for the month in 4700,
7200, and 8000 cannot exceed $1,800.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Sent: Wednesday, June 16, 1999 11:52 AM
Subject: Re: [GL: Budgetary Control and Encumbrance Entries]
Andy,
Is there a way to prevent the encumbrance entries from coming over to the
General Ledger?
Thanks so much for your help,
Scott
Subject: RE: [GL: Budgetary Control and Encumbrance Entries]
Date: Thu, 17 Jun 1999 08:41:28 -0400
I don't think you would want to (not bring over the encumbrance entries).
The reason to go with encumbrance accounting is so that you CAN see the
entries.
Again, if you don't want to see the entries, utilize the Funds Available and
the Funds Checker without encumbrance accounting.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
From: ?iso-8859-1?Q?FranE7ois_Gendron? fgendron@cpa.qc.ca
Subject: RE: GL: Budgetary Control and Encumbrance Entries
The funds checker is able to give REAL-TIME funds available information
because it looks into both the current actual and encumbrance GL_BALANCES
and a temporary table (GL_BC_BUCKETS) where fund reservation transactions
which have not yet be summarized into the GL_BALANCES are kept.
If you do not create encumbrance journl entries (from the GL_BC_BUCKETS
transactions) into the GL, the temporary table will not be cleared and
can grow very quickly. As the table grows, funds checking will gradually
slow down until it becomes unbearably slow.
Regards,
--
François Gendron
Oracle Applications Advisor
Tél: (450) 651-8471 Fax: (450) 651-7375
From: Ananth Swaminath ananth999@hotmail.com
Subject: Reply: GL: Budgetary Control and Encumbrance Entries
Hi
A few more issues to be kept in mind. (Do correct me if I am wrong)
1. Budget transfers and budget journals submit the Create Journals request
automatically when the transaction passes funds reservation. Requisitions,
PO’s, unmatched Invoice distributions and Inv. Price Variances all create
budgetary control transactions that will remain in the queue table
(GL_BC_BUCKETS) until the Create Journals request is submitted and the JVs
posted.
2. Invoice approval, inventory receipts and inventory adjustments create
encumbrance entries without the Create Journals Program. These entries are
transferred to GL through Journal Import. AP uses its own GL post task to
accomplish this feature and therefore submits its own Journal Import
program. Inventory requires the GL transfer process to be run along with a
Journal Import in GL.
Ananth
Senior Applications Consultant
From: "Farber, Andy" farban@consumer.org
Subject: RE: Reply: GL: Budgetary Control and Encumbrance Entries
Two corrections, if I may...
1. Payables encumbrance journal entries resulting from PO matches are
created when the Create Journals program is run, which reverse the PO
encumbrance and set up an Invoice encumbrance. When the payables GL POST is
run, the invoice encumbrance is reversed, and the actual created.
2. The temporary table GL_BC_PACKETS (in Rel 10). Is the name changed to
"..BUCKETS" in Release 11?
Andy
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
From: Ananth Swaminath ananth999@hotmail.com
Subject: Reply(2): GL: Budgetary Control and Encumbrance Entries
Hi Andy
Sorry about the typo: The queue table is still GL_BC_PACKETS.
And yes you are right on the process. No issues on that at all.
Ananth
Senior Applications Consultant
From: Thomas Matthews tjohnmatthews@netscape.net
Subject: GL: Fund Type Reporting (Non-Profit)
Hello,
I have another issue that I am unsure how to handle.
It seems that in certain non-profit entities, there are needs to generate
financial reports by fund type. Fund Type means: Unrestricted (U),
Temporarily Restricted (TR), and Permanently Restricted (PR). This is in
accordance with FASB 117.
We have a segment in our COA that is called "Donor". When a donor is added,
our current system allows us to classify it with "U", "TR", or "PR". When we
run a report we can show a balance sheet or income statement by fund type
Does Oracle Public Sector G/L offer any functionality to handle this?
Thanks again,
Tom
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: Fund Type Reporting (Non-Profit)
Have you researched the Attribute Reporting functionality that exists in the
Public Sector GL? This would allow you to associate an attribute "U" or
"TR" or "PR" with a particular "donor" segment. However, you could only
associate one of the three attributes to a particular donor segment value.
Is this requirement one-to-one, or can the same donor segment value have
multiple Fund Types?
Kathy Farmer
From: Thomas Matthews tjohnmatthews@netscape.net
Subject: Re: [RE: Fund Type Reporting (Non-Profit)]
Hello Kathy,
I was looking into Attribute Reporting, but I could not determine from the
User Guide if I would be able to report on an attribute using FSG. Do you
know the answer here?
Also, If I use a Fund Type of Restricted, and un-restricted for the balancing
segment, will Oracle generate a separate fund balance at the beginning of each
new fiscal year?
Thanks for you help,
-Scott
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: [RE: Fund Type Reporting (Non-Profit)]
Yes, you can use reporting attributes with FSG.
Not sure if I completely understand your second question - the balancing
segment would track the fund balance for any given year and that balance
would carry forward by fund balancing segment. The Fund Type in the scenario
where Fund Type is just a reporting attribute, it doesn't' exist as a
"segment" it's another way to report on a segment.
For example, we have multiple revenue accounts that correspond to the same
Federal Funding source. By associating a Federal Funding source code with
each of those revenue accounts we are able to run an operating FSG that
sorts the revenue by Federal Funding source, rather than revenue account.
The balances are still in the same revenue accounts.
Did that help?
From: Thomas Matthews tjohnmatthews@netscape.net
Subject: Re: [RE: [RE: Fund Type Reporting (Non-Profit)]]
Kathy,
Thanks so much, that explains alot.
I have one additional question relating to the reporting attribute:
If I am entering a journal entry, or any other transaction involving my chart
of accounts structure, does the reporting attribute allow me to select a
value at that time, or is it strictly behind the scenes?
We need to track the dollar amount of expenses that were incurred against
the principal and interest of a donation. Depending on the transaction, the
expense that I "hit" could be related to the interest or principal.
For example:
--------------------Attribute----------
DR - 01.100.7000.400 (Principal) $500
CR - 01.100.2010.400 $500
Thanks again,
Tom
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: [RE: [RE: Fund Type Reporting (Non-Profit)]]
The attribute is "hard-coded" - that is it is associated with the segment
value in the accounting flexfield. You can have multiple types of
attributes for the same segment value, but you can't have multiple values
for the same type of attribute for one segment.
If you want to be able to select a value on the fly that sounds more like
either a dependent segment in your AFF or a DFF.
Kathy