FW: RE: Updateable BAQ Help needed - 9.05.702A


(system) #1

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]

(system) #2
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]