Thanks, Miguel! Now I see what I missed. I will keep this for future reference! Have a great day!
Beth
---In vantage@yahoogroups.com, <msantillan@...> wrote:Sent you the exported BAQ....
You should just import and change your criteria's and regen the directive.
Miguel A. Santillan
Compass Manufacturing Systems
510-661-6666 Office
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brye@...
Sent: Tuesday, October 29, 2013 9:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updateable BAQ Help needed - 9.05.702A
OK, I did all that and now I get an error that says " No header records found - processing aborting." Do I need to move Company to the top of my display list?
---In vantage@yahoogroups.com, <brye@...> wrote:
Here is the query:
For each Part no-lock where Part.PartNum BEGINS 'R' And Part.TypeCode = 'P' , each PartPlant no-lock where (Part.Company = PartPlant.Company and Part.PartNum = PartPlant.PartNum)
The fields I am displaying are:
Part.PartNum
Part.PartDescription
PartPlant.MinOrderQty
PartPlant.PartNum
PartPlant.Plant
The Business Object is PartPlantSearch and the table is ttPartPlant
---In van tage@yahoogroups.com, <vantage@yahoogroups.com> wrote:
What is your query like and what field are you displaying?
Miguel A. Santillan
Compass Manufacturing Systems
510-661-6666 Office
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bethany Rye
Sent: Tuesday, October 29, 2013 8:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updateable BAQ Help needed - 9.05.702A
Hi all,
I am writing an updateable BAQ for a user to show part number, description
and minimum order quantity so that he can update the minimum order
quantities on a certain group of parts. I am using two tables, Part and
PartPlant. I am only updating the Minimum Order Quantity in PartPlant, so
I'm not updating both tables. I can "Get List" fine, but when I change the
value in the Min. Order Qty field and click Update, I get the error message
"Table: PartPlant, Level:, Type: 3, RowID: 1, Text:
Program:bo/PartPlantSearch/PartPlantSearch.p Method:part:PlantBeforeUpdate
Message:Update of Part Plant not allowed."
Not sure what I did wrong. Any suggestions?
Bethany Rye
Epicor Business Analyst
<http://www.teampti.com/>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]