Updateable BAQ Help needed - 9.05.702A

Yahoo Archive
1


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 vantage@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]

2
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]
3

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]

4

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 vantage@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]

5

I forgot to add that the only field that is marked updateable is the PartPlant.MinOrderQty 



---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 vantage@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]

6

ok.  I had to look at one I created myself for changing all the Planning Parameters as well.

 

You should also have company in the display as well.  I put any fields that are prim index.

 

The  BO is Part - UpdateExt.  Tables to Update are ttPart and then ttPartPlant (which is under the ttPart tree)

 

Regen the BPM 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 8:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updateable BAQ Help needed - 9.05.702A

 

 

I forgot to add that the only field that is marked updateable is the PartPlant.MinOrderQty 



---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 vantage@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]